Data Oracle

Padmini Papineni

Sr Oracle Database Administrator

PH: 510-***-****

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

Summary

8+ years of experience in IT industry, worked as Oracle Database Administrator in Retail, Financing and Banking segments, encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Monitoring and tuning RAC, Data Guard and Grid Control. Extensive 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.

Extensive Experience in database administration for Oracle 9i, 10g 11g and 12c, with experience in very large scale database environment and mission critical large OLTP and OLAP systems

Over 5+ years’ experience in working in RAC environment, Installing, maintaining & troubleshooting issues in the environment

Over 5+ years Extensive experience in Data Guard Configuration, Implementing and Executing, Maintaining Standby Databases i.e. ACTIVE DATAGUARD &SNAPSHOT STANDBY and trouble shooting

Over 3+ years’ experience in Installing, maintaining GoldenGate 11g/12c and used defgen, logdump to trouble shoot issues.

Have good knowledge about Physical and Logical structure of a database.

Over 2+ years’ experience in Working EXADATA environment, worked with Oracle for Platinum support.

Over 5+ years Hands on experience in Grid Control 10g/11g/12c.

Over 5+ years Hands on experience in Service Oriented Architecture (SOA).

Over 5+ years Hands on experience working in an enterprise production support environment.

Installed and configured 2, 4, 6 node server side load balancing RAC (Real Application Clusters)databases on HP UNIX and Linux with ASM (Automatic Storage Management) and Data Guard.

Installed 12C for database Monitoring/Performance/Diagnostics.

Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, TKPROF, Analyze, ADDM and Explain Plan Methods.

Tuning the Database Initialization Parameters using tuning advisors, AWR and Oracle Enterprise Manager.

Over 7 years in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

Maintained Catalog Server and involved in registering the Databases in Catalog Server.

Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table-spaces.

Good experience in PATCHING AND UP-GRADATION of database from 10.2.0.x to 11.2.0.4.

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).

Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.

Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.

Experienced in maintaining databases on large Production, Testing and DEV environments.

Experience in software testing and users training using DATA MASKING.

Experience in applying MASKING to the data represented outside of the Production system.

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

Handled daily production problems/change requests (DBCRS) with Oracle. Developed database monitoring/health check alert scripts for database-uptime/downtime status, and sizing issues using grid control (OEM).

Proficient in raising Service Requests with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.

Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams

Experience:

World Fuel Services, Plymouth, MN

Oct 2013 – Till Date

Role: Sr Oracle DBA

Responsibilities

Worked as operation database administrator (ODBA) and Responsible to provide 24x7 database administrative activities over different database servers.

Installed RAC on RHEL 6.7 11GR2 and involved in migration of databases to RAC environment.

Tuning the RAC interconnect for better performance, Finding RAC wait events And Maintaining ASM in RAC environment.

Participated on a project to migrate a 17TB data warehouse to Exadata from 5-Node Oracle RAC Cluster.

Performed Add-Node procedure on a 5-Node RAC Cluster to add two additional nodes.

Performed migration to Exadata Machine in two days. This was essential to make a buy/no-buy decision due in sixty days.

Monitoring Health checks of OCR, VOTING-DISKS and troubleshooting issues in RAC environment (11GR2).

worked on Cluster ware troubleshooting, CRS-ERRORS, CRS-4639, CRS-4530 and CRS-4535 and wait events in RAC environment.

Installed DR for 26 databases using Data Guard IN RAC & NON RAC environments, Configured Physical Standby databases using data guard.

Converted Physical-standby to Snapshot Standby and active data-guard depend on Business Requirement.

Maintained DR server and troubleshooting issues in Data Guard environment.

