Manager Oracle

Bhanu Madala

Email: **************@*****.*** Ph: 469-***-****

Professional Summary:

Oracle Database Administrator with 8 years of professional work experience with updated database administration skills based on implementing different versions of oracle available in the industry from the administration, installation, configuration, upgrades and migrations of Oracle 12c, 11g, 10g performed all tasks based on the different business, financial, IT sector requirements. Implemented databases on the application load and availability to clients using GoldenGate, DataGuard, Real Application Clusters(RAC), ASM with Advanced security and Backups with RMAN including Performance Tuning techniques.

Experience synopsis:

Oracle databases with 12c/11g/10g with extensive experience installing, configuration and maintaining very large scale databases.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Monitored databases using different Oracle Enterprise Manager OEM 13c/12c/11g and resolved several incidents.

Advanced Security Features Database vault

Migrated databases between different versions using character set scanner utilities.

Created Materialized views, refreshed views and monitored logs improved performance of queries and performed aggregation and transformation of data.

GoldenGate implementation in active-passive and active-active configuration as high availability and technique on 11g and 12c.

Performed Zero-Down migration from AIX to RHEL using DataPump and GoldenGate.

GoldenGate implementation with different parameters to resolve conflicts,avoid looping, and to perform batch SQL.

Configured Disaster recovery database with DataGuard using DataGuard broker monitored the primary and multiple standby databases.

Configured DataGuard Broker, fast start failover and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing.

Implemented Active DataGuard for querying on standby to load balance the databases.

Implemented snapshot standby databases for testing objects performance resolved missing archivelog, Out of sync issues of standby databases.

DataGuard Configuration, Implementing and Maintaining physical standby databases in 10g/11g/12c on Solaris, AIX, RHEL.

Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of

up- gradation and migration.

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD

Handled Oracle GoldenGate Replication in Oracle Real Application Clusters (RAC).

Implemented Oracle RAC with ASM in different environments such as development, testing, pre production, production.

Implemented basic tasks on RAC like Mirroring OCR on different ASM diskgroups, Tuning Node Evictions by setting disktimeout, reboottime, miscount.

Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

Administering and setting up of 11g/12c RAC and Clusterware and instances.

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

Hands on experience in applying One-Off Patch and also applying patchsets Quaterly.

Upgraded Oracle GRID, ASM and Database from 10g and 11g to 12c. Implement12c new features in mission-critical production environments.

Migrated Standalone databases to RAC 12c clusters and Supported Application.

Migrated the data from oracle database to Amazon S3 RDC INSTANCE by sending the backupfiles through AWS Snowba

Technical Skills:

Operating Systems

HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x

RDBMS

Oracle 12c/11g/10g/, Oracle 12c/11g Real Application Cluster (RAC), ASM.

Tools and Utilities

RMAN, OEM 13c/12c/11g/10g, TOAD, SQL*Loader, Export/Import, Data pump, Web logic Server, Logdump, Defgen, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations.

Languages

C, SQL, PL/SQL, UNIX/NT Shell Scripting.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Ticketing Tools

BMC Remedy, JIRA, NEWS, Service Now.

Education: BACHELOR OF SCIENCES (B.S.C) FROM NAGARJUNA UNIVERSITY IN COMPUTER SCIENCE.

Professional Experience

Client: County of Los Angeles, Downey, CA June 2016 – Till date

Role: Sr.Oracle DBA

Responsibilities:

Installed and configured Oracle 12c/11g on RHEL and AIX platforms.

Up-graded databases from 11.2.0.4 to 12.1.0.1 on Linux.

Installed High Availability Oracle GoldenGate (OGG) systems on Oracle 11g and 12c environments.

For confidentiality and security purpose created password Wallet to avoid the password in the GoldenGate parameter file of the process.

Using log dump utility in GoldenGate analyzed the data on the trail and fixed the abended process by outer repositioning the process.

Implemented OEM (Oracle Enterprise Manager)13c in the Test and non-production Environments.

