Manager Oracle

Sai Krishna Pavalla

Sr Oracle Database Administrator

Email: ********.***@*****.***

Phone: +1-785-***-****

8+ years of professional experience in IT industry as an Oracle database administration in Linux, UNIX and Windows platforms. Experience include design, build, test and supporting next-generation database solutions in Oracle enterprise. Proficient in Database Administration, Database Installation, Upgradation, Migration, Patching, RAC installation, setting up and configuring DataGuard, Databases clone, Performance tuning and monitoring the database using OEM Grid Control, RMAN backups, GoldenGate replications, product support.

EXPERIENCE SYNOPSIS

•Excellent experience in Installation and configuration of Oracle 10g,11g,12c in UNIX/LINUX and Windows environment.

•Expertise in Installation and configuration of Oracle Enterprise Manager(OEM) Cloud control 12c on RHEL.

•Proficient in Database System Architecture, Data Modeling, Logical/Physical database design (DataGuard implementation for Disaster Recovery).

•Expertise in DataGuard Configuration, Implementing and Maintaining Physical Standby databases in 10g/11g/12c on Solaris, AIX, RHEL.

•Proficient in setting up Standby Database using RMAN utility tool, activating and re-building Standby Databases.

•Good Experience in configuring Active DataGuard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases.

•Configured DataGuard Broker and managed standby databases using DG broker.

•Troubleshooting DataGuard using dynamic views, troubleshooting missing archive log scenario using Incremental backup. patching DataGuard environment.

•Expertise in Installing and configured transactional level DDL, DML, BI-DIRECTIONAL replication using GoldenGate v11 and v12.

•Oracle GoldenGate troubleshooting using ggserror log.

•Upgrading GoldenGate from v11 to v12 and Expertise on Oracle GoldenGate and configuration.

•Used Logdump Utility to Investigate data on the trail, defgen utility to create definition files in GoldenGate.

•Experience in Cross Platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate with Zero downtime.

•Supported advanced replication (Oracle Streams) to replicate data between production databases for local and downstream capture architectures.

•Expertise in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.

•Monitored database servers and optimized database performance using various tools such as Oracle Enterprise Manager (OEM), Oracle Grid Control.

•Deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, AWR, ASH reports, scheduling jobs using Auto sys, blackout scheduling, SQL tuning advisor to tune sql’s on databases.

•Performed Data Redaction, Data Masking and configured Database Vault in 12c using grid control (OEM) to protect sensitive data.

•Using AWR, ASH reports, ADDM reports, provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, system partitioning, Creating Views & Materialized Views.

•Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN, Snap Level backups

•Good Knowledge in the functional and technical aspects of Oracle E-Business Suite/ Applications 10g and 11i deployment Requirements, Coding and Development.

•Worked on supporting EBS Financial, WebLogic Middleware Stack and Oracle Fusion Middleware.

•Expertise in upgrade process from 10g to 11g and 11g to 12c and data migration using Expdp and Impdp.

•Expertise in Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQLNet, V$, DBA views.

•Good experience in Patching PSU and CPU Patches Quarterly.

•Performed database backups with RMAN incremental and cumulative backups by registering 10g/11g databases in recovery catalog.

•Experience in applying Oracle rolling patches on RAC 11g/12c environment using response file.

•Involved in moving databases in EXADATA RAC environment.

•Worked on RAC and ASM, building and supporting 11GR2 and 12C RAC clusters using ASM storage.

•Proficient in EBS Installation, Patching, Cloning, Database Refresh, Upgrade (Database), Disaster Recovery, High Availability and Backup & Recovery (RMAN).

•Migrated databases into Exadata Machine with minimal downtime using DataGuard.

•Attended various workshops with Oracle-10g Grid Control Workshop, Oracle 11g DataGuard and 11g ASM Workshop, Oracle GoldenGate 12c, OEM 13c.

•Good knowledge in managing MySQL and Oracle databases in Production, Test, Development environment.

•Supported machine critical application databases by giving 24x7 supports.

•Have Ability to function independently and plan, evaluate and design solutions to problems and Ability to work well in a group environment.

TECHNICAL SKILLS:

Databases

Oracle 12c/11gR2/11gR1/10gR2/9i, SQL 2012/2008R2, MYSQL 5.7

