Software Development Specialist

Company Overview

NTT DATA strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a professional to join our team in Jersey City, New Jersey (US-NJ), United States (US).

About the Role

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.

Key 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.

Required Skills & Qualifications

• 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.

About NTT DATA

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize, and transform for long-term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation, and management of applications, infrastructure, and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an 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. For our EEO Policy Statement, please click here. If you’d like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.