Sr. SQL Developer/ Lead

NTT DATA - King of Prussia, PA

Full-time - Mid Level

King of Prussia, PA

10,001+ employees

Professional, Scientific, and Technical Services

About the position

NTT DATA Services is seeking a Sr. SQL Developer/Lead to join our team in King Of Prussia, Pennsylvania. This position is primarily onsite with a hybrid work model allowing for 2-3 days per week in the office. The ideal candidate will be responsible for defining, documenting, and developing software applications while contributing to architecture and technical design discussions. This role requires a strong focus on code reviews and technical specifications in collaboration with the project team. As a Sr. SQL Developer/Lead, you will independently handle the development, enhancement, testing, support, maintenance, and troubleshooting of software applications that support various business units. You will create thorough and professional quality project documentation and technical specifications, assess the impact of software changes, and conduct integration tests to mitigate risks. Mentoring junior team members and promoting a knowledge-sharing environment will also be key responsibilities. Performance tuning of complex queries, developing dynamic SQL and stored procedures, and creating database schemas that represent and support business processes are essential tasks. You will design and develop objects and components of both relational and non-relational databases, write reusable functions, views, and database objects, and apply fundamental design principles for building scalable applications.

Responsibilities

• Help in defining, documenting and developing software applications.
• Contribute to architecture and technical design discussions, code reviews, and technical specifications.
• Independently responsible for development, enhancement, testing, support, maintenance, and troubleshooting of software applications.
• Create thorough, professional quality project documentation and technical specifications.
• Assess the impact of software changes and new development on other systems; conduct integration tests to mitigate risks.
• Mentor junior team members and promote a knowledge-sharing environment.
• Performance tune complex queries and optimize queries.
• Develop dynamic SQL and stored procedures.
• Use indexes to speed up SQL queries.
• Create database schemas that represent and support business processes.
• Design and develop objects and components of relational and non-relational databases.
• Write reusable functions, views, and database objects.
• Understand fundamental design principles for building scalable applications.

Requirements

• 8+ years of experience 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.
• Experience writing complex SQL queries, stored procedures, functions, and triggers.
• Familiarity with SQL BI stack or SSRS, SSIS, and SSAS.
• Experience with source controls like GitHub and Bitbucket.
• Knowledge of Windows Server and WSFC, including management of HA and DR, as well as troubleshooting performance and connectivity issues.
• Proficiency in PowerShell and creating custom modules for management and automation in SQL Server environments.
• Experience with MSDTC and MSMQ, including triaging issues.
• Ability to develop both physical and logical ERDs.
• Familiarity with agile methodologies.

Nice-to-haves

• Familiarity with various design and architectural patterns.