Senior SQL Database Administrator - Hybrid (Azure/AlwaysOn)

TAFF Inc; New York (NY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

TAFF Inc is seeking a SQL Database Administrator for a 12-month hybrid role at the MTA Headquarters, located at 2 Broadway. The role requires 3 days on site or as needed, with ongoing design, implementation, and optimization of Microsoft SQL Server and Azure databases to support current and future software requirements.

The primary duties include installations, upgrades, migrations, performance tuning, security and backup strategies, and collaboration with development teams.

Qualifications

• 5+ years of hands-on experience as a SQL Server Database Administrator.
• Bachelor's degree in Computer Science, IT, or equivalent experience.
• Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically SQL Managed Instance, Azure Storage account and Azure security fundamentals.
• Experience implementing High availability (Always-on).
• Strong Knowledge of SQL. Knowledge of Python is preferred.
• Strong problem-solving skills with a focus on logical troubleshooting.
• Certifications in Microsoft technologies are preferred

Responsibilities

• Design and oversee the installation, configuration, and maintenance of database technologies and resources to ensure that all MTA application and systems availability targets are met.
• Perform database administration tasks including but not limited to defining data process flows, data modeling, data migrations, security and fine tuning database performance.
• Design, configure and install database software modules and applications.
• Develop system backup schedules, verification testing and all related documentation requirements.
• Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements and analyze / troubleshoot issues as they arise.
• Ensure all required system documentation and record keeping requirements associated with maintaining and controlling IT assets are completed accurately, timely and in accordance with MTA policies and procedures and department requirements.
• Participate in the evaluation of new database products and technologies and influence future direction and provide input into the overall impact of introducing the technology in the MTA environment.
• Guide less senior database technicians and staff in the performance of their tasks.
• Design, engineer and document solutions and standards to be applied within the IT Department.
• Contribute to the planning and coordination of tasks associated with database installations, support and maintenance

Skills

SQL Server

Azure

Windows Server

Always-on HA

Python

Troubleshooting

Security/compliance

Education

Bachelor's degree in Computer Science / IT

10+ years in DB administration / related disciplines

Tools

Azure SQL Managed Instance

Azure Storage

UNIX/Linux/Windows

Shell scripting

Oracle

Job description

TAFF Inc is seeking a SQL Database Administrator for a 12-month hybrid role at the MTA Headquarters, located at 2 Broadway. The role requires 3 days on site or as needed, with ongoing design, implementation, and optimization of Microsoft SQL Server and Azure databases to support current and future software requirements.

The primary duties include installations, upgrades, migrations, performance tuning, security and backup strategies, and collaboration with development teams.