PROFESSIONAL SUMMARY

* ***** ** ********** ** Information Technology in various roles, my experience has scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, Performance tuning and monitoring the database using OEM Grid Control, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning, space management, shell scripting using ORACLE 12c/11g/10g, performing the role of Oracle Database Administrator according to the set standards and timelines, Install and configure Container and Non-Container 12c databases, Pluggable databases – Architecture, Installation and the concepts associated with 12C database. Convert Non-CDB to Pluggable database.

Experience in configuring and managing Oracle Real Application Cluster (RAC) with ASM, Data Guard for Oracle High Availability.

Experience upgrading Oracle databases from 9iR2 to 10gR2, 9iR2 to 11gR2 and 10gR2 to 11gR2 [11.2.0.2.2] on RHEL, AIX and Solaris 10 SPARC 64-bit systems.

Experience in Oracle Patching for 9i, 10G and 11G.

Experience as Oracle security DBA- worked extensively in rolling out auditing across a wide environment.

Real time experience in remediating all the Oracle DBs to comply with industry security standards.

Configuration and Management of Data Guard.

Knowledge of Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers. Worked on Oracle Exadata servers.

Configuring Oracle Golden Gate for DDL/Uni-Directional/Bi-directional replications.

Experience in upgrading Golden Gate from v9.5 to v10.4 and from v10.4 to v11.1 from 11.2 to 12.1.2.1.0

Experience in configuring Integrated Extract and Co-ordinated Replicat after upgrading Golden gate software to 12.1.

Have Relative Professional Experience on Oracle Siebel Architecture.

Worked extensively on Very Large Databases (VLDB) ranging from 200 GB to 8 TB

Migrating databases from cross platforms windows, Solaris and Linux from 9i to 10g, 10g to 11g, 11g to 12c.

Planning and scheduling Backups using RMAN (hot, cold and incremental backups).

Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).

Installation and configuration of Recovery Catalog for multiple Databases.

Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)

Providing DBA support to multiple Cluster, Non Cluster and ASM Databases in production, development and Testing Servers in UNIX & Windows Environments.

Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, STATSPACK, and SQL TRACE.

Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid).

Implementation of Flashback Technology.

Managed Database Structures, Converted Logical data to Physical data, Storage Allocation, Table/Index segments, Rollback and undo segments, Constraints, Database Access, Roles and Privileges and Database Auditing.

Experience using Erwin as a Data Modeling tool & Designing the ETL processes.

Experienced in loading data from flat files into database tables using SQL*Loader and ETL

Tools like Informatica, Data flux, Data Stage.

Worked closely with Development, QA teams to recommend appropriate changes to applications and coordinate in reduction of down time for the conversion.

Experience in UNIX Shell Scripting for automating the DBA tasks.

Strong Understanding on Principles of Data Warehousing.

Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN) and Oracle ZFS storage.

Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.

Participated in 24 X 7 on-call rotation, off-hour production problem resolution activities.

Excellent communication skills, with strong troubleshooting and problem solving ability.

TECHNICAL SKILLS:

SKILLS PROFILE:

Databases Skills: Oracle 9i/10g/11gR2/12c, SQL Server 2005, Backup planning and Implementation, Performance Monitoring, Analysis and Tuning, Install, Patch and Upgrade, Disaster Recovery planning and implementation, Partitioning, Replication.

Database Advance Feature: RAC, Data Guard, ASM, Standby Database, Oracle Golden Gate, Advanced Replication/ Materialized View, Grid Control, OEM (GC), Tivoli, TOAD, SQL Developer, logminer, Cron tab

Oracle Utility: RMAN, RCONFIG, 12cOEM, Export/Import, DataPump (expdp, impdp), SQL*Loader, DGMGRL, ASMCMD, OID.

Performance Tuning: Grid control, AWR, ADDM, ASH report, SQL performance analyzer (SPA), SQL Optimizer, STATSPACK, DB Artisan and OS Watcher.

Languages: C, C++, UNIX shell scripts, PL/SQL, SQL, Perl

Project Management Tools: Project Scheduling (Microsoft Project), Microsoft Office Suite 2013, Minitab, Proplanner, SPC, FMEA, Design Of Experiments, Six Sigma, Lean Manufacturing, Quality Analysis.

Operating Systems: Sun Solaris 5.8, 9, 10, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

Education: Bachelor of Technology JNTU HYD.

