Sql Developer

Job Title: SQL Developer
Location: Newark, NJ (Onsite)
Job type: Contract

Job Summary

We are looking for an experienced SQL Developer responsible for designing, developing, maintaining, and optimizing database solutions. The ideal candidate should have strong SQL programming skills, experience in writing complex queries, developing stored procedures, and optimizing database performance. The candidate will work closely with development, data engineering, and business teams to ensure efficient data management and database operations.

Key Responsibilities

• Design, develop, and maintain SQL queries, stored procedures, functions, triggers, and views.
• Write complex SQL queries to retrieve, manipulate, and analyze large volumes of data.
• Optimize SQL queries and database performance through indexing, execution plans, and query tuning.
• Develop and maintain database objects to support business applications and reporting requirements.
• Perform database troubleshooting, debugging, and performance tuning.
• Work on data extraction, transformation, and loading (ETL) processes.
• Ensure data integrity, consistency, security, and accuracy across databases.
• Collaborate with application developers, business analysts, and data engineering teams.
• Participate in database design, development, testing, and deployment activities.
• Create and maintain technical documentation for database objects and processes.

Required Technical Skills

• Strong hands-on experience with SQL programming.
• Expertise in writing complex SQL queries, joins, subqueries, and CTEs.
• Experience developing stored procedures, functions, triggers, and views.
• Strong knowledge of database concepts, normalization, and relational database design.
• Experience with query optimization and performance tuning.
• Hands-on experience with one or more database platforms:
  • Microsoft SQL Server
  • Oracle
  • PostgreSQL
  • MySQL
• Knowledge of indexing, execution plans, and database optimization techniques.
• Experience with data migration, ETL, and data validation.