Executive - SQL DBA

About KPMG in India

RESPONSIBILITIES

TITLE

STATUS

LOCATION

OVERVIEW

RESPONSIBILITIES

• Manage On-premises and Cloud DB Support
• Monitor DB health and performance
• DB creation and manage DB permission
• Manage SQL Server databases maintenance tasks like DBCC Check DB, Rebuild Indexes, Update Stats
• Installation of SQL Server version 2016/2017/2019/2022
• Perform SQL Server Hardening as per best practice
• Perform SQL Server patching on Standalone and Cluster Servers
• Manage SQL DB log file size
• Ability to prepare database activity plan and execute
• Ability to Troubleshoot DB issue and provide solution.
• Manage DB backups and restores
• Provide 24x7 support for critical production systems
• Implementation of Alert configuration to get notification for any issue
• Configure and manage SSRS, SSIS and SSAS.
• Monitor daily backup activity and reporting to proactively avoid issues and troubleshoot missed and failed backup jobs.
• Perform restores for various type of data in case of data loss as per business requirement.
• Manage Business Continuance in relation to Disaster Recovery
• Provide assistance on SOP documentation at all levels of the projects/changes/support.
• Assess and implement best practices in line with change management process
• Ability to handle escalated tickets and provide solution/RCA in time
• Ability to explore automation of current tasks and drive it
  

EXPERIENCE

• Experience on Installation of SQL Server version 2016/2017/2019/2022.
• Experience on configure and manage SQL Server High Availability (HA) setup like SQL Cluster, AlwaysOn with SQL Version 2016/2017/2019.
• Experience on configure Disaster Recovery (DR) for SQL Server DB via Log Shipping
• Experience on migration and upgradation of SQL Server Database
• Experience in managing SQL Server Security
• Experience on configure Database mirroring and Replication
• Experience in performance tunning
• Manage Cloud DB
• Basic knowledge on MySQL and PostgreSQL
  

Qualification:

• MS SQL Server certifications a plus
  

QUALIFICATIONS

Equal employment opportunity information

KPMG India has a policy of providing equal opportunity for all applicants and employees regardless of their color, caste, religion, age, sex/gender, national origin, citizenship, sexual orientation, gender identity or expression, disability or other legally protected status. KPMG India values diversity and we request you to submit the details below to support us in our endeavor for diversity. Providing the below information is voluntary and refusal to submit such information will not be prejudicial to you.