Database Administrator - Programmer II (HYBRID)

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, while also leveraging 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 environments remain 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, APIs, etc.).
• Create ETL workflows using Mirth Connect (NextGen Connect) and ad-hoc scripting where necessary.
• Write code that conforms to industry standards for design and security.
• 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 databases including performance problems, software issues, server related issues and connection issues.
• Work closely with internal and external IT support staff to help resolve incidents or requests.
• Assist users with accessing and using databases and related 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 and programming standards.
• 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