Database Administrator-Programmer II (HYBRID)

Database Administrator/Programmer II

This position will be hybrid and will require some on site work. Applicant MUST reside within a 2-hour radius of our home office in Binghamton NY. No relocation, provided. Applicants must be authorized to work for any employer in the U.S. Care Compass is unable to sponsor employment visas for this role.

Position Summary

Working closely with IT and Analytics team, this role will be responsible for the design, implementation, maintenance, and security of our databases. The position will require programming skills to optimize performance, develop automation scripts, and support application development. This role requires both technical depth in database management and proficiency in programming to ensure seamless integration with business applications. The position will report to the IT Infrastructure Manager and will work closely with the Security Officer to ensure that the database and network environment remains within our HITRUST boundaries.

Responsibilities

The responsibilities of Database Administrator/Programmer II will include the following:

Essential Functions:

• Install, configure and maintain database systems as well as database design, backups, auditing and logging.
• Implement and manage database security, backups, recovery plans, and disaster recovery strategies.
• Develop and maintain automation scripts for routine database tasks using programming languages (Python, PowerShell, Bash, SQL, C#, Java, etc.).
• Previous experience with ETL tools such as Mirth (NextGen), Snowflake, PilotFish, SSDT and others.
• Knowledge of different healthcare related data formats HL7, CCDA, 837, FHiR and others.
• Create ETL workflows using Mirth Connect (NextGen) and ad-hoc scripting where necessary.
• Work closely with the Security Officer and compliance department to ensure all policies, procedures and auditing are in place and adhered to.
• Identify and resolve issues related to database.
• Work closely with internal and external IT support staff to help resolve incidents or requests.
• Assist users with accessing and using database resources.
• Perform regular audits to ensure data integrity, consistency, and compliance with organizational standards.
• Monitor the performance of databases to identify and address potential problems.
• Create and maintain documentation related to database configurations, procedures, and troubleshooting steps.
• Keeping up-to-date with the latest technologies and trends in database management. Also, provide input for recommendations on IT solutions.

Non-Essential Functions:

May assume additional responsibilities as requested.

Minimum Requirements

• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent work experience).
• 3+ years of experience as a Database Administrator.
• Knowledge of HIPAA, HITECH, PHI, PII
• Experience in medical data setting, healthcare quality measures highly desirable.
• Familiar with HITRUST/SSP
• Strong knowledge of MS SQL Server database management. Experience in other database systems (i.e. Oracle, MySQL, MS Fabric, etc.) highly desirable.
• Knowledge of ETL processes, EMPIs, APIs, data warehousing, and database design principles.

License/Certification

• Minimum Required: N/A