Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Job Skills
Accomplishments
Certification
Timeline
Generic
Rahulla Baig Mohammad Esa

Rahulla Baig Mohammad Esa

Oracle Database Administrator
Chennai

Summary

Knowledgeable Database Administrator with comprehensive background in database design, optimization, and management. Successfully implemented database solutions that enhanced data integrity and streamlined operations for various clients. Demonstrated expertise in SQL and database migration, effectively utilizing problem-solving and analytical skills.

Overview

16
16
years of professional experience
4
4
years of post-secondary education
6
6
Certifications
5
5
Languages

Work History

Associate Consultant

TCS Consultancy Services
Chennai
11.2022 - Current

Clients - Ahold Delhaize (Netherlands), Comcast (USA), British Telecommunication Group (UK)

  • Driving Database & ERP/ FMW Application for new as well as existing projects, live production environment, resolving incidents, BAU issues & providing L2/L3 technical support as well as ensure DB availability all the time based on SLA
  • Designing, planning, configuration including installing, testing, upgrading, operating, administering Oracle Databases on OCI platform with high availability architecture
  • Setup multi node Oracle Key Vault, migrating TDE file based keys/wallets to OKV using Ansible automation, troubleshooting & administering with OKV wallets/end-points
  • Monitoring DB & WLS/FMW applications using OEM and custom scripts resolving production issues, clustering databases & maintenance of disaster recovery plans
  • Experience on Exadata VMs with RAC, ASM, Data guard, upgrade lower to higher Databases, resolution providing for critical issues by consulting Oracle service SR
  • Cloning/Refreshing the lower environments from PROD using RMAN restoration and migrating the Databases using export & import/Cross platform (XTTS) based on the business strategies
  • Well-coordinating with teams like DevOps, testers, OS, storage and network teams to support activities using planning, change management & problem managements
  • Applying Database and Application enhancement/latest patches like CPU/PSU security patches to fix the bugs reported and maintain best data security strategies
  • Take ownership of performance and capacity management aspects of the DB and responsible for designing and scale-up/down hardware requirements
  • Scripting Shell/ksh and automate them on OS based on the requirement to monitor the Database health regularly

Application Development Team Lead

Accenture Solutions Pvt Ltd
Chennai
05.2014 - 10.2022

Clients - Merck (USA) & GSK Ltd (UK)

  • Driven, Managed and poise Database and Application with Oracle EBS Suite systems R12.1.x/R12.2.x production instances integrated with multiple third-party client specific reporting tools like Life Sciences Data Hub/DMW/WCC/SOA & FMW applications
  • Install, configure, maintain and supported multitenant Databases and pluggable databases like CDB and PDBs. Converting standby Databases to Container Databases and clone the PDBs.
  • Upgraded Databases from 11g/12c to 19c version.
  • Troubleshooting the application & Database issue on all PROD/Non-Prod environments
  • Setting up OEM architecture, configure DBs, promote them and setup notifications to monitor regularly and flag for any availability challenges as a proactive measure.
  • Configure and maintain Golden Gate architecture and perform initial load, logical replicat and extract loads.

Oracle Database Administrator

Bahwan Cybertek Pvt Ltd
Chennai
04.2013 - 05.2014

Clients - Biogen Idec, USA

  • Managed and poise Database and Application with R11.5.10/R12.1.3 production instances integrated with third party tool like Marekview & Kofax of client specific reporting tools
  • Cloning the instances from PROD to DEV and TEST for UAT testing as per client requirement using rapid clone utility
  • Applying latest release of patches to enhance product related bugs and new features, quarterly CPU/PSU patches on Databases and applications and FMW homes
  • Take and maintain regular backups like Cold, Hot and logical backups like export backups, and import them to target databases
  • Tracing and generating tkprof files, analyzed AWR, ADDM reports and suggested for best resolution for performance issues

Oracle Database Administrator

Accel Frontline IT Solutions
Chennai
03.2011 - 04.2013

Clients - Sandhar Technologies & Mando India

  • Managed and configured Oracle Database 11gR1/R2 with E-Business Suite R11.5.10 /R12.0.4 production and Non-Prod environments of client
  • Troubleshooting concurrent manager and request related issues, trace the sessions, analyze for performance issues
  • Troubleshooted the daily issues with Database like user access, roles, tablespace reorganizing and performance related BAU issues
  • Plan and execute maintenance support activities like indexing, Update Stats, DBCC checks, space issues, cleanup tasks, access issues
  • Troubleshot database issues to create and resolve trouble tickets.

Oracle Database Administrator

Techmetric Info Systems Pvt Ltd
Chennai
06.2009 - 02.2011

Clients - Nat Steel Pvt Ltd, Singapore

  • Implemented and configured multiple database and application requirements for new, existing projects and maintained 24/7 support model
  • Applied Database and Application patches like One-off, Roll-up, Family packs and Quarterly Security patches to fix the business-related bugs as well as security patches
  • Upgraded multiple Databases from 9i/10g to 11g versions managing databases on Linux/Solaris/Unix operating system using dbua utility or manual upgrades
  • Involved in creating documentation work like SOAP, Architectural, Work instruction, patch analysis and known bug consolidation with resolution documents for quick reference.

Education

Bachelor of Engineering (B.E) - Electrical And Electronics Engineering

Anna University
Chennai
07.2002 - 06.2006

Skills

Oracle Database 10g

Oracle Database 11g

Oracle Database 12c

Oracle Database 19c

MSSQL

PostgreSQL

OCI

AWS

Azure

SQL

Shell Script

Ansible

undefined

Personal Information

  • Date of Birth: 01/08/85
  • Gender: Male
  • Nationality: Indian

Job Skills

Oracle Database Administrator, DB administration, MySQL server Databases, Design, installation, configuration, patching, and upgrading of Databases, E-Biz/WebLogic applications, OCI, Database backup policies, High Availability & DR concepts, Oracle Key Vault, Logical backups, Cross platform migration, Oracle Database 10g, Oracle Database 11g, Oracle Database 12c, Oracle Database 19c, MSSQL, PostgreSQL, OCI, AWS, Azure, SQL, Shell Script, Ansible, Linux, AIX, Unix, SUSE Linux, Exadata, Windows, SQL Developer, TOAD, JIRA, Confluence, Terraform, Ansible

Accomplishments

    Awarded with Accenture Excellency award in 2016 for the process of solving multiple complex issues on Production along with cost saving up to 30-40% by automation of deployment activities by reducing manpower.

Certification

Certified Oracle Cloud Infrastructure Foundations Associate 2024

Timeline

Certified Oracle Cloud Infrastructure Foundations Associate 2024

02-2025

Certified OCI Architect Associate 2024

02-2025

Associate Consultant

TCS Consultancy Services
11.2022 - Current

German B1 Writing certified

07-2022

Oracle WebLogic Server 12c Certified Implementation Specialist

12-2019

German A1 Language

02-2019

Certified Oracle Database 11g Associate

12-2018

Application Development Team Lead

Accenture Solutions Pvt Ltd
05.2014 - 10.2022

Oracle Database Administrator

Bahwan Cybertek Pvt Ltd
04.2013 - 05.2014

Oracle Database Administrator

Accel Frontline IT Solutions
03.2011 - 04.2013

Oracle Database Administrator

Techmetric Info Systems Pvt Ltd
06.2009 - 02.2011

Bachelor of Engineering (B.E) - Electrical And Electronics Engineering

Anna University
07.2002 - 06.2006
Rahulla Baig Mohammad EsaOracle Database Administrator