Database Administrator in Malden, Massachusetts at Cambridge Health Alliance

Location: Commerce Place
Category: Information Technology
Department: IT Web Development
Job Type: Full Time
Union Name: Non Union

Work Schedule: Day
Length Of Shift(s) In Hours: 8
Shift Details: Mon-Fri 8:00a-4:30p
Hours/Week: 40
Weekend Requirements: No
Holiday Requirements: No
On Call Requirements: No

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.

• 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.

• 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.

• 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.

• 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.

• 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

Please note that the final offer may vary within the listed Pay Range, based on a candidate's experience, skills, qualifications, and internal equity considerations.

In keeping with federal, state and local laws, Cambridge Health Alliance (CHA) policy forbids employees and associates to discriminate against anyone based on race, religion, color, gender, age, marital status, national origin, sexual orientation, gender identity, veteran status, disability or any other characteristic protected by law. We are committed to establishing and maintaining a workplace free of discrimination. We are fully committed to equal employment opportunity. We will not tolerate unlawful discrimination in the recruitment, hiring, termination, promotion, salary treatment or any other condition of employment or career development. Furthermore, we will not tolerate the use of discriminatory slurs, or other remarks, jokes or conduct, that in the judgment of CHA, encourage or permit an offensive or hostile work environment.