Created Application Data Modeling using Oracle Enterprise Manager(OEM)13C to discover the sensitive columns from tables which have parent-child relationships and export the application data model to mask the sensitive information.

Deployed Jagent and implemented GoldenGate plugin in the OEM to monitor the GoldenGate

Installed Oracle Enterprise Manager repository (OEM) database and deployed the agents on the target hosts and monitored the different services running on the hosts.

Applied Patch Set Updates quarterly on 11g/12c GRID & RDBMS homes using opatch auto and Up-gradation of 11g/12c databases.

Installed ASM on standalone servers used asmcmd command line utility to manage disk groups in the ASM and created fail groups tuned the asm power limit value when new disks are added to the disk group.

Performed various tasks in RAC Cluster pinning nodes, and performed backup of OCR, OLR and voting files, Multiplex Voting files.

Configured GoldenGate on 12c RAC, RAC Active configuration with 12c database .

Maintained high availability and high scalability Oracle 12cRAC two node cluster on the RHEL.

Adding a New Node to RAC cluster and Installed Oracle RDBMS on new node of cluster and Created ASM Volume using ASMCA and Created ACFS for GoldenGate 12c.

Migrated Standalone databases to RAC 12c clusters and Supported Applications.

Configured DataGuard broker in the DataGuard environment for easy role transitions between the primary and the standby databases.

Upgraded databases in Dataguard Evnironment from 11.2.0.4 to 12.1.0.1 for primary and standby.

FAST START FAILOVER Dataguard configuration in maximum performance mode.

Missing archive log scenarios in Dataguard environment resolved by restoring archive logs from backup and incremental backups through RMAN.

Restored data file from primary database to standby database using RMAN recovered the standby database from the data corruption.

Experience in backup and recovery. Cold backups, Hot backups, Logical backups, RMAN backups performed at different levels of Full backup, Incremental backup, Cumulative backups.

Recovered dropped tablespace using RMAN performed TSPITR on dropped tablespaces.

Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.

Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Worked with the application development team to ensure that appropriate and efficient SQL is being coded and tested. Maintained stored procedures, triggers, and User defined functions.

On-Call 24x7 DBA support for production databases.

SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports.

Created materialized views and fine-tuned them for better performance.

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

Scheduled jobs using Autosys implemented command jobs, box jobs, file watcher.

Implemented different methods of Partitioning at table level and index level.

Worked with development team in creating PL/SQL, Stored Procedures, Triggers, views, constraints and cursors.

Worked on debugging issues reported by users. Analyzed complex PL/SQL packages.

Supported for high-availability solutions for mission critical SQL Server databases, including clustering, mirroring and replication.

On-Call 24x7 DBA support for production databases.

Environment:Oracle 12c/11g/10g, Sun Solaris, Red Hat Linux, MS SQL Server 2008R2/201/2014, RMAN, RAC, DataGuard, Autosys, Datapump, GoldenGate, OEM, Grid Control, STATSPACK, Patching, AWR, Explain Plan.

Client: University of Massuchusets, Shrewsbury May 2014 – April 2016

Role: Sr.Oracle DBA

Responsibilities:

Worked in migration project, Migrated databases from Sun Solaris to RHEL 6.7

Performed Add-Node procedure on a 2-NodeRAC Cluster to add an additional node.

Performed tuning and monitoring for Oracle Real Application Clusters (RAC) nodes running on the ASM disk storage.

Performed tasks on RAC like Creating New VIP to manage high availability, and used different parameters, Configuring ACFS and configuring for Automatic failover

Implemented Active – Active (Bi-directional ) replication in the GoldenGate environment using Conflict Detection and Resolution parameters.

In GoldenGate for large transactions split the replicat to improve the performance of the process without affecting the parent-child relationship between the tables.

Configured Coordinated replicat with maximum performance depending upon CPU count to improve the performance of the process in the GoldenGate.

