Lead/Senior SQL Developer - Onsite Hybrid

Req ID: 318985 

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 Lead/Senior SQL Developer - Onsite Hybrid to join our team in King Of Prussia, Pennsylvania (US-PA), United States (US).

 

This position is onsite with hybrid 2-3 days/ week in the office.

 

Role Responsibilities/Accountabilities:

- Help in defining, documenting and developing software, software applications, as well as contributes to architecture and technical design discussions, code reviews and technical design/specifications in collaboration with the project team

- Independently responsible for development, enhancement, testing, support, maintain and troubleshoot/ debug software applications that support business units or support functions

- Create thorough, professional quality project documentation and technical specifications

- Assesses the impact of software changes and new development on other systems; conducts integration tests to mitigate risks

- Mentor junior team members and participates in and promotes a knowledge-sharing environment.

- Performance tune complex queries and query optimization

- Develop Dynamic SQL and stored procedures

- Using indexes to speed up the SQL queries

- Create database schemas that represent and support business processes

- Design and develop objects and components of relational and non-relational database

- Write reusable functions, views and database objects

- Understanding of fundamental design principles for building a scalable application

 

Basic Qualifications: 8+ years with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns)

- In-depth understanding of data modeling best practices, normalization techniques, and database design patterns Advanced Knowledge in Always On, Transactional Replication, Clustering and T-SQL

- Writing complex SQL queries, stored procedures, functions and triggers

- SQL BI stack or SSRS, SSIS and SSAS

- Source controls GitHub and bitbucket

- Windows Server and WSFC with an understanding of things needed to manage HA and DR as well as troubleshoot performance and connectivity

- PowerShell and creating your own modules for management and automation in SQL Server environments (beyond basic use of community created modules such as DBA Tools)

- MSDTC and MSMQ – Triage MSDTC issue Triage private queues of MSMQ issues

- Developing ERD – both physical and logical.

- Agile methodologies

 

Nice to have:

- Familiar with various design and architectural patterns

 

Education:

- Bachelor of Science in Engineering or Computer Science or applicable experience

 

#INDFSINS

#L1-NAM

 

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 ma