Linked In

  • Opportunity

    our quality team can
    enhance your career

  • 1


SQL Developer

Location: Aliso Viejo, CA
Our direct client is actively seeking a SQL Developer for their office located in Irvine, CA.

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, troubleshoot 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). The Sr. SQL Developer is responsible for development of reporting systems and ETL processes.

  • 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.
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.

This is exciting team that operates with a lot of energy.  They set very ambitious goals and work hard to deliver superior security.  This team is looking forward to bringing in new ideas and experiences to the team to strengthen it further.
For immediate consideration please submit your resume in Word format, along with daytime contact information.  LOCAL CANDIDATES ONLY PLEASE unless you are willing to relocate yourself at your own expense.  Client is unable to provide H-1B Visa sponsorship at this time. All submittals will be treated confidentially.  Selected candidate may be asked to pass a comprehensive background, credit and/or drug screening.  Principals only, no third parties please.
Established in 2000, Atrilogy Solutions Group, Inc. provides organizations of all sizes with high-quality, cost effective information technology (IT), business process and health care consulting and staffing services.  Our industry-leading service model combines experienced project managers with seasoned technical and functional consultants to eliminate client uncertainty and deliver superior value and results.
Clients turn to Atrilogy for expertise in:
  • IT staffing and placement (Project Managers, Business Analysts, DBA’s, Developers, Quality Assurance and Testing, Software Configuration Management, etc.)
  • All major Enterprise Resource Planning packages (including Oracle, PeopleSoft, JD Edwards, SAP, Microsoft, Lawson)
  • Health care consulting resources and services (including ICD-10)
  • Customer Relationship Management (CRM)
  • Creative (Interactive Project Manager/Art Director, Information Architect, UI/UX Designer, Web/Graphic Design)
Atrilogy has been recognized by CRN magazine as one of the nation’s fastest-growing IT solution providers and by Inc. magazine as one of the nation’s fastest-growing, privately-held companies. Based in Irvine, California, Atrilogy also has offices in Denver, Phoenix, and Atlanta.
this job portal is powered by CATS