SQL Developer

SQL Developer NTT DATA Services is seeking a SQL Developer to join their team in King Of Prussia, Pennsylvania (US-PA), United States (US). The SQL Developer will focus on development, maintenance, and support of Platform applications. This role will be responsible for delivery of critical product requirements and will interact with a culturally and technically diverse team, which includes.Net developers, SQL developers, QA and product management teams. Functions/Responsibilities: 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. Assess the impact of software changes and new development on other systems; conduct integration tests to mitigate risks. Mentor junior team members and participate in and promote a knowledge-sharing environment. Required Qualifications: 5+ years of related experience; or equivalent combination of education and experience 5+ years Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns) 5+ years Experience with Advance SQL development skills. 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 complex SQL queries, stored procedures, functions and triggers. 5+ years of experience with SQL BI stack or SSRS, SSIS and PowerBI. 5+ years of experience in source controls GitHub and bitbucket. Preferred Qualifications: Knowledge in scripting/programming 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). Performance tune complex queries and query optimization. Developing Dynamic SQL and stored procedures. Using indexes to speed up the SQL queries. 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 database. Full Text Searching Developing ERD – both physical and logical. Strong experience with Agile methodologies Skill for writing reusable functions, views and database objects. Excellent written/verbal communication, presentation, and listening skills. Excellent collaboration/teamwork skills. Understanding of fundamental design principles for building a scalable application Familiar with various design and architectural patterns. NTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this role is $83,520.00 to $125,280.00. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidate's actual work location, relevant experience, technical skills, and other qualifications. This position may also be eligible for incentive compensation based on individual and/or company performance. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. Sierra Systems, An Ntt Data Company