Santosh Ganga
Senior Database Administrator
Hire this person
Send a job offer directly to this candidate
About
Senior Database Administrator with 12+ years of experience managing mission-critical Oracle and Microsoft Azure SQL Server environments across large-scale enterprise, production, DR and 24×7 operations. Extensive expertise in Oracle 9i–19c, RAC, ASM, Data Guard, Active Data Guard, RMAN, GoldenGate, OEM, TDE, performance tuning, backup/recovery and disaster recovery, with strong focus on database availability, resilience and operational excellence. Proven experience in cloud database transformation and migration, including Oracle migrations to AWS RDS and EC2 using RMAN, cross-platform migrations using XTTS, AWS infrastructure, and Azure SQL Database provisioning and right-sizing using Bicep.
Strong track record in database automation, performance optimization, capacity planning, proactive monitoring and incident/RCA management, with experience collaborating across application, infrastructure, cloud, network, storage, security and vendor teams.
Experience
IT Developer/Engineer III at DXC Technology (2018-05 – Present)
Managed and supported mission-critical Oracle and PostgreSQL databases. Supported HPE, Microfocus and Internal Support clients.
- Managed and supported mission-critical Oracle 9i–19c databases across production, DR, UAT and development environments, ensuring high availability, performance, security and operational stability.
- Administered Oracle RAC, ASM, Data Guard, Active Data Guard, RMAN and GoldenGate, including configuration, monitoring, troubleshooting, switchover/failover, replication and DR activities.
- Performed comprehensive Oracle database performance tuning and health assessments using AWR, ASH, ADDM, SQL execution plans and wait-event analysis, resolving complex SQL, CPU, memory and I/O performance issues.
- Executed Oracle database migrations to AWS RDS and Amazon EC2, using RMAN backup/restore and recovery techniques, including database preparation, backup transfer, restoration, validation and post-migration activities.
- Performed cross-platform Oracle database migrations using XTTS (Cross-Platform Transportable Tablespaces) and RMAN, including source/target platform preparation, metadata transfer, incremental synchronization, recovery and migration validation.
- Implemented and supported Oracle GoldenGate replication environments, including extract/replicat configuration, monitoring, lag analysis, troubleshooting and replication recovery.
- Managed Oracle backup, recovery and disaster recovery using RMAN, including full/incremental backups, archive log backups, database restore/recovery, RMAN duplication and recovery validation.
- Managed Oracle storage and capacity, including tablespaces, datafiles, ASM diskgroups, FRA, archive destinations and database growth, with proactive capacity planning and performance benchmarking.
- Performed Oracle database upgrades, patching and maintenance, including version upgrades, Release Updates (RU), security patches and post-patching validation.
- Managed Oracle users, roles, privileges, database links, profiles, password policies and TDE, supporting enterprise database security and access-control requirements.
- Supported Oracle database migrations to AWS RDS and Amazon EC2, leveraging RMAN backup/restore, database recovery and migration validation to support cloud adoption with minimal business disruption.
- Supported database workloads hosted on AWS cloud infrastructure, including EC2 compute, EBS storage and S3-based backup/data transfer activities.
- Performed Oracle-to-AWS migration planning and assessment, including database sizing, storage requirements, compatibility checks, backup strategy, connectivity and post-migration validation.
- Supported multi-cloud database environments across AWS and Azure, with focus on database availability, performance, capacity, security and operational stability.
Database Administrator at T-Systems Malaysia Sdn Bhd (2013-03 – 2018-04)
Administered and supported Oracle and Microsoft SQL Server databases for SHELL Corporation across production, UAT, development and DR environments.
- Administered and supported Oracle 11g/12c/19c and Microsoft SQL Server databases across production, UAT, development and DR environments, ensuring database availability, performance and stability.
- Performed Oracle database administration including installation, configuration, database creation, user/role management, tablespace and storage management, patching, upgrades and routine maintenance.
- Managed Oracle RAC, ASM, Data Guard and RMAN environments, including backup/recovery, database monitoring, DR activities, switchover/failover and troubleshooting.
- Performed Oracle performance monitoring and tuning using AWR, ASH, ADDM, SQL execution plans and database-level diagnostics to resolve performance and resource-related issues.
- Performed Microsoft SQL Server administration, including database creation, configuration, login/user and permission management, database backup/restore, SQL Server Agent jobs and routine maintenance.
- Supported SQL Server performance and database health monitoring, including disk space, database growth, transaction logs, indexes, statistics, blocking sessions and basic query performance troubleshooting.