Job Summary:
NTT DATA is a global innovator of business and technology services, currently seeking a Senior SQL Developer to join their data engineering team in Jersey City, New Jersey. The role involves serving as a subject matter expert in relational database design and development, while mentoring junior developers and delivering high-performance data solutions.
Responsibilities:
• 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.
• Identify and resolve bottlenecks, long-running queries, and resource-intensive operations in production environments.
• Establish and enforce SQL coding standards, naming conventions, and best practices across the team.
• Lead the logical and physical design of database schemas, including normalization, partitioning strategies, and data modeling.
• Develop and maintain complex reports, dashboards, and data extracts for business intelligence and operational needs.
• Monitor database health, performance metrics, and capacity planning to proactively address issues before they impact operations.
• Manage database backups, recovery procedures, and ensure compliance with data retention policies.
• Handle schema migrations, database upgrades, and patch deployments with minimal downtime.
• Implement and maintain database security, including role-based access control and data masking where required.
Qualifications:
Required:
• 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).
• Advanced knowledge of indexing strategies (clustered, non-clustered, covering indexes, columnstore), execution plan analysis, and query optimizer behavior.
• 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).
• 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.
Company:
NTT DATA, Inc. is a trusted global innovator of business and technology services. Founded in 2019, the company is headquartered in Tokyo, JP, , with a team of 10001+ employees. The company is currently Late Stage.