Senior Database Administrator

Job Requirements

Role/Job Title: Senior Database Administrator

Function/ Department: Information Technology

Location: Navi Mumbai – Airoli Processing Centre (Gigaplex Office)

Job Summary: Database Administrator – Information Technology

Key Responsibilities

· Project/People Management

· Load balancing during EOD and SOD job

· External/Internal Audit

· Memory configuration

· DB Security

· Trouble shoot all jobs, maintenance plan issue, login/instance connectivity issues and Shipping/Mirroring Issues

· Mirroring Configuration in asynchronous mode / synchronous mode without automatic failover / synchronous mode with automatic failover

· Reconfiguration and setup DB cluster in case of failure due to incident

· Trouble shoot DB cluster Issue

· System database movement

· DR drill activity

· System/Database/Instance Performance analysis

· Configuring / Re-configuring AlwaysOn and Trobleshooting.

· Preparation of RCA for Major Incidents

· Repeat Incident / Alert Analysis

· Performance tuning suggest by OEM

· Updating and maintenance of Availability, Capacity management

· Risk Analysis and providing mitigation planning

· Continual Service Improvement Planning and executions

· Planning and execution of DR Drills based on availability of DR setup and recovery procedures

· Preparing, maintaining and updation of SOP and KBase

· Maintaining and updation of Infra AS IS / Infra Documents

· Incident / Problem / Change management

· Reinstallation and configuration raised due to Incident

· Configuring/Applying new policy.

· Analysis of blocked rules.

· Database VA / CA Management.

· Version upgrade.

· Capacity planning.

· RCA submission.

· Adherence to ISMS policy.

· Database software Installation.

· Cross Platform Linked server/DB Link configuration/Troubleshooting.

· Database Encryption for all Database Technology.

· Installation and troubleshooting Golden Gate/Kafka integration.

· Database Masking for all Database technology

· Cross platform Database migration

· Database code review and suggestion for performance improvement for all DB technology.

Education Qualification: Graduation: Bachelor of Science (B.Sc) / Bachelor of Technology (B.Tech) / Bachelor of Computer Applications (BCA) Post-Graduation: Master of Science (M.Sc) /Master of Technology (M.Tech) / Master of Computer Applications (MCA)

Experience

• 10 – 18 years.