Manager Oracle

Sai Bavineni

Contact 929-***-****

***********.***@*****.***

ORACLE DATABASE ADMINISTRATOR

PROFESSIONAL SUMMARY

I have 9 years of experience in IT industry, worked as Oracle Database Administrator in Retail, Ecommerce, Financing and Banking segments, Health care, encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Monitoring and tuning RAC, Dataguard, Goldengate, Grid Control. Extensively Worked on databases in mission critical large OLTP systems in a variety of environments like Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL and Windows.

Expertise with planning, creation, administration and troubleshooting of Oracle 12c/11g/10g/9i, OLTP (multiple instances)/OLAP databases in production.

Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager and Involved in registering a database in grid control.

Monitoring of the databases using Oracle Enterprise Manager (12c).

Responsible for Monitoring 24/7 Production Support and Performed upgrades from Oracle 11g to 12c and applied patches.

Hands on experience in implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using .02 on 11g/12c).

Expertise in trouble cluster ware startup issues.

worked on Exadata X3-2, migrated databases on X3-2 machine, half rac, quarter rac.

Design and implement the high availability solutions (RAC, Goldengate and Dataguard).

Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Goldengate & Dataguard.

Implemented disaster recovery databases using dataguard & configured physical standby on 11g/12c.

Oracle Goldengate installation, configuration, troubleshooting Goldengate Extract and Replicat files.

Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases i.e. Active Dataguard & Snapshot Standby.

Configured Dataguard broker for both RAC and standby databases in environment and Maintained Dataguard Server and troubleshooting issues

Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC with EMC.

Experienced in setting up/installation and configuration of release 11g RAC/10g R1 RAC with EMC Storage.

Solid experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies. Implemented database security using Transparent Data Encryption.

Created and monitored database objects like Tables, Indexes, Views, Users and DB links.

Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.

Proficient in setting up the network connections (i.e. setting up Listener and TCP/IP Connections).

Performance tuning of the database SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Writing scripts in the UNIX based environments for Managing the user's roles and privileges, scheduled backups (using data-pump / cold backups), manage statistics, Disk space management.

Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various Unix Shell Scripting

Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.

Worked along with System and Network Administrators for minimal downtime of the Databases

Involved in doing extensive administrative tasks on UNIX & Red Hat Linux server Databases

Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment

Good knowledge on (RMS) application.

Worked on resolving issues pertaining to struck transactions in O2C cycle of E-business Suite(EBS).

Knowledge on Fusion Middleware.

Supported machine critical application databases by giving 24x7 supports.

TECHNICAL SKILLS

Database

OEM 12C, Oracle 12c, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i/MSSQL 2014/2012/2008R2.

Oracle Products

Real Application Cluster, Golden Gate, Dataguard, Import and Export, Data pumps, Oracle Wallet Management, Automatic Storage Management, Oracle10g/11g/12c (Grid Control), RAC,RMAN, OEM, Transparent Data Encryption

Operating System

Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL), Sun Solaris, Windows XP/2003/2008, AIX 6.1

Languages

SQL, PL/SQL, Unix shell scripting

Tools & Utilities

SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, BMC Remedy, Red gate, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool

PROFESSIONAL EXPERIENCE

PNC Bank, Pittsburgh, PA Jan 2016 – Till DATE

Role: Sr. Oracle DBA

Responsibilities:

Administering and supporting Oracle database environment over 120 databases, up to 15TB, utilizing advanced concepts such as Dataguard and Oracle RAC combined on all the production, development and testing environments.

Configured, administered, and monitored a Streams environment using various tools like OEM console.

Installed Oracle 12C Control for diagnosing and monitoring performance related problems and configured with Application servers on databases

Deployed and configuring database entries and monitoring of the databases using Oracle Enterprise Manager (12cOEM)

Installation and configuration of Oracle Enterprise Manager Cloud control 12c on RHEL

Installed Oracle 12c Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK

Worked on ASMCA and used SYSASM for creating disks, drop and add disks to disk groups and tuning ASM parameters per requirement

Configured disaster recovery databases using dataguard and performed DR Testing

Performed switchover and monitor using DGMGRL

Worked on Active dataguard and performed Troubleshooting dataguard environment

Involved in Oracle Goldengate installation, configuration, troubleshooting Goldengate Extract and Replicat files.

used Defgen utility to create definition files in Goldengate

Migrated databases using Goldengate with minimal downtime

Implemented and supported Goldengate replication in production, and development environments.

Hands on experience in Installing Goldengate Replication, tools in Goldengate logdump, Defgen for troubleshooting issues in environment

Setup, administer and troubleshoot Goldengate Replication issues across database environment.

Experience of installing, configuring Goldengate Replication from OLTP databases to Data warehousing environments.

Involved in up-gradation of databases from 11g to 12g and applied patch set and interim patches whenever required

Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching

Hands on experience in Oracle 11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup

