Golden Gate Oracle Dba

RAMESH DAYAKA

Ph.: +1-571-***-****

E-mail: **********@*****.***

ORACLE DBA PROFESSIONAL

Professional Summary

14+ years of experience as Oracle DBA and Exadata DMA providing support for production 19c/12c/11g database versions on various platforms and Exadata versions from X2 till X9M.

In Depth knowledge of Exadata Compute, Storage, Network configuration and their internals.

Knowledge on Building Exadata from OEDA and configuring networks

Experience in installing, configuring standalone and Oracle RAC database versions 19c,12c,11g

Experience migrating Databases from Non-Exadata to Exadata systems

Worked on data replication and achieved high availability using Oracle Data guard and Golden Gate

Expertise in restoring and recovering databases using RMAN/Data pump.

Applied security patches/bug fixes and upgraded the databases from 12c to 19c.

Configured and maintained oracle enterprise manager 13C for monitoring databases and all the Exadata Components.

Experience in extending the Exadata configuration from Quarter rack and Half Rack

Experience with Database instance and SQL performance tuning using AWR, ASH, ADDM and explain plan.

Configured Uni and Bidirectional replication using Oracle Golden Gate and implemented conflict detection and resolution.

Experience on Exadata systems and hands-on experience in Exadata X8 patching, battery and disk replacements

Experience in resolving performance issues by analysing smart scan, storage indexes and HCC

Golden Gate Data Replication to non-oracle database platforms.

Experience in automation of Databases Patches using shell script

Automating regular database tasks using Shell and Python scripting TECHNICAL SKILLS

Databases Oracle 9i/10g/11g/12c/19c, Exadata, RAC, OCI, Oracle EBS:11i, R12.1, R12.2, WebLogic Replication Methods Oracle Golden Gate, Data-guard, ASM Programming Languages SQL, PL/SQL, Shell Script, Python. DBA Tools/Utilities OEM, GGSCI, SQL Developer/Toad, RMAN, EXPDP/IMPDP,TOAD Tuning Tools TKPROF, AWR, ASH, ADDM, EXPLAIN PLAN, Performance Tuning, Trouble-shooting Ticketing Tools Service-Now, Remedy

Operating Systems RHEL 4.x/5.x/6.x, Solaris 8/9/10, HP-UX 10.x/11.x and Windows 98/NT/XP Networking TCP/IP, HTTP, HTTPS, FTP/SFTP, DNS, DHCP, Telnet Other MS-Office, PowerPoint etc.

EDUCATION

Bachelor of Technology (B. Tech) in Electronics and Communication Engineering, JNT University–INDIA.

Master of Science (M.S) in Computer Science and Information Technology, Sacred Heart University–USA. CERTIFICATIONS

Oracle Certified Professional (OCP)–19c Oracle Database Administration–II(1Z0-083)

Oracle Certified Associate (OCA) –19c Oracle Database Administration–I(1Z0-082)

Oracle Certified Exadata Database Machine X9M Implementation Specialist 1Z0-902

Oracle Certified Golden Gate 12c Implementation Specialist –1Z0-447 Employer#6: VISA Inc. – Texas, USA

Duration: Dec 2024 to Till Date

Role: Senior DBA Consultant

Roles and Responsibilities:

Installation and configuration of 19C/12c/11g Oracle RAC Databases on Exadata Systems.

Identified Faulty disks and replaced physical disks in ASM and ensured rebalance is done.

Worked on Extending Exadata Quarter rack to half rack on X8.

Configured monitoring of Exadata compute, storage nodes and InfiniBand switches OEM and configured ASR.

Worked on upgrading the databases from 12c to 19c on RAC databases.

Worked on node addition /deletion in oracle RAC and troubleshooting RAC start-up issues.

Applied in place and out of place database patches for bug fixes and quarterly patches and automated patching procedure

Support production issues, troubleshoot both on premise databases as well as Relational Database Service (RDS).

Performing SQL tuning using Smart scan, Flash cache, Storage indexes and HCC.

Hands-on experience in Exadata X8 patching, battery, and disk replacements

Applied patches on Exadata compute, storage, and InfiniBand switches.

Administering Exadata components in ILOM and backup various Exadata configuration files

Configured IORM for performance enhancement and worked on DBFS DG

Analysed for performance improvement using various Exadata features such as smart scan, HCC and storage indexes

