Senior Database Administrator

Job description

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.