Sr. SQL Developer/ Lead

Req ID: 289166 

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 Sr. SQL Developer/ Lead 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

#LI-PAS

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 is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.