We are seeking a highly skilled MS SQL DBA with 5 to 10 years of experience to manage, maintain, and optimize our SQL Server databases. You will be responsible for designing and optimizing stored procedures and queries, continuously monitoring performance, enhancing security measures, and addressing various database and server configuration issues. This role requires expertise in defining backup/restore strategies, resource monitoring, and comprehensive documentation management.
Roles & Responsibilities:
- Design and provide inputs to optimize stored procedures and queries based on system performance to reduce server load.
- Monitor performance continuously and take immediate measures based on the analysis of current system behavior.
- Conduct in-depth analysis of current server configuration and identify requirements to improve performance, particularly in database settings.
- Enhance security measures to ensure data privacy and information security.
- Address issues related to DB configuration, server configuration, partitioning,
and indexing by applying industry best practices/standards.
- Define Server Health Policies like Temp DB configuration, and analyze server configuration based on user base, CPU utilization, etc.
- Execute SQL software/patch upgrades and technical initiatives.
- Perform resource (CPU, memory, IO & network) monitoring and management .
- Handle Ad-hoc requests from the business for DM and reporting extraction based on request type.
- Define DB backup and restore strategy and archiving .
- Manage documentation on installation, server build, migration, and infrastructure dependency setting/configuration.
- Manage access based on Role and Responsibility (RnR) and participate in Audits for Access management.
- Create and periodically track DB maintenance plans for Backup, Update Statistics, Indexing, and DBCC integrity.
Skills Required:
- Expertise as a Microsoft SQL DBA .
- Robust knowledge of designing and optimizing stored procedures and que
📌 MS Sql DBA (Pune)
🏢 Apex 2000
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.