Oracle Data

NAGARAJU MANNEM

Sr. Oracle DBA

E-Mail: acznfu@r.postjobfree.com

Phone: +1-816-***-****

Professional Summary

Highly accomplished in Implementing Maximum Availability Architecture with a successful 8+ years track record of success in administering Oracle 12c,11g and 10g databases and Repeatedly successful in navigating complex and technical environment. Having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, RAC installation and maintenance, setting up and configuring, performing all kinds of backups and recoveries, cloning databases, database security, migration and documentation.

Key Responsibilities Handled

Provided 24x7 on-call support for production databases.

Expertise in Dataguard configuration, implementation and maintaining physical standby databases in 12c / 11g / 10g on Linux.

Expertise in configuring Active Dataguard, snapshot standby and troubleshooting issues and configuring service level agreements(SLA) for query’s accessing standby databases.

TroubleshootingDataguard using views, troubleshooting missing archive log issues, patching Dataguard environment, applied logs with delay.

Configured Dataguard Broker and managed standby databases using Dataguard Broker.

Implemented and configured GoldenGate onstandalone database.

Expertise in installing and configuring transactional level DDL, DML, BI-DIRECTIONAL, UNI-DIRECTIONAL replication using GoldenGate v10, v11 and 12c.

GoldenGate utilities like GGSCI, Logdump, defgen for troubleshooting issues and performed data replication from SQL server database to Oracle database using GoldenGate 11g.

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

Implemented GoldenGateReplication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and Handy in upgrading GoldenGate from v11 to 12c.

Implemented and configured GoldenGate on a 2-node RAC cluster.

Troubleshooting and fixing GoldenGate errors in a 2 node RAC production environment.

Configured Automatic Storage Management (ASM) for 11g RAC databases.

Monitored and Administrated ORACLE RACdatabases on ORACLE 11g Clusters

Migrated Non ASM databases to ASM.

Addeddisks to disk groups usingASM system when the file system is full.

Developed database monitoring and health check alert scripts for database uptime and downtime status, and sizing issues using grid control(OEM).

Hands on experience in OEM 13c, involved in upgradingOEM from 11g to 12c

Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling RMAN jobs, SQL tuning advisor.

Successfully implemented the planneddowntime by creating blackoutsin OEM.

Involved in creating templates to monitor the databases based on requirements.

Configured DatabaseVault, Data Redaction, and Data Masking techniques in OEM.

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

Implemented scheduling full, incremental, cumulative and hot, cold backups.

Performed Various Tasks on RMAN: configuring backup, Block recovery, data file recovery, registering databases in catalog, TSPTR (Tablespace point in time recovery).

Configured Catalog database for RMAN backups.

Experience in logical backups and Database migration tools with Data pump, Export/Import.

Experience in implementing Flash-Back Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database.

Experienced in maintaining large Production, Testing and DEV environments and worked on database cloning with RMAN.

Good experience in Patching PSU and CPU Patches Quarterly and Upgradation of databases from versions 10g,11g to 12c.

Experience in Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.

Had a good experience in closely working with Engineering Team to implement databases as specified.

Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.

Have a good knowledge on small flash cache and troubleshootedExadata small scan off load issue.

Compressed data in different levels using Exadata.

Worked on Instance Tuning, Memory Tuning and SQL Tuning.

Involved in Migrating SQL server 2008 to 2012.

Experienced in Performance Tuning by analyzing AWR, ASH and ADDM reports.

Good exposure to oracle technologies like AWR, ASM, Flashback and Data pump Import/Export.

Created ASM Disk & Disk groups and Maintained Oracle ASM instance.

Installed and configured EBS 12.1.3 Validation environment with a 2 node 10g RAC (ASM)

Worked in environment Upgrading EBS 11.5.10 to EBS 12.2.4 and Oracle DB from 11g to 12c.

Installed and Configured Oracle Retail Merchandising System (RMS) 8.0.

Tested and Supported various Oracle RMS applications.

Upgraded current systems from Oracle Retail Merchandising System(RMS) 8.0 to latest version.

Hands on partitioning tables and creating Materialized views.

Replicated data based on column and row level sub setting using Materialized views.

Worked with Ticketing tools like BMC remedy, service now, Pack 200 etc.

Technical Skills

Operating System

Oracle Linux, Red Hat Enterprise Linux(RHEL), Sun Solaris, Windows 2008/2003

RDBMS

Oracle 12c/11g/10g

Languages

SQL, PL/SQL, UNIX shell scripting, XML, C, C++

Tools & Utilities

