SQL Developer

US-CA-Irvine
Req No.
2017-2074
Category
Information Technology
Type
Regular Full-Time

Overview

The SQL Developer is responsible for development of SQL view, tables, or stored procedures used by internal applications. They will also be required to design and code new interfaces which will map data and propagate the data into standard production tables, as well as enhance, troubleshot and fix issues that arise with existing interface code. They will analyze and problem-solve issues with current and planned systems as they relate to the integration and management of patient data (for example, review for accuracy in record merge, unmerge processes).

This is a full-time position, based in the Concerto Healthcare offices in Irvine. SQL Developer will report to the Director of Data Solutions.

Responsibilities

  • Act as liaison between information technology and business units. Interpret business requirements and, with developers’ input, design new database functionality.
  • Develop strategies for data acquisitions, archive recovery, and implementation of a database.
  • Design and manage the enterprise data warehouse - data marts, facts and dimensions
  • Design, develop and unit test new database code to support requirements, using database triggers, stored procedures and views.
  • Migrate data by writing data extract, transforming, and loading routines for both loading new data as well as performing migration.
  • Troubleshoot and resolve database performance issues.
  • Monitor production sizing information in order to possibly prevent future performance issues.
  • Assist application developers in writing complex queries to optimize performance.
  • Lead and mentor team members and customers in best practices and techniques to implement and manage a Data Warehouse system.

 

Job Complexity:

The SQL Developer will work with operational support to understand data requirements surrounding the exchange and reporting of data as well as with engineering for necessary table structure or other code needed to support those data requirements yet ensure optimal performance and scalability. The SQL Developer will need to execute against projected plans while meeting changing production needs and requirements.

 

Qualifications

Education:

·         Bachelor’s degree in Computer Sciences, Computer Engineering, Computer Information systems, or work equivalent.

 

Experience:

·         5+ years of SQL development.

  • 3+ Experience in data integration within the Healthcare Provider and Managed care space
  • An ability to understand front-end user’s requirements and a problem-solving attitude.

 

Specialized Abilities:

·         Advanced SQL Server with demonstrated capability using MS SQL.

·         Previous experience working in Healthcare will be preferred

 

Skills:

·         Excellent analytic and problem solving capabilities.

·         Good organizational, interpersonal and team skills.

·         Attention to detail

·         Good written and verbal communication skills.

 

 

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed