Location: Mechanicsburg PA
Hybrid Role: The candidate must work onsite for six weeks before being eligible for 2 remote days per week.
Contract Length:Longterm contract 6 months Right to Hire)
US Citizens or Permanent Residents only. Must be a PA Resident.
Position Overview:The SQL Server Database Administrator is responsible for the daytoday configuration maintenance and performance of critical MS SQL Server systems ensuring the integrity reliability and recoverability of data for a wide variety of inhouse developed applications and offtheshelf software. The position requires solid technical skills as well as excellent interpersonal and communication skills and involves assuming rotating oncall duties.
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 realtime providing endtoend 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 oncall rotation.
Required Skills:- Bachelors degree in an ITrelated field. Minimum of one year of IT experience involving the analysis design and maintenance of databases in support of overall database administration.
- 3 years of MSSQL server administration experience is required.
- Extensive experience with backups restores and recovery models.
- Proficiency with writing TSQL 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
Required Experience:
Senior IC