Manager Oracle

Vijay Reddy Kunduru

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

Ph: 917-***-****

PROFESSIONAL SUMMARY

* ***** ** ****** ******** Administration has scaled my experience in providing Analysis, Designing, Development, Installation, Testing, Maintenance, Migration and Client Support for oracle databases which included understanding the requirements for Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Tuning, AWS, RAC, Data Guard, Golden Gate and Enterprise Manager.

Expert with planning, creation, administration and troubleshooting of Oracle 12c/11g/10g OLTP (multiple instances)/OLAP databases.

Extensive knowledge on database administration for Oracle 12c, 11g, 10g very large-scale database environments and mission critical large OLTP systems in a variety of environments like Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL and Windows.

Extensive experience in Amazon AWS cloud infrastructure with particular reference to provisioning, security, and management.

Experience in installation and configuration of Oracle Database on AWS instance, creating roles and implementing security groups for Inbound/Outbound access.

Experience in migrating on premise databases to AWS RDS instance using DMS (Database Migration Service) and Data Pump.

Experience in setup and configuration of Flyway tool for Oracle, PostgreSQL and Sybase databases.

24*7 on-call production database support and maintenance including remote database support.

Installed and configured OEM 12C cloud control and set up Incident Rule sets and Email notifications for events & incidents.

Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle client, Grid Control, Cloud Control, Oracle Enterprise Manager (OEM) in various versions.

Working experience with an Agile, Scrum methodology to ensure delivery of high quality work with every monthly iteration.

Experience working with Delphix software and Jet Stream UI in refreshing production databases to virtual databases for testing.

Supported database migrations in DevOps environment using SVN, Git repositories, automated build tools like Jenkins, Nexus, iCART and database deployment tool Flyway.

Manage, deploy, and install Oracle Golden Gate in Uni-directional and Bi-directional modes.

Have hands on experience in Oracle 11g 2 Node RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, Backup and Recovery).

Added a new node to existing cluster for minimizing the downtime, maximizing availability and also achieved load balancing by minimizing the interconnect traffic.

Experience in Capacity Planning, Undo segments and Health check reviews in RAC.

Migrated single Instance database to RAC Environment and NON-ASM databases to ASM using RMAN.

Experienced with Golden Gate 12c installation and configuration and creation of Golden Gate parameter files for data transformation.

Performed Schema as well as Table Level Replication using Oracle Golden-Gate and also did set up Disaster Recovery solution using Golden-Gate.

Experience on Data Replication using Snapshot, Materialized views, Export/Imports.

Extensive experience with Database Cloning and Refreshing lower environment databases with prod databases.

Experience in MySQL Server Installation, Configuration and upgrading, Performance Tuning, Query Optimization and Supported backend SQL on Linux.

Have implemented replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for high availability.

Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.

Effectively configured MySQL Replication as part of HA solution.

Installation and configuration of RMAN with and without Recovery Catalog.

Implementation of Flashback Technology.

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

Extensive experience in Oracle Upgrades, Critical Patch Updates (CPU), Patch Set Updates (PSU) and other oracle patches.

Experience with 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.

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

Proficient in INDEX REBUILDING and INDEX TUNING.

Experience in working with loading of huge data from OLTP systems into data warehouse databases.

Proficient in setting up the network connections i.e. setting up Listener and TCP/IP Connection.

Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using OSWatcher, NMON and TOP commands.

Experience working with Database Resource Management

Working experience in creating Materialized views.

Extensively worked on Installation and Maintenance of SQL Server 2014, 2012/2008R2 on Test, Development and Production Environments.

Proficient in writing PL/SQL Procedures, Functions and Triggers, various UNIX Shell Scripting.

Experience using Erwin as a Data Modeling tool.

Expertise in Using Backup Tools like Tivoli Storage, Veritas, Net Backup, Data Domain Boost.

Good understanding of database block corruption.

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

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

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

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

Technical Skills:

Operating Systems

SUSE Linux, HP-UX, Sun Solaris, AIX, Red Hat Linux and Windows

RDBMS

AWS Oracle RDS, Oracle 12c/11g/10g/9i, Oracle 11g/10g RAC, ASM

Tools and Utilities

RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, EMC Data Domain Boost, Erwin, Flyway, Jenkins, SVN, GIT, AutoSys, AWS Management Console, AWS Command Line Interface, Amazon Cloud Watch, Amazon RDS Console, Delphix, Jet Stream.

Languages

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

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQLT, ASH

Terminal Emulation

Putty, Telnet, FTP, Tectia Ssh, WinSCP

EDUCATION: Bachelors in Computer Science from Jawaharlal Nehru Technical University.

Fannie Mae, Herndon, VA Aug 2015 – Till Date

Role: Oracle DBA

