Data Performance & Integrity Specialist

Information Technology Santa Ana, California


Dynamic Healthcare Systems, a leading provider of enterprise-wide solutions (SaaS) to health plans and health systems, is hiring a Data Performance and Integrity Specialist.

The Data Performance and Integrity Specialist specializes in designing and developing database programs and systems, maintaining, and updating them regularly. As the Data Performance and Integrity Specialist you’ll be responsible for understanding project needs and guidelines, establishing and implementing test systems to identify potential risks and issues, fixing and upgrading components, and storing data according to protocols. You might also produce and present reports to managers and participate in creating security and recovery plans to protect company data.

Key Responsibilities:

  1. Oversight of Dynamic’s database environment, including development and leadership of appropriate governance, development and institution of requisite policies and procedures, establishment of sustainable and effective means of quality performance monitoring, and training of partners on the principles of data integrity and performance.
  2. Develop, manage, and execute import and update scripts, ETL and jobs supporting Dynamics Integration team.
  3. Support development team efforts creating and modifying database schema and procedures maintaining standards, compliance, and performance.
  4. Serve as the primary Point of Contact for Dynamic’s database environment and Subject Matter Expert for data integrity and performance.
  5. Work with analysts, team members, and stakeholders to understand software requirements, and ensure applications are developed according to specifications, including those defined by CMS for Medicare Advantage health plans and health systems.
  6. Develop and implement procedures and policies to support the operation of database management systems according to performance and data integrity requirements. 
  7. Tune SQL queries and overall database performance for Dynamic applications and troubleshoot problems, whether due to data or software, working to rapidly implement repairs. Maintain and develop SQL server databases and custom applications and windows service applications.
  8. Support SSRS reporting stored procedures using grouping, totals, sub-reports, expressions, adding actions. 
  9. Provide database analysis, design, and support for software development and develop successful backup strategies base on recovery model for accomplishing optimal data safety and to ensure nil loss of information.

Required Education, Experience and Skills:

  1. Bachelor’s degree (or higher) in Computer Science or related technical discipline, or the equivalent combination of education and work experience.
  2. Minimum of seven (7) years of professional experience in a database administration, development, or equivalent role.
  3. Expert level knowledge of MS SQL Server; T-SQL (schema, table, stored procedure); MS SQL Server SSIS; MS SQL Server SSRS; and MS SQL Server Data Analytics
  4. Full Software Development Life Cycle experience

Preferred Skills:

  1. Message Queues: JMS, AMQP, Rabbit MQ
  2. Enterprise Architect experience
  3. Continuous Integration systems (Jenkins, Hudson, etc.)
  4. High volume transactions systems/Batch processing
  5. Healthcare Informatics domain knowledge

 

This is a direct hire, full-time position. No third-party agencies please.