Key Skills/Responsibilities:
- Installation, Administration and Maintenance of SQL Server Instances
- Owns the strategic direction for the database topography
- Create Users and assign permissions based on the level of database access the user would need
- Design database backup and restore strategy
- Setup High-Availability as part of Disaster Recovery Strategy for the Databases
- Troubleshoot various problems that arise in the day-to-day operations and fix the issues
- Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning to include index optimizations
- Failover clustering, SAN replication, and other high availability technologies
- Database growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)
- Manage Maintenance Plans
- Monitor backups to ensure they are being performed regularly
- From time to time recover the databases to a specific point of time, as per the requests
Qualifications:
- Microsoft SQL Server DBA experience.
- Microsoft Azure experience
- SSIS / SSAS / SSRS experience
- Data Warehousing experience
- 5-10 years of experience
- Bachelor’s degree in Computer Science, Information Systems, or related technical field; or equivalent work experience.
- MCTS, MCITP, and/or MVP certifications