Fannie Mae is a leading source of financing for mortgage lenders and provides financial products and services for housing since 1968. Fannie Mae financing makes sustainable homeownership and workforce rental housing a reality for millions of Americans.

Responsibilities:

Primary DBA for 50+ databases of Oracle 12c/11g on SUSE Linux, HP-UX, Sun Solaris and responsible for maintenance, administration and health checkup.

Supported very large critical production databases of 2 to 5 TB in size and also responsible for maintaining OLAP databases of 5 to 10 TB in size.

Installed, configured, and maintained Oracle 12c and 11g R2 on SUSE Linux & Sun Solaris and also Upgraded from Oracle 11g to 12c.

Achieved High Availability, Data Protection and Maximum Performance for production databases by maintaining Physical standby database using Data guard.

Installation and configuration of Oracle Database on AWS instance, created roles and implemented security groups for Inbound/Outbound access.

Applied SCN-based incremental backup to sync standby after loss of Archive logs on primary.

Migrated on premise databases to AWS RDS instance using DMS (Database Migration Service) and Data Pump.

Refreshing production databases to virtual databases for testing using Delphix and Jet Stream.

Setup and configured Flyway tool for Oracle, PostgreSQL and Sybase databases.

Supported database migrations in DevOps environment using SVN, Git repositories, automated build tools like Jenkins, Nexus, iCART and database deployment tool Flyway.

Validate and check-in database changes to repositories like SVN and GIT for automated deployments.

Configured multiple standby databases using RMAN active duplication.

Perform Database tuning and Performance tuning to tune SQL queries and stabilize performance in Production and LEs.

Manage, deploy, and install Oracle Golden Gate in Uni-directional and Bi-directional modes.

Estimate growth (capacity planning) of production databases by detail analysis for future.

Provide guidance and support to development team regarding application design and performance issues.

Migrated Oracle databases from IBM Soft Layer to on-premise.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups and implementing recovery strategies.

Proficient experience in installation of Enterprise Manager Cloud Control 12c in non-interactive mode

Installed Oracle Management Agents (OMS) in silent mode and also experience in configuring EM for high availability and for firewalls.

Performed database refresh from production to QA, development databases and testing environments.

Working experience in configuring AWR Warehouse which consolidates and stores detailed performance data from the AWR.

Provide 24x7 on-call support for production environments.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.

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

Applied specific bug-fixing patches, security patches, and patch sets across all the environments on Standalone databases and databases on VCS hosts.

Worked extensively with Oracle support on the SR requests for bug fixes and other issues.

Worked with an Agile, Scrum methodology to ensure delivery of high quality work with every monthly iteration.

Environment:

Oracle 12c/11g, SUSE Linux, Sun Solaris, AWS, SoftLayer, OEM, ASM, SQL*LOADER, AWR, ADDM, ASH, AutoSys, OSWatcher, SVN, GIT, Jenkins, Flyway, Cloud Watch, Toad, NetBackup, Delphix, Jet Stream.

DTE Energy, Detroit, MI July 2013 – Jun 2015

Role: Oracle DBA

DTE Energy is a diversified energy company involved in the development and management of energy-related businesses and services nationwide which is also the largest electric utility in Michigan and one of the largest in the nation.

Responsibilities:

Installed, configured, and maintained Oracle 12c and 11g R2 on Linux & AIX and also Upgraded from Oracle 10g to 11g.

Setup very large critical production databases of 3 TB in size and supported VLDB’s of 12 TB in size for Data warehouse databases.

Upgradation of Grid Infrastructure and Oracle Databases from 11.2.0.2 to 11.2.0.4 on 3 node RAC environment.

Database Refresh from one version to another version.

Configured EMC Data Domain Boost, which provides advanced integration between backup and enterprise applications replacing Net Backup for AIX & LINUX.

Installation and Configuration of OEM 12C cloud control.

Migration of database from one server to another server.

Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.

Implemented Active Data guard, creating physical standby database in 11g RAC environment for production database.

Experience with Active-Active and Multi-Master Golden Gate configurations and ability to diagnose and understand Golden Gate errors and replication failures.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Migrated non-ASM database to ASM database.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

Used cross platform transportable table space (TTS) to transport table spaces across platforms.

Data Refresh in Test and Integration Databases using Transportable Table spaces.

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

Experience with Oracle Golden Gate installation, configuration, troubleshooting issues.

Performed patching on Oracle Database Server 10g and 11g using OPatch utility.

Daily Health Check Up of the Database using AWR, ADDM.

Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, memory structures, rollback segments, logs and alerts.

Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.

Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.

Experience with MySQL on both Linux and Windows.

MySQL database backup and recovery strategies and Replication and synchronization.

Replication of tables to cross platform and creating Materialized Views.

Configured and implemented Cold/Hot Backups.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.

Performed database cloning using RMAN.

Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.

24*7 on-call production database support and maintenance including remote database support.

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

