Description

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

Education

Any Graduate