Responsibilities:
- The primary responsibilities of the MSCE SQL Server DBA and HyperV Engineer is to deliver:
- A stable, secure and resilient database infrastructure
- A performant database environment for business applications
- A log of all database operational events, alerts and alarms
- A set of operational scripts for the databases
- Reliable and timely backup and restore capabilities
- Exceptional reviews and reports
Requirements:
- Five plus years of experience with Microsoft SQL server, versions 2005 through 2012
Qualifications and Proficiencies:
- SQL server:
- Installation, upgrades, and patching
- SQL server query performance tuning
- Backup and recovery
- Integration services
- SQL agent management
- SQL server system internals and performance
- Log shipping, database mirroring and clustering
- Infrastructure components:
- HyperV virtualization technologies
- Windows server configuration and management
- Windows domains and security
- Storage architecture
- Windows clustering