SQL DBA

Ampcus - New York, NY

Full-time

New York, NY

Professional, Scientific, and Technical Services

About the position

The SQL DBA position at Ampcus, Inc. involves managing SQL Server databases, particularly in an AWS environment. The role requires a highly motivated individual with expertise in database administration, troubleshooting, and migration processes. The successful candidate will be responsible for ensuring high availability and performance of large databases while addressing various SQL Server issues.

Responsibilities

• Manage SQL Server databases on AWS.
• Obtain and maintain database administrator certifications from Microsoft or a reputable organization.
• Handle extra large databases with high availability and real-time replication from OLTP and OLAP using distributed databases.
• Troubleshoot SQL Server issues including system locks, fragmentation, index reorganization and rebuild, system logs issues, replication delays, and ghost records.
• Oversee SQL Server migration from on-premises to AWS and from older SQL Server versions to newer versions, including expert handling of DAG setup and troubleshooting.

Requirements

• Experience as a SQL Server DBA with a focus on AWS.
• 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.
• Experience in SQL Server migration processes.

Nice-to-haves

• Expertise in DAG setup and troubleshooting.