Title: SQL Server DBA
Location: Mechanicsburg PA - 100% onsite. Must be local to Mechanicsburg Pennsylvania
Candidates must be able to come onsite for 1st 6 weeks then remote 2 days per week, 3 days onsite.
Description 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.
Job Duties - Manage SQL Server implementations across all environments from development through testing to production.
- Maintain database servers and processes to ensure high levels of integrity, reliability, and recoverability while keeping performance and security in line with industry standards.
- Analyze, solve, and correct issues in real-time, providing end-to-end problem resolution.
- 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 Regular Business Hours.
- Participate in an on-call rotation.
Minimum Qualifications - Bachelor's degree in an IT-related field. Minimum of one year of IT experience involving the analysis, design, and maintenance of databases in support of overall database administration.
- satisfactory criminal check is required (to be completed by Client).
Technical Requirements - 3+ years of MSSQL server administration experience is 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