Database Administrator

Location: Commerce Place | Job Type: Full Time | Union: Non Union | Schedule: Day, Mon–Fri 8:00 a.m.–4:30 p.m. (40 hrs/week), no weekends, holidays, or on‑call

About the role

The Information Technology Department at Cambridge Health Alliance empowers high-quality, equitable, and patient-centered care through innovative and secure health IT solutions. Grounded in CHA’s mission and strategic plan, IT supports clinical, operational, and academic excellence by providing reliable infrastructure, safeguarding health information, and enabling data-driven decision-making. With a future-focused approach, the team works to enhance access, advance health equity, and drive innovation across the system. We are seeking an experienced and proactive SQL Database Administrator (DBA) to join our IT team. In this role, you will be responsible for maintaining the health, performance, and security of our database environment while supporting ongoing data integration needs. You will manage existing ETL pipelines, develop new data ingestion and export workflows for both internal and third-party systems, and collaborate closely with our Systems and Applications teams to onboard new software solutions. Additionally, as we look to modernizing our infrastructure, you will play a key leadership role in guiding our data migration strategy to the cloud.

Responsibilities

• Database Maintenance, Operations & Security
  • Proactively monitor, optimize, and support existing SQL Server instances, jobs, and scheduled tasks to ensure high availability and performance.
  • Manage database security, routine patching (Cumulative Updates / Security Updates), and major version upgrades/migrations.
  • Perform routine health checks, performance tuning, index maintenance, and backup/disaster recovery planning.
• Data Integration & ETL Development
  • Maintain and troubleshoot existing ETL processes and data pipelines.
  • Design, build, and deploy new ETL/ELT routines to import and export data securely between internal systems and external third-party entities.
  • Create and optimize complex SQL queries, stored procedures, functions, and views to support business requirements.
• Third-Party Application Implementation & System Support
  • Partner with Systems and Applications teams to evaluate, implement, and integrate new third-party software applications.
  • Assist in database schema design, permissions provisioning, and data mapping for application deployments.
• Cloud Strategy & Migration Leadership
  • Serve as the technical lead and subject matter expert in moving on-premises database workloads to cloud environments (e.g., Azure SQL, MS Fabric, or GCP).
  • Architect cloud data strategies that ensure scalability, cost efficiency, and security during and after migration.

Requirements

• BS in Computer Science or equivalent experience
• 6+ years IT experience with 4+ years database administration experience in a networked environment with MS SQL Server

Schedule

Day shift, Monday–Friday 8:00 a.m.–4:30 p.m. (8-hour shifts, 40 hours/week). No weekend, holiday, or on-call requirements.