SQL Developer w2

$128,024 - $133,786/Yr

Creed Infotech - Jersey City, NJ

Full-time

Jersey City, NJ

About the position

The SQL Developer position at Creed Infotech involves strong SQL Server development experience, focusing on the analysis, design, and mentoring of the team in creating OLAP database schemas. The role requires designing various database objects and optimizing SQL queries to enhance application performance.

Responsibilities

• Analyze, design, and mentor the team on OLAP database schema design.
• Design tables, stored procedures, views, indexes, user-defined functions, and other database objects for Tier 1 and Tier 2 applications.
• Analyze and performance tune SQL queries to reduce response time without impacting application performance.
• Implement and document best practices for database object creation, maintenance, performance tuning, and optimization.
• Develop and document data quality, data discovery, and data lineage measures.
• Experience in CI-CD (Jenkins/DACPAC) deployments.

Requirements

• Strong SQL Server development experience (10 years).
• Experience in designing OLAP database schemas.
• Ability to analyze and performance tune SQL queries.
• Experience with CI-CD deployments (Jenkins/DACPAC).
• Preferred experience in Informatica or SSIS development.

Nice-to-haves

• Experience in Informatica (1 year preferred).
• Experience in SQL (1 year preferred).
• Experience in data warehouse (1 year preferred).

Benefits

• 401(k)
• Dental insurance
• Health insurance