Advanced Database Administrator

Metropolitan Transportation Authority; New York (NY); Hybrid; USD 140,000 - 190,000; Full time

Job summary

The Metropolitan Transportation Authority is seeking an Advanced Database Administrator to lead design, implementation, and ongoing management of multi-platform database environments. This role ensures data integrity, security, availability, and performance across on-premises and cloud systems, with guidance to junior staff and collaboration across IT domains.

Responsibilities include architecture contributions, performance tuning, disaster recovery, and roadmap support.

Qualifications

• Bachelor's degree in Computer Science or related field.
• Extensive experience designing and managing complex database environments.
• Strong expertise in SQL optimization and performance tuning.

Responsibilities

• Contributes to database architecture, ensuring secure, scalable, high-performing platforms.
• Acts as SME across multiple database technologies and guides modernization projects.
• Supports roadmaps, capacity planning, and disaster recovery for critical systems.
• Diagnoses and remediates complex performance and scalability issues.
• Mentors junior staff and collaborates with stakeholders to improve data reliability.

Skills

Advanced SQL

Database design

Performance tuning

Cloud databases

Leadership

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server Management Studio

Oracle Enterprise Manager

MySQL Workbench

PostgreSQL tools

Job description

9:00 am - 5:30 pm (7.5 hours/day) or as required

This position is eligible for telewor k ing, which is currently 2 days per week . New hires are eligible to apply 30 days after their effective date of hire.

Opening :

The Metropolitan Transportation Authority is North America's largest transportation network, serving a population of 15.3 million people across a 5,000-square-mile travel area surrounding New York City, Long Island, southeastern New York State, and Connecticut. The MTA network comprises the nation’s largest bus fleet and more subway and commuter rail cars than all other U.S. transit systems combined. MTA strives to provide a safe and reliable commute, excellent customer service, and rewarding opportunities.

Job Summary :

The Advanced Database Administrator serves as a senior technical expert responsible for the design, implementation, optimization, and ongoing management of the organization's database environments. This role ensures data integrity, security, availability, and performance across complex, multi-platform, on-premises, and cloud database systems. The Advanced DBA supports database architecture and capacity planning, implements performance tuning, and maintains high-availability and disaster recovery solutions. Acting as a technical leader within the team, this role provides guidance to junior staff, collaborates across IT domains, and contributes to best practices, standards, and operational improvements to ensure reliable, secure, and high-performing database services.

Responsibilities :

• Contributes to database architecture and design within assigned environments, supporting scalable, secure, and high-performing database platforms for critical business applications.
• Serves as a technical subject matter expert (SME) on multiple database technologies, providing guidance on integration, optimization, and modernization projects .
• Supports database technology roadmaps and platform improvements, ensuring alignment with enterprise standards and business requirements.
• Resolves complex database performance, scalability, and resilience issues, coordinating troubleshooting and implementing effective remediation solutions.
• Evaluates emerging database technologies to support future platform enhancements, providing recommendations to senior leadership or project teams.
• Collaborates with business and technical stakeholders to identify opportunities for leveraging data to improve business processes and system performance.
• Designs, engineers, and documents database solutions and technical standards, ensuring alignment with business objectives and architectural guidelines.
• Implements and maintains disaster recovery and high-availability solutions for supported database platforms to minimize service disruption.
• Develops and executes database backup strategies, including scheduling, validation testing, and documentation, meeting recovery objectives and compliance requirements.
• Plans and coordinates database installations, upgrades, and maintenance activities, ensuring reliable operations and consistent performance.
• Provides technical guidance and mentoring to junior or mid-level DBAs, promoting best practices and efficient workflows.
• Ensures data consistency, integrity, and availability through robust database design, configuration, and lifecycle management practices.
• Monitors database performance using diagnostic tools and metrics, identifying trends and proactively addressing potential issues.
• Performs advanced SQL optimization, including query tuning, indexing strategies, and configuration adjustments across platforms.
• Implements automation and scripting solutions to