MS SQL DBA

Location:

Role & Responsibilities

• Provide Microsoft SQL Server database administration support for all lines of business applications and infrastructure applications.
• Strong experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
• Strong experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space and other resource contention.
• Strong knowledge of backups, restores, recovery models, database maintenance tasks.
• Hands-on experience in Disaster Recovery solutions like Log-Shipping, Mirroring & Replication.
• Hands-on experience in High Availability solutions like SQL Clustering.
• Experience on SQL HA/DR solutions like ALWAYS ON is a big plus.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching.
• Knowledge of SQL Server tools (Profiler, DTA, SSMS, SSCM, PerfMon, DMVs, DBCCs).
• Proficient on DC-DR Replication and DR-Drills.
• Strong experience in database upgrades from one SQL version to another SQL version.
• Knowledge of Development environment will be an advantage.
• Knowledge of open-source databases (My-SQL, MariaDB, MongoDB) will be an advantage.
• Good exposure on Security/compliance audit management.
• Should be proficient in backup and recovery of databases.
• Should have good knowledge of database monitoring.
• Hands-on experience of implementation of Security policies.

Competencies:

• Team Working
• Analytical Skills
• Good Communication skill and Assertiveness
• Result Oriented