Golden Gate Oracle Database

Kiran Kumar Ravva

Email: ***************@*****.***

Mobile no: +484-***-****

Over 10 years of experience as an Oracle Database Administrator having hands on experience in Oracle Database administration, Installation, configuration, patches, upgradation, backup & recovery, cloning, database security, Oracle Golden Gate and Exadata seeking challenging position to utilize my skills and knowledge in managing and optimizing Oracle database and ensuring their high availability and performance.

Summary of qualifications:

• 10 years of experience as an Oracle Database Administrator.

• Strong knowledge of Oracle database Administration, including installation, configuration, patches, upgradation, backup & recovery, cloning, database security.

• Proficient in Oracle Golden Gate for real-time data integration and replication.

• Experience in managing Oracle Exadata Database Machine for high-performance and scalable database solutions.

• In-depth understanding of Oracle database, Golden Gate, Exadata Architecture, performance tuning, backup and recovery, and security.

• Strong knowledge on SQL queries.

• Excellent problem-solving and analytical skills.

• Strong communication and interpersonal skills.

Feb 2019 – May 2023.

Oracle Database Administrator

Client: State of PA

Loc: Pennsylvania, Philadelphia.

Roles and Responsibilities:

• Worked with Implementation services team being part of Design, Develop, Implementation, Test (POC), Go-Live.

• Extensive experience as an Oracle Production DBA in Installations, Configuration, Upgradation, Management and troubleshooting of Oracle Databases 12c platforms covering in Linux operating systems and Windows.

• Installed, configured and maintained Oracle Database11g,12c,18c,19c on various operating systems (Linux, Windows, Unix).

• Worked in Data Centre environments.

• Managed database security by implementing user access controls, roles, and privileges.

• Monitored Database performance using Oracle Enterprise Manager, identifying and resolving performance bottlenecks and optimizing SQL queries.

• Implemented Backup and recovery strategies, including full and incremental backups, point-in-time recovery, and disaster recovery solutions.

• Conducted regular database health checks and performed routine maintenance tasks such as database reorganizations, index rebuilds, and statistics gathering.

• Worked closely with application developers to design and implement efficient database schemas and SQL queries.

• Implemented High Availability Solutions using Oracle Data Guard for Database replication and Failover.

• Configured and managed Oracle Golden Gate for real-time data replication between production and reporting databases.

• Resolved the issues in conflicts between the target and source database in Golden Gate.

• Migrate Oracle database 11g from Linux Boxes to Exadata machine using Golden Gate and Export & Import.

• Installed and configured extract, pump, replicat, manager parameter file of Golden Gate.

• Successfully configured Oracle Golden Gate unidirectional and Bidirectional replication Configurations.

• Performed Oracle Golden Gate Initial load.

• Performed Active-Active Oracle Golden Gate Bidirectional replication.

• Designed, implemented, and managed multiple Oracle Exadata environments, including Exadata X8-2 and X7-2 models, for a large-scale enterprise.

• Conduct capacity planning and performance analysis to optimize database performance and ensure efficient resource utilization.

• Developed and implemented backup and recovery strategies to minimize data loss and ensure disaster recovery preparedness.

• Collaborated with cross-functional teams to provide database support, including performance monitoring, troubleshooting, and resolving production issues.

• Implemented security measures, such as user access controls, data encryption, and vulnerability assessments, to protect sensitive data.

• Successfully Implemented 11g/12c/19c RAC Database server configuration setup.

• Applying Patches at grid level and database levels.

• Successfully implemented Data Guard setup for 11g,12c & 19c Databases.

• Performed switchover activities in physical standby databases.

• Adding and re-allocating Cluster related resources using CRSCTL and SRVCTL command line utility in RAC.

• Applying the necessary Oracle Patches to Production and Test Servers and Install new versions of the Oracle and its tools.

• First hands-on experiences in software and firmware maintenance of both Database and storage servers in the Exadata database machine including upgrades and patching.

• Deep Understanding about Exadata specified features like Smart scan, HCC Hybrid Columnar Compression, Flash Cache, Flash Logs, etc.

• Worked on Exadata X7 and X8 machines which include Half Rack and Full Rack.