Oracle Products

Oracle Real Application Cluster 12c/11g/10g, GoldenGate, DataGuard, Import and Export, Data pump, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c (Grid Control), Oracle EXADATA, RMAN, Oracle Wallet, Transparent Data Encryption, Oracle Enterprise Manager (OEM) 11g,12c,13c.

Operating System

Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Oracle Linux, HP UNIX 11i, AIX 6.1, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008

Languages

SQL, PL/SQL, Unix shell scripting, Java

Tools & Utilities

SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Oracle SQL Developer, ERWIN, ETL

PROFESSIONAL EXPERIENCE

Con Edison of New York - Irving Pl, New York Duration: Aug 15 - Present

Role: Senior Oracle Database Administrator/ EDW Level 3 Support

Responsibilities:

•Installed, configured, and maintained Oracle 11gR2, 12c on Linux and also Upgraded from 11g to 12c, and refreshed Oracle 11gR2 and Oracle 12c databases using file system for storage to ASM.

•Supported Production and Development environments for business-critical application (Data Guard Physical Standby architecture, GoldenGate).

•Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, DataGuard.

•Responsible for setup and implementation of 3 Node RAC and RAC One Node on Linux in 12c.

•Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 11g/12c and 13c for Configuration of error notifications

•Implemented Disaster Recovery database 11g/12c DataGuard on physical standby database in maximum performance mode using LGWR ASYNC mode.

•Expertise in configuring Active DataGuard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases.

•Troubleshooting DataGuard using Views, troubleshooting missing archive log scenario, patching DataGuard environment, Applied logs with delay.

•Configured DataGuard Broker and managed standby databases using DG broker.

•Configured a real-time downstream capture processes using GoldenGate and Active DataGuard.

•Installed GoldenGate for replication of database on 12c RAC environment and Configured parameters for the Bi-directional replication.

•Configured GoldenGate as CRS resource to provide uninterrupted service of RAC instance node failure.

•Configured Integrated Extract, Integrated replicat and coordinated replicat on Oracle multitenant database 12.1.0.2.

•Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and upgraded GoldenGate from v11 to v12.

•Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied patches to GoldenGate environment 12.1.0.2.

•Resolved the issues in conflicts between the target and source database in GoldenGate.

•Configured and build GoldenGate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in GoldenGate.

•Monitored databases performance using Oracle Enterprise Manager (OEM) 11g/12c Grid control.

•Implemented ASM on RAC and stand-alone databases, managed disk groups with ASM.

•Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM

•Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate and process improvement for GoldenGate by proactive monitoring using Shell scripts.

•Used Different RAC utilities: raccheck, orachk, oratop, TFA Collector, ocrconfig, OSWatcher, Srvctl and Crsctl

•Upgradation of CRS/ASM/RAC databases from 11.1.0.7 to 11.2.0.4,11.2.0.4 to 12.1.0.2 etc.

•Worked on EXADATA(X5-2) RAC and having good Experience with Oracle for Exadata or Database Appliance hardware issues.

•Expertise in Oracle for Exadata patching (Rolling/ Non- Rolling).

•Created volumes on ASM disk groups and maintaining ACFS Cluster File system in RAC.

•Performed patching on Oracle Database Server 11gR2 and 12c using Opatch utility and Opatch auto.

•Applied rolling patches to fix known bugs as well as PSU.

•Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

•Expertise in implementing database Backup and Recovery concepts using RMAN utility

•Use Oracle Metalink Support to resolve issues related to database servers, security patches and Proficient in raising SR with Oracle Support.

•Developed UNIX script to monitor various events in the database and also to maintain and cleanup oracle generated files/logs.

•Worked on resolving issues pertaining to Struk transaction in O2C, P2P business cycle in E- Business Suits.

•Worked on databases ranging from 500GB to 10TB and participated in monthly on-call DBA schedule.

•Provided on-call support 24x7 for any issues with system by receiving text messages when an issue arose and logging in remotely to resolve those issues.

Environment: Oracle12c/11g, Oracle EXADATA X5-2 HALF RACK, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL GoldenGate, Linux 5.8, Sun Solaris, Red Hat Linux, RMAN, SQL server, DataGuard, GoldenGate, OEM, Grid Control, STATSPACK, AWR, Exports/Imports, Oracle-Wallet-Management, WebLogic server, Fusion Middleware, PL/SQL Tuning, WebSphere, Data Pump, Business Objects, putty, TOAD 11.6.

