AddressJob Description (Posting).MSSQL DBA Job description for L2/L3:Description: - Candidate must be an excellent communicator, organized, multi-task oriented and able to meet deadlines, and complete assignments with minimal supervision. Should have working experience of SQL Server versions 2000, 2005, 2008, 2008 R2,2012,2014,2016,2017 & 2019 Ability to install SQL, Patch & Upgrade all versions in Standalone, Cluster & Always on Setup Ability to create, configure & support AWS RDS instances Should be able perform database health check activities. Ability perform backup & restoration of SQL databases including point in time state. Ability to restore and recover the corrupted databases Ability to troubleshoot issues arising out of High Availability Techniques Like Always on, Database Mirroring, Cluster Management, Log Shipping and Replication. Should be able to handle migration activities across servers / domains / Cloud Should be able to manage transaction logs, database files and file groups and keep storage under control Should be able to manage logins / users with least privileges to non admin users Should be able to create, manage & schedule Agent Jobs, Alerts, Database mail profiles Identifying and Resolving Blocking / deadlock issues. Dealing with performance issues, rebuilding indexes Understanding the performance , connectivity problems and providing appropriate recommendation to fix them. To maintain good rapport with customer and provide regular updates/follow-ups, answer client queries. Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities. Implementation of Release, Change Requests and handling Incidents. Should have experience on Query Optimization and Query Execution plan Analysis. Should be able to support 24/7 operations. Should have knowledge on automation (1.) To provide support for on call escalations and doing root cause analysis of given issue (2.) To independently resolve tickets within agreed SLA of ticket volume and time (3.) To adhere to quality standards, regulatory requirements and company policies (4.) Work on value adding activities such Knowledge base update and management, Training freshers, coaching analysts (5.) To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases
QualificationB.E, B-Tech
Skill (Primary)EPS-Database-MS SQL
Skills: Sql Server, cluster management , Automation, Database Mirroring, Replication, change requests , Performance Tuning, Aws Rds, Query Optimization, Release, Log Shipping
Experience: 0.00-2.00 Years