Compressed tables using Hybrid columnar compression based on the usage and validated InfiniBand switch performance

Performed near to zero down time upgrades using Golden gate

Configured and implemented physical standby database using Data Guard for high availability and providing critical solution with disaster recovery plan.

Performed switchover/failover activities in oracle data guard and converting physical standby to snapshot standby

Data Refresh from Production to Test and Development environments using RMAN Duplicate Database &Data Pump.

Configured and maintained Oracle uni and bidirectional Golden gate between multiple datacentres.

Configured Conflict detection and resolution, creating exceptions using Golden Macros.

Code deployments and adding tables to the golden configuration and creating the golden gate macros for CDR handling

Implemented backup/recovery procedures using RMAN, Data Pump.

Implemented flashback technology for performing point-in-time recovery and restore points.

Reorganizing tables and indexes thereby tuning the performance of a database.

Performance Tuning slow running queries using Explain Plan, SQL Trace, AWR, ADDM, SQL tuning advisor, SQL profiles, SQL plan baselines.

Performed near to zero down time upgrades using Golden gate

Performed code deployments in golden gate environment by adding tables with their exception handling and CDR columns.

Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.

Tuning slow Golden gate processes and upgrading extract, replicat from Classic to Integrated.

Automated regular DBA tasks using shell scripts

Environment: Oracle 12c,11g/10g, Linux, Solaris, AIX, OEM, ASM, RMAN, AWR, ADDM, TOAD, Shell scripting,SQL*Loader, Data guard, Stored Procedures, Grid Control, SFTP, Exadata, Golden Gate Employer#5: Oracle Corporation – California, USA.

Duration: Jul 2014 to Jul 2023

Role: Lead Oracle DBA

Roles and Responsibilities:

Implementation of High Availability solutions with Oracle 12C RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate. Establishing standards, policies and procedures for Goldengate replication administration.

Worked on Extending Exadata Quarter rack to half rack on X5-2.

Configured monitoring of Exadata compute, storage nodes and InfiniBand switches OEM and configured ASR.

Worked on upgrading the databases from 12c to 19c on RAC databases.

Worked on node addition /deletion in oracle RAC and troubleshooting RAC start-up issues.

Applied in place and out of place database patches for bug fixes and quarterly patches and automated patching procedure

Support production issues, troubleshoot both on premise databases as well as AWS - Relational Database Service (RDS).

Applied patches on Exadata compute, storage and infini-band switches

Administering Exadata components in ILOM and backup various Exadata configuration files

Configured IORM for performance enhancement and worked on DBFS DG

Hands-on experience in Exadata X8 patching, battery and disk replacements

Performing SQL tuning using Smart scan, Flash cache, Storage indexes and HCC.

Configure DG Broker setup for the data guard environments to assist automatic failovers.

Assisted in integration of Exadata applications into current IT actionable events and solutions

Troubleshooting and resolved issues in Golden Gate bi directional environment.

Identified Faulty disks and replaced physical disks in ASM and ensured rebalance is done.

Performed of databases using OEM 12C. Generated AWR, ADDM, ASH and taken Backups using OEM.

Responsible for performance tuning and identifying system bottlenecks / blocking and resolving in a timely manner.

RAC architecture implementation on 3 nodes for PROD and UAT environments.

Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity

Database backup and recovery using scripts to automate backup and recovery procedures for production databases

Troubleshooting & rising SRs with Oracle Metal ink for various database issues, upgrades, patches and performance issues.

Installation of Oracle 11g database and cluster ware software on Red hat Linux and creating new databases.

Installation, configuration, maintenance and tuning of ORACLE 11g, 10g databases on Sun Solaris 9 and IBM-AIX 6.1.

Upgraded Oracle 10g to 11g databases on Sun Solaris and Red hat Linux O.S.

Implemented Oracle 11g RAC installation on ASM and load balancing in RAC instances

Implemented 11g RAC Cluster installation and upgrades on Sun Solaris.

Involved in Performance tuning of the requests from end users created SQL Profile through SQL Tuning Advisory tool in OEM and through Command line.

Compressed tables using Hybrid columnar compression based on the usage and validated Infini-Band switch performance

Performed near to zero down time upgrades using Golden gate and Created XAG cluster resource on oracle RAC for Golden Gate high availability.

Tuning slow Golden gate processes and upgrading extract, replicat from Classic to Integrated.

