Senior Database Developer

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
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
Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters

Skills:

Expertise in Database Architecture in an environment that handles large volumes 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 client's 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
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
Performance tuning experience using 3rd party tools
Audit/compliance experience in a 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
8 years + relational database and SQL experience
Creativity, curiosity, initiative, and self-management are key attributes a 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
Healthcare domain knowledge is a big plus
BS or equivalent in engineering or related technical area

Benefits:

🌟 Design, develop and optimize large, complex DB schemas, SQL scripts and objects
🚀 Working with stakeholders including data, design, product, and executive teams
💡 Working closely with application developers and business teams
📈 Implement processes and procedures for the development and release of products/projects
💻 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
🔄 Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters