Previous Job
Previous
SQL Server DBA Lead
Ref No.: 18-08955
Location: Spartanburg, South Carolina
The Manager, Database Administration is responsible for leading a team of Database Administrators and all activities related to the design, planning, implementation and administration of enterprise database systems. Is expected to be the technical lead and mentor team members. May assign personnel to various projects and directs their activities. Monitors project schedules and costs. Confers with and advises subordinates on administrative policies and procedures, technical problems, priorities, and methods. Business matters will be treated with the utmost urgency and focus on results and deadlines until each task or project is completed is key. The qualified candidate will display excellent problem solving, analytical, communication, coordination and team management skills. Daily activities will include participating in daily planning meetings, providing estimates, handling ad-hoc requests, and tracking and communicating daily progress on projects and initiatives. This position will also take on various responsibilities throughout the department as assigned.
Responsibilities
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Work with engineers to determine where the databases will reside in multi-tier distributed/shared applications, comparing hardware/infrastructure alternatives in conjunction with cost, use, growth, supportability, etc.
  • Define database authorization rules, perform security audit, and perform platform assessment regarding proper support for the selected databases. Read and implement entity-relationship diagrams
  • Handle multiple projects simultaneously and engage in problem solving on these projects
  • Collaborate with application architects, product managers, business analysts and technical management team to design, develop and document databases, schemas, tables, functions, triggers, procedures, relationships and other necessary aspects of the database
  • Design and develop complex data models from high level business requirements. Must be able to provide design options, alternatives and recommendations based on experience and best practices for database design
  • Establish standards for documentation and ensure that all designs are documented.
  • Other tasks as assigned
Qualifications
  • Bachelor's Degree or higher strongly preferred in Computer Science or a related discipline and typically eight to ten years of experience
  • 7+ years of SQL database technology experience.
  • 2+ years of people and database management experience.
  • In depth experience with database installation, configuration and upgrade.
  • Table space management of DPF databases.
  • Excellent knowledge of Database backup and recovery of very large databases, typically multi terabytes.
  • Expert level of performance and tuning skills.
  • Excellent knowledge of SQL database/instance tuning, optimizing complex SQL statements for best possible performance.
  • Proven leadership skills and ability to manage instances with multiple operating system platform.
  • Understanding of application development, database, and infrastructure capabilities and constraints
  • Excellent verbal and written communication skills
  • Experiences in DW Appliances like Netezza and Teradata will be a strong plus
  • Experience in Big data technologies - Hadoop, Hive, NoSQL etc. or Machine Learning technologies is a strong plus