Developed scripts for transferring data from production server to testing/development servers.

Shell scripting and PL/SQL programming to resolve business problems of various natures.

Managing databases on multiple servers.

Environment:

Oracle 9i/10g/11g/12c, RHEL Linux, OEM, DBUA, RMAN, RAC, ASM, Data Guard, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports.

Cleveland Clinic, Cleveland, OH Apr 2012 – June 2013

Role: Oracle DBA

Cleveland Clinic is a nonprofit multispecialty academic medical center that integrates clinical and hospital care with research and education.

Responsibilities:

Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) 3 Node RAC.

Installation and maintenance of Oracle 10g, 11g Data Guard.

24*7 available for unexpected emergency situations.

Standby database setup via Data guard for Database Disaster Recovery.

Backup and recovery using RMAN.

Provided backup/recovery, problem diagnosis, performance tuning, and database upgrade support.

Installed and configured DATAGAURD for 23 databases on file-system and ASM in production Environment.

Installed 11 STANDALONE servers on ASM, Red hat LINUX.

Migrating single Instance Databases to 3 Node RAC environments.

Providing technical support to Application Support team for performance and database related issues.

Installed and configured 12C Cloud Control.

Involved in migration of databases from HP-UNIX to RHEL.

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

Data Guard using physical standby database, implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.

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

Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.

Database Sizing, Tablespace Management and Rollback Tablespace Management and Security Administration.

Modified and updated the Performance tuning scripts.

Manage users, privileges, profiles and schemas using Grid Control of Oracle Enterprise Manager.

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

Performed Explain Plan analysis for Query Optimization and SQL tuning.

Performed Database and SQL tuning by using various Tools like AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.

Effective Production Support and off-hour support, support handover, offshore co-ordination.

Experience with MySQL on both Linux and Windows.

Data Refresh in Test and Integration Databases using Transportable Table spaces.

Environment:

Oracle 11g/10g/9i, Red Hat Linux, Data Mover, Application Designer, TOAD, RMAN, SQL server, Data Guard, OEM, Grid Control, STATSPACK, AWR, Explain Plan.

Cerner Corporation, Kansas City, MO Jun 2010 – Mar 2012

Role: Oracle DBA

Cerner Corporation is transforming health care by eliminating error, variance and waste for health care providers and consumers around the world. Our solutions optimize processes for health care organizations ranging from single-doctor practices to entire countries, for the pharmaceutical and medical device industries, and for the field of health care as a whole.

Responsibilities:

In charge of maintaining DPH and EPA Production and Development Oracle databases.

Supporting more than 120 production and development databases 10.2.0.4.

24*7 on-call production database support and maintenance including remote database support.

Created and maintained failover logical standby database.

Converted physical Standby to Snapshot standby for reporting process.

Using Automatic Shared Memory Management (ASMM) for optimal use of available SGA memory.

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

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

Installed and configured Oracle Enterprise Manager 10g Grid Control.

Worked on Performance Tuning Oracle DBA (11g &10g) on Solaris 10, AIX 5.2.

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

Installed and upgraded Oracle 10.2.0.1 database to 10.2.0.4.

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

Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica.

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

Tested database performance issues (monitoring and tuning) to ensure database optimization.

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

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

Creation of materialized views and fine-tuned them for better performance.

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

Tuning SQL statements using Explain Plan and STATSPACK.

Created bit-map Indexes for data warehouse databases.

Configured Physical and Logical Standby database for reporting environment.

Implemented database refresh with the hot backup using full export.

Environment:

Oracle 9i, 10g, 11g, RAC on AIX/Linux, RMAN, Data Guard, UNIX Shell Scripting, Quest Performance Analysis, Quest Space Management tool, Tivoli Storage Manager, Toad, PL/SQL Developer, OEM, Windows NT/XP.

Regions Bank, Atlanta, GA Oct 2008 – Apr 2010

Role: Oracle DBA

Regions Financial Corporation was formed in 1971 as First Alabama Bancshares Inc., Alabama’s first multibank holding company. With the combination of three well-respected banks, the holding company began operations with a total of $543 million in assets and 40 banking locations in Birmingham, Huntsville and Montgomery.

Responsibilities:

Installed and configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 10g to 11g.

Maintenance of around 20 databases combined on all the production, development and testing environments.

Install and configured Oracle databases on windows server 2003 and 2008 platform.

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

Implemented Oracle Database 10g Two 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.

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.

Performed automated backups and scheduling using scripting.

Responsible for migration of databases.

Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.

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

Experienced in performing Point in time recovery using RMAN.

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

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

Created indexes to facilitate easy user interface implementation and tuning.

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

Tested database performance issues (monitoring and tuning) to ensure database optimization.

Involved in gathering requirements from end users.

Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

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

Environment:

Oracle 10g/9i, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle 10g RAC, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Contact this candidate