SQL Developer - Performance Tuning & Data Modeling Pro

Ztek Consulting INC; Mount Laurel Township (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

Ztek Consulting INC in Mount Laurel, NJ is seeking a SQL Developer to design, optimize, and maintain complex SQL databases. The role focuses on translating business needs into scalable DB solutions and ensuring data integrity across ETL processes.

Ideal candidates will have strong SQL skills across SQL Server/Oracle/PostgreSQL, data modeling experience, and familiarity with Agile development practices. On-site position in Mount Laurel, NJ with opportunities to leverage Azure Cosmos DB and

Qualifications

• Strong experience with SQL Server, Oracle or PostgreSQL.
• Proficient in advanced SQL programming and optimization.
• Background in data modeling and database design.
• Experience with ETL and data integration processes.
• Familiarity with Agile development methodologies.
• Knowledge of Azure DB or Cosmos DB and scripting basics in shell.

Responsibilities

• Design, develop, and maintain complex SQL queries, stored procedures, and database objects.
• Translate business requirements into scalable database solutions.
• Optimize query performance and troubleshoot DB issues.
• Support ETL, data integration, and data validation activities.
• Ensure data accuracy and reliability through testing and QC.
• Collaborate with dev and business teams to deliver quality solutions.
• Provide timely updates on tasks, risks, and resolutions.

Skills

SQL Server

Oracle

PostgreSQL

Advanced SQL

Performance Tuning

Query Optimization

Data Modeling

Database Design

ETL

Data Integration

Agile

Azure DB

Cosmos DB

Shell scripting

JSON

Splunk (Nice to have)

Job description

Ztek Consulting INC in Mount Laurel, NJ is seeking a SQL Developer to design, optimize, and maintain complex SQL databases. The role focuses on translating business needs into scalable DB solutions and ensuring data integrity across ETL processes.

Ideal candidates will have strong SQL skills across SQL Server/Oracle/PostgreSQL, data modeling experience, and familiarity with Agile development practices. On-site position in Mount Laurel, NJ with opportunities to leverage Azure Cosmos DB and