Performed code deployments in golden gate environment by adding tables with their exception handling and CDR columns.

Enforced best execution plan to Oracle Optimizer by using base lines and also by attaching the SQL profile to database.

Adding a node and deleting node in 11g RAC Versions.

Worked on up gradation of all Dev/non-prod and production databases from 10.2.0.4 to 11.2.0.3 on Sun Solaris 9.

Handling large database environments and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and providing on-fly solutions to make database healthy and running. Environment: Oracle11g, OEM 11G, Oracle Golden Gate, Oracle RAC 11g, ASM, Linux, AIX 7.1, Solaris Net Backup, Toad, PL/SQL Developer, win-scp, putty

Employer#4: Emerson –Missouri, United States

Duration: May 2014– Jul 2014

Role: Lead Oracle DBA

Roles and Responsibilities:

Provided technical assistance for designing, installation and upgrading of existing Oracle databases.

Involved in Set up, configuration and maintenance of Oracle Data Guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

Disaster recovery management defined and implemented Production DR Databases, administration for log-shipping/stand-by database systems.

Worked on Extending Exadata Quarter rack to half rack on X5-2.

Applied patches on Exadata compute, storage and infiniband switches

Administering Exadata components in ILOM and backup various Exadata config files

Configured monitoring of Exadata compute, storage nodes and InfiniBand switches OEM and configured ASR.

Performing SQL tuning using Smart scan, Flash cache, Storage indexes and HCC.

Hands-on experience in Exadata X8 patching, battery and disk replacements

Delete/Add RAC nodes from an existing 12c/11g RAC cluster.

Oracle ASM on both clustered and non-clustered (Oracle Restart) databases

Configured and Designed RMAN backup strategy for various databases.

Installed, configured and maintained PostgreSQL databases

Moved non -sharded collection data from one shard to another and removing a share from the cluster in Mongo DB.

Monitored and killed long running operations on MongoDB and checking the replication lag.

Configured Golden gate uni and bi-directional replication and troubleshooting GG lag issues

Performed near to zero down time upgrades using Golden gate and Created XAG cluster resource on oracle RAC for Golden Gate high availability.

Implemented Golden Gate on AWS and Azure environments for cloud scalable solutions. Environment: Oracle 10g, Sun Solaris 9, Toad 8, Flashback, Data Pump, DBCA, DBUA, Grid Control (OEM 10G), Enterprise Manager Console, SQL*Loader, ODBC, OLTP, SQL Plus, SQL Developer, Putty. Employer#3: Tesco – London, United Kingdom

Duration: Nov 2012 - Jun 2013

Role: Senior Oracle DBA

Roles and Responsibilities:

Responsible for maintaining the Windows and UNIX servers covering following activities.

Network Management, Software installation / uninstallation, User management, Operation management, Space management, Add/remove devices.

Disaster backup recovery planning for OS level.

Cross platform activities like printing on NT printing server etc.

Responsible for OS level auditing & securities as per company standard.

Database Administration, Multiple databases on multiple platforms. OS platforms include IBM AIX, HP-UX.

Oracle up gradation and migration across various versions. Applying oracle security patches. Involved in setting up plan to apply oracle quarterly patches.

Technical support, accepting and solving problem tickets for various clients.

Installation of Oracle 8i/9i/10g on HP-UX/IBM AX/Linux, Solaris Production servers

Planed, tested, implemented Deployment check list and Upgrade documents in upgrading databases from 8.1.7.4 to 10.2.0.4

DB up gradation from oracle 9.2.0.6 to oracle 10g.

Involved in developing shell scripts which helped in managing Production systems.

Provided On call support for 380 production databases. Database size ranging from 10 GB to 3TB.

Involved in DBA activities for Production Environments

Installation, creation and support of Oracle 9i / 8i database in Production Environments

Monitoring databases, which include basic health checks, growth of objects, performance of the database and giving recommendations

Configuring database connectivity using Net8

Migration of Oracle databases from 8i to 9i using Export / Import

Setting up MTS / Shared Server, Standby databases

Performed HOT and COLD BACKUPS

Environment: Oracle 8i/9i/10g, ASM, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, UNIX Shell Scripting, Quest software tools, PL/SQL Developer. Employer#2: Oracle Corporation – California, USA

Duration: Mar 2012 - Sep 2012

Role: Oracle DBA

Roles and Responsibilities:

Installation, configuration, and maintenance of Oracle 10g/11g databases.

