Database Administrator-Programmer II (On-site)

Care Compass Network•City of Binghamton, NY

1d•Hybrid

About The Position

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.

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
Familiar with HITRUST/SSP
Strong knowledge of MS SQL Server database management.

Nice To Haves

Experience in medical data setting, healthcare quality measures highly desirable.
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.

Responsibilities

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.
May assume additional responsibilities as requested.