Experienced database administrator with expertise in Oracle (11g, 12c, 19c), MS SQL Server (2012, 2019), and PostgreSQL. Proficient in cloud technologies, particularly Oracle Cloud Infrastructure, and skilled in high availability solutions such as Oracle RAC, Data Guard, GoldenGate, and Always On Availability Groups. Demonstrates strong capabilities in performance optimisation using AWR, ADDM, SQL Tuning, and TKPROF. Adept at backup and recovery processes with RMAN and Data Pump. Experienced in scripting and automation with SQL, PL/SQL, and Bash Scripting across various operating systems including Red Hat Linux, HP-UX, Sun Solaris, IBM AIX, and Windows.
Overview
13
13
years of professional experience
Work history
Senior Officer - Database Administration
Ajman Bank
Ajman, UAE
08.2023 - 02.2025
Managed installation and administration of Oracle databases across various operating systems
Applied RU patches to address vulnerabilities and optimise database performance
Monitored database performance, storage, and availability using OEM and OCI Monitoring tools
Oversaw OCI Compute, Storage, Networking, and Database services
Implemented RU patches enhancing security and performance for databases on-prem and OCI
Configured high-availability solutions with Data Guard for standby databases
Specialised in database performance tuning using AWR, ADDM, Explain Plan, TKPROF, and SQL Trace
Implemented Oracle GoldenGate solutions for data replication and integration
Scheduled daily tasks to initiate audit reports
Updated UAT databases using production backups to support testing requirements
Monitored database health and performance using Oracle Enterprise Manager to identify and resolve issues
Managed Oracle ASM to improve database performance and ensure efficient storage utilisation
Executed database cloning, migrations and replication using Oracle Data Pump, RMAN and Oracle GoldenGate
Configured roles and privileges for data protection compliance
Set up initial databases, defined file groups, and optimised storage allocation
Developed backup strategies utilising SQL Server and third-party tools
Installed, configured and upgraded PostgreSQL databases across Linux and Windows operating systems
Enhanced database security by managing roles, assigning privileges and implementing SSL encryption
Automated routine administrative tasks utilising Bash scripting and cron jobs
Collaborated effectively with cross-functional teams to ensure business continuity
Assistant Consultant
Tata Consultancy Services (TCS)
Riyad, Saudi Arabia
07.2019 - 07.2023
Upgraded Oracle databases from 12c to 19c, implementing 19c Grid Infrastructure and performance tuning
Built and managed standby databases; executed switchover operations
Managed standby databases in active mode for testing and reverted to standby
Implemented security patches to ensure compliance and mitigate vulnerabilities
Oversaw Oracle GoldenGate environments, identified issues, and ensured smooth synchronisation and minimal lag
Managed database storage by resizing tablespace data files and adding disks to disk groups
Conducted regular RMAN backups, restoration, and cloning for database integrity
Implemented and monitored Enterprise Manager and cron jobs for timely alerts
Configured Oracle Data Guard for high availability and disaster recovery
Coordinated log sequence synchronisation between primary and standby databases
Applied PSU and CPU patches to RAC and standalone databases
Conducted schema refreshes from production to pre-production using Data Pump for seamless testing transitions
Enhanced system performance via AWR report analysis and bottleneck resolution
Monitored database performance and resolved long-running queries to maintain operational efficiency
Administered databases and managed alerts using Oracle Enterprise Manager
Managed and expanded ASM for production and non-production databases
Assisted application team in creating online partitions to enhance database performance
Conducted file system housekeeping to maintain optimal space utilisation
Managed blocking sessions in databases and cleared upon approval
Led annual disaster recovery drills to ensure recovery operations aligned with business continuity plans
Developed and administered RMAN backup solutions using Oracle Cloud Control, optimising data recovery processes
Deployed and configured cloud agents for target monitoring in Oracle Cloud Control
Managed third-party target monitoring with OEM for various database integrations
Clients: STC(Saudi Telecom), Cisco
IT Consultant
Ericsson Global India
Bangalore, India
01.2019 - 07.2019
Installed and configured Oracle 11g and 12c RAC databases across Linux and Solaris platforms
Installed Oracle Enterprise Manager 13c on Linux systems
Monitored databases and related services using Oracle 12c and 13c Cloud Control
Migrated non-RAC database to RAC infrastructure and managed cluster node adjustments
Updated clusterware and databases with latest patches promptly upon release
Recovered Oracle 11g/12c RAC databases using RMAN to validate reliability of backup strategy
Updated clusterware and database software with latest patch set
Configured Active Data Guard in Oracle 11g R2 and 12c for reporting purposes
Installed EM agents and configured monitoring for multiple hosts
Conducted proactive 24/7 monitoring of database activity and health checks
Coordinated with Oracle for P1 issue resolution
Applied patches to Oracle database following Oracle's recommendations
Configured and managed Oracle Golden Gate replication across Oracle database environments
Managed client accounts at Mobily Telecom
Senior Software Engineer
Oracle India Pvt. Ltd.
Bangalore, India
08.2014 - 12.2018
Handling Critical Service Requests
Support the customer related issue's resolution on-site and remotely
Multiple database targets patching using Cloud Control
Involved with installation and maintenance of ORACLE 11g, 12c and standby database for High Availability and Disaster Recovery purpose
Created 100+ defect change requests reflected in code patches and hotfixes
Experience in working with Oracle Product Support using Metalink to resolve critical issues
Installed and Upgradation of Cloud Control from 11g/12c to 13c
Supporting Customers to apply patches CPU, PSU and SPU's and applying bug fixes using Cloud Control and OPatch utility
Installed and configured Data Guard using physical-standby for high availability and reporting
Troubleshooting RAC instances, Services, Node Apps and Cluster-ware using SRVCTL and CRSCTL command line utilities
Creation and configuration of databases as per client requirements