Management of schemas, objects, partitioning the tables to improve the query processing

Implemented the DataGuard with delay shipping of the archive logs in order to avoid the logical corruption on the physical standby database

Converted Physical standby to Snapshot Standby for testing performance of the indexes

on the primary databases in DataGuard Environment

Created SQL baselines to capture SQL, execution plans generated by the SQL plan management

Experience on hands with oracle utilities like Database Configuration Assistant(DBCA), Database Upgrade Assistant(DBUA) for upgrading the databases and used specific templates for creating the database

Working experience with the latest TOAD having new features PLSQL&SQL Script debugger Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query builder

Provided Instance level performance monitoring and tuning of wait events, Sessions, Physical and Logical I/O and Memory Usage

Performed RMAN incremental backups for the standby database in order to sync it with the primary database

Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR)of databases.

Performed datapump operations to refresh lower environments with parallel option to increase the performance datapump jobs

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

Established performance tuning best practices used by the DBA and Development teams.

Monitored queries which have high response time, high disk read per execution and tuned the queries same using Explain Plan,TKPROF and SQL tuning advisor

Creating Views & Materialized Views, Implementing SQL profiles and Migrating SQL BASELINES, Creating and rebuilding Index’s, re-organizing tables.

Configured Active Snapshot standby databases for production databases using Oracle Dataguard for disaster recovery. Tested switch over & fail over for standby database using Dataguard broker DGMGRL.

Responsible for optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, AWR, ASH, ADDM.

Environment: Oracle10g/11g/12c databases on Solaris/HP-UX/RedHat/AIX/Exadata, OEM 11g/12c. Oracle 10g/11g/12c, RMAN, RAC, DATAGUARD, Standby, SQL, DATAPUMP, GoldenGate, ASM, SQLLOADER, AWR, ADDM, Explain Plan.

Client: Prudential Financial, Roseland, N.J Feb 2012 – April 2014

Role: Sr.Oracle DBA

Responsibilities:

Performed migration of the oracle databases whose database sizes vary from 450 GB to 1.2 TB from Oracle 11.2.0.3/11.2.0.4 to Oracle 12.1.0.2 using DATAPUMP.

Implemented Oracle Partitioning, Advance Queuing, and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience

Upgrade 11gRAC to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL and applied patches in rolling fashion

Hands on experience in GGSCI utility for administering Extract, Pump, Replicate & reviewing the error logs and troubleshooting abend scenarios.

Full database, Schema refresh using RMAN, Datapump and Implemented the Backup strategies using RMAN catalog and nocatalog methods

Configured diskgroups with different redundancy levels and created fail groups and managing and tuning ASM parameters

Upgraded database from 11.2.0.1 to 12.1.0.1 with minimal planned downtime.

Programming in shell to create shell scripts that automate the database backups and maintenance

Responsible for setting up effective monitoring for alerts and capacity analysis. Also, tuning the database environment to insure optimal performance and resource utilization

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Experience in Flashback Technologies, RMAN Active Database Cloning, Virtual private Catalogs and Merging Recovery Catalogs

Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time

Installation, Configuration and Maintenance of Oracle 11g/12c RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.

Scheduled Oracle Jobs using DBMS_SCHEDULER and Backups using CRONTAB

Configured Listener and TNS names using NETCA for creating the client-server

Extensively used SQL* LOADER as a tool for loading data.

Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.

Applied patch set and interim patches whenever required to make the database software up to date

On-Call 24x7 DBA support for production databases.

Wrote new and maintained and extended existing PL/SQL code that was used to convert existing data sets and enhanced the PL/SQL code

Involved in doing block recovery and backup validations using RMAN. Implemented backup strategy using RMAN, Oracle Utilities (Export/Import) and OS methods.

Configured Heart Beat Table on both source and target to monitor GoldenGate lag.

Performance Tuning for the SQL queries by scrutinizing the long-runningSQL queries.

Experience in applying quarterly security patches (PSU/CPU), as well as interim patches for fixing bugs.

