Senior SQL Developer/ Lead - Oaks, PA

NTT DATA - King of Prussia, PA

Full-time - Senior

King of Prussia, PA

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Senior SQL Developer/Lead position at NTT DATA Services is a critical role focused on the development, maintenance, and support of Platform applications. This position requires a highly skilled individual who will be responsible for delivering essential product requirements while collaborating with a diverse team that includes .Net developers, SQL developers, QA professionals, and product management teams. The role is primarily onsite at the SEI office in Oaks, PA, with a hybrid work model allowing for 2-3 days of remote work each week. In this role, the Senior SQL Developer will engage in the full software development life cycle, which encompasses design, testing, deployment, and documentation activities, utilizing agile and scrum methodologies. The ideal candidate will possess advanced SQL development skills, including a deep understanding of data modeling best practices, normalization techniques, and database design patterns. Proficiency in writing complex SQL queries, stored procedures, functions, and triggers is essential, along with experience in the SQL BI stack, including SSRS, SSIS, and SSAS. The Senior SQL Developer will also be responsible for performance tuning complex queries, developing dynamic SQL, and creating database schemas that support business processes. The role requires extensive knowledge of Windows Server and WSFC, as well as experience with PowerShell for management and automation in SQL Server environments. Additionally, the candidate will mentor junior team members, contribute to architecture and technical design discussions, and create thorough project documentation and technical specifications. This position is pivotal in ensuring the successful integration and functionality of software applications that support various business units.

Responsibilities

• Define, document, and develop software applications, contributing to architecture and technical design discussions.
• Independently develop, enhance, test, support, maintain, and troubleshoot/debug 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.

Requirements

• 8 or more years of related experience or equivalent combination of education and experience.
• Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns).
• Advanced SQL development skills, including in-depth understanding of data modeling best practices, normalization techniques, and database design patterns.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Experience with SQL BI stack or SSRS, SSIS, and SSAS.
• Experience in source controls GitHub and Bitbucket.
• High level of knowledge of Windows Server and WSFC, with an understanding of managing HA and DR as well as troubleshooting performance and connectivity.
• Extensive experience with PowerShell and creating custom modules for management and automation in SQL Server environments.
• Performance tuning complex queries and query optimization.
• Experience in creating database schemas that represent and support business processes.
• Extensive knowledge and hands-on experience designing and developing objects and components of relational and non-relational databases.
• Experience with MSDTC and MSMQ, including triaging MSDTC issues and private queues of MSMQ issues.
• Strong experience with Agile methodologies and understanding of SDLC.

Nice-to-haves

• Familiarity with various design and architectural patterns.
• Skill for writing reusable functions, views, and database objects.
• Excellent written/verbal communication, presentation, and listening skills.
• Excellent collaboration/teamwork skills.