Senior Database Architect — Remote 2x/Week

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

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.