What are the responsibilities and job description for the Senior Database Architect and Administrator position at City of New York?
Company Description
Job Description
About TRS
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.
Position Summary
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. If you thrive on innovation, high-stakes reliability, and ensuring data integrity in a hybrid environment, this is your opportunity to make a lasting impact.
Key Responsibilities
Cloud Architecture & Optimization
-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.
Data Protection & Resilience
-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.
Security & Compliance Leadership
-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.
Advanced Database Administration
-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.
Scalability & Modernization
-Evaluate and implement modern database architectures, server configurations, and migration strategies.
-Drive modernization initiatives that support high-scale, evolving applications.
Data Integration & Reporting
-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.
Monitoring & Operational Excellence
-Proactively monitor database health, performance, security, and recoverability using industry-leading tools.
-Identify and resolve issues before they impact service availability.
Cross-Functional Collaboration
-Partner with developers, QA teams, and application owners to deliver reliable, high-quality solutions.
-Support major production releases, including weekend or off-hours work.
Environment Refresh Expertise
-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.
Preferred Skills in Addition to Minimum Qualifications
-5 years of hands-on experience in database design, administration, performance tuning, security, backup/recovery, and ETL processes.
-Strong expertise in Microsoft SQL Server and PostgreSQL, including installation, configuration, patching, high availability/DR (replication, clustering), SSIS, and SSRS.
-Advanced AWS proficiency, particularly RDS/Aurora PostgreSQL management; AWS Certified Database - Specialty or Solutions Architect certification strongly preferred.
-Experience with hybrid environments, automation/scripting (PowerShell preferred), Windows Server, storage, and security delegation.
-Solid knowledge of cloud database solutions (AWS and Azure), data warehousing, and performance monitoring tools.
-Proven ability to research emerging technologies, conduct root-cause analysis, document standards, and present findings.
-Familiarity with low-code platforms (e.g., Mendix) and their data patterns.
SENIOR IT ARCHITECT - 06800
Qualifications
1. A baccalaureate degree from an accredited college and six years of satisfactory full-time experience related to the area(s) required by the particular position; or
2. Education and/or experience which is equivalent to "1" above.
Additional Information
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.
Job Description
About TRS
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.
Position Summary
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. If you thrive on innovation, high-stakes reliability, and ensuring data integrity in a hybrid environment, this is your opportunity to make a lasting impact.
Key Responsibilities
Cloud Architecture & Optimization
-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.
Data Protection & Resilience
-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.
Security & Compliance Leadership
-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.
Advanced Database Administration
-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.
Scalability & Modernization
-Evaluate and implement modern database architectures, server configurations, and migration strategies.
-Drive modernization initiatives that support high-scale, evolving applications.
Data Integration & Reporting
-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.
Monitoring & Operational Excellence
-Proactively monitor database health, performance, security, and recoverability using industry-leading tools.
-Identify and resolve issues before they impact service availability.
Cross-Functional Collaboration
-Partner with developers, QA teams, and application owners to deliver reliable, high-quality solutions.
-Support major production releases, including weekend or off-hours work.
Environment Refresh Expertise
-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.
Preferred Skills in Addition to Minimum Qualifications
-5 years of hands-on experience in database design, administration, performance tuning, security, backup/recovery, and ETL processes.
-Strong expertise in Microsoft SQL Server and PostgreSQL, including installation, configuration, patching, high availability/DR (replication, clustering), SSIS, and SSRS.
-Advanced AWS proficiency, particularly RDS/Aurora PostgreSQL management; AWS Certified Database - Specialty or Solutions Architect certification strongly preferred.
-Experience with hybrid environments, automation/scripting (PowerShell preferred), Windows Server, storage, and security delegation.
-Solid knowledge of cloud database solutions (AWS and Azure), data warehousing, and performance monitoring tools.
-Proven ability to research emerging technologies, conduct root-cause analysis, document standards, and present findings.
-Familiarity with low-code platforms (e.g., Mendix) and their data patterns.
SENIOR IT ARCHITECT - 06800
Qualifications
1. A baccalaureate degree from an accredited college and six years of satisfactory full-time experience related to the area(s) required by the particular position; or
2. Education and/or experience which is equivalent to "1" above.
Additional Information
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.