SQL DBA L3

Netmagic Solutions Pvt LTD
  • Mumbai
  • Confidential
  • 7-10 years
  • Views
  • 07 Dec 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

Primary Responsibility:

Working on Escalated/P1 issues and providing solutions abiding the SLACreation & regular reviews of Audit Checklists to be followed by Jr. EngineersSystem builds and configuration managementCarry out db upgrades & migrations of applications across multiple platformsDesigning and Implementation for database architecturesEffective Problem ManagementVendor ManagementEnsuring that the changes are implemented with in defined timelines approved by CABEnsure Availability of Infrastructure services as per SLARegularly 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 Internal/ 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 DBT-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


Competencies/Skill sets for this job

Migrations New Technologies Root Cause Coding

Job Posted By

About Organisation

Netmagic Solutions Pvt LTD