Planned and implemented DR & high availability solutions using OEL Standby Database using Oracle Dataguard, 11g and 12c RAC.

Standby Database (Dataguard) setup and configuring DB links.

Maintained Dataguard to ensure high availability, data protection and disaster recovery for enterprise data.

Implementation of High Availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases (Dataguard) and Replication using Goldengate.

Upgraded development and production databases from 11g to12g on Linux

Involved in Installation and Configuration of Management agents in 12C (Cloud Control)

Used 12C/11G grid control Maintenance, tuning and monitoring databases

Providing Application Support for performance and database related issues

Worked with teams and Involved in building Databases.

Worked on storage Indexes and tested their behavior with different query predicate conditions

Performed cross platform migration of databases on Solaris 11g to Linux 11g using Goldengate

Documented and logged errors in Goldengate environment and worked on OLTP Compression

Extensively used Log dump utility and define utility for resolving issues in Goldengate

Extensively used data pump for migrating data between platforms

Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.

Involved in scheduling incremental, cumulative and full backups and configured retention policy Using RMAN

Worked in Data Warehouse environment, involved in activities like partitioning tables, Creating materialized views and reorganizing index’s

Applied patching on 11g/12c and Up-gradation of Hp-Unix critical databases from 11.2.3.x to 11.2.4.x.(11gr2)

Database Sizing, Table space Management and Rollback Table Space Management, Transaction Management and Security Administration.

Good knowledge on Revenue Management and Billing(RMS) application

Used 10046 Trace for tracing client connections, sql statements and bind variables

Configured Oracle Wallet for Transparent Data Encryption (TDE)

Encrypted sensitive information like Tables, table spaces, Encrypted columns within the database and implemented Encryption keys on relational database management systems by using TDE.

Performed Explain Plan analysis for Query Optimization and SQL tuning.

Performed Database and SQL tuning by using various Tools like AWR, ADDM, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints.

Environment: OEM13C, OEM 12C, Oracle 11gR2/12C, SQL 2014/2012/2008R2, Solaris/Linux, SQL, OEM, RAC, ASM, Dataguard 11g/12c, Goldengate, putty, RMAN, Explain Plan, AWR, ADDM, ASH, TTS, Flashback, Data pumps.

State of Michigan, Lansing, MI Jan 2015 –Dec 2015

Role: Sr. Oracle DBA

Responsibilities:

Installed, setup and configured Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring and alerts.

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK

Worked an Operation DBA and having good experience working in build-stage Planned and Implemented High Availability using RAC and Dataguard

Worked in build stage, Installed and configured oracle software, databases from scratch

Installed and configured RAC (2node) & created Databases using dbca.

Created custom services for RAC database for distribution of load across the nodes.

Performed various operations on X3-2 machine, bringing down oracle cluster-ware resources, created ASM disk groups and managed grid infrastructure network resources

Responsible for Monitoring 24/7 Production Support and Performed upgrades from Oracle 11g to 12c and applied patches

Configured, administered, and monitored a Streams environment using various tools like OEM console.

Migrated databases into EXADATA RAC- databases, x3-2 successfully using data pump

Installed standalone servers on ASM, created disk groups on ASM

Worked on ASM and Performed SAN migration

Performed Migration of databases from HP UNIX to Oracle 11.2.0.x on RHEL.

Implemented load balancing using 11.2.1.0.6 Oracle Goldengate,

Installed and configured, troubleshooting Goldengate Extract, pump and Replicate processes on AIX 5.x servers

Troubleshooting Goldengate issues in both development and production environments.

Performed Uni-directional and Bi-directional replication through Goldengate for zero downtime Database migrations.

Implemented and supported Goldengate replication in production, and development environments.

Performed Cross platform migration and used Oracle Goldengate to transfer database from Hp-unix to RHEL

Zero downtime migration using oracle datapump and Goldengate between Oracle 11g and 12c with Linux, Solaris, and Windows platforms.

Migrating and upgrading Oracle Database from 11gR1 on Solaris/Windows to 12cR2 on Linux environment using datapump and Goldengate replication.

Configured disaster recovery databases using DATAGUARD & worked on 11g new feature active dataguard.

Converted physical standby databases to snapshot standby, performed manual switch over to DR servers

Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers.

Applied patches on standalone servers using Opatch utility and upgraded Opatch utility from lower version to higher version.

Involved in migration of databases from standalone (ASM) to cluster Environment.

Maintained catalog server and registered databases in catalog server.

Using SQL Tuning Advisor and SQL Access Advisor to fix bad SQL.

Having Good experience in monitoring databases through grid control.

Installed and configured Oracle Enterprise Manager 11 g Grid Control.

Implemented data transfer using Data Pumps and Export/Import utilities.

Involved in scheduling incremental, cumulative and full backups and configured retention policy.

