Advanced Database Administrator

Description

JOB TITLE:

Advanced Database Administrator

SALARY RANGE: $140,828 - $166,223

DEPT/DIV:
Information Technology

SUPERVISOR:
Manager, Product Development

LOCATION:

2 Broadway, New York, NY 10004

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

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

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.

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.

• 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 proactively identify and remediate performance bottlenecks and reduce manual administrative effort.
• Conducts system health checks and recommends operational or configuration improvements to optimize resource utilization.
• Implements and maintains backup and recovery solutions aligned with defined RTO and RPO objectives.
• Supports high-availability and resiliency architectures, including replication, clustering, mirroring, and failover setups.
• Participates in disaster recovery testing exercises, validating procedures, documenting results, and supporting continuous improvement efforts.
• Supports data protection and business continuity initiatives through redundancy and fault-tolerance implementations.
• Implements database security policies, access controls, encryption, and authentication procedures in accordance with standards.
• Participates in security audits and vulnerability assessments, assisting with remediation of identified risks.
• Maintains confidentiality, integrity, and availability (CIA) of sensitive data assets within assigned environments.
• Configures and maintains monitoring frameworks to track database performance, availability, and usage trends.
• Responds to…