Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this Senior Database Architect and Administrator role.

Rezi rewrites your resume against City of New York's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Senior Database Architect and Administrator posting at City of New York — free, in seconds.

About the Role

We are seeking a Senior Database Administrator (DBA) who will be pivotal in safeguarding and optimizing the enterprise database systems that power critical pension and retirement services for city members. The DBA will lead cloud-native architecture on AWS, drive performance and security excellence across PostgreSQL and Microsoft SQL Server, and translate complex business needs into reliable, scalable solutions.

Responsibilities

Lead the design, deployment, configuration, scaling, and optimization of AWS RDS and Aurora PostgreSQL environments.
Ensure high availability and performance, including support for low-code/no-code platforms such as Mendix.
Architect and maintain enterprise-grade backup, recovery, Disaster Recovery (DR), automated failover, and Point-In-Time Recovery (PITR) strategies.
Guarantee 24/7 availability and integrity of sensitive pension and member data.
Implement and enforce multi-layered security controls, including encryption, auditing, IAM, and network segmentation.
Ensure alignment with TRS frameworks and regulatory requirements across all database environments.
Oversee installation, patching, upgrades, troubleshooting, and performance tuning for PostgreSQL and SQL Server.
Manage hybrid environments spanning on-premises and cloud across development, testing, and production.
Evaluate and implement modern database architectures, server configurations, and migration strategies.
Drive modernization initiatives that support high-scale, evolving applications.
Design, troubleshoot, and deploy SSIS packages, data bridging programs, SSRS reports, and migration processes.
Collaborate with data and application teams to ensure seamless integrations and accurate reconciliations.
Proactively monitor database health, performance, security, and recoverability using industry-leading tools.
Identify and resolve issues before they impact service availability.
Partner with developers, QA teams, and application owners to deliver reliable, high-quality solutions.
Support major production releases, including weekend or off-hours work.
Perform backup and restoration of production databases to non-production environments, ensuring data integrity and consistency.
Develop and maintain automation scripts using PowerShell, T-SQL, and SQL Server Agent jobs to streamline database refresh and maintenance processes.
Configure and integrate SAML-based authentication by working with Identity Providers (IdPs), managing metadata exchange, and accurately mapping attributes to database systems.
Design and implement automated processes to refresh environment-specific configuration settings and application constants across environments.
Plan, schedule, and execute database refresh activities with a focus on minimizing downtime and reducing impact to business operations.

Requirements

A baccalaureate degree from an accredited college in computer science, information systems, engineering, mathematics or related field and six years of satisfactory full-time experience related to enterprise architecture, solutions architecture, network architecture and/or IT infrastructure systems.
A baccalaureate degree from an accredited college and ten years of satisfactory full-time experience related to enterprise architecture, solutions architecture, network architecture and/or IT infrastructure systems.
Education and/or experience which is equivalent to the above.

Skills

Database design
Database administration
Performance tuning
Security
Backup/recovery
ETL processes
Microsoft SQL Server
PostgreSQL
Installation
Configuration
Patching
High availability/DR (replication, clustering)
SSIS
SSRS
AWS RDS/Aurora PostgreSQL management
Hybrid environments
Automation/scripting (PowerShell preferred)
Windows Server
Storage
Security delegation
Cloud database solutions (AWS and Azure)
Data warehousing
Performance monitoring tools
Root-cause analysis
Documentation
Presentation
Low-code platforms (e.g., Mendix)
PowerShell
T-SQL
SQL Server Agent jobs
SAML-based authentication
Identity Providers (IdPs)
AWS

Location

New York City

Work Type

Hybrid

Experience Level

Senior
5+ years of hands-on experience

Education Level

Baccalaureate degree

Salary/Compensations

USD 100000 - USD 170000

About the Company

Since 1917, the Teachers’ Retirement System of the City of New York (TRS) has been securing better futures for NYC educators.
With a pension fund valued at approximately $123 billion, TRS serves over 274,000 members, providing them with retirement, disability, and death benefit services.
At TRS, we seek dedicated professionals who are passionate about their work and committed to excellence.
We pride ourselves on our member-centric culture, focused on delivering outstanding service and support to our members.

Equal Opportunity

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.