Advanced Database Administrator

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.

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 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 incidents affecting database performance, connectivity, or data integrity, ensuring timely resolution.
• Performs root cause analysis for recurring or systemic database issues and implements corrective actions.
• Automates database operations using scripting and orchestration tools (e.g., Shell, Python, Ansible) to improve efficiency and reliability.
• Supports integration with enterprise identity platforms, such as Active Directory, to ensure secure and centralized authentication.
• Executes cross-platform data transport, including transportable tablespaces, endian conversion, and platform migration support.
• Performs other duties as assigned
• Complies with all policies and standards
• May be required to work hours outside regular work hours, as applicable
• Observes the work performed by contractors, as applicable
• Reviews invoices and approves them if the work has contractual standards, as applicable
• Addresses performance issues with the contractor when possible, as applicable
• Escalates issues to other parties when needed, as applicable

Required Qualifications:

• Bachelor’s Degree in Arts/Sciences (BA/BS). An additional 4 years of combined education and experience may be considered in lieu of a degree.
• Minimum 8 yearsof relevant experience.
• Requires at least one certification in the current platform/domain/technical skill. Possible certifications could be, but are not limited to:
  • AWS Certified Cloud Practitioner
  • AWS Certified Solution Architect - Associate & Professional 
  • Azure Administrator Associate 
  • Fundamental knowledge of Oracle AWS RDS or Azure cloud
  • Google Certified Professional Cloud Architect 
  • Microsoft Azure Administrator 
  • Microsoft Certified: Azure Administrator Associate 
  • Oracle Database Administrator certification (e.g., OCP or OCE)

Technical Skills:

• Expertise installing, configuring, and administering Oracle Database platforms (11g, 12c, 19c) in complex enterprise environments.
• Proficient in managing multiple relational database platforms, including Oracle, SQL Server, MySQL, and PostgreSQL, with a focus on cross-platform integration and interoperability.
• Skilled in database provisioning, cloning, and migration using DBCA, SQL scripting, and Oracle Data Pump to support multi-environment deployments.
• Advanced experience designing and implementing backup, recovery, and cloning strategies using RMAN, Flashback technologies, and Recovery Catalogs to meet RTO/RPO objectives.
• Expert in database security and compliance, including user and role management, privilege assignment, auditing, and implementing regulatory controls.
• Advanced SQL performance tuning and query optimization using AWR, ASH, ADDM, and SQL Monitor reports to ensure high performance across multiple environments.
• Strong expertise in query execution plan analysis using EXPLAIN PLAN, DBMS_XPLAN, SQL Trace, and TKPROF, including cross-instance performance troubleshooting.
• Database and instance performance tuning expertise, including SGA, PGA, I/O optimization, and parallel execution, with experience in proactive monitoring and predictive tuning.
• Hands-on experience configuring, patching, and troubleshooting Oracle Real Application Clusters (RAC) environments for high availability and scalability.
• Implementation and management of Oracle Data Guard and Active Data Guard solutions, including monitoring, switchover, failover, and disaster recovery planning.
• Configuration and administration of Oracle GoldenGate replication, including conflict detection, resolution, and cross-environment synchronization.
• Design, implementation, and maintenance of Automatic Storage Management (ASM) environments to optimize storage performance and reliability.
• Proficient in provisioning and managing Oracle Cloud Infrastructure (OCI) database services, including Autonomous Database, Exadata Cloud Service, and OCI DB Systems, with operational integration across hybrid environments.
• Experience leveraging automation and scripting (e.g., Shell, Python, Ansible) to streamline database management, performance monitoring, and maintenance processes.
• Participates in capacity planning, performance benchmarking, and advanced diagnostic activities to ensure sustained database availability and efficiency.

Behavioral Skills:

• Advanced in establishing and maintaining effective working relationships with employees at all levels within the organization, and with both internal and external customers.
• Advanced interpersonal and verbal and written communication skills, with the ability to effectively collaborate with both technical and non-technical peers.
• Advanced in communicating effectively, both orally and in writing, to interact with team members, customers, management, and support personnel (technical and non-technical)
• Adept in identifying and analyzing risks and developing effective mitigation strategies.
• Adept in critical thinking, problem-solving, and decision-making skills.
• Adept in active listening, attention to detail, customer service, prioritization, and problem-solving skills.
• Adept in hands-on experience with related tools.
• Adept in working independently and strategically.
• Adept in technical knowledge and diverse skillset to understand various technologies, systems, and potential risks. 
• Adept in managing multiple projects simultaneously and prioritizing tasks based on urgency and impact.
• Adept at working under pressure and meeting deadlines individually and collaboratively. Thinks logically, assesses problems, and is results-oriented. 
• Adept in identifying complex business and technology risks and associated vulnerabilities.

Competencies:

Other Information:

Pursuant to the New York State Public Officers Law & the MTA Code of Ethics, all employees who hold a policymaking position must file an Annual Statement of Financial Disclosure (FDS) with the NYS Commission on Ethics and Lobbying in Government (the “Commission”).

Equal Employment Opportunity:

MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including with respect to veteran status and individuals with disabilities.

The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.