TOAD, SQL Tools, ADDM, DBCA, Log miner, BMC Remedy, AWR,ASH, Putty, ETL tool, Log dump, defgen, Tuning advisors, ORACHECK, TFA.

Oracle Tools

RAC, RMAN, ASM, OEM (11g, 12c, 13c), SQL *Loader, exp/imp, GoldenGate, Dataguard

Oracle products

Real Application Cluster (RAC), GoldenGate, Dataguard, Import & Export, Data pumps, Oracle wallet management, Automatic Storage Management (ASM), Recovery Manager(RMAN).

Ticketing Tools

BMC remedy, Service now, Pack 2000

Project Experience

Client: American Automobile Association, Dearborn, Michigan. Nov 2015 - Till Date Sr. Oracle DBA

Environment: Oracle RMAN, Oracle 11g (11.2.0.2) and 12c (12.1.0.4), Data pump, GoldenGate, Dataguard, RAC, Linux, Solaris, ASM, OEM, TOAD, SQL-T.

Worked as a primary DBA for more than 150 databases and provided applicationsupport as required.

Installed and configured Oracle12c,11g, 10gon Linux for Production, Development and Testing environments.

Provided on-call 24x7 DBA support for Production databases and Test databases.

Worked closely with Engineering team in creating Databases.

Installation of Oracle 12c Real Time Application Cluster(RAC) on ASM, Upgrading RAC cluster from 11.2.0.4 to 12.1.0.2 and upgrading databases, monitoring and managing databases on RAC

Used OCRCONFIG for OCR and OLR backups, Used CRSCTL, SRVCTL utilities to manage cluster ware and services in RAC environment

Worked on ASM in RAC and involved in creating DBFS in RAC, created ASM Volume, ACFS in RAC environment.

On daily basis activity monitored the databases using OEM, Worked with Data Masking Pack, Oracle Database Vault, Audit Vault, DataRedaction in OEM.

Mass deployment of agents on target servers and monitoring the servers using OEM.

Troubleshoot Database performance issues using Automated Workload Repository(AWR) and Automatic Database Diagnostics Monitor(ADDM). Tuned database for optimum performance.

Experience in Oracle GoldenGate installation, configuration and troubleshooting GoldenGate issues.

Performed replication of data in different levels using GoldenGate and Dataguard techniques.

Configured active-active(Bi-directional), active-passive (Uni-directional) GoldenGate replications.

Involved in Classic and Integrated extractimplementation and operations.

Hands on Cross platform migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate with minimal downtime.

Involved in deploying new application and setting up replication between the databases using GoldenGate and troubleshooting issues.

Performed GoldenGate replication Monitoring, PerformanceTuning, and Capacity Planning.

Worked with defgen and logdump utilities in troubleshooting GoldenGate performance issues.

Enabled DML/DDL data replication, setup the heart-beat table to monitor GoldenGate replication lag and provided real-time lag report.

Replicated tables to different instances for load balancing and configured GoldenGate to support 24x7 environment.

Involved in moving databases in Exadata on various versions on half node RAC environments.

Experienced in compressing data in different levels using Exadata.

Created Oracle 12c databases for 2 large departments, from planning and testing through production.

Involved in Installation and configuration of Oracle 11g and 12c RAC using Cluster ware and ASM.

Migrated databases using GG and RMAN for 2 node RAC.

Setup Automatic Storage Management to reduce I/O contention and support RAC databases.

Implemented Disaster Recovery for production database using Dataguard.

Upgradeddatabases from 11gR2 to 12c withDataguardconfiguration.

Created standby databases and involved in convertingPhysical to Snapshot standby and Active Dataguard.

Configured Dataguard Broker and performed Switchover/Failover using Dataguard Broker.

Resolved blocking sessions on Oracle databases and monitored alert logs and applying shipped archive logs to standby databases using Media Recovery Process(MRP).

Performed Backup, Restore and Recovery using RMAN and Flashback.

Used RMAN new feature of 11g and 12c.

Involved in all phases of database development, from needs assessment to QA/QC, design, and support.

Implemented and configured GoldenGate on a 2-node RAC cluster

Configured Automatic Storage Management (ASM) for 11g RAC databases.

ASM Management using RACutilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL.

Migrated Non ASM databases to ASM and Configured ASM disk groups to store Datafiles, redo log files, and control files.

Worked on refreshing Materialized views, creating reverse key indexes and hash partitioning tables

Upgraded Oracle databases from 11g to 12c and applied PSU patches when required.

UsedData pump operations to migrate the data in different levels.

