Senior SQL Developer

The Senior SQL Developer (SQL Server + PostgreSQL) will take full ownership of SQL development, performance tuning, execution plan analysis, and database structure improvements across both SQL Server and PostgreSQL environments.

• Design and implement complex stored procedures, functions, and SQL scripts
• Lead performance tuning across both SQL Server and PostgreSQL
• Analyze and optimize execution plans, indexes, and schema design
• Work independently with product team to translate requirements into efficient SQL solutions
• Troubleshoot and resolve production performance issues
• Support ETL processes, data pipelines, and staging systems
• Maintain data quality, integrity, and consistent performance across environments
• Recommend improvements to table structures, indexing strategies, and partitioning

• 7+ years of SQL development experience
• Strong, senior-level expertise in SQL Server (T-SQL)
• Strong experience with PostgreSQL (PL/pgSQL)
• Deep knowledge of indexing, execution plans, statistics, and concurrency
• Proven experience tuning large tables (millions to billions of rows)
• Ability to independently gather requirements and deliver complete SQL solutions
• Strong communication skills to work directly with product and engineering teams

Preferred Skills:

• Experience with AWS RDS / Aurora
• Experience with high-availability, replication, or partitioning
• Exposure to .NET or backend development patterns (bonus)

Position Salary: $120K-$160k depending on experience

We offer a highly competitive salary, and a generous comprehensive benefits package, including PTO, 401k sponsored plan, and Health/Dental insurance.

Join us and make a difference every day.

Z-Pax is committed to a diverse and inclusive workplace. We are an equal opportunity employer and do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.