SQL DBA Job Winston-Salem area,North Carolina USA,IT/Tech

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:

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.

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.

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.

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.

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.

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.

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:

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 a production environment.

Strong SQL scripting skills and expertise in performance tuning.

Familiarity with database security best practices.

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

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

#J-18808-Ljbffr