Data Administrator
Job Description
SALARY RANGE (Grade 14A) CSA311: $87,293.31/yr. -- $130,530.11/yr (Commensurate with experience)
GENERAL STATEMENT OF DUTIES
The Office of the State Auditor (OSA) operates within a hybrid data environment that includes both on-premises Microsoft SQL Server and Azure Government (GCC) cloud services. The Database Administrator (DBA) plays a key role in securely operating, optimizing, and evolving these platforms. This position supports the full lifecycle of data management across on-premises and cloud systems, aligns operations with data governance and DevOps best practices, and collaborates closely with architecture and security teams to deliver reliable, cost-effective, and compliant data services.
The DBA serves as a technical consultant to development teams, maintains and enhances mission critical databases, and ensures the integrity, performance, and availability of OSA's data assets across internally developed applications, third-party systems, and data warehouse solutions
SUPERVISION RECEIVED
Receives supervision and direction from the Assistant Director of IT, Development, and Special Projects
SUPERVISION EXERCISED
Provides technical supervision over 1-3 contract personnel on an as needed or by project basis
DUTIES AND RESPONSIBILITIES
• Install, patch, upgrade, secure, and manage MS SQL Server database hosts, including Azure-related database technologies.
• Maintain an accurate inventory of all servers, databases, and Azure data services; ensure lifecycle management and adherence to naming conventions and organizational standards.
• Create new and maintain existing PowerShell and DOS scripts used to monitor database availability and health.
• Troubleshoot database issues, recovery, and resolve SQL Server errors and failures.
• Provide high availability, performance tuning, and proactive maintenance for new and existing databases.
• Assist OSA IT employees charged with managing storage for on-premises and Azure database-related services, including monitoring utilization, organizing storage layout, and supporting archival and data retention processes.
• Assist OSA developers with performing ad hoc data loading and data manipulation tasks as needed.
• Maintain and improve backup and recovery strategies, ensuring systems meet OSA business continuity and disaster recovery requirements.
• Administer and enhance database security configurations, including encryption at rest and in transit, firewall rules, and vulnerability remediation.
• Manage database access control mechanisms, implement RBAC, and maintain service or managed identities in alignment with OSA security policies.
• Configure and administer SQL Server Auditing across all databases.
• Create, schedule, and monitor SQL Server Agent jobs and other automated processes supporting applications, data exchanges, and ETL/ELT workloads.
• Administration and deployment of ETL processes and data pipelines powered by SQL Server, SSIS, Azure Data Factory, or GitHub Actions.
• Manage database schemas, indexes, constraints, and related metadata to optimize application performance and maintain integrity.
Want more jobs like this?
Get Data and Analytics jobs in Waltham, MA delivered to your inbox every week.
• Provide guidance to development teams on database standards, conventions, and best practices.
• Lead or support projects involving database related technologies.
• Work closely with system administrators, developers, and other IT staff to troubleshoot, enhance, and support enterprise applications and data services.
• Research and evaluate emerging database services and technologies to recommend improvements.
The Office of the State Auditor is committed to providing equal employment opportunities. Employment actions such as recruiting, hiring, training, and promoting individuals are based upon a policy of non-discrimination. Employment decisions and actions are made without regard to race, color, gender, religion, age, national origin, ancestry, sexual orientation, gender identity and expression, disability, military status, genetic information, political affiliation, or veteran's status.
Qualifications
SALARY RANGE (Grade 14A) CSA311: $87,293.31/yr. -- $130,530.11/yr (Commensurate with experience)
MINIMUM QUALIFICATIONS
The successful candidate will possess and/or demonstrate:
• A Bachelor's Degree in a technology related area, including Information Systems, Engineering, or Mathematics.
• 5-10 or more years administering and securing Microsoft SQL Server
• MS SQL, Azure database-related services, PostgreSQL, Native SQL, and Rubrik for database backup and recovery
• Experience with performance tuning, query and index optimization, and workload right-sizing.
• Proficiency with SQL Server monitoring tools and exposure to TSQL, including stored procedures and triggers.
• Strong communication, organizational skills, and ability to collaborate effectively across the organization.
• Demonstrated experience with process improvement through prior technical implementations.
• Strong knowledge of security best practices to protect sensitive information
• Understanding of business continuity and disaster recovery practices
PREFERRED QUALIFICATIONS
• Five or more years of SQL Server platform experience with advanced DBA responsibilities.
• Experience supporting small to mid-size organizations with diverse database needs.
• Experience working with audit, healthcare, or government data.
• Hands-on experience with ETL and data pipeline technologies such as SSIS, Azure Data Factory, and GitHub Actions.
• Experience with GitHub and Git based workflows.
• Experience administering platforms supporting business intelligence tools (SSAS, SSRS, Power BI).
The Office of the State Auditor is committed to providing equal employment opportunities. Employment actions such as recruiting, hiring, training, and promoting individuals are based upon a policy of non-discrimination. Employment decisions and actions are made without regard to race, color, gender, religion, age, national origin, ancestry, sexual orientation, gender identity and expression, disability, military status, genetic information, political affiliation, or veteran's status.
Perks and Benefits
Health and Wellness
- Health Insurance
- Health Reimbursement Account
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Long-Term Disability
- FSA
- HSA
- Mental Health Benefits
Parental Benefits
- Adoption Assistance Program
- Family Support Resources
Work Flexibility
- Flexible Work Hours
- Hybrid Work Opportunities
Office Life and Perks
- Commuter Benefits Program
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Volunteer Time Off
Financial and Retirement
- Pension
- Financial Counseling
Professional Development
- Promote From Within
- Mentor Program
- Access to Online Courses
- Lunch and Learns
- Internship Program
- Leadership Training Program
- Associate or Rotational Training Program
Diversity and Inclusion
- Diversity, Equity, and Inclusion Program