• Created OEDA requirement document for Oracle to setup the new Exadata X7 and X8 machines so Oracle ACS can install Grid infrastructure 12cR2 and Databases 11g R2 and 12c and 19c.

• Installation of OJVM patch on 11gR2 database on Exadata X7 environments before migrating it to Exadata X8 machines to match with Bundle patch version.

• Software and Firmware maintenance of Exadata storage servers in the database machine including routine health check, patching and upgrades according to suggestions from Oracle support department.

• Cloning the Production database to Master Database using gDBCLONE utility

• Migrating Database to Exadata using RMAN Duplicate.

• Migrating Database to Exadata using active duplicate database.

• Creating N number of clone databases for UAT/TEST/DEV for Application testing.

• Exadata Bundle patching with Oracle support department using Patching Scheduling Tool.

• Patching Exadata Machines using Rolling/Non-Rolling/Hybrid Methods to achieve better performance.

• Providing EXACHECK report to Oracle support team for Patch analysing.

• Used Tools like Exachk, Sundiag, ILOM Snapshot, Oracle TFA, Exa-Watcher/OS-Watcher, SOS report, Diag collection and Smart Scan for Monitoring and Diagnosing Exadata and RAC Machines.

• Managing the databases in 24/7 in high-availability Production Environments.

• Cloning of Database (Refresh of Test DB with Production DB), handling the SLA’s as per client agreement.

• Applying Oracle quarterly released patches on regular basis on approvals from application team and client.

• Analytical and able to adapt to new environments and learn new technologies quickly.

• Analysing and determining informational needs and elements, data flow and storage requirements, and data output, reporting capabilities for complex databases.

• Good knowledge on MS-SQL Database servers.

• Provide problem resolution of reported database issues reported via IT team members, automated notifications, and IT Request system in compliance with applicable SLA (Service Level Agreement). Provide support to junior staff members who cannot find resolutions to open issues.

• Designs, installs, monitors, and maintains Dev, QA and production Oracle (11g, 12c,18c,19c) database environments.

• Developing and creating database performance monitoring and tuning strategy.

• Managed user’s passwords and account unlocks.

• Performing ongoing database activities to keep Databases up-end-running.

• Maintained and updated the database schemas as requested by the Lead Dba.

• Created roles and users and managed their privileges.

• Optimizing database uptime/availability.

• Adding and re-allocating Cluster related resources using CRSCTL and SRVCTL command line utility in RAC.

• Applying the necessary Oracle Patches to Production and Test Servers and Install new versions of the Oracle and its tools.

• First hands-on experiences in software and firmware maintenance of both Database and storage servers in the Exadata database machine including upgrades and patching.

• Advise, provide guidance and develop Disaster Recovery strategies for Exadata Machines.

• Solid skills to configure Exadata to meet company internal security requirements.

• Monitoring and escalation into existing IT monitoring and actionable events solutions.

• Handled Critical issues while implementing 12c RAC setup.

• Handling the Service Request SLA's as per client agreement.

• Database support for daily activities such as checking and Troubleshoot database problems if any.

• Needs effective communication skills to interact with different teams and management.

• Analysing and determining informational needs and elements, data flow and storage requirements, and data output and reporting capabilities for complex databases.

• Experience with Oracle and MS-SQL Databases.

• Provide problem resolution of reported database issues reported via IT team members, automated notifications, and IT Request system in compliance with applicable SLA (Service Level Agreement). Provide support to junior staff members who cannot find resolutions to open issues.

• Designs, installs, monitors, and maintains Dev, QA and production Oracle (11g, 12c,18c,19c) database environments.

• Developing and creating database performance monitoring and tuning strategy.

• Managed user’s passwords and account unlocks.

• Performing ongoing database activities to keep Databases up-end-running.

• Maintained and updated the database schemas as requested by the Lead Dba.

• Created roles and users and managed their privileges.

• Optimizing database uptime/availability.

• Implemented RMAN backup and monitoring of all backup jobs. NCG – Team Lead May 2018 – Jan 2019.

Oracle Database administrator

Client: RBS (Royal Bank of Scotland)

Loc: Mumbai, India.

