Client: Sedgwick Claims Management Services, Inc.
Title: IT DBA Advisor Senior
Requisition ID: 9047713
Duration: 6 months CTH
Location: Dublin, OH 43017
Hours: 8 hours per day & 5 days a week role
Work Authorization: USC & GC ONLY
Openings: 2
8+ years of experience in database configuration, administration and support in MS SQL Server environments including experience in Database Administration of SQL Server (2005, 2008,2014,2016) running on Windows server OS 2008 and above. (Experience with higher SQL Server versions would be a plus).
This should include:
- Strong knowledge of and experience with index, and statistic, and execution plan management
- Ability to write and troubleshoot SQL Code for stored procedures, functions, views, and triggers
- Experience in troubleshooting and resolving all types of database issues (experience troubleshooting replication, log shipping issues would be a plus)
- Strong Knowledge of Microsoft best practices for configuring and operating SQL Server
- Strong knowledge of Backup and Recovery methods
- Experience with SQL Database Operational support of Developers and Business users
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
- Knowledge of and experience with implementing automation of reoccurring DBA tasks.
- Good communication and documentation skills for processes and procedures
- Clustering configuration and support
- Backup/Restore
- Log Shipping
- Replication
- SQL Server AlwaysOn
- Knowledgeable of Performance tuning at the server and SQL Server level
- Knowledgeable of Microsoft best practices for configuring and operating SQL Server
- Exposure to Idera SQL Diagnostic monitor would be helpful
- SANs
In addition to the above required items any of the following would be a plus:
- Any SAN configuration knowledge and experience in line with Microsoft best practices for SQL Server
- Knowledge and experience with configuration and maintenance of SQL Server Clustering
- Experience with using any of the following 3rd party DBA tools/Applications with SQL Server: Redgate, Idera, Subversion (SVN)