MS SQL Database Administrator 6 To 9 Years Pune Mumbai Bangalore
Job Description
- SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.
- MS SQL Server DBA (L3 / L2 Level Support for SQL Server): 2022 / 2019 / 2017 / 2016 / 2014
- Hands on technical experience with AG replica failover/Failback and HA-DR Solutions (Log shipping / Replication / Mirroring).
- Experience in Database Administration including Installation, Configuration, User Access Management, Backup/Recovery, Monitoring and Performance Tuning, Space Utilization.
- Troubleshoot issues related to SQL Backup – Restore, DB performance, Shrink DB files, Blocking and deadlock,
- SQL Server Build including Post QA checks.
- SQL Server Upgradation / Patching on Always ON / Standby servers.
- Perform system health checks and provide recommendation reports.
- PowerShell programming experience preferred (would like to automate sql installs, and other processes)
- DB maintenance plans, Plan and Perform Patching (pre and post checks), Server Decommissioning
- Administration and refinement for Monitoring tools: Review, revise, and update monitoring thresholds and alerts to enable infrastructure stability.
- Installation/Upgradation/Migration of SQL Servers.
- Apply any patches or service packs for SQL Server.
- Configure High Availability/Disaster recovery solutions.
- Configure automated alerts to send a mail to team if any issues.
- Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
- Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
- Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
Primary Skills
- MS SQL Database administration
- MS SQL Server DBA
- Database tuning
- Data modeling
- Microsoft SQL Server
- Troubleshooting
- SQL SERVER
Secondary Skills
- Work on Writing custom stored procedures, t-sql queries , powershell scripts , views, and triggers based on requirements for DB maintenance and automate tasks.
- Work on writing technical and RCA(Root Cause Analysis) documentation.
- Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
- work on performance tuning like provide suggestions to crete indexes and tune stored procedures.
- Troubleshoot recurring problems and fix them permanently.
- Conduct DB DR Drill activity , ensure to bring the DR site online if any outage at Primary site.
- Work on prepare and create standardize operational and process documents.
Ref:
1772035
Posted on:
Mar 31, 2024
Experience level:
Experienced
Contract Type:
Permanent
Location:
Pune, MH, IN
Department:
Infrastructure & Service Integration