Oracle Manager

Location:

Irving, TX

Posted:

September 21, 2020

Contact this candidate

Resume:

Manohar Reddy Padamati ******.******@*******.***

Sr. Oracle Database Administrator Phone# 972-***-****

PROFESSIONAL SUMMARY:

10+ years of experience in IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 19c/12c/11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.

Hands on experience with database performance tuning, backup and recovery, cloning, space management, and database security.

Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).

Experience in configuring Oracle Multitenant Container Databases (CDB) and Pluggable Databases (PDB) in Oracle 19c/12c RAC.

Strong experience in Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.

Experience in Backup and Recovery, Disaster Recovery options and Oracle Recovery Manager (RMAN).

Experience in configuring standby databases using Oracle Data Guard.

Proficient in working with Grid Control and Oracle Enterprise Manager (OEM) Cloud Control 13c/12c, and OEM 11g/10g.

Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.

Expertise in Installing and configuring ASM and RAC for high availability databases.

Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.

Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.

Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.

Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Experience in cloning Database from Production to Test and Development and from Development to Production.

Over 4+ years of Oracle Golden Gate experience in performing database upgrades, Cross platform/heterogeneous environment (Operating Systems & Databases) migrations, and replications.

Good knowledge in Oracle Golden Gate installation, configuration (Extract/Pump/Replicat processes), and troubleshooting Oracle Golden Gate issues.

Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.

Experience in Oracle 19c GDS (Global Data Services) Catalog creation, GDS GSM (Global Service Manager) Server installation, registration of Oracle GSM Server with the GDS Catalog, Oracle GDS pools creation, registration of databases in GDS pools, and Oracle GDS services creation.

Hands on experience in setting up and administering Oracle Streams, also configured replication based on Oracle Streams.

Worked on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack.

Experience in migration of oracle database to higher version and installing patches.

Experience in writing shell scripts to check to the Status, Space Management and Performance of Database. Exporting and Importing of dumps using expdp and impdp.

Extensively used the Grid Control for maintaining many databases together on separate servers.

Having experience in performance tuning issues using AWR and ADDM Reports.

Responsible for interacting with business partners to identify information needs and business requirements.

Excellent interpersonal, strong analytical and problem-solving skills with customer service-oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

PROFESSIONALL SKILLS

Operating Systems

Red Hat Linux RHEL 2.1, 3.x, 4.x,5.x,6.x,7.x, HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.

Data Bases

Oracle 12cRAC/12c/11gRAC/11g/10gRAC/10g/9i/8i, SQL Server 2005/2008

Languages

SQL, PL/SQL, Dynamic SQL, C, C++, UNIX Shell Scripting, Perl Script, XML, JAVA

Tools/Utilities

RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, DBArtisan, Patch Management, SQLNET, ODBC, Oracle Streams, Data pump, Data Guard, VERITAS Net Backup, VMware, Zabbix,AWS

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation

Putty, MTPutty, Telnet, Secure CRT, FTP, WinSCP

PROFESSIONAL EXPERIENCE

Delta Air Lines, Inc. March’19 – Present

1500 Towerview Rd, Building J, Eagan, MN 55121

Role: Senior Oracle DBA

Delta Air Lines, Inc. located in Atlanta, Georgia, is in the business of transportation of passengers and cargo. Delta has 80,000 employees worldwide and offers service to more than 350 destinations in nearly 70 countries on six continents. The project (AppMod-Application Modernization) we’re working on is about upgradations, and cross-platform migrations to setup stabilize and maintain database environments in Non-prod and Prod with Oracle 12c R2/19c R1 RAC using Oracle Golden Gate 12c/19c and Oracle Data guard 12c R2/19c R1.

Responsibilities:

Building new, or upgrading / patching existing databases and associated software in accordance with vendor best practices;

Setting up/Installation and configuration of 18c/19c ASM GI (Grid Infrastructure), Oracle Binaries 12c/19c, and 12c/19c RAC databases and Non-RAC CDBs/PDBs on EXADATA machines.

Managing Tablespaces, Users, and privileges for Container Databases (CDB), and pluggable databases (PDB) in Oracle 12c/19c RAC.

Delivering required database functionality that meets project requirements on or before defined due date;

Working with Delta Oracle Engineers and our service provider to deliver a highly available, resilient and performant database environment;

Translate a logical data model and user specifications into a physical design;

Ensure the detailed physical design of data structures and database complies with enterprise build and configuration standards and processes;