Roles and Responsibilities:

• Worked with Implementation services team being part of Design, Develop, Implementation, Test (POC), Go-Live.

• Experience as an Oracle Production DBA in Installations, Configuration, Upgradation, Management and troubleshooting of Oracle Databases 12c platforms covering in Linux operating systems and Windows.

• Installed, configured and maintained Oracle Database11g,12c,18c,19c on various operating systems (Linux, Windows, Unix).

• Successfully Implemented 11g/12c Database server configuration setup

• Raising tickets in service now, raising standard change as a part of change management to perform scheduled activities like DR Drill, Oracle Patching, DB Upgradation, Annual power shutdown.

• Applying the necessary Oracle Patches to Production and Test Servers and Install new versions of the Oracle and its tools.

• Checking the Archive log shipping between the Primary and the standby databases and Troubleshooting it by rebuilding the Standby databases.

• Support to development, testing and production support team for database related issues in the application.

• Database support for daily activities such as checking and Troubleshoot database problems if any.

• Performed DR activities.

• Handling the Service Request SLA's as per client agreement.

• Working in DATA Centre of Production as well as DR.

• Creating DB link between two databases.

• Managing Archive logs to maintain spaces on mount points.

• Checking DR in sync with production databases.

• Taking Backup of Tables, Schemas, Tablespaces.

• Export & Import using Data pump.

• Taking RMAN Backup of Database.

• Taking cold and hot backups on scheduled times and monitoring backups.

• Monitor & analyzing Indexes and rebuilding indexes online.

• Refresh Logical Data from Production to Development or Testing databases.

• Creating and maintaining the physical standby database using data guard.

• Monitored the production Oracle alert logs / Cluster alert log for database errors.

• Experience with switchover and switchback between primary and standby databases.

• Planning and executing switchover procedures during Annual Power Shutdown.

• Solving customer’s issue based on tickets & raising change requests. TECHMAHINDRA FEB 2017 – APR 2018.

Software Engineer

Client: SBI (State Bank of India)

Loc: India

Roles and Responsibilities:

• Extensive experience as an Oracle Production DBA in Installations, Configuration, Upgradation, Management and troubleshooting of Oracle Databases 11g,12c platforms covering in Linux operating systems and Windows server.

• Successfully Configured 4-Node RAC on Linux Platform.

• Worked for Critical Database Performance Related Issues and Part of Serverity-1 (high priority) Call and handled many issues.

• Successfully installed oracle 12c in windows2012 R2 servers.

• Handled Critical issues while implementing 12c Rac setup.

• Cloning of Database (Refresh of Test DB with Production DB).

• Handling the Service Request SLA's as per client agreement.

• Applying the necessary Oracle Patches to Production and Test Servers and Install new versions of the Oracle and its tools.

• Database support for daily activities such as checking and Troubleshoot database problems if any.

• Performed DR Implementation in DATA Centre.

• Working in DATA Centre of Production as well as DR.

• Installing and configuring CRS on all cluster nodes and installing oracle 12c software for RAC.

• Applying patches at Grid level and database level in 12c environment.

• Successfully implemented Data guard setup in 12c Rac.

• Managing Archive GAP in Physical Standby databases and resolving the issues related to Data guard.

• Managing the databases in 24/7 in high-availability Production Environments.

• 24/7 collaborating with client for integration of database servers.

• Excellent communication (verbal/written) and Client facing skills. Oracle Core DBA Skills:

• Experience with Installing Oracle 10g and 11g software on Red hat 5/6 and windows platform.

• Experience in monitoring and troubleshooting database performance bottle-necks.

• Experience in ASM.

• Experience in monitoring & resolving standby database (Data guard).

• Experience in handling Diff. types of recovery.

• Experience on applying patches.

• Good experience with database upgrade.

• Developing and creating database performance monitoring and tuning strategy.

• Managed user’s passwords and account unlocks.

• Performing ongoing database activities to keep Databases up-end-running.

• Maintained and updated the database schemas as requested by the Lead Dba.

• Created roles and users and managed their privileges.

• Optimizing database uptime/availability.

• Implemented RMAN backup and monitoring of all backup jobs IT CONVERGENCE Mar 2016 - Feb 2017.

