Key Skills: MS SQL Server, Always On, Mirroring, Replication, Backup & Recovery, Performance Tuning, SQL Server Upgrade, Query Optimization, HADR Solutions, Compliance Tools
Roles & Responsibilities:
- Design, configure, implement, and administer all databases for the respective parties involved.
- Manage SQL Server installations and high availability configurations, including patching and troubleshooting.
- Perform SQL Server upgrades and ensure optimal database performance.
- Troubleshoot and resolve database issues including performance tuning, capacity planning, blocking/locking/deadlocks, memory pressure, CPU, I/O latency, and capacity management.
- Implement and maintain High Availability and Disaster Recovery (HADR) solutions using Always On, Mirroring, and Replication.
- Analyze and report performance of database operations against key database performance metrics.
- Use Database Diagnostic & Compliance Management tools for troubleshooting and monitoring.
- Execute and manage database backup and recovery strategies.
- Optimize stored procedures and query performance to improve execution plans and ensure faster application response times.
Experience Requirement:
- 6-12 years of experience with MS SQL Server 2008/2008 R2/2012/2014/2016/2017/2019.
- Experience with SQL Server 2016 & 2017.
- Expertise in high availability configurations, SQL Server upgrades, troubleshooting, and performance tuning.
- Proven experience in implementing and supporting HADR solutions including Always On, Mirroring, and Replication.
- Solid experience in database backup/recovery and performance monitoring tools.
Education: Any Post Graduation, Any Graduation