Senior Database DeveloperEngineer

Job Description:

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 datarelated technical issues.
Working closely with application developers and business teams at all levels to assist with datarelated technical issues and help ensure the successful designing and delivering data driven solutions.
Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment.
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.

Skills

Must have

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. This job involves analyzing existing databases and the clients needs to develop effective data driven solutions.
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.
Handson 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

Monitor and perform tuning on complex ETL jobs using metadata/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 selfmanagement 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 TestDriven 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.


Education

BS or equivalent in engineering or related technical area
Masters degree preferred