SQL DBA L3

Job Designation: SQL DBA L3

Department: Operations

Reporting To: Program Manager

Work Shift: Rotation

Location: Mumbai


Primary Responsibility:

  • Working on Escalated/P1 issues and providing solutions abiding the SLA
  • Creation & regular reviews of Audit Checklists to be followed by Jr. Engineers
  • System builds and configuration management
  • Carry out db upgrades & migrations of applications across multiple platforms
  • Designing and Implementation for database architectures
  • Effective Problem Management
  • Vendor Management
  • Ensuring that the changes are implemented with in defined timelines approved by CAB
  • Ensure Availability of Infrastructure services as per SLA
  • Regularly review Backup & recovery policies of all managed databases


Secondary Responsibility:

  • Ensure Availability of Infrastructure services as per SLA
  • Regularly review Backup & recovery policies of all managed databases
  • Review & respond to feasibility requests by SE team
  • Conducting POC & evaluation of new technologies
  • Identify & Report risks along with mitigation plans
  • Identify performance bottle necks and Mitigate them
  • Automation of various tasks to improve the operational efficiency
  • Equip team with necessary documents /Audit trails/evidences for Audit purpose
  • Prepare RCA for major customer issues
  • Ensure critical patches are updated for all infrastructure servers
  • Conducting Patch Management for all managed devices
  • Analysis of Tickets/IR/CR for quality updates and,timely updates
  • Review & ensure BCP and mock restoration process is followed
  • Prepare SOP's all crtical services
  • Face Interna/ External Compliance Audits
  • Effective Root Cause Analysis (RCA) of S1 / S2 incidents
  • Should be willing to learn, adapt & work on at least 2 different databases
  • Evalaute new tools / technologies for PoC & management
  • Impart training on team members on periodic basis
  • Regular mentoring of L2 engineers


Mandatory Technical Skills:

  • Planning & Execution for Migrations, Upgradations, Patch Management of DB
  • T-SQL coding and optimization
  • Advanced Performance tuning
  • Planning & Implementation experience in High Availability features in SQL Server for e.g. Replication, Clustering, and Mirroring etc.
  • Experience in planning & executing DR / BCP drills
  • Experience in Security Hardening & compliance / audit requirements
  • Experience on more than 1 databases would be an advantage


Typical Years of Experience:

  • 7-10 years


Education Qualifications:

  • Any graduate



Join Netmagic

Send us your profile and resume at careers@netmagicsolutions.com