Import/export/refresh data with Datapump, load data for App teams.

Worked with developers in T-SQL programmingin writing complex Queries, stored procedures, Triggers, Functions using T-SQL, MySQL database administration on a largescale MySQL installation.

Client: Employment Security Department, State of Washington, WA Nov 2013- Oct 2015 GoldenGate consultant

Environment: Oracle 11/10g/12c, Data Guard, ASM, Oracle Enterprise Manager Grid Control 10g, 11g/12c GoldenGate, RMAN, Exadata, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, Solaris.

Supported and monitored more than 100 production and development databases using OEM

Provided on-call 24x7 DBA support for production databases.

Provided day to day and on-call Oracle DBA technical support for clients by monitoring database servers, reacting to alerts, providing maintenance reports and other support requirements.

Handled Change Requests of users by troubleshooting Level1 and Level2 tasks as per SLA defined.

Configured GoldenGate components for unidirectional and bidirectional replications and maintained data synchronization.

Monitored and performed Performance Tuning of GoldenGate at database level and GGSCI level, investigated replication failures using Logdump utility.

Planned and implemented cross platformupgrades from 11g to 12c using GoldenGate.

Extensively used GoldenGate during Migration and Troubleshooting issues.

Worked with defgen and Logdump utilities in-order to resolve the issues in GoldenGate.

Implemented security access controls to data: Set up users, assign roles and security profiles, grant permissions, and manage resources, etc.

Proactively identified and mitigated project risks by analyzing gathered statistics.

Planned and Implemented Disaster Recovery (DR) and High Availability using RAC and Dataguard.

Performed installations of Oracle databases. Configured Listeners, create/migrate databases as per client requests. Oracle 11g installations on Linux servers, configuring Listeners and backup Listeners.

Cloned Databases using RMAN and Cold Cloning.

Used Oracle Datapump to export and import database table information.

Extensive experience in RMAN recovery in RAC and standalone database environments.

Worked with Oracle grid control. Oracle databases were under Linux and Unix operating systems.

Used to take the backup of databases using RMAN catalog. The restore capability included the restoring via stored RMAN tapes and using the RMAN database and tablespace restore and / or recover capability of RMAN.

Created Duplicate Database Using RMAN, Strong in Oracle Backup and Recovery.

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

Experience doing Oracle RAC security patches, upgrades and installs.

Applied patches to resolve the Bug issues.

Installed and configured EBS 12.1.3 Validation environment with a 2 node 10g RAC (ASM)

Upgraded EBS 11.5.10 to EBS 12.2.4 and Oracle DB from 10g to 11.2.0.4.

Performed health checks of RAC cluster-ware components OCR, voting files and backups using OCR config and Troubleshooting Issues using Cluster-ware logs in 12C and 11g RACDAT

Experience in shell scripting and a good understanding of the Cron Jobs.

Installed and configured MySQL on Linux and Windows environments.

Effectively configured MySQL Replication as part of HA solution.

Installed, security, and maintenance of Linux based systems including MySQL 5.0.22 configuration.

Hands on upgrading databases from 10g to 11g and from 11g to 12c.

With the help of Datapump operations performed the backup operations of database in different levels.

Copied data from one server to other using SCP and Datapump.

Created SQL Tuning Sets and loading the plans into SQL Plan Management (SPM).

Enhanced performance of databases using various components like ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.

Client: Asea Brown Boveri (ABB) Inc, St. Louis, Missouri. Feb 2012- Oct 2013 Sr. Oracle DBA

Environment: Oracle 11g, 10g, Linux, Solaris, ASM, Data Guard, GoldenGate, RMAN, OEM, TOAD, SQL, RAC.

Extensive knowledge on database administration for Oracle 11g/10g with experience in very large scale database environments and mission critical systems.

Experience in Installation, Configuration and Monitoring of Oracle Server on Linux.

Provided 24x7 support and on call support on rotational basis.

Daily health check of the database using AWR, ADDM reports.

Experience in Oracle GoldenGate installation, configuration and troubleshooting GoldenGate issues.

Used defgen and Logdump utilities to solve the issues in GoldenGate configuration.

Migrated databases from one server to other using GoldenGate configuration.

Configured GoldenGate for Uni-directional replication.

Configured wallet in GoldenGate for security and confidentiality purposes.

Implemented Data guard with maximum availability, protection and performance configurations and worked withSwitchover case and have knowledge in Failover process.

Configured Oracle Dataguard for Disaster Recovery(DR) on standalone databases in 11g.

Configured Snapshot standby database for Real timetesting environment.