University of Massachusetts- Boston, MA Duration: May 14 - July 15

Role: Senior Oracle/Banner Database Administrator

Responsibilities:

•As an Oracle DBA, supported Ellucian Banner ERP systems within and outside of the organization.

•Upgraded all databases from 11.2.0.4 to 12.1.0.2 using Banner application Oracle Databases

•Planning, scheduling and implementing upgrades of all Banner instances, according to Ellucian schedule.

•Monitoring and managing the database environments.24x7 database production support.

•Implementation of High Availability solutions with Oracle 11g RAC, Standby Database (Active DataGuard) to ensure high availability, data protection and disaster recovery for enterprise data.

•Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database.

•Worked on OEM 11g/12c agent installation on servers, configure new databases for monitoring, Setup jobs, alerts, notifications etc.

•Extensively involved in analyzing the functional requirements for the Database Access Profiles.

•Configured RMAN backups using NetBackup and DDBoost.

•Design and implement Oracle Fusion Middleware components for systems integration on WebLogic 11g and OAS 12c platforms.

•Successful in installation/maintenance of Physical Standby database using Oracle DataGuard for Oracle 11.2.0.4 and Oracle 12.2.0.1 databases.

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

•Performed Upgrades, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.

•Installed GoldenGate software 11g/12c and configured extract, data pump and Replicat processes for

•multi-master architectures.

•Setup classic capture replication mechanism using GoldenGate.

•Install and configure Goldengate replication. Perform zero downtime migrations.

•Planning Recovery Procedures and Performing backups in both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities

•Identified and fixed the logical block corruption using RMAN & PERFORMED logical backup using Data pump Expdp and Impdp Utility.

•Knowledge in Oracle Retail suite of Merchandising and Store level applications such as RMS, RPM, REIM.

•Performed cross platform migration of databases from IBM - AIX, Solaris, HP-Unix to Linux 11g using RMAN, FLASHBACK and Data Pump.

•Installing MySQL with source and binary distribution.

•Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs.

•Attended Developer’s code review meetings and made recommendations to improve Efficiencies.

•Expertise in optimizing SQL queries by reading Explain Plan Statistics, developed backend interfaces using PL/SQL Packages, Stored Procedures, Collections.

•Upgraded the Oracle 11g database to 12c version and also applied patch set and interim patches whenever required to make the database software up to date.

Environment: Oracle 11g/12c, BANNER- ERP, DataGuard, ASM, Banner, Oracle Enterprise Manager(OEM) Grid Control 12c, 11g, GoldenGate, RMAN, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, Solaris.

Department of Transportation Penn DOT- Harrisburg, PA Duration: Mar 13 - April 14

Role: Oracle Database Administrator

Responsibilities:

•Configured and tested Replication using GoldenGate where Source Database on Sun Solaris 10 SPARC 64 bit with Oracle 11g and Target Database on Linux with Red Hat Enterprise Linux Server release 5.4 with Oracle 11g Database with 2 node RAC on ASM.

•Configure Oracle GoldenGate Monitor/Director, OBIEE and integration with Oracle Enterprise Manager Grid Control with Remedy using User Define Metrics.

•Involved in testing Oracle GoldenGate in staging environment.

•Adding a new node to RAC cluster and installed Oracle RDBMS software on new node of cluster and created ASM volume using ASMCA and created ACFS for GoldenGate 11g.

•Divided replicated tables among multiple GoldenGate processes to speed up performance.

•Installed, configured and maintained databases on high availability systems like DataGuard and Real Application Cluster environments.

•Setup and maintain Oracle DataGuard (Physical) with Fast Start Failover, Active DataGuard.

•Setup and maintain 11g RAC-Dataguard setups

•Configured Oracle DataGuard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing.

•Setup multiple DataGuard Setups (DataGuard Broker-DGMGRL) for 2/3 Node 11g RAC Clusters, Enabled Fast Start Failover.

•Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 with Oracle 11g on ASM and performing health checks on RAC using SRVCTL and CRSCTL.

•Adding a New Node to other Node RAC cluster and Installed Oracle RDBMS software on new node of cluster, Created ASM Volume using ASMCA and Created ACFS for GoldenGate 11g