Installation, configuration, and maintenance of 11.2.0.3 Oracle Data Guard as a high availability solution.

Installing and configuring physical standby database using RMAN duplicate from active database on RHEL 6.3.

Maintaining Oracle Data Guard and ensuring that the physical standby is always in sync with primary database.

Possess strong RHEL and Solaris skills.

Experienced in Oracle Golden Gate installation, configuration and troubleshooting the gg issues.

Deployed uni-directional replication using Oracle Golden Gate

Create and maintain oracle Data guard database with physical standby using RMAN for the critical and production database. Monitor and manage effectively the Data guard, RAC and ASM databases.

Perform switchover or failover for Data guard database whenever is required. Troubleshoot data guard

Database related issues/failures.

Clone/Duplicate production database into Test/Development database using RMAN including Data guard, RAC and ASM databases.

Installing & configuring 11.2.0.3 RAC database on RHEL 6.3

Applying one off patch using OPATCH utility.

Creating and managing application schemas with appropriate table spaces and Indexes.

Refreshing application schemas using data pump export/import

Used RMAN to cloned and duplicated databases.

Environment: Oracle 11g/10g, RHEL 6, AIX 5.X, OEM grid control, TOAD, Data Pump, RMAN, AWR, ASM, Oracle Exadata Database Machine.

Employer#1: Xtreme IT Solutions, India.

Duration: May 2008 - Feb 2012

Role: Oracle DBA

Roles and Responsibilities:

Installation, configuration, and maintenance of Oracle 10g/11g databases.

Installation, configuration, and maintenance of 11.2.0.3 Oracle Data Guard as a high availability solution.

Installing and configuring physical standby database using RMAN duplicate from active database on RHEL 6.3.

Maintaining Oracle Data Guard and ensuring that the physical standby is always in sync with primary database.

Possess strong RHEL and Solaris skills.

Performance tuning of instance and SQL’s using AWR, ADDM, and ASH and tuning Golden gate Extracts/replicats .

Performed database management functions such as maintenance, access issues and security.

Executed processes for evaluation of system space, database allocation and storage metrics.

Maintained all existing databases and new installations at current and stable production levels.

Provided technical assistance for development of physical and logical architecture models on all Oracle server platforms.

Installation of 11g Oracle Software and create databases and migrate databases using export /import data pump utilities.

Upgraded databases from 10.2.0.4 to 11.2.0.3 and 11.2.0.4 manually (utlul12i) and also by using DBUA.

Made performance improvements to the database by building Partitioned tables and indexes and converted non-partitioned tables to partitioned tables.

Handling Database change request from the application developers on need basis.

Table space creations and adding data file to the database as database grows over a period of time.

Troubleshooting database problems faced by the application developers / users.

Involved in huge migrations of the databases through RMAN, traditional export/import and data pump.

Applied PSU and CPU patches as required by the standards.

Database migrations and upgrades using export/import from SUN Solaris servers to IBM Aix server.

Databases/Schema/Table Re-Organization for faster performance using export/import.

Suggested procedures for database performance and tuning of all database machines and related components.

Created approved processes and procedures for maintenance and upgrading of all database machines.

Developed strategies for disaster recovery services of all database machines along with advisory services.

Monitoring data loading jobs and to identify bottle necks and blocked sessions and create a report on the performance related issues.

Installed MongoDB, created setup replica sets, data scaling and clusters.

Installing, configuring and maintaining PostgreSQL databases, creating database cluster

Configuring high availability, load balancing and replication of PostgreSQL database

Backup and restore of PostgreSQL databases using SQL dump and file system level backup

Configure PostgreSQL standby databases and monitoring

Routine PostgreSQL database administration tasks such as vacuuming, reindexing and log file maintenance

Database Security - Respond to all Security Deviations, perform database configuration changes to maintain compliance, and provide support to internal and external auditors to maintain compliance.

Analysed for performance improvement using various Exadata features such as smart scan, HCC and storage indexes

Compressed tables using Hybrid columnar compression based on the usage and validated InfiniBand switch performance

Automating regular database tasks using Shell and Python scripting Environment: Oracle 11g/10g, RHEL 6, AIX 5.X, OEM grid control, TOAD, Data Pump, RMAN, AWR, ASM, Oracle Exadata Database Machine.

Thanks,

Ramesh Dayaka.

***

Contact this candidate