Senior SQL Server Database Administrator (SQL Server & Azure)

TheCorporate; New York (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

TheCorporate is seeking a Senior SQL Server Database Administrator in New York, NY to design, implement, and maintain SQL Server and Azure Managed Instance databases for enterprise applications.

You will perform installations, upgrades, migrations, security hardening, and performance tuning while collaborating with IT teams to ensure high availability and robust backup/recovery strategies.

Qualifications

• Bachelor’s degree in Computer Science, IT, or equivalent experience.
• Minimum of 8 years in IT with SQL Server/DBA responsibilities.
• Experience with Windows Server, SQL Server, Azure, and Always On High Availability.
• Certifications such as MCSE or Azure DBA preferred.

Responsibilities

• Design and oversee the installation, configuration, and maintenance of database technologies to ensure system availability targets are met.
• Perform core DBA tasks including data modeling, migrations, security configuration, and performance tuning.
• Coordinate with system admins, network engineers, and help desk to address infrastructure and database issues.
• Mentor junior database staff and document standards for enterprise-wide use.

Skills

Microsoft SQL Server Administration

Azure SQL Managed Instance

SQL Server Installations & Migrations

SQL Performance Tuning

Always On Availability Groups

Backup & Disaster Recovery

Azure Storage & Security

Database Security & Compliance

Automation / Scripting / Python

Windows/Linux/UNIX Admin

Education

Bachelor’s degree in Computer Science / IT or equivalent

10+ years of related experience in DB administration / programming

Job description

Job Title: Senior SQL Server Database Administrator (SQL Server and Azure)

Location: 2, Broadway, NY, NY

Duration: 1 year

Interview Mode: Phone then Video

Description

Job Summary:

The primary purpose of this position is to design, implement, maintain, tune, and optimize all MTA databases to meet current and future software application requirements.

• Design, implement, and maintain Microsoft SQL Server and Azure Managed Instance databases.
• Perform SQL Server installations, upgrades, and migrations.
• Collaborate with the infrastructure team on regular patching.
• Troubleshoot and remediate database-related issues.
• Ensure database security and compliance with relevant regulations.
• Optimize SQL database performance and conduct query tuning.
• Develop and implement robust database backup and recovery strategies.
• Partner with application development teams to support database requirements.
• Stay current with the latest Microsoft SQL Server and Azure technologies and industry best practices.
• Develop and maintain procedures, best practices, and standards documentation.
• Perform other duties as assigned.

Critical Skills

• 5+ years of hands-on experience as a SQL Server Database Administrator.
• Bachelor’s degree in Computer Science, IT, or equivalent experience.
• Expert knowledge of Windows Server, SQL Server, Azure cloud platform — especially SQL Managed Instance, Azure Storage, and foundational Azure security concepts.
• Experience implementing high availability solutions (e.g., Always On Availability Groups).
• Strong SQL knowledge; Python is a plus.
• Strong problem-solving and logical troubleshooting skills.
• Microsoft certifications (e.g., MCSE, Azure DBA) are preferred.

Qualifications

• Advanced knowledge of installing, maintaining, and troubleshooting database technology, computer hardware, operating systems, and storage area networks as they relate to database performance and reliability.
• Advanced knowledge of MTA standard shell scripting for database automation.
• Proficiency in general-purpose programming languages (e.g., Python, PowerShell) to support database automation.
• Ability to troubleshoot and support technical issues both remotely and on-site using MTA-standard tools and methodologies.
• Ability to interpret technical documentation, schematics, and manuals to maintain systems with minimal supervision.
• Strong oral and written communication skills.
• Strong analytical and problem-solving abilities.
• Strong interpersonal and collaboration skills.
• Ability to plan activities and provide technical guidance to junior team members.
• Ability to design and engineer scalable solutions and establish department-wide standards.
• Bachelor’s degree in Computer Science, Information Technology, or a related field; OR a minimum of 10 years of relevant experience in programming, systems administration, and/or database administration.
• Minimum of 8 years of experience installing, maintaining, administering, and supporting computer hardware, operating systems (UNIX, Linux, Windows), and database products (Oracle, MS SQL Server).

Responsibilities

• Design and oversee the installation, configuration, and maintenance of database technologies to ensure all MTA application and system availability targets are met.
• Perform core DBA tasks, including data modeling, process flow definition, data migrations, security configuration, and performance tuning.
• Design, configure, and install database software modules and applications.
• Develop system backup schedules, perform verification testing, and maintain all required documentation.
• Coordinate with system administrators, network engineers, help desk staff, and other IT teams to address infrastructure and database issues.
• Ensure accurate, timely, and compliant record-keeping for IT assets per MTA policies.
• Evaluate new database technologies and provide strategic input on their adoption and impact.
• Mentor and guide junior database technicians and staff.
• Design, engineer, and document solutions and standards for enterprise-wide implementation.
• Contribute to planning and coordination of database installations, support, and maintenance activities.

Skills

• Microsoft SQL Server Database Administration
• Azure SQL Managed Instance (MI)
• SQL Server Installation, Upgrades, and Migrations
• SQL Performance Tuning and Optimization
• High Availability / Always On Availability Groups
• Database Backup and Disaster Recovery
• Azure Cloud, Storage, and Security Fundamentals
• Database Security and Compliance
• Database Automation / Shell Scripting / Python
• Windows, Linux, and UNIX Systems Administration