Advanced Database Administrator

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 #J-18808-Ljbffr Metropolitan Transportation Authority