Sr. Oracle DBA
Resume:
Ravi Peri
Email : ***********@*****.***
Skype: ***********@*****.***
Summary:
Experienced Database Administrator committed to maintaining cutting edge technical skills and up-to-date industry knowledge Over 20 years as DBA in Production Environment. Experience includes Database Administration, Software Analysis, Design, Coding & Testing of Business Applications with various responsibilities as Technical Architect, Senior DBA, Lead DBA, System Analyst, Analyst and Programmer. Strong Knowledge of SQ, PL/SQL, TSQL, Shell Scripting, Install, Configure, Upgrade, Migrate, Replication, High Availability, Disaster Recovery, Data Guard running on UNIX/LINUX (RedHat Linux, Sun Solaris, AIX, HP-UX) and MS SQL Server on Windows NT Platforms.
Extensive experience Installing Multi Node RAC using DBFS, ASM, OEM, Active Data Guard.
Extensive knowledge on Oracle databases from Oracle 7x to 12 C with large Databases and OLTP & OLAP Databases.
Golden Gate Installing and configuring Oracle 9i to 12 c RAC, Active Data Guard Standby Databases for High Availability and Disaster Recoveries.
Experience in setting up Oracle Clusterware setup, RAC Installation using ASM and non-ASM, Grid Installation.
Implemented successful High Availability solutions viz. Oracle Data Guard, RAC, Oracle Advance Replication, Golden Gate, TOAD, SpotLight, SharePlex.
Extensive experience with very large Databases over 12 Terabytes.
Expert in Migrating Oracle Databases using Oracle Golden Gate Bi-directional Replications and Cross-Platform Data Migrations.
Replication and Extracting data and applying on production using GoldenGate.
Extensive experience in installing and managing Oracle Grid Control 13 c, (OEM).
Implemented Oracle Audit and Security Policies with fine grained access control for users.
Setup and configure Oracle RMAN, Backup’s & Recoveries and build Disaster Recoveries systems and failover testing.
Experience in Setup and configuration TDE (Transparent Data Encryption) for Table space/Column level Encryption and generate P12 & SSO Wallets.
Write Encrypt/Decrypt functions for Credit Card Encryption for PCI Project (Processing Card Industry).
Expert in Performance and Tuning and Implementing SQL Plan Management (Baselines), SQL Profiling and SQL Hints.
Extensively worked on tuning the database like memory tuning for database buffer cache, shared pool and log buffer, identifying and resolving contention for system resources, latch contention, data block contention and I/O waits using Explain Plan, Statspack, SQL Trace, TKprof.
Experience reading ASH, AWR and ADDM reports
Extensive experience using backup tools like RMAN, Actifio, Commvault, Data Domain, TSM & Avamar.
ETL SQL Loader and Informatic ETL Jobs.
Support ETL Informatica Jobs.
Experienced in Shell Scripting Borne Shell, Korn Shell, C Shell including AWK, SED and Phyton and automate the Process.
Practical understanding of the Data modelling (Dimensional & Relational) concepts like 3N, Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimensional tables.
Data Architecture, Modelling, Design, ERD’s.
Experience on SQL SERVER Administration.
Have experience working on Cloud Technologies (Delta, IBM Internal Cloud Data Centers)
Experience in working with HDFS, MapReduce, Hadoop Components, Cloudera Manager and Administration.
TECHINICAL SKILLS:
RDBMS: Oracle 7 to 18c, Oracle RAC, Exadata, ASM, DBFS, Streams, AWR/StatsPack, OEM 13c, Oracle Golden Gate, SQL Server, Informix 7x, MySQL, Postgres DB, Big Data Apache Hadoop from Cloudera, Phyton.
Operating Systems: Linux redhat 6.2/7.1, HP-UX 10.2, AIX 5.2/5.3,7.1, Sun Solaris 9/10, Microsoft SQL Server 2012/14, Server Virtualization with IBM PowerVM & VMWare ESXi Servers,
ETL & Reporting Tools: Informatica, Power Center 8.5/8.0, ata, Oracle Data Integrator,
Backup Tools: Actifio, RMAN, IBM Tivoli, Commvault, Data Domain, VERITAS Net Backup, NetApp, HP OmniBack, TSM, EMC
Security: Oracle Advance Security Option, Encryption/Decryption, Database Vault, Audit Vault, CyberArk,
ERP: BaaN ERP, BaaN Tools, Yantra (IBM Sterling Order Management) PkMS, and Warehouse Management & Adage.
EDUCATION and CERTIFICATION:
1Oracle New Features for 18c and 19c Administration Training from Oracle Corporation.
2Oracle Golden Gate 12c Fundamentals and Advance Configuration Training from Oracle.
3Oracle Global Data Services (GDS) Training from Oracle Corporation.
4Oracle Exadata Administration, Training from Oracle Corporation.
5Oracle RAC 11g Cluster Training from Oracle Corporation.
6Oracle Certified DBA Professional
7Cloudera Administration for Bigdata Apache Hadoop.
8Bachelor's Degree in Electronics
PROFESSIONAL EXPERIENCE:
Delta Airlines, Corporate Office Atlanta/Minneapolis Sep 16 – May 2020
Oracle DBA Architect
Oracle Upgrade from 10g to 12c/18c RAC from Sun Solaris to RedHat Linux Servers, Exadata X7 Servers
Database Migrations to Single and Multi- Node RAC with Active Data Guard.
Data Base Server Build, Setup and Configuration on Virtualization and Exadata Servers in Delta Internal Cloud Data Centers in Atlanta & Minneapolis)
Build Standby Databases using Oracle Data Guard in DR (Disaster Recover Data Center) and setup Oracle Replication using Golden Gate
Build Oracle Physical/Logical/Snapshot and Active Data Guard using Oracle Data Guard.
Implement Logical and Physical Database Design and Data Modeling
Migrated Very large Database Oracle 10g Databases (6 TB) from Sun Solaris Systems to RedHat Linux Servers using Oracle Golden Gate Setup and implement Bi-Directional Replication between Data Centers.
Migrated ETL Jobs from Oracle 10g to 12c and re-engineered SQL Loader ETL Jobs.
Modified DDL and Character Conversion for Failing SQL Loader ETL Jobs while Migration.
Worked extensively with Classic and Integrated Versions of Oracle Golden Gate.
Install, Setup, Administration and Troubleshoot Oracle Golden Gate Extract & Replication on both Source and Target on Very Large Exadata Databases.
Environment Refresh ad Support for Clinical Application Upgrades.
Testing E2E with Application team for DR type Scenarios.
Exadata – Implementation of Migration of Databases from Oracle Standalone to Exadata for ARV & SKED Test Applications
Character Set and Platform Conversion.
Patching Exadata Frames and Upgrade image versions of DB / Cells, IB Switches, Compute Nodes and Oracle GI & RDBMS Database.
Implement database patching and upgrade all the environments.
Expert in reading Plan table and Execution plan fine tine based on the findings
Expert in handling Performance PL/SQL Tuning and fine tune Queries.
Analyze performance problems using AWR & ASH.
Very well versed with Performance & Tuning using ASH, AWR and ADDM Reports tuning and gather Stats on Exadata / Non-Exa Databases.
Implement Oracle Wallets as Oracle Advance Security and TDE (Transparent Data Encryption).
Very strong experience working on GRID Control. RAC, ASM, Partitioning, RMAN and other Oracle Tools.
Modify PostgreSQL database functions for better performance and structures.
Optimize Oracle procedures source code for better performance.
Database Physical Modeling and normalization using SQL Developer and phModuler.
Clone PostgreSQL instance using pgdump and snapshots.
Cleanup existing application data based and data integrity.
Work with Application team and support Weblog Application.
Very well versed with Unix Shell Scripting and automate the processes where possible.
Testing backup and Recovery scenarios for Disaster Recovery using RMAN and Actifio.
Written some Bash Shell scripts including AWK & SED to automate the processes.
Failover/Break fixing RAC Network, Server, Nodes testing with Application team.
Williams Companies, Inc. (Energy), Tulsa, OK Sep 15 – Sep 16
Oracle DBA Architect
Oracle 12c RAC/11g RAC, on RedHat Linux, IBM AIX servers Virtual Unix Servers.
Understanding of systems design and Architecture, Oracle RAC Clustering, High Availability, ASM, Disaster Recovery using Data Guard, Backup and Recovery of Databases and Application Servers.
Installation and configuration, Clusterware, Oracle RAC, Oracle LDAP, Oracle Data Guard, Databases and System Administration both Production and develop operations and maintenance.
Create and Test using Shareplex multimaster replication between 10g and 11g databases and ensure data integrity.
Performance and tuning Oracle 12c, 11g, 10g, Oracle Weblogic Application SQL and PL/SQL Code tuning.
Provide Oracle engineering, design and administration services to several large-scale mission critical Oracle based application and environments.
Convert Oracle RAC databases to Primary, Standby Data Guard environments.
Performance and Tuning using SQL Plan Management (Baselines), SQL Profiling and SQL Hints.
Applying Patching and upgrading Oracle EBS R12 Suite.
Install, Configure and Administration of MySQL Databases.
Implement Oracle Wallets as Oracle Advance Security.
Implement TDE (Tablespace Data Encryption).
Performing data encryption and validation.
Testing of data encryption and data integrity.
Implement Data Masking in the development environments.
Assisting UAT and testing team.
DSW Designer Shoe Warehouse, (DSW) Columbus, OHIO Nov 14 - Sep 15
Technical Consultant
This Project is about Migrating Oracle 10 g to 12 c with 3 Node RAC Servers along with ATG Upgrade from Version 9 to 11.
Application: ATG eCommerce and Yantra, (IBM Sterling Commerce).
Successfully Migrated ATG database from Oracle 11g to 12 c and also supported ATG migration form version 9.4 to 11.
Install, configure and setup Oracle 12 C 3 Node RAC for Tokenization Project.
Work through the ATG Upgrade Mock conversions and successfully cutover to Prod migration.
Working on Yantra Mock conversions and planning on the prod cutover for BOPIS Project (Buy Online and Pick up at Store).
Developed code for Oracle Encryption/Decryption and implemented Oracle TDE (Transparent Data Encryption) for Credit Card Data per PCI Compliance Project (Processing Card Industry).
Extensive Database Tuning, M Views, Partition Maintenance, Grid Control.
Apply database patching using OPatch utility for all the RAC & Non-RAC Databases.
Apply critical and CPU patches and keep all environments in-sync.
Work closely with Oracle Support and raise SR's for any critical issues.
Refresh Clone DEV/QA environments using RMAN backups.
CARGILL Corp Head Quarters, Minneapolis Oct 09 - Oct 14
&
Sr. Oracle DBA Oct 06 - Mar 08
Working in I & D (Implement and Design Team) Help team Install and Configure Oracle 9i,10g,
11g Databases on Linux and IBM Linux Servers, Exadata and Non Exadata Oracle RAC, Data Guard, High Availability, (Physical and Logical Standbys) Building Disaster Recoveries across multiple Cargill Internal Cloud Data Centers and configuring ASM and Database Upgrades
Install, configure and maintain Oracle 10g, 11g Databases on IBM Linux and Windows servers.
DR Set-up using Data Guard, Data Guard Broker and Streams.
Cross Platform Data Migration.
Configuration and Monitor Alerts using CRON and OEM Grid Control.
Implementation and support of Oracle 10g and 11g migrations and Upgrades from Oracle 9i and 10g databases, including Oracle RAC (Real Application Cluster) on Exadata Servers.
Provide Implementation and support for SAP/Oracle and other application Migrations and Upgrades, including environments using Oracle Data Guard.
Setup and configure Golden gate and migrated large databases on Exadata RAC Databases using Golden gate.
Install, Configure and Administration of Windows MS SQL Server 2012 & 2014 Databases.
ETL SQL Loader and Informatic ETL Jobs
Implement Logical and Physical data models and maintain using Erwin tool.
Apply critical and CPU patches and keep in-sync all environments.
Used Commvault tool to Oracle backup and restore Databases for SAP Project.
Using RMAN, performs Backup's restores and clone QA/DEV environments for developers testing.
Kaiser Permanente (Corporate Head Quarters)
Oakland, CA
Data Architect / DBA Apr 09 - Sep 09
Lead and work with a team of DBA's migrating Oracle and SQL Server Databases on to IBM Infrastructure Data Center. Build, Install and Configure 10g databases on RAC and Non-RAC environments on IBM 3850 M2 series Servers, Virtualization on IBM ESX Servers.
Created the plans and design diagrams for the Data migration / consolidation of 4 Data Centers
Built primary and standby Databases with Data Guard and rolled over to new Servers.
Used RMAN backup and restores to migrate databases with minimum downtime.
Developed and designed physical and logical databases.
Support and Maintain and Informatica ETL Jobs.
Write Shell scripts to run ETL Jobs and schedule them in the Unix Cron Tab.
Ensure the recoverability of all production data for operational and business continuation needs.
IBM Corporation (Database Conversions and Data Center Migration)
Minneapolis, MN / Rochester, NY.
Lead Oracle DBA / Architect Jun 08 - Mar 09
Lead and work with a team of DBA's migrating Oracle and SQL Server Databases on to IBM Infrastructure IBM Cloud Data Center( Rochester NY) . Build Install and Configure Oracle 9i and 10g databases on RAC and Non-RAC environments and Server virtualization with IBM PowerVM & VMware ESX Servers.
TOYOTA MOTORS (Corporate Head Quarters ) Sep 05 - Sep 06
Sr. Oracle DBA
Provide technical and strategic plans in the DBA team for Oracle databases. This includes shell scripting for ETL loads in a Data Warehousing environment using Informatica 7.1 tools.
Work with functional experts and application architecture teams to design the logical and physical models for databases of different applications.
Development of Standards/Procedures.
Client: Target Corporation (Corporate Head Quarters) Minneapolis, MN. Apr 05 – Aug 05
Sr. Oracle DBA
Description: Help Database Migration team to Migrate Oracle 9i Databases from Sun Cluster to Linux Systems.
Client: Best Buy (Corporate Head Quarters) Minneapolis, MN. Oct 03 – Mar 05
Sr. Oracle DBA
Description: Working in a team of DBA's, responsible for providing 24x7 high- Production, Staging,
Prod Supp, QA and Dev environments under Oracle 9i RAC/non RAC. DB Code
Migration and Deployments across all environments and S/W Deployments
Client: ASCI (American Systems Consulting Corporation) Columbus, OH.
Oracle DBA Oct 00 – Sep 03
Description: Working in a team of DBA's, responsible for providing 24x7 high - Level Oracle
Support of Mission-critical Production Systems which includes providing on call
Support for Database Issues and develop Procedures and Documentation.
Application: PkMS (Pick Warehouse Management System)
DIBS (Defense Interactive Business Systems)
Install and configure Oracle 8.1.7.4 and 9.2 on HP-UX 11i and Linux RH9 Production servers.
BaaN Info Systems Oct 97 – Sep 00
BaaN Global Support
BaaN Global Support, Hyderabad provides on-line and off-line after Sales Support across the Globe 24x7 to the clients. This project is to support Baan Application with Oracle and Informix database support.
Application: BaaN ERP, TRITON 3x, BaaN IV C and BaaN Tools.
Contact this candidate