Sr./ Lead SQL Developer

Job Description:
Senior SQL Developer/ Lead
The Senior SQL Developer will primarily focus on development, maintenance, and support of Platform applications. This role will be responsible for delivery of critical product requirements and will be interact with a culturally and technically diverse team, which includes .Net developers, SQL developers, QA and product management teams.

Job Duties:

• Performance tune complex queries and query optimization.
• Developing Dynamic SQL and stored procedures.
• Using indexes to speed up the SQL queries.
• Developing ERD - both physical and logical.
• Can 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.

• SQL queries, stored procedures, functions and triggers.
• Experience with SQL BI stack or SSRS, SSIS and SSAS.
• Must have experience in source controls 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)
• Advance SQL development skills like -
• 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
• Proficiency in writing complexGitHub and bitbucket.
• Knowledge in scripting/programing languages: PowerShell, Bash, Python.
• High level of knowledge of Windows Server and WSFC with an understanding of things needed to manage HA and DR as well as troubleshoot performance and connectivity.
• Extensive experience with 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).
• Experience with MSDTC and MSMQ - Triage MSDTC issue Triage private queues of MSMQ issues.

About NTT DATA Services:

NTT DATA Services is a recognized leader in IT and business services, including cloud, data and applications, headquartered in Texas. As part of NTT DATA, a $30 billion trusted global innovator with a combined global reach of over 80 countries, we help clients transform through business and technology consulting, industry and digital solutions, applications development and management, managed edge-to-cloud infrastructure services, BPO, systems integration and global data centers. We are committed to our clients' long-term success. Visit nttdata.com or LinkedIn to learn more.

NTT DATA Services 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.