configure Dataguard broker (DGMGRL) and enabled 11g new feature FAST-START FAILOVER IN Dataguard.

Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (Installed 12C grid control and registered Databases in OEM. Used Oracle Enterprise Manager to protect sensitive data in production databases.

Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing at different levels, and analyzing security problems.

Applied patching on 10g/11g and Involved in Up-gradation of HP- UNIX databases from11.2.0.4 to 12.1.0.x. (12c).

Performed non-production Operation in environments security cleared to operate with the information contained in the production data using DATA MASKING

Performed Connectivity to integrate across cloud, on -premise and business to business using Service Oriented Architecture (SOA).

Performed Protecting Data such as personal identifiable data, personal sensitive data or commercially sensitive data using Data Masking

Performed data refresh at Schema level using EXPDP and IMPDP UTILITIES for exporting and importing of database objects between databases.

Used RMAN for backups and recovery and configured databases in Catalog server and involved in backup of Catalog database.

Scheduled Oracle Jobs USING DBMS_SCHEDULER and Backups using CRONTAB.

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

Performed Block Recovery and Data file recovery using RMAN. Assisting in implementation of change control process in production.

Handled daily production problems/change requests (DB-CRS) with Oracle.

Involved in Cross platform migration and used Oracle Golden Gate to transfer database from Hp-Unix to RHEL.

Performed Golden Gate Active - Active Data Replication and reviewing schema objects.

Performed Zero-Down Time migration from HP-Unix to RHEL.

Configured Extract and Replicate pumps for Golden gate replication and troubleshooting issues in GOLDEN GATE Environment.

Used DEFGEN utility to create definition files, log dump utility to analyze trail files, Implemented heartbeat tables to monitor lag in Golden gate Environment, Migrated oracle databases with minimal down using Oracle Golden Gate .

Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.

Creating SQL BASLINES & Profiles, User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Configured and Installed Oracle-Wallet-Management (OWM) for Data Security.

Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF and Tuned the SQL*s using TKPROF and STATSPACK reports.

Involved in fine tuning stored procedures by making use of PL/SQL Collections and its Bulk Fetch and Bulk Insert features.

Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.

Performance Tuning for the SQL queries which are Running slow and taking more CPU cost Involvement in day to day activities like Space management, rectification of Lock problems, managed quotas, Table partitioning to improve I/O access.

Alert log Monitoring for critical databases every day in the production environment.

Scheduled and attended day to day meetings as part of agile methodology.

Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, RHEL 5.x, 6.x, ASM, OEM, 12C(Grid Control), RAC 11gR2, 12C, RMAN and Data Guard, ORACLE GOLDENGATE, Explain Plan, DBMS_SCHEDULER, SQL Developer, Table partitioning, PL/SQL Tuning, Data Pump, Business Objects, putty.

True Value,Chicago, IL

Oct 2011 - Sep 2013

Role: Sr Oracle DBA

Responsibilities:

Implemented Oracle Database 11gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.

Installed and Configured Oracle 11g databases on AIX 6.1 and RHEL 6.X Worked on large databases size greater than 12TB.

Involved in designing of Disaster Recovery using Data Guard and High Availability using 11gRAC.

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

Installed 17 standalone servers on ASM and maintained DR databases on it.

worked on world fastest machine EXADATA X3-2, MIGRATED DATABASES TO Exadata

Worked with Oracle in setting up Oracle Exadata nodes in environment

Having good experience in using Storage Index, enabling and disabling flash cache, tested HCC in environment

Performed various tasks on ASM, creating a disk group, Adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.

Installed Golden gate on source and target side for Replication and implemented load-balancing topology using GoldenGate.

Configured Golden Gate Parameter files for Extract and Replica process for replication.

Performed automated backups and scheduling using scripting and Configured RMAN and registered databases in Catalog server.

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

Implemented Oracle database backup & recovery solutions using RMAN.

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

Generated AWR reports, ADDM reports for fine performance tuning and worked closed with PL/SQL developers to tune TOP SQL running queries in databases.

Used Invisible Indexes, and turn off indexes temporarily to check how queries perform without them.

Performed separating Functions into District Units or service using (SOA)

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

Created User accounts, Roles and worked with developers in granting access and writing store procedures and privileges

Used Data masking to protect private and confidential data by replacing sensitive information with dummy data Experience in Performance Tuning

Environment: Oracle 9i, 10g, 11g, HP-Unix, Sun Solaris, Linux, RMAN, DBCA, GOLDENGATE 11.2.0.3.x, Dataguard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF and putty.

Bahrain Financial Company, Fort Lauderdale, FL

July 2010 - Oct 2011

Role: Oracle DBA

Responsibilities:

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

Configured Oracle Data guard for Oracle Disaster recovery.

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

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

CAP, Hyderabad, India

Dec 2008 – June 2010

Role: Oracle DBA

Responsibilities:

Worked in build stage and implemented and installed 10g / 11g oracle databases on R.H.E.L servers 4.X and 5.X

Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes and granted privileges Grant and Revoked user privileges and roles as per requirement and killed blocking session.

Performed Auditing on user activities on request and per organization policies.

Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files.

Configured Recovery Manager (RMAN) and Performed Hot, Cold and Incremental backups for production databases using RMAN.

Performed Cloning and Refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.

Identified and fixed the logical block corruption using RMAN Involved in taking logical backup using Data pump Exp-dp and Imp-dp Utility.

Performed Data load on different databases from flat file using SQL*Loader. Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.

Environment: Oracle 9i/10g/11g, Red Hat Linux, SQL, TKPROF, STATSPACK, OEM, PL/SQL.

Education

BACHELOR’S OF MECHANICAL ENGINEERING &TECHNOLOGY JNTU (INDIA).

Contact this candidate