Software Engineer

Project: Orthofix

Loc: India.

Tasks Handled:

Oracle RAC Environment:

• Regular monitoring of Databases on day-to-day basis in RAC setup.

• Maintaining RAC databases.

• Performed successful Upgradation of 10g RAC TO 11G RAC.

• Successfully Installed and Configured 11g RAC 2 node cluster setup.

• Successfully performed adding node and removing node in existing 11g RAC environment.

• Successfully done cloning of prod database for Development and Testing in 11g RAC environment.

• Successfully converted single instance database to Cluster database.

• Applied Patches successfully in 11g RAC environment.

• Monitoring and Troubleshooting Interconnect related issues.

• Trouble-shooted RAC performance related issues using AWR report.

• Providing Scalability by adding Nodes in RAC environment. Oracle Core DBA Environment:

• Regular monitoring of Databases on day-to-day basis.

• Performed successfully upgradation of database from 10g-11g.

• successfully done installation of 11g oracle.

• Applied successfully database Patches using OPatch Utility.

• Monitoring and resolving standby database Configuration.

• Performed ASM installation successfully.

• Adding disks, creating Disk Groups and Monitoring Disk Groups.

• Managing the database security with users/session, privileges, roles and auditing.

• Regularly performed Refresh of schemas/tables using data pump utilities.

• Performed Database backups using Cold and Hot backup methods.

• Performed successful in Configuring and managing backup through RMAN utility.

• Recovery of the database in case of failures [loss of Control file, loss of Data file(s), loss or crash of Table space(s), entire database crash.]

• Recovery using RMAN Methodologies.

• Cloning of the databases using online, offline, RMAN and export/import backups.

• Performed successful of cloning the databases through Hot/Cold and RMAN utility and refreshing the databases.

• Troubleshoot the issue as and when required.

• Analytical and able to adapt to new environments and learn new technologies quickly. Cognizant Apr 2013 - Mar 2016.

Oracle DBA

Project: Internal

Loc: India.

• Troubleshoot the issue as and when required.

• Analytical and able to adapt to new environments and learn new technologies quickly.

• The role needs excellent problem solving and troubleshooting skills.

• Needs effective communication skills to interact with different teams and management.

• Analyzes and determines informational needs and elements, data flow and storage requirements, and data output and reporting capabilities for complex databases.

• Experience with Oracle and MS-SQL Databases.

• Provide problem resolution of reported database issues reported via IT team members, automated notifications, and IT Request system in compliance with applicable SLA (Service Level Agreement). Provide support to junior staff members who cannot find resolutions to open issues.

• Designs, installs, monitors, and maintains Dev, QA and production Oracle (10g, 11g,) database environments.

• Developing and creating database performance monitoring and tuning strategy.

• Managed user’s passwords and account unlocks.

• Performing ongoing database activities to keep Databases up-end-running.

• Maintained and updated the database schemas as requested by the Lead Dba.

• Created roles and users and managed their privileges.

• Optimizing database uptime/availability.

• Implemented RMAN backup and monitoring of all backup jobs.

• Utilized oracle support to troubleshoot and solve critical issues.

• Installed and configured databases in Linux and Unix and windows servers. Education:

Academic Credentials

Bachelors:

Bachelors of Electronics and Communication Engineering JNTU HYD in 2010, Andhra Pradesh, India. Technical skills:

Languages

SQL, PL/SQL, Unix/Linux/Aix.

Databases

Oracle 10g, 11g, 12c, 18c, 19c & MS-SQL

2012, 2016,2019.

Development Tools

SQL, Plus, RMAN, Data Pump

(exp, imp, expdp, impdp), Asmcmd,

Asmca, VMware, Putty, Exachk,

sundiag, TFA, ILO, SOS, Golden

Gate.

Operating Systems

Oracle Linux, Red Hat Linux RHEL 5/6/7,

MS Windows 95/98/ME/NT/2000/XP

Environment: Oracle 10g,11g,12c,18c,19c Oracle RAC 11g,12c,18c,19c, Exadata X7/8, Oracle Linux 5/6/7.

Contact this candidate