Database Administrator 4 at 4P Consulting Inc. Atlanta, GA

4P Consulting Inc.; Atlanta (GA); Presencial; USD 110.000 - 150.000; Jornada completa

Descripción de la vacante

4P Consulting Inc. is seeking a Senior Database Administrator to coordinate, design, and secure large databases and to serve as a highest-level subject matter expert. Local candidates only.

The role involves advanced SQL Server administration, security, backups, high availability, and performance tuning across production, test, and development environments. The ideal candidate has 7+ years of hands-on experience with SQL Server, Always On, ERDs, and documentation, and can lead or guide

Formación

• Bachelor's degree in computer science or a related field.
• 7+ years of experience in database/operating system support or a related field.
• Strong knowledge of SQL Server, HA, backups, and performance tuning.
• Experience with ERDs, data dictionaries, and system documentation.

Responsabilidades

• Manage all aspects of physical database administration including schema management, security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning and capacity planning for SQL Server.
• Support application teams and their projects to troubleshoot and performance tune.
• Support SQL Server databases in Production, Test and Development environments and within Microsoft SharePoint farm.
• Install, upgrade, configure Always On, test and deploy complex database software.
• Develop and implement database recovery plans and procedures.
• Analyze the performance of databases and recommend tuning and application changes.
• Implement user authentication and validate databases security protocols across systems.
• Review system design and develop new database systems as needed.
• Modify database structure or deploy schema changes as a result of new requirements.
• Scripting batch data loads and operational job automation.
• Working knowledge of Cohesity Backup Appliance.
• Working knowledge of Cloud Technology and governance.

Conocimientos

SQL Server

Backup and recovery

Performance tuning

T-SQL

Communication skills

Documentation

Educación

Bachelor's degree in computer science or a related field

Herramientas

Always On Availability Groups

SharePoint

Cohesity Backup Appliance

Microsoft Windows Server

Descripción del empleo

Job Summary:

Under limited supervision, coordinates, designs, and secures computer databases to store, track, and maintain a large volume of critical business information. Serves as highest advanced-level subject matter expert, providing authoritative guidance for professional staff. May also serve in a lead role. Local Candidates Only.

Job Responsibilities:

• Manage all aspects of physical database administration including schema management; security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning and capacity planning for SQL Server.


• Support application teams and their projects to enhance, troubleshoot and performance tune


• Support SQL Server databases in Production, Test and Development environments and within Microsoft SharePoint farm


• Install, upgrade, configure ALWAYS ON, test and deploy complex database software


• Develop and implement database recovery plans and procedures


• Analyze the performance of databases and recommends tuning and application changes


• Implement user authentication and validate databases security protocols across systems


• Reviews system design and develop new database systems as needed


• Modifying database structure or deploying schema changes as a result of new requirements


• Scripting batch data loads and operational job automation


• Working Knowledge of Cohesity Backup Appliance.


• Working Knowledge of Cloud Technology and governance.

Qualifications:

Bachelor's degree in computer science or a related field from an accredited college or university AND Seven years of experience in support of an operating system, database management system or a related field

Skills Required :

• 6+ years of hands–on administrative experience with SQL Server RDBMS


• 6+ years of hands–on experience managing backup, recovery, and high–availability scenarios


• 6+ years of hands–on experience in SQL Server database development and performance tuning


• 6+ years of hands–on experience with Microsoft Operating Systems , SQL Server clustered environments , database optimization , and T–SQL programming


• 6+ years of strong SQL query development and scripting experience


• 4+ years of strong knowledge and hands–on experience with Always On High Availability Groups


• 4+ years of strong experience with SQL Server migrations


• 3+ years of experience in database space management , storage design , and capacity planning following best practices


• 4+ years of demonstrated ability to communicate effectively , both verbally and in writing, with technical teams and management


• 3+ years of experience creating entity relationship diagrams (ERDs) , database documentation , data dictionaries , and system architecture documentation