ENVIRONMENT: ORACLE 12C,11G, TOAD, Flash/Flashback Recovery, RMAN utility, RAC, ASM, DATAGUARD, GOLDENGATE, PL/SQL stored procedures, OEM, DataGuard, Flashback, SQL*Loader, Export/Import, Data Modeling, AWR, ADDM, ASH, Explain Plans, TKProf, STATSPACK, SQL* Trace, SQL Developer, Exadata, UNIX, SOLORIS, AIX, RHE-LINUX.

CLIENT: TATA DOCOMO LTD, INDIA Jan 2010 - Nov 2011

ROLE: Oracle DBA

Responsibilities:

Configured users into consumer groups and set the resource utilization based upon business activity using RESOURCE MANAGER.

Involved in monitoring the Database related activities using Oracle Enterprise Manager 11g Grid Control (OEM Grid) and monitoring the backup jobs scheduled in OEM Grid.

Performed configuration of Oracle ASM on HP-UX, RHEL.

Performed Installation, Configuration, and Monitoring of Oracle 11gR2, 11gR1 and 10g on UNIX, Linux.

Installed, configured and monitored Oracle RAC 11gR2 and 10gwith ASM.

Configured and implemented Oracle 11gR2 Data Guard for Database disaster recovery.

Experience in Planning Database, Sizing tablespace, create database, scripts, monitor databases, interact with developers, Oracle Install, Upgrade, 24x7 DBA support, Disaster recovery Automate daily jobs, Schema management, SQL loader, Export/import Database, Tune database.

Experience in RAC, EXADATA, ASM, DATAGUARD, Patching, Upgrades & Migrations.

Working Experience with the latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.

Implemented and documented backup/recovery strategies using hot backup, cold backups using RMAN and Export/Import utilities and Wrote Shell Scripting for managing day-to-day activities and automation of backup.

Performed logical backup of the database and Schemas using DATAPUMP (Expdp/Impdp) as per the requirement.

Migration of databases from MS SQL server 2008 and Oracle 11g.

Involved in implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases on HP-UX and Linux.

Involved in PL SQL programming and Performance tuning for oracle Database by generating AWR and ADDM reports

Performed Database activities using Development tools like SQL Developer and TOAD.

Effectively resolved incident tickets in the production environment.

ENVIRONMENT: Oracle 9i, 10g & 11g, RHEL 4.2, IBM AIX 5.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, Tuning Advisors, TOAD, Oracle 10g RAC, Sybase, SQL Server 2005.

CLIENT: SUNDARAM FINANCE GROUP, INDIA Oct 2008 – Dec 2009

ROLE: Jr.Oracle DBA

Responsibilities:

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.

Installed and configured Oracle and Oracle Products on Linux and Windows Environments.

Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments.

Supported databases on AIX, UNIX and Linux.

Evaluated the hardware requirements before upgrading/migrating the database.

Good experience with recovery managed backups i.e. RMAN.

Manage users, privileges, profiles and schemas.

Experience in using automatic monitoring and management processes such as batch processing using Crontab for processes like import, export databases.

Involved in checking the status of listener and restarting listener.

Involved in Schema management, Table space Management, User Creation.

Monitoring the alert logs and trace files regularly. Administering the Client’s Oracle 10g Database.

Compared schemas, databases, TNSNAMES.ORA file and Tablespaces for better understanding of databases between test and production environment.

Storage management, sizing the database objects, monitoring Disk usage.

Involved in writing UNIX shell scripting for automating the jobs.

Experience with SQL query tuning, SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.

24/7 on-call production database support.

Architecture reviews, Change management meetings and Team meetings.

Documented the complete project including all pre-installation, post installation and database configuration steps.

Environment: Oracle9i/10g, SQL, PL/SQL, Shell Scripting, Windows NT/03, Linux, AIX5.1, Hp-UX, Sun Solaris.

Contact this candidate