SQL Server DBA

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.