What are the responsibilities and job description for the SQL Server DBA position at Administrative Office of PA Courts?
SQL Server Database Administrator is responsible for the day-to-day configuration, maintenance, and performance of critical MS SQL Server systems, ensuring the integrity, reliability, and recoverability of data for a wide variety of in-house developed applications and off-the-shelf software. The position requires solid technical skills, as well as excellent interpersonal and communication skills, and involves assuming rotating on-call duties.
The AOPC does not sponsor work visas.
Job Duties
- Manages SQL Server implementations across all environments from development through testing to production.
- Maintains database servers and processes to ensure high levels of integrity, reliability, and recoverability while keeping performance and security in line with industry standards.
- Analyzes, solves, and corrects issues in real time, providing problem resolution end-to-end.
- Automate regular processes, track issues, and document changes.
- Assist in providing 24x7 support for critical production systems.
- Perform scheduled maintenance, which includes the deployment of CUs and Hotfixes outside of regular business hours.
Minimum Qualifications
- Bachelor’s degree with an IT-related major or minor, PLUS
- One year of IT experience involving the analysis, design, and maintenance of databases in support of overall database administration.
- An equivalent combination of education, experience, and/or training may be considered.
Requirements/Preferences
- 3 years MSSQL server administration experience required.
- Extensive experience with backups, restores, and recovery models.
- Proficiency with writing T-SQL code.
- Moderate experience with High Availability (HA) options.
- Moderate experience with Disaster Recovery (DR) options.
- Moderate experience with SSIS (SQL Server Integration Services).
- Moderate experience with SSRS (SQL Server Reporting Services).
- Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools.
- MS Dynamics CRM MSSQL server administration experience.
- SharePoint MSSQL server administration experience.
- TFS MSSQL server administration experience.
- BIS for Visual Studio experience.
- Windows Server administration experience.
- VMWare vSphere experience.
- Satisfactory criminal background check required.
Job Highlights
- Excellent benefits program, including comprehensive, low-cost medical, dental, vision, and prescription plans for employees and eligible family members beginning on the first day of employment
- 13 paid holidays, 12 paid sick days, and 12 paid vacation days per year.
- Salary increases, employee assistance programs, and State retirement plans.
- Telework may be available up to 2 days per week after training.
Salary information
Starting Annual Salary
$78,832 - $94,986
Applicants requiring accommodation, for any part of the application and/or interview process, should contact Human Resources at (717) 231-3309 or human.resources@pacourts.us.
Salary : $78,832 - $94,986
