Description
Job Description:
Our client, a Fortune 500 company, seeks an experienced Microsoft SQL Server Database Administrator for a contract position.
Responsibilities will include providing operational support for Microsoft SQL Server 2005, 2008, 2012 and 2014 SSDS, SSIS, SSRS and SSAS. Operational support responsibilities for databases includes installing binaries, creating instances and databases, creating/altering database objects, ensuring the availability and performance of databases, creating backups and performing restores, troubleshooting service issues, determining the causes, and resolving them. The position will also involve management of security and change control for SSDS, SSIS, SSRS and SSAS.
The position will work closely with the Team Lead, other Database Administrators, and Developers. This position will involve participation in on-call rotation for 24/7 support.
Education:
4-year College Degree preferably in Information Systems, Computer Science, Engineering or related field
Responsibilities:
- Install and patch SQL Server 2005, 2008 R2, 2012 and 2014 SSDS, SSAS, SSIS and SSRS.
- Manage security and permissions on SSDS, SSAS, SSIS and SSRS.
- Manage change control for code promotion on Microsoft database resources.
- Participate in on-call rotation to provide 24/7 operational support.
- Troubleshoot service problems; determine root cause, and provide resolutions.
- Produce documentation as needed on database standards and policies.
- Monitor database performance and derive solutions for performance problems.
- Provide guidance on good database design and implementation practices to Developers.
- Perform capacity planning for database systems.
- Perform and ensure database backups and restores.
- Participate in DR testing and execution.
- Participate in team environment to share workload and responsibilities as circumstance warrants.
- Ensure compliance with database policies and procedures.
- Perform object creation and alteration according to established change control procedures.
- Maintain working knowledge of relevant operating system, network and storage principles relating to database platforms.
Required Skills:
- 5+ years of production support on SQL Server
Preferred Skills:
- 2+ years database development
- 2+ years application development
- 2+ years Windows OS support