Work Experience:

Client: Wells Fargo Feb 2016 – Till Date

Role: Oracle Database Analyst

Responsibilities:

Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases including a 4 Node RAC on EXADATA.

Installed, configured and maintained Oracle Database 12c on Oracle Sun Solaris T4-1 SPARC servers and 11g on T3-1 SPARC servers.

Setup physical standby’s (DATAGUARD) for several Databases running 11g and 12c as well (CDB and Non-CDB)

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI.

Converted physical standby to Snapshot standby and back to physical standby.

Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.

Configure and build Golden Gate Extracts/replicat for Uni-directional and Bi-directional replications on Exadata and Non-Exadata servers using DBFS and ACFS storage.

Performed Goldengate initial load using (expdp and impdp) from source to target.

Worked on Logdump utility of Goldengate.

Good at altering the Rba for replicat during the troubleshoot of Goldengate based on the transaction type and not missing any transactions.

Installed VERIDATA tool for comparing data synchronization between SOURCE and TRGET.

EXADATA monitoring, Setting up the alerts for database, listener, tablespace monitoring, ZFS backups setup from OEM 12c.

Migrated 11g, 12c databases from Old Hardware (RHEL6) to new hardware (RHEL7).

Goldengate monitoring was done using the cronjobs, where it does report a mail in case of a process abend or Lag more than threshold and any Checkpoint.

Worked on Shell Scripts for the Goldengate monitoring and Trail file system size alerts.

Worked on writing PL/SQL packages that would find any duplicates in the tables, this is as per requirement, where the tables have no primary or unique

Error handling for restart, logging, production support and status reporting in Golden Gate

Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.

Migrating existing 10g/11g databases to 12.1.0.1 using transportable tablespace method. Upgraded supported versions to 12cR1 using DBUA (direct path upgrade)

Plugging from and Unplugging into XML files, creating the Container database and pluggable databases. Migrating the 11g database to 12c pluggable database.

Migrating the databases from Non-ASM to ASM.

Creating Solaris Zones, zone Snapshots for backup. Configuring the disks and slices for ASM

Research, Implement, Test and configured various compression methodologies.

Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism & Compression.

Setting up Hugepages - Calculated the recommended values and setup hugepages on linux severs.

Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.

Built databases with different blocksizes and tested the performance with various parameter settings.

Capacity planning for the projects owned in the environment.

Created shell scripts for RMAN incremental backups and also for full database backups using datapump.

Upgraded the binaries by applying patch set and interim patches using OPatch and OPatch Auto.

Providing technical support to Application Support team for performance and database related issues.

Effective Production Support and off hour support, support handover.

Environment: Linux, Sun SPARC T4-1/T3-1 running Oracle 11g/12c, Oracle EXADATA X2-2 HALF RACK 4,7, OEM 12c, RAC, CDB/PDB, Dataguard, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD, SQL Developer.

State Street Financial Corporation. May 2015- Jan-2016

Boston, MA

Sr. Oracle DBA

Responsibilities:

Installation, Configuration and maintenance of Oracle Goldengate software on Unix systems, Sybase, Sun Soloes systems, Oracle GoldenGate on Oracle Exadata Database Machine

Configured DDL replication from Oracle on Sun to Oracle on Linux.

Performed Uni-directional replication both DDL and DML.

Troubleshooting Goldengate issues at the replicate end and resynchronizing tables when they go out of sync.

Replications of public synonyms over dblinks were configured in DDL replication.

Performed testing on Oracle GoldenGate 11.2 with Oracle 12c Database.

Replication was configured to run even at the time of failover (Data Guard) of the source database.

Performing the initial load using (expdp and impdp) from source to target.

Goldengate performance issues were resolved by splitting the process into subsets, so that performance is improved.

Troubleshooting Goldengate process abends, analysing report files, error log file and discard files.

Worked on Logdump utility of Goldengate .

Performed skipping the transactions which are not necessary using logdump utility.

Good at altering the RBA for replicat during the troubleshoot of Goldengate based on the transaction type and not missing any transactions.

Maintenance of Goldengate process during the batch loads.

Goldengate monitoring was done using the cronjobs, where it does report a mail in case of a process abend or Lag more than threshold and any Checkpoint.

Conducted migration across various platforms like sysbase to oracle and SQL server to Oracle.