Involved in the conversion of Physical to Logical standby database to apply SQLgenerated statements to Standby database in Dataguard configuration.

Configured and Managed Dataguard to implement Physical standby database for DR solutions.

Configured DataguardBroker and performed Switchover processes.

Configured multiplestandby databases for a primary database.

Management of Objects, Schemas, Partitioning the tables and Indexes and administration of RAC and Dataguard databases in Oracle 11g.

Involved in Upgrading OEM from 10g to 11g and 11g to 12c.

Deployed and configured 12c agents in OEM.

Expertise in monitoring, troubleshootingOEM 12C.

Assisted developers in tuningSQL statements in the applications.

Experienced in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate and Dataguard with minimal downtime.

Upgraded databases from 10g to 11g.

Migrated databases from one server to another server using RMAN, Datapump etc.

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

Administrated and Monitored databases of various sizes from 500GB to 15TB.

Applied recommendedPatches to the Production and Test environments.

Migrated the data from one server to other server using Datapump operations.

Experienced in performing Performance tuning using AWR and ASH reports.

Created stored procedures, Functions, Triggers, Cursors and SQL scripts Using SQL Server Management Service(SSMS).

Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing Materialized views, created Partition tables and maintaining index’s.

Installed and Configured Oracle Retail Merchandising System (RMS) 8.0.

Tested and Supported various Oracle RMS applications.

Upgraded current systems from Oracle Retail Merchandising System(RMS) 8.0 to latest version.

Applied PSU Patches in the test environment whenever required.

Client: Broadridge financial solutions, INDIA Jan 2011- Oct 2012 Oracle DBA/ Developer

Environment: ORACLE 9i/10g/11g, Oracle 10g RAC, ASM, Windows 2003, RHEL 4.x, OLTP, Data Warehouse, RMAN, TOAD, SQL*Loader, Datapump, SQL, PL/SQL, Data guard, OEM, Shell Scripting, GoldenGate, Dataguard, OEM Grid Control.

Good experience in Data Migration using traditional export/import and Datapump.

Provided 24x7 on call support on rotational basis.

Proficient in space management, capacity planning, monitoring and management.

Experienced in database migration by designing and implementing database logical and physical storage structures.

Experienced in taking Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. Performed full, incremental and cumulative backups using RMAN.

Extensive knowledge of Oracle Architecture, SGA, PGA, Static and Dynamic views.

Experience in user management which includes creating users, assigning roles and privileges.

Closely worked with Engineering team while InstallingGoldenGate on source and target servers for Replication and implementing load balancing topology.

Configured GoldenGate Parameter files for Extract, Pump and Replicat process for replication.

Monitored and supported more than 50 database instances using scripts and daily health check like alert logs, invalid objects, table spaces usage, long running queries, backups, listener up and running, etc.

Configured and administered ASM instances and worked on troubleshooting ASM related issues.

Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.

Involved in the process of upgrading databases from 10g to 11g.

Involved in building backup and recovery plans for critical databases from failures with minimum downtime.

Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.

Involved in troubleshooting of database using AWR, ASH and ADDM reports for better performances.

Worked on Table partitioning to increase performance.

Responsible for Network configuration and involved in a Client -Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.

Performed Cross Migration and Migration of data using traditional export/import and Datapump.

Client: Canara Bank, INDIA. Jan 2009 - Nov 2010

Jr. Database Administrator

Environment: Oracle 9i/10g, Sun Solaris, windows NT/2000/2003, RMAN, DBCA, Dataguard, Oracle Enterprise.

Provided 16x7 supports for Oracle 9i/10g production databases in UNIX environments.

Granting and monitoring user access rights and privileges through Roles.

Monitoring the table space growth periodically.

Regular monitoring of alert and trace files, database disk usage on the server.

Moving database to archive log mode and no archive log mode.

Altering of system parameters (p-file and sp-file).

Used EXPORT/IMPORT/DATAPUMP to do table/schema level and full database refresh.

Configured Recovery Manager (RMAN) to perform backup, restore, and recovery operations.

Implemented Hot, Cold and Logical backup plans.

Performed Schema and Table level replication using Oracle Streams.

Terminating user locks and user account locks and jobs as per user request.

Migrated the data from one server to the other using traditional export/import.

Creating users, giving privileges to them on particular tables etc. And maintaining tablespace sizes.

Altering the databases from archive log mode to no archive log mode and vice versa depending on requirement.

Applied interim Patches every quarterly in the test environments.

Education Qualification

Bachelor of Technology in Computer Science, Jawaharlal Nehru Technological University.

Contact this candidate