Sr.Database Developer

Roles & Responsibilities

• Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.
• Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.
• Create SQL Server Reporting Services reports.
• Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.
• Diagnose and resolve database performance issues.
• Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standard best practices.

Experience Required

• Experience with data modeling tools such as ER/Studio or ERWin.
• Experience using version control systems (e.g., TFS, Git).
• Familiar with Agile software development process.
• Working experience with Azure DB technologies and Azure deployments is a plus.
• Experience in the healthcare industry is a plus.

Skills & Certifications

• Experience or Equivalent: 8+ years of experience working with Microsoft SQL Server with emphasis on database code, ETL and Reporting Services development.
• Knowledge, Skills, and Abilities Requirements: Database design skills including normalization and data warehouse design; Strong hands-on T-SQL development skills including stored procedure, function, and trigger creation; Excellent query optimization and performance tuning skills; Extensive experience developing SSRS reports; Strong SSIS skills; Detailed analytical skills; Structured troubleshooting skills.
• Toolset: Microsoft SQL Server 2012 and above; Microsoft SQL Server Integration Services (SSIS); Microsoft SQL Server Reporting Services (SSRS); Microsoft Visual Studio 2012 and above; Embarcadero ER/Studio is a plus.

Physical/Mental Requirements

• Ability to communicate clearly both verbally and in writing.
• Ability to analyze complex application and business operational issues.
• Ability to multi-task and respond to quickly-shifting priorities.
• Ability to work in a team and/or independently.