Job Description
Position: SQL DBA L3
Experience: 8 to 10 Years
Location: Mumbai
Shift: 24x7 Support Environment (On-call Support Required)
Key Responsibilities:
• Manage, administer, and support Microsoft SQL Server databases in a production environment.
• Configure, maintain, and troubleshoot High Availability and Disaster Recovery solutions including Always On, Clustering, Log Shipping, Mirroring, and Replication.
• Perform database performance tuning, query optimization, and capacity planning.
• Manage database backup and recovery strategies (Full, Differential, and Transaction Log backups).
• Design and implement database maintenance activities and automation scripts.
• Monitor database health, troubleshoot issues, and ensure maximum uptime.
• Support database migrations, upgrades, and patching activities.
• Implement database automation using Ansible and other scripting tools.
• Provide L3 support in a 24x7 environment and participate in on-call rotations.
• Follow ITIL processes and support transition management activities.
͏
Required Skills:
7+ years hands on experience on SQL DBA
· Thorough Knowledge of Windows Operating System, Networks and Active Directory
. Knowledge of creating and maintaining standby / replication setup
. Strong in SQL fundamentals
. Knowledge of using Enterprise Manager and Query Analyzed for basic administration
. Knowledge of configuring and setting up maintenance activities for DB
. Knowledge of SQL statements tuning and DB Tuning
. Knowledge on DB structures (filegroups, Indexes - clustered /non clustered/fillfactor)
. Knowledge on Memory structures (configurable parameters)
· Knowledge of complete /differential / transactional backups and their recovery scenarios
. Knowledge on High Availability configuration like replication and log shipping , cluster setup
. Knowledge of DTS and bcp and other data load tools across same and different RDBMS
· Knowledge on database design and storage recommendation and NTFS file systems & capacity planning
. Knowledge in making scripts for automations , writing procedures and functions
. Knowledge of ITIL processes & Transition Management
. Excellent communication Skills
· Prior experience in a 24x7 environment desired
· Strong analytical and troubleshooting skills.
· Provide on-call support as and when required
Ability to handle pressure
͏
͏
͏
Mandatory Skills: MSSQL Database Admin .
Experience: 5-8 Years .
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.