Senior Systems Administrator, Senior Desktop Engineer
Brigham and Women's Hospital
At Mass General Brigham, we know it takes a surprising range of talented professionals to advance our mission—from doctors, nurses, business people and tech experts, to dedicated researchers and systems analysts. As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community. We place great value on being a diverse, equitable and inclusive organization as we aim to reflect the diversity of the patients we serve.
At Mass General Brigham, we believe a diverse set of backgrounds and lived experiences makes us stronger by challenging our assumptions with new perspectives that can drive revolutionary discoveries in medical innovations in research and patient care. Therefore, we invite and welcome applicants from traditionally underrepresented groups in healthcare — people of color, people with disabilities, LGBTQ community, and/or gender expansive, first and second-generation immigrants, veterans, and people from different socioeconomic backgrounds – to apply.
Job Summary
Senior Database Administrator (Mass General Brigham Health Plan; Somerville, MA):The Senior Database Administrator role leads the effort in the maintenance and monitoring of scheduled database and server processes including data loads, user logins, backups, performance monitoring and tuning utilizing Microsoft SQL Servers on both onprem(2016, 2017 & 2019) and Azure cloud (SQL PASS, IAAS & Managed Instances) instances. The Senior Database Administrator implements server upgrades, ensures data integrity, maintains up-to-date data schemas, database contents, and metadata documentation, and defines and administers security policies using Active Directory groups.
Specific responsibilities include: Working with little supervision, assuming immediate day-to-day responsibility for managing multiple MSSQL databases (2016/2017/2019/Azure SQL); Evaluating new releases of OS and database software; Recovering and repairing data systems in the event of data corruption or system failure; Proactively scheduling and facilitating necessary server upgrades to accommodate growth and ensure acceptable system performance and response times.; Writing Transact SQL scripts as needed; Leading efforts and participating in the analysis, design, development, documentation, testing and implementation of SQL server upgrade projects to latest version of SQL Server; Acting as a direct liaison with customers, Technical Services, and developers; Providing support to department management and staff in technical, training and administrative areas; and participating in the development, revision, and implementation of policies, guidelines, standards and procedures, including request management, project management, change management, and standardization requirements; Leading the effort for automating and supporting the daily/weekly/monthly maintenance jobs, monthly Data Warehouse processes, and various day-to-day tasks/activities; Setting up and maintaining replication technologies such as Read Scale Availability Groups; Leading efforts for the support, maintenance and performance of 3rd party applications used in the Finance Department (including Great Plains, Dynamics CRM, SAS etc.), the Human Resources department, and the Help Desk; Monitoring and keeping up-to-date status/activities of all requests logged, ensuring the on-time delivery of performance reports, promptly addressing production control related issues and concerns, and ensuring all system outages or incidents are logged, resolved and followed-up on through to complete resolution; Utilizing strong knowledge of scripting (like T-SQL, PowerShell etc.) to automate various DBA activities and create new solutions for troubleshooting issues; Participating in yearly Disaster Recovery related activities, preparing monthly, yearly and ad-hoc requests, and preparing audit reports for SQL database and other systems access; Position based at company headquarters; Telecommuting from within U.S. permitted pursuant to company policy.
Qualifications
Minimum requirements: Bachelor’s degree in computer science or other quantitative field or equivalent and 5 years of experience in Database Administration or any occupation/title providing experience in health care related development and maintenance including data warehouse modeling, design, development, performance analysis, and programming scripts.
Must have: Demonstrated working knowledge of MS SQL Server 2014 and above, including strong skills in SQL, Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) & PowerBI; Demonstrated experience in database design and architecture; Demonstrated experience using monitoring, reporting and auditing tools like SCOM, Power BI dashboards and Idera SQL Compliance Audit; Demonstrated strong track record of an ability to execute on time, on budget, and on scope; Demonstrated strong aptitude for technology-based solutions; and Demonstrated current knowledge of healthcare trends. (Unless otherwise indicated, employer is seeking the ability in the skills listed above with no specific number of years of experience required. All experience can be gained concurrently.)
Additional Job Details (if applicable)
Remote Type
Work Location
Scheduled Weekly Hours
Employee Type
Work Shift
EEO Statement:
Mass General Brigham Competency Framework
At Mass General Brigham, our competency framework defines what effective leadership “looks like” by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.