SQL Developer

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

Job Role: SQL Developer

Location: Mount Laurel, NJ

Job Description:

Must Have Technical/Functional Skills

• SQL Server / Oracle / PostgreSQL
• Advanced SQL Programming
• Performance Tuning & Query Optimization
• Data Modeling & Database Design
• ETL and Data Integration
• Agile Development Methodologies
• Azure DB, Cosmo DB, Shell scripting, JSON query and data structure
• Auto sys scheduling and Splunk monitoring tool (Nice to have)

Roles & Responsibilities

• Design, develop, and maintain complex SQL queries, stored procedures, functions, and database objects.
• Translate business requirements into efficient and scalable database solutions.
• Optimize query performance and troubleshoot database-related issues.
• Support ETL, data integration, and data validation activities.
• Ensure data accuracy, integrity, and reliability through testing and quality checks.
• Collaborate with development and business teams to deliver high-quality solutions.
• Provide timely updates on technical tasks, risks, and issue resolution.