Supported Business, Post go-live by Cloning/refreshing Production to DEV, UAT, TEST and PREPROD Database instances, for testing at Scheduled intervals.

Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.

Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.

Implemented Backup and recovery strategies using export/import, RMAN and online backups.

Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring, for custom scripts troubleshooting using SQLTRACE utilities

Automated several scripts to monitor various processes, sessions and taking back up’s using crontab.

Analyzed the user requirements and designed partitioned tables for improving performance.

Performing the daily Maintenance tasks and interacting with Oracle Customer service when required.

Used Oracle Streams for Basic and Advanced Data Replication between oracle database servers.

Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.

Involved in the Migration projects Extensively using Data pump and Rman utilities

Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool

Excellent in writing SQL scripts using SPOOL command

Expert in using Data pump

Involved in the migration of huge databases of sizes ranging from 100GB to 7TB

Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Experience in moving the data from one server to another server using SFTP,FTP and SCP

Building new databases and schemas from the scratch on Linux and UNIX Boxes.

Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.

Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.

Configured Oracle Data guard for Oracle Disaster recovery on standalone database.

Troubleshooting ORA errors when occurred.

Performance Tuning for the SQL queries by scrutinizing the long running sql queries.

Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts.

Scheduled Oracle Jobs and Backups using CRONTAB.

Environment: Oracle 11g/10g, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RBAC, RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP.

Client: Caterpillar, IL Aug 2011–April 2013

Role: ORACLE DBA

Caterpillar Inc. provides Web-based sales, service, and process automation solutions to create health insurance marketplaces and exchanges for the health and benefits insurance industry. State Advantage, is the project that I have worked on, provides solution that enables state governments to offer health insurance exchange. Its Web-based systems provide support for multiple product lines, including medical, dental, life, vision, disability, HRA, HAS, and Section 125 pre-tax funding; and enable consumers, employers, and brokers to shop for, purchase, and renew health insurance products. It serves insurers, brokers, retailers, and state governments in the United States.

Responsibilities:

Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases including a 4 Node RAC on EXADATA.

Installed, configured and maintained Oracle Database 12c on Oracle Sun Solaris T4-1 SPARC servers and 11g on T3-1 SPARC servers.

Setup physical standby’s (DATAGUARD) for several Databases running 11g and 12c as well(Container level and Non-CDB)

Setup the standby via OEM cloud control 12c for several databases.

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI.

Assisted in keeping a daily log of Sharepoint issues and submitting that log each week to IT management.

Converted physical standby to Snapshot standby and back to physical standby.;

Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.

Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate

Error handling for restart, logging, production support and status reporting in Golden Gate

Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.

Migrating existing 10g/11g databases to 12.1.0.1 using transportable tablespace method. Upgraded supported versions to 12cR1 using DBUA (direct path upgrade)

Plugging from and Unplugging into XML files, creating the Container database and pluggable databases. Migrating the 11g database to 12c pluggable database.

Setup Storage Migrations: Solely responsible for migrating the Prod/Tst/Dev Databases from NetApp to HNAS and also to block level storage. (Migrating the databases from Non-ASM to ASM)

Creating Solaris Zones, zone Snapshots for backup. Configuring the disks and slices for ASM

Exadata Scan query specific – Compress for query high/low

Storage Savings specific – Compress for Archive high/low

Implemented DBFS on Exadata.

Implemented PARTITIONING using EXCHANGE PARTITION method.

Data pump including database links and network links.

Migrated databases from NETEZZA, AS 400 to ORACLE 11g.

Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism& Compression.

Setting up Huge pages - Calculated the recommended values and setup hugepages on linux severs. Also configured huge pages for the X2-2 half rack boxes.

Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor,ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.

Built databases with different block sizes and tested the performance with various parameter settings.

Capacity planning for the projects owned in the environment.

Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using data pump.

Provided backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.

Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.

Creating and maintaining database objects in operational data store.

Creation of new PL/SQL procedures and triggers based on the project requirement.

UNIX shell scripting as and when required based on the requirement.

Providing technical support to Application Support team for performance and database related issues.

Effective Production Support and off hour support, support handover.

Environment: Sun SPARC T4-1/T3-1 running Oracle 12c, Oracle EXADATA X2-2 HALF RACK 4,7/Oracle 11g, Red Hat Linux 5.8, OEM 12c, RAC, Oracle Advanced Security, Pluggable databases, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations.

Contact this candidate