• Administer and maintain Oracle (12c-19c) and Microsoft
SQL Server (2019-2022) databases across production, UAT,
and DR environments.
• Deployed and configured multiple SQL Server Always-On
Availability Groups and Oracle Data Guard setups from
scratch, ensuring high availability and disaster recovery
readiness.
• Installed, upgraded, and migrated Oracle databases
(including 19c RAC on ODA) and SQL Server instances
across Windows and Linux platforms.
• Performed RMAN XTTS migration for UAT Oracle database
from AIX legacy systems to Exadata Cloud@Customer
(ExaCC) with zero data loss.
• Managed ASM storage using ASMCMD to create disk
groups, add storage, and optimize space utilization.
• Implemented Transparent Data Encryption (TDE) and data
masking policies to enhance database security and meet
compliance requirements.
• Conducted Data Guard and Always-On DR drills,
validating role transitions, redo transport, and recovery
performance. Kubernetes / kubectl
Docker / YAML
5 years of
• Monitored and tuned database performance, analyzing
AWR/ASH reports, redo generation rates, and network
throughput between primary and standby databases.
• Diagnosed and resolved critical Data Guard issues (e.g.,
ORA-16198, NI checksum mismatch, FAL archive errors)
following MOS and Oracle best practices.
• Configured and maintained RMAN backup strategies,
ensuring validated recovery windows and automated
cleanup policies.
• Performed network throughput testing (oratcptest) and
optimized redo transport.
• Managed Oracle Audit Vault & Database Firewall (AVDF)
setup, unified audit policies, and wallet rotation
procedures for compliance.
• Applied and validated quarterly patch updates for both
Oracle and SQL Server databases
• Performed database schema migrations across multiple
environments.
• Worked extensively on Linux and Windows servers,
including file system management, and service
automation.
• Collaborated with application and infrastructure teams
during migrations, patching, and troubleshooting to
ensure smooth database operations.
- Company industry:
- IT Services