> Markdown version of [/jobs/ext/3128215-senior-developer-sql-and-mendix](https://www.wearedevelopers.com/jobs/ext/3128215-senior-developer-sql-and-mendix). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Developer - SQL and Mendix

- **Company:** City of New York
- **Location:** Jersey City, NJ, United States
- **Experience:** Expert
- **Salary:** $155,000.0 - $160,000.0
- **Contract:** Permanent contract
- **Skills:** .NET Framework, Component-Based Software Engineering, IBM System I, BASIC (Programming Language), Information Systems, Databases, Data Governance, Data Integration, Extract Transform Load (ETL), Data Migration, Data Systems, IBM DB2, Database Development, Database Queries, Database Schema, Software Debugging, PostgreSQL, Microsoft SQL Server, Network Architecture, Packet Analyzer, Performance Tuning, Windows PowerShell, Query Optimization, DataOps, Mendix, Software Deployment, Software Engineering, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Agent, SQL Server Integration Services, Data Streaming, Tableau (Software), Transact-SQL, Enterprise Application Integration, Data Logging, Freeform SQL, Enterprise Software Applications, Database Optimization, Database Performance, Indexer, Amazon Relational Database Service, Information Technology, Low-code, Data Pipelines
- **Published:** September 28, 2026
- **Apply:** https://www.careerjet.com/job/us7e6a110dbb46ba9697db2451d0c110c6/eaa

## About the Role

1. 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
 2. 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
 3. 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.
Public Service Loan Forgiveness

## Description

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., 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., 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., Position: Senior SQL BI Developer Location: Jersey city, NJ***Onsite*** Duration: 1 Years Job Summary: Skilled SQL BI Developer responsible for designing, developing, and mai…
 + 14 hours ago
 + Apply easily


## Related Videos

- [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization)
- [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core)
- [Next Level Enterprise Architecture: Modular, Flexible, Scalable, Multichannel and AI-Ready?](https://www.wearedevelopers.com/videos/1017-next-level-enterprise-architecture-modular-flexible-scalable-multichannel-and-ai-ready)
- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option)
- [C++ Features You Might Not Know](https://www.wearedevelopers.com/videos/616-c-features-you-might-not-know)

## Related Articles

- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Fullstack developer salary in Germany [2023]](https://www.wearedevelopers.com/magazine/197-fullstack-developer-salary-in-germany-2023)
- [Software Developer Salary in Switzerland [2023]](https://www.wearedevelopers.com/magazine/215-software-developer-salary-in-switzerland-2023)
- [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)
- [Software Developer Salary in The Netherlands [2023]](https://www.wearedevelopers.com/magazine/217-software-developer-salary-in-the-netherlands-2023)