Senior SQL Server DBA - HA & Performance Expert

4P Consulting Inc.; Atlanta (GA); On-site; USD 110,000 - 150,000; Full time

Job summary

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

Qualifications

• 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.

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 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.

Skills

SQL Server

Backup and recovery

Performance tuning

T-SQL

Communication skills

Documentation

Education

Bachelor's degree in computer science or a related field

Tools

Always On Availability Groups

SharePoint

Cohesity Backup Appliance

Microsoft Windows Server

Job description

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