MS SQL Database Administrator - Project Management (5-8 yrs) Bangalore (DevOps)
Magna Infotech
Bangalore, India
15h ago
source : hirist.com

Job Description :

  • 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
  • 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)
  • Skills :

  • Hard core technical guys who has worked on MSSQL
  • Version 2005-2017)
  • Should be strong in Architecture
  • Manage Crisis calls, performance tuning, end to end
  • Should be currently working as technical person.
  • Legacy management, up gradation, migration, problem management.
  • Identifying issues and look for permanent solution.
  • Will be working 24 / 6 - Sundays (on call).
  • Rotational Shifts - 1 week in every 2 months.

    Work Location / Drive Location : Voyager.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form