SQL DBA

6AM City, LLC; North Carolina; On-site; USD 120,000 - 180,000; Full time

Job summary

6AM City, LLC is seeking a Microsoft SQL Server Database Administrator to join our IT team in Charlotte, NC. The role is full-time and in-office, requiring relocation to or residence in the Charlotte area.

You will manage large SQL Server databases, implement Always-On AG, and optimize performance across TB-scale data environments. The ideal candidate has strong SQL scripting and tuning skills, experience with sharding/partitioning, and familiarity with Azure-based SQL services.

Qualifications

• Bachelor's degree in Computer Science/Information Technology or related field.
• Proven experience as a Microsoft SQL Server Database Administrator.
• In-depth knowledge of Always-On Availability Groups.
• Experience managing TB-sized databases in production.
• Strong SQL scripting and performance tuning skills.
• Familiarity with database security best practices.
• Azure certifications and experience deploying SQL Server on Azure are a plus.
• Relevant certifications (e.g., Azure Database Administrator Associate) are a plus.

Responsibilities

• Database Administration: manage, monitor, and maintain Microsoft SQL Server databases, ensuring high availability and performance.
• Sharding or partitioning: design and implement sharding for scalable data distribution.
• Azure SQL Server: manage SQL instances and databases in Azure.
• Backup and recovery: develop robust backup/recovery strategies and test restores.
• Performance tuning: analyze and optimize queries, indexing, and config; identify bottlenecks.
• Security: implement database security measures and stay current with best practices.
• Collaboration: work with developers and admins on database-related projects.

Skills

SQL scripting

Performance tuning

Database security

Education

Bachelor's degree in Computer Science/IT or related field

Azure Database Administrator certification or equivalent

Tools

Always-On Availability Groups

Azure SQL Server

Job description

No C2C

Must live in Charlotte NC

In office 5 days a week.

Microsoft SQL Server Database Administrator

Position Type: Full-time

About Us: We are seeking a highly skilled and motivated Microsoft SQL Server Database Administrator to join our talented IT team. If you possess strong expertise in managing large-scale databases, and are passionate about ensuring optimal performance and reliability, we want to hear from you.

Responsibilities:

1. Database Administration:
   
   
   
   • Manage, monitor, and maintain Microsoft SQL Server databases, ensuring high availability and performance.
   
   
   • Implement and manage Always-On AG to provide fault tolerance and high availability.
   
   
   • Handle TB-sized databases, optimizing performance and resource utilization.
   
   
   
   


2. Sharding or Partitioning Experience:
   
   
   
   • Design and implement database sharding strategies for efficient horizontal scaling.
   
   
   • Monitor and manage sharded databases to ensure even distribution of data and optimal query performance.
   
   
   
   


3. Azure SQL Server:
   
   
   
   • Experience in handling VM’s in Azure, Manage SQL Instances, and SQL Databases in Azure.
   
   
   • Utilize Azure services for scalability, security, and performance enhancements.
   
   
   
   


4. Backup and Recovery:
   
   
   
   • Develop and maintain robust backup and recovery strategies for large databases.
   
   
   • Perform regular database backups and conduct periodic recovery tests to ensure data integrity.
   
   
   
   


5. Performance Tuning:
   
   
   
   • Analyze and optimize query performance, indexing, and database configuration.
   
   
   • Proactively identify and resolve performance bottlenecks to ensure optimal database responsiveness.
   
   
   • Query Store experience required.
   
   
   
   


6. Security:
   
   
   
   • Implement and enforce database security measures to protect sensitive data.
   
   
   • Stay current with industry best practices and security trends to ensure databases are protected against potential threats.
   
   
   
   


7. Collaboration:
   
   
   
   • Collaborate with cross-functional teams, including developers and system administrators, to address database-related issues and ensure smooth operations.
   
   
   • Participate in the planning and execution of database-related projects.
   
   
   
   

Qualifications:

1. Bachelor's degree in Computer Science, Information Technology, or related field.


2. Proven experience as a Microsoft SQL Server Database Administrator.


3. In-depth knowledge of Always-On Availability Groups.


4. Experience managing TB-sized databases in a production environment.


5. Strong SQL scripting skills and expertise in performance tuning.


6. Familiarity with database security best practices.


7. Azure certifications and experience deploying SQL Server databases on Azure are a plus.


8. Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.