Senior SQL Developer (Expert Level / FTE / Onsite)

NTT DATA
Jersey City, NJ
Job Description
Role Overview

We are looking for a seasoned Senior SQL Developer to join our data engineering team. In this role, you will serve as a subject matter expert in relational database design, development, and optimization — driving best practices across the organization and mentoring junior developers. You will work closely with data architects, analysts, and business stakeholders to deliver robust, scalable, and high-performance data solutions.

What You Will Do

Design, develop, and maintain complex SQL queries, stored procedures, functions, triggers, and views across large-scale relational databases. Perform deep-dive query performance tuning using execution plans, indexing strategies, query rewrites, and statistics analysis.

Why It Might Be a Fit

10+ years of hands-on experience writing and optimizing complex SQL in production environments. Deep expertise in at least one enterprise RDBMS platform — Microsoft SQL Server or Oracle (proficiency in both is a strong plus).

Requirements

  • 10+ years of hands-on experience writing and optimizing complex SQL in production environments
  • 10+ years of Deep expertise in at least one enterprise RDBMS platform — Microsoft SQL Server or Oracle (proficiency in both is a strong plus)
  • 10+ years of Advanced knowledge of indexing strategies (clustered, non-clustered, covering indexes, columnstore), execution plan analysis, and query optimizer behavior
  • 10+ years of Proven experience with stored procedures, CTEs, window functions, dynamic SQL, cursors, and advanced T-SQL / PL-SQL constructs
  • Strong understanding of database design principles — normalization, referential integrity, partitioning, and data modeling (ER diagrams)
  • 10+ years of Experience with ETL tools and data pipeline development (SSIS, Informatica, dbt, or equivalent)
  • Familiarity with high-availability and disaster recovery configurations (Always On, RAC, mirroring, log shipping)
  • Solid understanding of ACID properties, transaction management, and concurrency control

Benefits

  • equal opportunity employer
  • qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status
]]>