SQL SERVER DBA

Quality It Source - New York, NY

Full-time

New York, NY

Telecommunications

About the position

The SQL Server DBA position is a 12-month contract role based in New York City, NY, requiring expertise in SQL Server database administration and some SQL development skills. The ideal candidate will manage large databases with high availability and real-time replication, particularly in an AWS environment. The role involves troubleshooting various SQL Server issues and overseeing migrations from on-premises to AWS.

Responsibilities

• Manage SQL Server databases on AWS with high availability.
• Troubleshoot SQL Server issues including system locks, fragmentation, and replication delays.
• Handle SQL Server migrations from on-premises to AWS and from older versions to newer versions.
• Perform index reorganization and rebuilds as necessary.
• Monitor and resolve system logs issues and ghost records.

Requirements

• Experience as a SQL Server DBA with SQL development skills.
• Database administrator certifications from Microsoft or a reputable organization.
• Hands-on experience managing extra-large databases with high availability.
• Experience with real-time replication from OLTP and OLAP using distributed databases.
• Ability to troubleshoot SQL Server issues effectively.