•Extensive experience with Database Cloning and Refreshing pre-prod databases.

•Proficient with Database Administration activities such as Installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.

•Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.

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

•Using Oracle Data Pump utility and performed Database Migration and Upgradation of databases.

•Developed Recovery Manager (RMAN) scripts for database backup and recovery for hot and cold backup options for both RAC and standalone instances.

•Supported more than 130 production and development databases.

•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.

•Expertise in analyzing database objects, dblinks, creating indexes, creating materialized views, Store Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle.

•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.

•Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.

•Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.

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

•Good Knowledge in Installing, Configuring, Upgrading MySQL 5.0/5.6/5.7 databases running on OEL

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

•Responsible for capacity planning, recovery planning and installing patches.

•Participated in On-Call providing 24x7 support for the databases and resolved assigned emergency tickets.

Environment: Oracle 11g RAC & 11g RAC, OEM Grid Control, Sun Solaris, HP-UX, RHEL, Windows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

Vodafone India Services Private Ltd. - Pune, India Duration: Mar 10 - Dec 12

Role: Junior Database Administrator

•Installation, Maintenance and administration of Oracle 10g on Red hat Linux, Windows, AIX,

•Used Enterprise Manager for diagnostic summary, CPU utilization, wait events, alert log errors etc.

•Installation and maintenance of Oracle 10g DataGuard.

•Standby database setup via DataGuard for Database Disaster Recovery.

•Worked on physical and snapshot standby databases in DataGuard environment.

•Involved in construction of Disaster Recovery (DR) for all the production databases using DataGuard.

•Tested many scenarios in RAC, DataGuard and RMAN environment.

•Experience in Creating Physical Design Data Models using Erwin Tool.

•Created, monitoring database objects like Indexes, Views, Users, and DB Links.

•Administered, maintained, developed and implement policies and procedures to ensure the security

and integrity of all Oracle and some SQL Server databases.

•Worked extensively on monitoring 10g/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control.

•Taking Backups on scheduled time and monitoring scheduled Backups.

•Installed Standalone servers on ASM and migrated databases to ASM.

•Implemented data transfer using Transportable Table Spaces (TTS), Data Pump and Export/Import utilities

•Collected ADDM recommendations using OEM 10g/11g to tune the top running SQL Queries.

•Implemented Disaster Recovery Plan for critical databases using DataGuard.

•Experienced in performing Point-in-Time Recovery.

•Monitoring tablespaces issues, creation tablespaces and adding datafiles.

•Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.

•Tuning heavy data loads. Monitoring and Performance tuning.

•On-Call 24x7 DBA support for production databases.

Environment: Oracle 10g/9i, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, PL/SQL, SQL Plus, Unix, Data Modeler, RMAN, DataGuard, RAC

Corporation Bank- Pune, India. Duration: Jan 09 - Feb 10

Role: Junior System Executive

Responsibilities:

•Creation of databases using DBCA and also using scripts.

•Setting up SQLnet /Listener/Tnsnames.ora.

•Oracle Configuration. Oracle Tuning. Oracle Patch Administration.

•Managed Tablespaces such as creation, reorganization and modification of storage parameters for optimization of disk space and defragmentation.

•Implemented data transfer using Data Pump Export/Import utilities.

•Created and maintained user accounts, roles, privileges, and system and user level database objects.

•Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.

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

•Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.

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

•Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.

•Tuned the performance of the SQL’s using TkProf and Stats pack reports.

•Creation of Tablespace, Data files, Indexes, Rollback Segment and monitoring them.

•Creation of Users and Granting them privileges and roles.

•Installed Oracle 9i/10g database on RHEL and applied all current patches.

•Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.

•Involved in writing complex SQL statements.

•Monitoring the data loading jobs and tuning the SQL queries.

•Database Backup and Restore using RMAN and Export/Import and used Crontab Schema refresh to lower environments using Expdp/Impdp.

Environment:

Oracle 10g, Windows 2008, Sun Solaris 5.x, IBM AIX Oracle RAC, TOAD, VERITAS, OEM, LOGMINER, Informatica, DB Links, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.

EDUCATIONAL QUALIFICATIONS

•Bachelor of Technology, JNTU, INDIA

Contact this candidate