Developed a bunch of Index monitoring scripts in an order to sort out the unused space occupied in table spaces.

Performance tuning of the oracle databases using the following tools/utilities: OEM, OEM 12C, AWR, ASH, Explain plan, ADDM, tkprof, DBMS stats

Performance tuning of the databases using: OEM, OEM12C, Toad, AWR, ASH, SQLT, DBMS stats, explain plan

Implemented advanced features AWR, ADDM reports for monitoring database performance, Modified and updated the Performance tuning scripts.

Involved in gathering requirements from end users.

Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Mentoring Level-II DBA’s and involved in 24x7 Production-on calls supports for all the production databases with Oracle.

Environment: OEM 12c, Oracle 12C/11g, Red Hat Linux 4.x, 5.x, Hp-Unix 7.1, RMAN, SQL server, RAC 11g/12c, EXADATA X3-2, CELLCLI, IORM, Dataguard, OEM, Grid Control 11g/12c, STATSPACK, AWR, Explain Plan.

Pfizer Inc., New York City, NY Nov 2012 –Dec2014

Role: Sr. Oracle DBA

Responsibilities:

Worked on Oracle Database 10g/11g 2 node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.

Configured Oracle Dataguard for Oracle Disaster recovery.

Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.

Used Dataguard broker to monitor Dataguard status periodically and Maintained DR server and troubleshooting issues in Dataguard environment

Successfully switched over databases to secondary databases during DR testing using Dataguard broker and Configured Dataguard broker

Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.

Applying Quarterly patches and CPU, PSU, One-Off Patches to update Oracle version and to fix the bugs using Opatch utility.

Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Dataguard) and Replication using Goldengate.

Involved in designing of Disaster Recovery using Dataguard and High Availability using 11g RAC.

Achieved High Availability, Data protection and Maximum performance by maintaining both Physical and Logical Standby databases.

Used Dataguard broker to monitor Dataguard status periodically.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Implemented Oracle database backup & recovery solutions using RMAN.

Extensive use of Oracle Data Pumps Exports/Imports utility for moving data among the servers.

Performed large batch jobs, and tuning of SQL queries and database systems.

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

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Worked with Data pump to take the logical backups of databases.

Experienced in performing Point in time recovery using RMAN.

Involved in designing logical and physical data models using Erwin.

Created indexes to facilitate easy user interface implementation and tuning.

Worked on Databases through Business Intelligence tool.

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle RAC, Data-Guard, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Ramco Systems, Chennai, INDIA Feb 2010 – Oct 2012

Role: Oracle DBA

Responsibilities:

Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade support for approximately 40 Oracle databases.

Administration and support of Oracle Application Server 9i and 10g.

Installation and maintenance of Oracle 10g Dataguard.

Involved in backup and recovery using Recovery Manager

Standby database setup via Dataguard for Database Disaster Recovery.

Performed Logical backup using and full/partial export/import and Data Pump.

Database Restore using RMAN, Cold Backup and Export/Import.

Responsible for planning, testing and implementing different backup and recovery strategies.

Created database objects such as tables, indexes and views.

Table Partitioning, creating Index Organized tables, Creating Locally Managed Table spaces and Responsible in configuring and backing up database using hot backups, Cold backups and Logical backups.

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

Good experience in Patching and Upgradation from 10g, 11g to 12.1.0.2

Migration and Up-gradations of Databases and Patched Oracle Database Server 10g using Opatch.

Performance tuning on production databases supporting the application using stats pack/AWR.

Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards.

Refresh development/test databases from copies of production.

24x7 Production-on calls supports for all the production databases with Oracle 10g/9i.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL plus, TOAD, Import/Export Oracle Enterprise Manager, Windows NT/2000, Sun Solaris 2.5/2.6, Red Hat Linux.

Magnaquest Technologies Ltd, Hyderabad, INDIA July 2008 - Jan 2010

Role: Oracle DBA

Responsibilities:

Installation, Maintenance and administration of Oracle 10g on Red hat Linux.

Implemented Dataguard and administered the production database.

Responsible to schedule backups through RMAN.

Involved in Up-gradation of databases from 9i to 10g.

Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.

Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.

Converted physical standby databases to Snapshot standby database.

Implemented Oracle database backup & recovery solutions using RMAN.

Configured and Tuned RMAN for better performance and backup strategies.

Involved in writing for shell scripts for taking RMAN backups.

Extensive application tuning through STATSPACK, explain plan, SQL*Trace.

Implemented scripts to capture high resource utilization query's, Implemented scripts for daily monitoring like db status, free space etc.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.

Tuned the SGA, Monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Table spaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.

Environment: Oracle Windows, IBM-AIX, RHEL, Oracle 10g PL/SQL, SQL*PLUS, Oracle Enterprise Manager 9.2.0/10g, RMAN

EDUCATIONAL QUALIFICATIONS

B-Tech in Information Technology from JNTUK.

Contact this candidate