Senior SQL Server DBA

$135,200 - $145,600/Yr

Cynet Systems - New York, NY

posted 3 months ago

Full-time - Senior
New York, NY
Professional, Scientific, and Technical Services

About the position

We are seeking a highly skilled Senior SQL Server DBA to join our team in New York City, NY. This position is a contract role that offers a competitive pay range of $65 to $70 per hour. The ideal candidate will have extensive experience in managing SQL Server databases, particularly in an AWS environment. The role requires a deep understanding of database administration, including certifications from Microsoft or a reputable organization. As a Senior SQL Server DBA, you will be responsible for overseeing extra-large databases with high availability and real-time replication from OLTP to OLAP systems using distributed databases. You will need to demonstrate your ability to troubleshoot various SQL Server issues, including but not limited to system locks, fragmentation, index reorganization and rebuild, system log issues, replication delays, and ghost records. Additionally, you will be expected to manage SQL Server migrations from on-premises environments to AWS, as well as upgrades from older SQL Server versions to newer ones. Expertise in DAG setup and troubleshooting DAG-related issues is also a critical requirement for this position. This role is essential for ensuring the reliability and performance of our database systems, and you will play a key role in maintaining the integrity and availability of our data.

Responsibilities

  • Manage and maintain SQL Server databases on AWS.
  • Troubleshoot SQL Server issues including system locks, fragmentation, and replication delays.
  • Oversee SQL Server migrations from on-premises to AWS and from older versions to newer versions.
  • Set up and troubleshoot Database Availability Groups (DAG).
  • Ensure high availability and real-time replication of databases.

Requirements

  • Extensive experience as a SQL Server DBA, particularly in AWS environments.
  • Database administrator certifications from Microsoft or a reputable organization.
  • Hands-on experience managing extra-large databases with high availability.
  • Proficient in troubleshooting SQL Server issues, including system locks and fragmentation.
  • Experience in SQL Server migration from on-prem to AWS and version upgrades.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service