Senior Database Developer/Engineer

*Project Description
Responsibilities:
• Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
• Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
• Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering data driven solutions.
• Provide solutions to promote data integrity in enterprise systems.
• Participate in code reviews to validate effectiveness and quality of code.
• Liaise with developers to improve applications and establish best practices.
• Publish documentation and collaborative information using internal tools.
*Mandatory Skills Description
prasanna@myspgcs.com
• Expertise in Database Architecture in an environment that handles large volume of data, excess of 500 million of new data records every day.
• Strong analytical and organizational skills. 
• Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions.
• Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures
• Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
• Hands-on development experience in SQL Server 2016 or above using SSIS and SSRS
• Experience in troubleshooting and resolving data related issues.
• Excellent oral and written communication skills
• Expertise in performance tuning especially tuning complex queries, procedure, and indexing strategies
*Nice-to-Have Skills
• Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
• Performance tuning experience using 3rd party tools
• Audit/compliance experience in highly regulated environment.
• Experience using Jira & Confluence as part of development life cycle
• Experience with Business Intelligence tools like Tableau, SSRS, Power BI etc.
• Familiar with Continual Improvement processes
• Familiar with Git Experience
• 8 years + relational database and SQL experience
• Creativity, curiosity, initiative, and self-management are key attributes candidate embodies.
• Solid experience (4 years +) in coding complex SQL queries and stored procedures. The ability to explain the details of performance tuning internals of the database.
• Strong understanding of database development methodologies (Source Control, Continual improvement, Release Management, Agile and Scrum)
• Experience with Continuous Integration Tools (Jenkins, TeamCity, Bamboo) and Test-Driven Development (TDD) a big plus
• Experience with Red Gate Tools a plus (SQL Source Control, SQL Compare, SQL Data Compare, DLM)
• Health care domain knowledge a big plus.