Install, configure, and maintain Oracle software on database and application servers as required;

Create physical database structures based on physical design for development, test, and production environments;

Install, configure and maintain Oracle Golden Gate for use as a database migration tool and for bi-directional replication;

Experience in Oracle Golden Gate installation, configuration (Extract/Pump/Replicat processes), and troubleshooting Oracle Golden Gate issues.

Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.

Performed Oracle Golden Gate upgradations, and cross-platform/heterogeneous environment (Operating Systems & Databases) migrations using Oracle Golden Gate 12c/18c/19c.

Provide consultation to application development teams on Oracle database technical issues and techniques;

Configured OGG (Oracle Golden Gate) Bi-directional setup by using Oracle DBFS (Database File System), XAG (Grid Infrastructure Bundled Agent), GoldenGate resources to support CA (Continous Availability).

Worked on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack.

Migrated databases from Exadata X2/X3 machines to Exadata x6 machines

Created OEDA (Oracle Exadata Deployment Assistant) requirement document for Oracle to setup the new Exadata X6 machines.

Worked with network and linux teams to configure the network (i.e., LACP (Link Aggregation Control Protocol) for client and backup network) on the Exadata x6 machines.

Worked with Storage team in configuring Netbackup and Datadomain on Exadata X6 machines.

Experience in Oracle 19c GDS (Global Data Services) Catalog creation, GDS GSM (Global Service Manager) server installation, and registration of Oracle GSM Server with the GDS Catalog.

Experience in Oracle 19c GDS pools creation, registration of databases in GDS pools, and Oracle GDS services creation to connect application users.

Database performance testing and tuning, user configuration, security and support processes including gather stats, database backup/recovery, partition administration, etc;

Ensuring Delta’s Oracle database environment is secure, providing recommendations for improving database security and implementing approved security improvements;

Coordinating downtime with application teams and system engineers to implement approved changes;

Interfacing with vendor Microsoft to resolve operational issues or questions;

Following established IT / DBA policies and procedures.

Environment: Oracle 19c R1 RAC, 12 R1/R2 RAC, 11gR2 RAC, OEM Cloud Control 13c, OEM 11g, RMAN, Data Guard/ADG, Oracle Golden Gate 19c/18c/12c, TOAD 12.8, EXADATA, RHEL/Linux 7.5, and ASM 12c/18c/19c.

Charles Schwab Dec’17 – Feb’19

4701 E Francisco Dr, Phoenix, AZ

Role: Senior Oracle DBA

The Charles Schwab Corporation is a bank and brokerage firm, based in San Francisco, California. It was founded in 1971 by Charles R. Schwab and is one of the largest banks in the United States as well as one of the largest brokerage firms in the United States. The company provides services for individuals and institutions that are investing online. The company offers an electronic trading platform for the purchase and sale of financial securities including common stocks, preferred stocks, futures contracts, exchange-traded funds, options, mutual funds, and fixed income investments. The project we’re working on is about upgradations, and cross-platform migrations to setup stabilize and maintain database environments in Non-prod and Prod with Oracle 12c R1 RAC using Oracle Golden Gate 12c and Oracle Data guard 12c R1.

Responsibilities:

Planning and implementing DR & high availability solutions using Oracle 12c R1 (12.1.0.2) Standby Database using Oracle Data guard, 12c R1 RAC.

Configuring Oracle Multitenant Container Databases (CDB) and Pluggable Databases (PDB) in Oracle 12c RAC.

Setting up/Installation and configuration of 12c R1 RAC CDB, PDB, and Non-CDB with ASM 12.1.

Converting Oracle 12c Non-CDB databases to PDB, and CDB databases.

Managing Tablespaces, Users, and privileges for Container Databases (CDB), and pluggable databases (PDB) in Oracle 12c RAC.

Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

Replicated databases using Oracle Golden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag.

Oracle Enterprise Manager (OEM) Cloud Control 13c on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.

Experience ensuring the high availability, integrity of databases & database designing.

Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.

Wrote Shell Scripting for managing day-to-day activities and automation of backup.

SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.

Creating and rebuilding indexes and optimizing the code to improve the performance.

Experience in Oracle Golden Gate installation, configuration (Extract, Pump, Replicat processes), and troubleshooting Oracle Golden Gate issues.

Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.

Performed Oracle Golden Gate upgradations, and cross-platform/heterogeneous environment (Operating Systems & Databases) migrations using Oracle Golden Gate 12c R1 & R2.

