MS SQL Administrator

Required Skills and Experience (5 7 Years)

• Roles & Responsibility

  Providing on-call database support during week-ends & out of business hours. Provide 24x7 support for critical production systems. Strong knowledge on Production Database Operations & understanding the importance of BAU Good Knowledge on ITIL Framework Effective communication (Written & Verbal) Experience on Incident Mgt and managing Crises calls by engaging with Vendors & Clients Strong analysis skills, Problem Solving and Decision making Willing to accept/take responsibility and problem ownership Skill-up on new concepts, features and Open source technology and being Mentors Ability to work in a rapidly changing environment Planning and execution of PSU Patching & Upgradation of SQL Server (Legacy Mgt) Good Experience on automating PSU Patching, installations and other BAU tasks Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries, blockings and deadlocks. Account Management (Login Creation, Deletion, Profile Modification) & managing Security/Audit parameters Knowledge on index de-fragmentation, re-indexing and update the index statistics Configuration & Monitoring High Availability, Log-Shipping, DB Mirroring, Replication, Clustering and Always-ON Periodical Backups of the database and timely recovery when required. Scheduling the automated backup jobs Scheduling, Monitoring and Trouble shooting SQL Agent Jobs/Autosys Maintenance Jobs & Maintenance Plans

  Required Technical and Professional Expertise

• Strong knowledge on Production Database Operations & understanding the importance of BAU
• Good Knowledge on ITIL Framework
• Effective communication (Written & Verbal)
• Experience on Incident Mgt and managing Crises calls by engaging with Vendors & Clients
• Good knowledge on Presentation skills with PPT and expert in Excel with functions & Macros
• Good Experience on Client projects/domain, End-to-End Project management, setting-up technology Roadmap
• Preferred Experience on LEAN methodology to optimize the BAU tasks
• Strong analysis skills, Problem Solving and Decision making
• Willing to accept/take responsibility and problem ownership
• Skill-up on new concepts, features and Open source technology and being Mentors
• Ability to work in a rapidly changing environment
• Planning and execution of PSU Patching & Upgradation of SQL Server (Legacy Mgt)
• Good Experience on automating PSU Patching, installations and other BAU tasks
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries, blockings and deadlocks.
• Account Management (Login Creation, Deletion, Profile Modification) & managing Security/Audit parameters
• Performance Tuning, Query Optimization, Client/Server Connectivity
• Knowledge on index de-fragmentation, re-indexing and update the index statistics
• Configuration & Monitoring High Availability, Log-Shipping, DB Mirroring, Replication, Clustering and Always-ON
• Good knowledge on troubleshooting of Always-ON, Clustering and other HA components
• Good Knowledge on Storage level replication like SRDF
• Periodical Backups of the database and timely recovery when required. Scheduling the automated backup jobs
• Scheduling, Monitoring and Trouble shooting SQL Agent Jobs/Autosys Maintenance Jobs & Maintenance Plans
• Trouble Shooting and fixing Data corruption (Page, table level)
• Preparing/Updating SOPs documents (Technical & Operational)