Lead System Engineer DRE – MSSQL DBA

Exadata admin/ Expert accountable & responsible for handling global database operations.

Experience of handling very large environment, min 500+ SQL Instances and TB's of database size

Key Responsibilities

- Role / Job Summary

Exadata admin/ Expert accountable & responsible for handling global database operations.

Mandatory Skills / Experience –

• Experience of handling very large environment, min 500+ SQL Instances and TB's of database size.

Profile Required

Primary Skills

MSSQL, MSBI

Secondary Skills

Optional - PostgreSQL

Any other additional Inputs

Powershell, Python

• Providing on-call database support during weekends & out of business hours.
• 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 Troubleshooting SQL Agent Jobs/Autosys Maintenance Jobs & Maintenance Plans

Mandatory Skills / Experience

Must have good team working skills balanced with ability to work in shifts (on rotation basis) / ability to work alone and a positive attitude.

• 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 Troubleshooting SQL Agent Jobs/Autosys Maintenance Jobs & Maintenance Plans
• Trouble Shooting and fixing Data corruption (Page, table level)
• Preparing/Updating SOPs documents (Technical & Operational)

.