Creating and managing database objects such as tables, indexes, partition tables and views.

Monitoring and Troubleshooting of Database Replication issues.

Environment: Oracle 12c R1, 11g R2 RAC, OEM Cloud Control 13c, RMAN, Data Guard, Oracle Golden Gate 12c R1 & R2, TOAD 12.8, Zabbix 2.4.4, AIX 7, RHEL/Linux 7.5, ASM 12.1.

Dell Inc. Oct’16 – Nov’17

One Dell Way, Round Rock, TX

Role: Senior Oracle DBA

Dell Inc. is a multinational computer technology company based in Round Rock, Texas and, along with Dell EMC, is a subsidiary of Dell Technologies, one of the largest technology companies in the world. Dell manufactures, sells, repairs, supports personal computers (PCs), servers, data storage devices, network switches, computer software, computer peripherals, high-definition televisions, cameras, printers, and electronics built by other manufacturers. The project we were working on was about OGG 12c virtualization, upgradations, and cross-platform migrations to setup, stabilize and maintain database environments in Non-prod and Prod with Oracle 11g R2 RAC using Oracle Golden Gate 11g/12c and Oracle Data guard 11gR2.

Responsibilities:

Planning and implementing DR & high availability solutions using Oracle 11g R2 Standby Database using Oracle Data guard, 11g R2 RAC.

Setting up/Installation and configuration of 11gR2 RAC with ASM.

Configuring Oracle Multitenant container databases (CDB) and pluggable databases (PDB) in Oracle 12c RAC.

Replicated databases using Oracle Golden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

Creation of Materialized views and partitioned the oracle tables to improve reporting performance.

Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

Oracle Enterprise Manager (OEM) Cloud Control 13c/12c on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.

Experience ensuring the high availability, integrity of databases & database designing.

Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.

Wrote Shell Scripting for managing day-to-day activities and automation of backup.

SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.

Experience in Oracle Golden Gate installation, configuration, troubleshooting Oracle Golden Gate issues.

Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.

Performed Oracle Golden Gate upgradations, and cross-platform/heterogeneous environment (Operating Systems & Databases) migrations using Oracle Golden Gate 11g R2 and 12c R2.

Creating and managing database objects such as tables, indexes, partition tables and views.

Monitoring and Troubleshooting of Database Replication issues.

Creating and rebuilding indexes and optimizing the code to improve the performance.

Environment: Oracle 11g R2 RAC, OEM 12c/13c, RMAN, Data Guard, Oracle Golden Gate 12c/11g, TOAD 12.9, UNIX, RHEL/Linux 6.7/7.0/7.5, ASM.

Wells Fargo Mar’15 – Sept’16

1525 W WT Harris Blvd, Charlotte, NC

Role: Senior Oracle DBA

Wells Fargo & Company is an American multinational banking and financial services holding company with operations around the world. Wells Fargo is the world’s largest bank by market capitalization and the third largest bank in the U.S. by assets. The project we were working on was about Configuration Management-P0503046, migrations from Solaris (10g/11g R2 databases) to RHEL 6.7 (11g R2 databases) to setup, stabilize and maintain database environments in DEV, SIT, UAT, PFIX, PRE-PROD (Staging), PROD, and Business Resumption Hot with Oracle 11g R2 RAC and Standalone.

Responsibilities:

Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams & failover.

Setting up/Installation and configuration of 11gR2 RAC with ASM.

Creating and managing users, roles, privileges, profiles, schemas using OEM 12c.

Planning and implementing DR & high availability solutions using Oracle 11g Standby Database using Oracle Data guard, 11g RAC

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

Creation of Materialized views and partitioned the oracle tables to improve reporting performance.

Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

Oracle Enterprise Manager (OEM) 12c on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.

Experience ensuring the high availability, integrity of databases & database designing.

Creating and managing database objects such as tables, indexes, partition tables and views.

Monitoring and Troubleshooting of Database Replication issues.

Experience in Oracle Golden Gate installation, configuration (Extract, Pump, Replicat processes), and troubleshooting Oracle Golden Gate issues.

Replicated databases using Oracle Golden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag.

Creating and rebuilding indexes and optimizing the code to improve the performance.

Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.

Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.

Wrote Shell Scripting for managing day-to-day activities and automation of backup.

SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.

