Gopal P

Having 10+ years of total experience as an IT professional.

Having around 5.6 years of experience as an Oracle Database administrator.

Well exposed to oracle practices and procedures in administration that includes Upgrade, ASM, RMAN, Datagaurd, Refresh and Backup & Recovery with RAC.

Amsurg (USA), OPTIMIZE RCM PVT. LTD, Oracle DBA, 04/01/24, 09/30/24, Involved in oracle 12c/19c DBA activities for supporting development and production environment., Managing the user accountable access and maintain the user profiles, roles and privileges., Monitoring and managing the listener and TNS connections for remote connectivity from end users and applications., Performing the schema and user object refreshes based on customer request using logical backups like EXP/IMP & EXPDP/IMPDP (Data pump)., Performing the day to day to daily check list of the databases and verifying the scheduled jobs., Experience in database upgrade 12c to 19c databases., Maintaining the database backups using RMAN and manual backups., Cloning the databases from one environment to another environment based on the client requirement., Experience in maintaining the ASM instances and diskgroups., Administration of database instances in RAC environment., Maintaining the RAC databases using srvctl commands., Experience in configuration and managing the Data guard., Supporting for on-call. Gensiscare (USA), Omega Healthcare Management service PVT.LTD., Oracle DBA, 03/01/22, 09/30/23, Installations and configurations of Oracle 12c, 19c on various UNIX Flavors., Creating table spaces and monitoring their growth and Resize or add more data files to database or table spaces for space related issues., Created Users, Roles, Profiles and assigned privileges, profiles and roles to appropriate users., Moving data between databases using utilities like Export /Import., Reorganization of Tablespaces on scheduled basis., Applying patches using OPatch utility., Taking the online and offline backups on weekly and Monthly basis., Implementation of Backup and Recovery Strategies using RMAN., Monitoring the alert log files on regularly., Data Guard configured Physical Standby and tested for switchover, failover for the production databases., adding the Cluster node to existing cluster, cloning the Non RAC databases to RAC databases, Taking backup of OCR and VOTING DISK., Load balancing on both server side and client side. CHMB Inc., ACN Healthcare RCM PVT. LTD, Oracle DBA, 05/01/18, 03/31/22, Creating table spaces and monitoring their growth and Resize or add more data files to database or table spaces for space related issues., Created Users, Roles, Profiles and assigned privileges, Profiles and Role to appropriate users., Moving data between databases using utilities like Export /Import and Transportable Table spaces., Reorgansing the Tablespaces on scheduled basis., Applying patches using OPatch utility., Implementation of Backup and Recovery Strategies using RMAN., Monitoring the alert log files on regularly., Monitoring Alert Log file., Experience in user managed cloning., Experience in Exp/Imp and Data pump utilities. Advocate, ACN Healthcare RCM PVT. LTD, Oracle DBA, 07/01/12, 04/30/18, Managed operational documentation and client communication., Acted as the first point of contact for internal users and client teams, logging and resolving IT-related queries., Managed ticketing and issue tracking, escalating unresolved incidents to appropriate teams., Maintained operational and support documentation., Facilitated access requests, password resets, and basic troubleshooting steps., Coordinated with infrastructure and application teams to ensure smooth issue resolution., Followed up on incident closures, collected user feedback, and maintained satisfaction logs., Managed operational documentation and client communication.

Linux, Windows, Solaris, AIX, Oracle 11g, 12c, 19c, Exp/Imp, Data Pump, RMAN, SRVCTL, Putty, VNC server, TOAD, SQL developer

• Monitoring and Maintenance of ORACLE Databases of Production, Development and Testing Environments.
• Installed, Configured & Administered Oracle Servers on Linux, Solaris and Windows in version 11g/12c and 19c versions.
• Having experience in creating database using manual and DBCA method.
• Monitoring & managing the table spaces growth.
• Enrolling new users and maintaining system security (Profiles), Roles, System and object Privileges and managing user quotas.
• Managing Redo log and Archive log files.
• Having experience in Configuring Pfile/SPfile in both 12c and 19c versions.
• Having extensive knowledge in OMF, Startup and Shutdown steps.
• Diagnose and monitoring Alert log files. Clean up of old logs and traces.
• Refreshing the schemas and user objects using logical backups Exp/Imp & Empdp/Impdp.
• Experience in maintaining physical backup (Hot and Cold backup).
• Performed and maintained backup and recovery strategies for the database using logical (Export & Import), physical (hot & cold) and RMAN backups.
• Cloning of the database using online, offline and RMAN.
• Having in-depth knowledge in oracle Architecture.
• Having Experience to Upgradation of Oracle databases from 11g to 12c and 12c to 19c.
• Applying database patches using Opatch Utility.
• Configure networking and managing DB links and Materialized Views.
• Experience in configuring ASM Disks & ASM database creation.
• Knowledge on Oracle Database performance-tuning service with AWR, ADDM reports.
• Having good experience on Creating indexes, Rebuilding indexes and Table re-organizations procedures.
• Configured and Managed Data Guard (Standby Database).
• Installation cluster ware software and Oracle Database software in RAC.
• Experience adding the Cluster node to existing cluster.
• Experience in maintaining the Cluster databases using Srvctl.
• Taking backup of OCR and VOTING DISK.
• Managing production/test database, ensure database availability.
• Resolve issues of customer through ticketing tool.
• Evaluate Oracle features & related products. Setup and maintain documentation and standards.
• Troubleshooting the Database Issues and Performance Issues.
• Working in 24/7 production support environment.