Shiny M.

.Having 5 years of experience as an Oracle Database Administrator with expertise in Oracle Database 12c and 19c in Production, UAT, and Development environments.
.Hands-on experience working with Oracle Enterprise Manager (OEM) 24 AI for database monitoring, incident management, performance analysis, compliance monitoring, and job scheduling.
.Experienced in administering 4-node Oracle RAC environments integrated with Oracle Data Guard, ensuring high availability and disaster recovery.
.Hands-on experience in Oracle software installation, database creation using DBCA, Manual, and ASM on Oracle 12c and 19c.
.Strong understanding of Oracle Database Architecture, memory structures, background processes, and storage architecture.
.Experience in creating, managing, and maintaining Tablespaces, datafiles, temporary tablespaces, and undo tablespaces.
.Experienced in creating and managing Users, Roles, Profiles, and granting/revoking system and object privileges based on security requirements.
.Hands-on experience in configuring, administering, and maintaining Oracle ASM Disk Groups, ASM instances, and storage management.
.Extensive experience in configuring and managing RMAN backups, backup validation, restoration, and database recovery.
.Experience in performing logical backup and migration activities using Oracle Data Pump (expdp/impdp).
.Hands-on experience in configuring, monitoring, administering, and troubleshooting Oracle Data Guard, including physical standby databases, log transport services, switchover, failover, and recovery operations.
.Led quarterly Oracle Release Updates (RU), OPatch activities, and database upgrades from Oracle 12.2.0.1 to Oracle 19c with post-upgrade validation.
Hands-on experience in Oracle Database upgrade planning, execution, and post-upgrade health checks.
.Experience in performing RMAN Active Database Duplication, backup-based cloning, and database refresh activities.
.Performed schema refreshes and database migration activities using Oracle Data Pump as per business requirements.
.Managed ASM disk groups by creating, adding, dropping, resizing, and rebalancing disks.
.Experience in monitoring Alert Logs, Trace Files, Listener Logs, ADRCI, and resolving production database issues.
.Hands-on experience in installing and configuring 2-node Oracle RAC 19c environments using Oracle Grid Infrastructure and ASM.
.Experienced in administering Oracle Clusterware using SRVCTL, CRSCTL, OCRCONFIG, ASMCA, and NETCA utilities.
.Experience in performing daily production database administration activities, including health checks, capacity planning, space management, performance monitoring, database cloning, patching, backup verification, and incident resolution.
.Worked on PostgreSQL database administration, including installation, database creation, user management, backup and restore, monitoring, and routine maintenance activities.
.Worked on MySQL and Microsoft SQL Server administration at the L1 support level, handling service monitoring, backup verification, user management, basic troubleshooting, and ticket resolution.
.Good exposure to Linux administration and Shell Scripting for database automation and routine administrative tasks.
.Strong analytical, troubleshooting, and problem-solving skills with experience in supporting 24×7 production environments and meeting SLA requirements.
.Hands-on experience using ServiceNow for incident management, service requests, change management, problem management, and SLA-based ticket handling in production support environments.