Environment: Oracle 11g, 11g RAC, OEM 12c, RMAN, Data Guard, Oracle Golden Gate 12c/11g, TOAD 12.9, UNIX, Linux 5.11/6.7/7.0, Secure CRT, DB Smart, ASM.

Dell Inc. Mar’14 – Feb’15

One Dell Way, Round Rock, TX

Role: Oracle DBA

Dell Inc. is a multinational computer technology company based in Round Rock, Texas, United States that develops, sells, repairs and supports computers and related products and services. The project we were working on was about COIN$ DR Infrastructure, migrations from one data center to other data center (RHEL 6.5, 11g R2 databases) to setup, stabilize and maintain database environments in prod and non-prod with Oracle 11g RAC.

Responsibilities:

Planning and implementing DR & high availability solutions using Oracle 11g R2 Standby Database using Oracle Data guard with 11g R2 RAC.

Setting up/Installation and configuration of 11g R2 RAC with ASM and Raw Devices, 11g CRS.

Oracle Enterprise Manager (OEM) 12c/11g/10g on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

Creation of Materialized views and partitioned the oracle tables to improve reporting performance.

Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.

Creating and managing database objects such as tables, indexes, partition tables and views.

Creating and rebuilding indexes and optimizing the code to improve the performance.

Refreshing of databases using datapump utilities expdp/impdp.

Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.

Wrote Shell Scripting for managing day-to-day activities and automation of backup.

Implemented 11g R2 RAC Data Guard with dg broker.

Experience in Oracle Golden Gate installation, configuration, troubleshooting Oracle Golden Gate issues.

Performed cross-platform/heterogeneous environment (Operating Systems & Databases) migrations using Oracle Golden Gate 11g R2.

Replicated databases using Oracle Golden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag.

SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.

Environment: Oracle 11/ 10g, 11g RAC, OEM 12c/11g/10g, RMAN, Data Guard, Oracle Golden Gate 11g, TOAD 10.6, DBArtisan 9.7.1, UNIX, Linux 6.5, Solaris, ASM.

Wells Fargo Feb’13 – Feb’14

1525 W WT Harris Blvd, Charlotte, NC

Role: Oracle DBA

Wells Fargo & Company is an American multinational banking and financial services holding company with operations around the world. Wells Fargo is the world’s largest bank by market capitalization and the third largest bank in the U.S. by assets. The project we were working on was about WATS – CH Exit - FTO, migrations from Solaris (10g R2 databases) to RHEL 6.5 (11g R2 databases) to setup, stabilize & maintain database environments in DEV, SIT, UAT, PFIX, and PROD/BCP with Oracle 11g Standalone and 11g RAC.

Responsibilities:

Setting up/Installation and configuration of 11g RAC R2 with ASM and Raw Devices, 11g CRS

Planning and implementing DR & high availability solutions using Oracle 11g R2 Standby Database using Oracle Data guard with 11g R2 RAC

Creation of Materialized views and partitioned the oracle tables to improve reporting performance.

Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.

Creating and managing database objects such as tables, indexes, partition tables and views.

Creating and rebuilding indexes and optimizing the code to improve the performance.

Refreshing of databases using data pump utilities expdp/impdp.

Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.

Wrote Shell Scripting for managing day-to-day activities and automation of backup.

SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.

Experience ensuring the high availability, integrity of databases & database designing.

Environment: Oracle 10/ 11g, 11g RAC, OEM 12c/11g/10g, RMAN, Data Guard, Shareplex, TOAD 10.6, DBArtisan 9.0.1, UNIX, Linux 6.5, Solaris, Secure CRT, ASM.

JPMorgan Chase & Co. Jul’12 – Jan’13

1CMP, New York, NY

Role: Oracle DBA

JPMorgan Chase & Co. is an American multinational banking corporation of securities, investments and retail. It is the largest bank in the United States by assets. The project we were working on was to setup; stabilize & maintain database environments in DEV, STG, UAT, PFIX, and PROD/BCP with Oracle 10g and 11g RAC.

Responsibilities:

Setting up/Installation and configuration of 11gR2 RAC with ASM and Raw Devices, 10g CRS & also with 11gR2

Creating and managing users, roles, privileges, profiles, schemas using OEM 12c/11g/10g

Planning and implementing DR & high availability solutions using Oracle 11g Standby Database using Oracle Data guard, 10g and 11g RAC

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

Creation of Materialized views and partitioned the oracle tables to improve reporting performance.

Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

Planning, Implementing and testing Oracle Streams.