About TRS Since 1917, the Teachers’ Retirement System of the City of New York (TRS) has helped secure the retirement futures of New York City educators. TRS administers the Qualified Pension Plan (QPP), a defined benefit plan, and the Tax-Deferred Annuity (TDA) Program, and provides retirement, disability, and death benefit services to members.
TRS is committed to a member-centered culture, grounded in operational excellence, service quality, accountability, and continuous improvement.
Position Summary The Senior Developer
- SQL and Mendix will be responsible for designing, developing, optimizing, and supporting database solutions, data integration pipelines, ETL processes, and low-code application components that support TRS business operations and enterprise systems.
The ideal candidate will have extensive hands-on experience with Microsoft SQL Server, IBM i DB2, Amazon RDS for PostgreSQL, SSIS, data migration, data bridging, and production deployment processes. The role requires strong technical expertise in T-SQL development, performance tuning, indexing strategies, enterprise application integration, and data integration across complex systems.
The Senior Developer will work closely with application development teams, production support teams, database teams, and business stakeholders to deliver reliable, scalable, and high-performing data solutions across development, test, and production environments.
Key Responsibilities
- Design, develop, and maintain data integration pipelines across enterprise applications using IBM i DB2, Microsoft SQL Server, and PostgreSQL database systems.
- Operationalize data integration pipelines and govern their operational aspects, including monitoring, reliability, performance, error handling, and ongoing maintenance.
- Design, develop, and maintain T-SQL scripts, stored procedures, functions, and views to support business processes, application functionality, and data operations.
- Develop and optimize complex SQL queries that operate on large production datasets, ensuring accuracy, reliability, scalability, and performance.
- Develop, maintain, and support Microsoft SSIS packages for ETL processes, including source-to-target data flows, staging, transformations, logging, error handling, and incremental data loads.
- Design and implement indexing strategies for high-volume transaction tables, including clustered indexes, nonclustered indexes, filtered indexes, indexed views, and partitioning recommendations.
- Monitor and tune database performance using execution plans, statistics, query optimization techniques, parameter sniffing mitigation, and index maintenance practices.
- Support data migration and data bridging activities across enterprise systems, including forward and backward bridging of data.
- Collaborate with application development teams to translate business and application requirements into reliable database objects, integration processes, and deployment-ready SQL artifacts.
- Support deployments of SQL scripts, database objects, and SSIS packages across lower environments and production, including deployment validation and rollback planning.
- Work with Sagitec’s Neospin Framework to develop, support, and optimize SQL components that integrate with .NET-based pension systems.
- Work with the Mendix platform to develop, support, and optimize platform components that integrate with Mendix-based pension systems.
- Create and support data models, data sources, and analytical reporting solutions using Tableau.
- Contribute to repeatable deployment processes, environment promotion, change control, production readiness, and operational documentation.
Benefits of Working for the City of New York:
- Flexible Work Arrangements: Hybrid work schedules offer a balanced combination of remote and in-office work, promoting a healthy work-life balance.
Comprehensive Health Benefits: Access to excellent healthcare coverage, including medical, dental, and vision plans.
- Retirement Plans: Robust pension plans, including the New York City Retirement Systems (NYCERS), and NYC Deferred Compensation (401k and 403b) providing financial security post-retirement.
- Commuter Benefits: Enjoy pre-tax deductions for eligible commuting expenses, reducing your taxable income and saving you money.
- Professional Development: Opportunities for continuous learning and career advancement through various training programs and workshops.
- Competitive Salaries: Competitive compensation packages commensurate with experience and responsibilities.
- Paid Time Off: Generous paid leave policies, including vacation days, sick leave, and holidays.
- Work-Life Balance: Programs and policies supporting a balance professional and personal life.
- Career Growth: Long-term career prospects supported by a stable and well-established city government.
- Public Service Loan Forgiveness (PSLF): Eligibility for federal loan forgiveness programs and state repayment assistance programs, while working full-time for a qualifying employer like the City of New York.
- Diverse Work Environment: Inclusive and diverse workplace culture, reflecting the vibrant city of New York.
Minimum Qualifications
- 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; or
- 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; or
- Education and/or experience which is equivalent to "1" or "2" above.
Preferred Skills
- Strong experience with IBM i DB2, Microsoft SQL Server, and Amazon RDS for PostgreSQL database systems and services.
- A minimum of 10 years of hands-on SQL Server development experience, including production experience with stored procedures, functions, views, and complex queries.
- Strong experience with SQL development, ETL technologies such as Microsoft SSIS, and production deployment processes.
- Experience creating data migration and data bridging scripts across DB2, SQL Server, and PostgreSQL.
- Experience with data integration across enterprise applications and heterogeneous database platforms.
- Working knowledge of low-code development platforms, preferably Mendix version 10 or higher.
- Proficiency with Microsoft SSIS, including package design, debugging, deployment, logging, error handling, and performance tuning.
- Strong database performance tuning experience, including query optimization, execution plan analysis, indexing, partitioning concepts, and index maintenance.
- Hands-on experience with Tableau, including creating data models, data sources, and analytical reports.
- Experience supporting deployment processes, including environment promotion, change control, release coordination, and rollback planning.
- Familiarity with enterprise application development and data integration.
- Hands-on experience with Sagitec’s Neospin Framework for .NET-based pension systems.
- Experience with SQL Server Agent, SSRS, and basic PowerShell scripting for automation.
- Understanding of data governance, data quality, and security practices for production databases.
- Experience working in pension, retirement, benefits administration, financial services, or other highly regulated environments.
- Strong analytical, troubleshooting, and problem-solving skills, with the ability to diagnose complex data and performance issues.
- Ability to collaborate effectively with application development teams, database teams, business stakeholders, and production support teams.
- Strong written and verbal communication skills, with the ability to explain technical concepts clearly to both technical and non-technical audiences.
Residency Requirement
New York City Residency is not required for this position