Maheswara Reddy

Oracle Database Adminstrator

919-***-****

ac2kaw@r.postjobfree.com

Professional Summary:

Over all 11+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.

Provided 24x7 support for mission critical projects as a production support DBA and specialist role of database administrator.

Experience in managing very large databases in data warehousing environment.

Experience in Microsoft DBA and Sybase DBA.

Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database.

Excellent experience in Installing, Configuring, Up-gradation, Patches Oracle 8.1.x/9.x/10g/11g/12C on Operating Systems such as Sun Solaris, AIX, HP-UX, Red Hat, Linux, and Windows. Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.

Installed Oracle 12c, 11g ASM & 10g RAC software with ASM & OCFS2 File systems and Migrated Non ASM database to ASM databases and ASM database to Non ASM database.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11gr2 RAC environment.

Experience in using OEM12c (Oracle Enterprise Manager) and OEM agents for Managing and Monitoring Databases.

Expertise in RMAN database backup and recovery to tapes and disk in catalog and no catlog mode.

Proficient in setting up Standby Database by RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported. Expertise in sync of standby databases when it is out of sync with production database.

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY and Strong knowledge of PL/ SQL and SQL

Configured DDL Replication in Golden Gate to enable DDL Synchronization and Troubleshooting Golden Gate issues.

Managing exadata compute nodes and cell nodes and frequently dealt with disk replacement failures completely transparent to end users via the ASR (Automatic service Request) set up.

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

Improve the Performance of SQL statements by using SQL_PROFILES and SQL_BASELINES and Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.

Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery,configuration datagurd broker and Implemented Fast Start Fail over (FSFO) to initiate failover .Doing switchover over by DGMGRL for annual test and if needed

Expertise in creating Users, Roles and Profiles and Privilege management with role-based security.

Technical Skills

RDBMS: Oracle 8i/9i/10g/11g, 12c, SQL Server 2005/2008.

Operating Systems: UNIX, Solaris, Linux, AIX, HP-UX 10.2/11.10/11.20, LINUX, Windows NT/95/98/2000/XP

Languages: PL/SQL, Shell Programming, C, C++, C#, PHP, HTML, XML, JavaScript, Batch Programming.

Utilities: SQL*Plus, SQL* Loader, EXPDP/IMPDP, RMAN, Export /Import, TKPROF, STATSPACK, OPATCH

Tools: SQL Developer, Oracle Enterprise Manager, Toad, Putty, Hummingbird 10, Erwin, Oracle Database Upgrade Assistant. ADDM, OEM12c, ADF, BC4J, ADF.

Education: Bachelor of Science (Bsc Computers) from Kakatiya University–India.

Certifications:

Oracle Certified Associate (OCA) in Oracle 11g Database Administration.

Professional Experience:

Citigroup, Irving, TX June '16 - Till Date

Oracle database administrator & Developer

Responsibilities:

Working as database specialist role in current project, taking care of all performance issues, and fixing them without missing SLA.

Responsible and Single Point of Contact for all kind of issues, incidents, problems and escalations that interrupts the Customer’s IT Services.

Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQLNavigator.

Generated server side PL/SQL scripts for data manipulation and validation for remote instances.

Involved in creating Unix Shell Scripting. Defragmentation of Tables, Partitioning, compressing and Indexes for improved performance and efficiency.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DBMS_SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for front end module.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in System Development Life Cycle.

Used principles of Normalization to improve the performance.

Involved in ETL code using PL/SQL in order to meet requirements for Extract, Transformation, Cleaning and Loading of data from source to target data structures.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for the Production databases.

Create and Configure new 12c pluggable databases (PDB’s) using DBCA.

Upgraded 11g Databases to 12c databases.

Migrated Non-Container databases to Pluggable databases.

Configure Instance Parameters and Modify Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1.

Convert database from non-pluggable database to pluggable database.

Installed OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.

Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.

Experience in patching RAC databases in rolling fashion to maintain high availability.

Configured Data Guard broker to manage standby databases for switchover and failover operations.

Implemented Data Guard Fast Start Fail over (FSFO) to initiate failover to the standby site.

Configured DDL Replication in GoldenGate to enable DDL Synchronization.

Troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility.

Improved performance of GoldenGate Replicat using Range & BatchSQL Parameters.

Configure and build heartbeat monitoring in GoldenGate.

Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

Checking the Heath Condition of Exadata X5 machines by Exacheck and Sundiag Utilities.

Used Exadata Hybrid Columnar Compression for a very Large Tables greater than 2 TB.

Monitoring the Exadata InfiniBand Switches/ports, DB/CELL nodes and IB topology through ILOM and OEM 12c.

Expertise in ESS patching and database BP/QDPE patches.

Administration of Exadata Storage cells.

CRS related issues in Exadata, ASM related issues in Exadata, Configuring DBFS in Exadata

Handling issues such as RDS ping, Kernel Issue and Grub configuration, ILOM Issues.

Exadata Patching using patchmgr, Grid /RDBMS Patching in Exadata.

Responsible for ASM diskgroup management and capacity planning and management.

Administration and monitoring of Exadata components through ILOMs.

Patch Management including CPU patches and interim patches

Configured and setup complex bi-directional topology based replication using GoldenGate Replication.

Diagnosed and resolved extract, replicate and network issues during golden gate replication.

Improved performance of GoldenGate Replicat using BatchSQL &Range Parameters.

Configure and build heartbeat monitoring in GoldenGate.

Developed monitoring scripts to monitor GoldenGate and report issues proactively.

Used Logdump utility to troubleshoot and fix Goldengate replication issues by analyzing Golden gate trail files.

Train client personals, reviewing GoldenGate reports and spend majority of time analyzing GGS error logs and troubleshooting.

Implementing Oracle GoldenGate in Oracle RAC environments (Source database).

Fine tuning existing GoldenGate processes with method of adding GoldenGate Parallel processing, Acceptation handling & adding heartbeat process to maintain lag reporting.

Designed implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle Goldengate product suite.

Upgraded Goldengate version from 12.1 to 12.2 release.

Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components.

Setting up the GoldenGate monitoring using OEM 12c / OEM 12c.

Install Oracle GoldenGate Veridata.

Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances.

Encrypting database user passwords by using USERIDALIAS.

Implement a Heartbeat mechanism for the GoldenGate replication.

Configured DDL Replication in GoldenGate to enable DDL Synchronization.

Troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility.

Environment: Oracle 11g, TOAD, ASM, RAC, TOAD, OEM12c.

UMB Bank, Kansas City, MO May '15 – June’16

Sr. Oracle DBA

Description: UMB bank is the consumer division of UMB Financial Corporation. UMB bank was founded in 1913 as the Storefront bank in Kansas City, Missouri. The project involved supporting critical banking applications, which use oracle 11gR2, and 12c databases.

Responsibilities:

Setup Oracle database 11g RAC & 12c Databases using Oracle Clusterware for achieving high Availability.

Performed Active duplication of databases and user-managed (hot/cold) backups through RMAN.

Migration of databases to Oracle 11g from Oracle 10g on AIX to Linux using RMAN.

Installed oracle 11g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Migrating databases to Oracle Exadata Database X4 Machine.

Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)

Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.

Installed GoldenGate Veridata and Repository Schema to monitor GoldenGate replication.

Configuring Domain for GoldenGate Veridata, and configuring agent.

Successfully configured and installed Oracle GoldenGate for Schema/Table replication.

Setting up CDC replication as active to passive & bi-directional topology for high availability active standby in data recovery scenario.

Upgraded Goldengate version from 12.1 to 12.2 release.

Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components for Goldengate.

Performed GG Extract and Replicat ETROLLOVER in cases when needed recovery due to loss of Trail files.

Setup and managed Bounded Recovery interval to manage Long running transactions.

Experience in Installing oracle 11g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.

Configured high availability services Load balancing and SCAN features for clustered databases.

Setup Oracle Audit Vault and Database Firewall for monitoring and blocking SQL statements according to the company standard policies.

Experience in setting up Oracle Database Vault for restricting access to special record for administrative users as a standard to SOX Compliance.

Experience in Enabling and Disabling Oracle Database Vault.

Used Oracle’s Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.

Enabled Fine-Grained auditing at the Object level & specific DML Operations.

Helping other DBAs in RAC, standalone installation of databases with ASM.

Performed cross Platform 11g database Migrations from AIX to linux platforms.

Performed Point-In-Time Recovery of the database using RMAN.

Worked on Data migration from SQL databases to Oracle Databases through MS-Access.

Provided 24x7 Support for Production/Development databases.

Performance tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components.

Environment: ORACLE 10/11g, 12C SQL SERVER, AIX 5, HP-UX 11, SLES 11, RHEL (Red Hat Enterprise Linux)6, SQL, PLSQL, RMAN, TOAD, OEM GRID, DATAGUARD, Golden Gate.

JP Morgan Chase, Parsippany, NJ Sep’14– Apr’15

Sr Oracle DBA

Description: JPMorgan Chase & Co. is an American multinational banking and financial services holding company headquartered in New York City. It is the largest bank in the United States, and the world's sixth largest bank by total assets. The project involved supporting critical banking applications, which use oracle 11gR2 databases.

Responsibilities:

Supported as 24X7 production/development DBA to 25+ databases on 10 different servers with 2 TB in size.

Installation and configuration of Oracle Database Software 11gR2.

Implemented ASM on RAC. Managing disks and disk groups with ASM.

Performed migration from 10.2.0.4 to 11.2.0.4 for large databases up to 7.5 TB.

Installed and Configured 3 Node 11gR2 RAC on Red Hat Linux and added 2 Node to make it a 5 Node RAC.

Tons of experience in installation, configuration, troubleshooting RAC environments.

Involved in the project implementing and configuring Real Application Clusters (RAC) on Oracle 11g on different nodes using ASM.

Experience in setting up Oracle Database Vault for restricting access to special record for administrative users as a standard to SOX Compliance.

Enabling and disabling Oracle Database Vault.

Performed Cloning for Oracle 11g databases to transport it to different machine, from development to testing environment applied patches using Opatch when required.

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

Migrating single Instance Databases to 2 Node RAC environments using Rconfig.

Built physical standby databases for RAC and standalone databases on Linux and UNIX platforms.

Load balancing of RAC instances.

Monitoring and administration of databases through OEM12c Cloud control 12.1.0.3.

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

Upgrading database from Oracle version 9i and 10g to 11g and migration of data.

Installation, Configuration and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).

Performance report and subsequent tuning, monitoring of production database.

Setting up Physical Standby Database environment using Dataguard in /11g in Max Availability Mode.

Responsible for providing DBA support for multiple SAP large databases in production, development and test environments.

Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.

Environment: Oracle 11g/10g/,RAC, AIX 6.1, OEM Grid Control, LDAP, RMAN, TkPROF, LDAP, RHEL (Red Hat Enterprise Linux) v5.8.

GE Capital, Stamford, CT Dec’13– Aug’14

Sr Oracle DBA

Description: GE Capital is a subsidiary of General Electric headquartered in Norwalk, Connecticut. GE Capital is one of the world’s largest providers of credit. GE Capital focuses primarily on loans and leases that it underwrites to hold on its own balance sheet rather than on generating fees by originating loans and leases, then selling them to third parties.

Responsibilities:

Responsible for providing DBA support for multiple SAP large databases in production, development and test environments.

Part of a 5-member DBA team managing 450+ production/QA/Development instances with databases sizes varying from few GB's to 75 TB's.

Developed UNIX shell script to automate the process of RMAN backups using RMAN Catalog.

Developed SQL Scripts to perform database checks.

Manage Oracle 11g/10g RAC databases of size 500g to 8TB.

Installed, configured, add, remove nodes in RAC environment and migrated single instances to RAC environment and performed RAC administration.

Involved in designing of disaster recovery using Data Guard, High Availability using 10g RAC

Adjusting Optimizer settings for improve SQL performance.

Role transition (Switchover/Failover) in Data guard.

Experience in upgrading the old OEM agents to the new OEM 12c agents and configuring different targets in 12c cloud control.

Created and setup rulesets for in OEM12c for user-defined metrics.

Worked on setting up Active directory based authentication in OEM 12c for determining the User Identity Access to enterprise manager cloud control.

Enabled Fine-Grained auditing at the Object level & specific DML Operations.

Used Data masking Pack as a security feature to secure the production environment data in other Non-Prod environment.

Involved in POC for DB Installation and configuration 11gR2 on Linux VM Environment’s.

Experience with Automatic Storage management implementation and also analyzing different problems including CSS related issues.

Adding, deleting and creating different ASM disk groups.

Performance analysis using AWR/ASH/ADDM reports and wait event analysis.

Manage Oracle 11gR2 RAC database varying from 2-6 nodes.

Administered 10g/11g Real Application Clusters (RAC) system on Linux x86-64 bit systems on ASM storage environments.

Involved in maintenance tasks like bouncing production databases and changing log modes of DB.

Test and Implemented NetApp Snap Manager for Oracle solution for configuring Backup & Restore for DB versions from 10.2.0.4, 11.1.0.7 and 11.2.0.2.

Installed Oracle 11gR1 & 11gR2 database for developers to test applications.

Performed regular Database Administration activities which involved - Database

Upgrades from 10g to 11gR1 and 11gR2. Installation of Oracle Software, Cloning Databases, Database Reorg and Backup and Recovery.

Environment: Oracle 11g/10g/ AIX, HP-UX,HP 9000, Windows NT 4.0, OEM Grid Control, LDAP, RMAN, TkPROF, LDAP, RHEL (Red Hat Enterprise Linux) v4.5.

Xerox Inc, Atlanta, GA Dec’12 – Nov’13 Oracle DBA

Description : Xerox Corporation is an American global corporation that sells business services and document technology products founded in 1906. Xerox is head-quartered in Norwalk, Connecticut.

Responsibilities:

Involved in 24x7 support for 800GB 2 Node production RAC database with on-call pager.

Installation and creation of 9i and 10g databases for Testing, Development and Production.

Installation of Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11.

Creating and Managing Tablespaces with different block-sizes to prevent row chaining.

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.

Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.

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

Developing and Implementing Disaster Recovery (DR) Plan.

Setup of Standby Database using Data guard for faster Disaster Recovery.

Upgrade and Migration of Database from 9.2.0.6 to 11.2.0.2 and applying patches whenever required.

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

Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Monitoring and Troubleshooting of Database Replication issues.

Performance tuning of Oracle Database Objects by fixing row chaining.

Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup.

Written shell scripts for digitization the process.

Handling Database storage.

Scheduling jobs through Oracle Job Scheduler.

SQL Tunings for Performance of Objects.

OS level activities like space monitoring of Mount point.

Reading Alert Log and User trace Files and Diagnosing the Problem.

Automation of Startup Shutdown on all Production and Development Database.

Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.

Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.

Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Installation and configuration of Oracle Client software and Tools.

Automated the process of analyzing tables every night.

Write SQL scripts to monitor tablespace and extent growth.

Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Space Management which includes table space creation, adding new datafiles.

Environment: Oracle database 10g (10.1.0.5 to 10.2.0.4), 9i (9.2.0.8), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Wipro Technologies, Chennai, India Feb’11 – Nov’12 Oracle DBA

Responsibilities:

24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Migration of Oracle databases from windows to Linux.

Applied patches to Oracle Databases and Oracle Applications.

Upgrading development and production databases to Oracle 10g.

Proactive database monitoring using 10g grid monitoring tool.

Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.

Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Performed database cloning to setup test and development databases.

Responsible for optimizing the queries and application tuning.

Performed SQL tuning and assist developers with coding PL/SQL.

Provided support to Application Database Administrators in designing the database.

Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.

Management of schemas, objects partitioning the tables & indexes.

Automation of data load using Korn shell scripting and SQL*Loader.

Responsible for setting and managing user accounts, and granting required privileges to users.

Performed other DBA activities like including space management and performance monitoring.

Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Environment: Oracle 10g/9i, SQL Server 2000, Sun Solaris 8.0, SUN SPARC, HP UNIX, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Sixgen, Hyderabad, India Sep’ 06 – Dec’10 Oracle DBA

Responsibilities:

Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.

Reconfigured the existing physical database layout, increasing the performance of the complete system by 20%, including better use of the hard disk space.

Installed, maintained new oracle 9i and 8i instances. Upgraded several Oracle 9i instances from 8i.

Connectivity with different client programs using ODBC.

Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.

Modified Korn shell scripts as per technical specifications.

Prepared Data Flow Diagrams for existing PL/SQL code.

Involved in coding of data extraction scripts as per technical specifications.

Analyzed the table structures using Analyze command.

Involvement in all phases of the project life cycle.

Maintained backups for recovery using RMAN in tapes and disks.

Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.

Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.

Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities.

Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.

Modified and maintained database structures and views for the core system.

Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures.

Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.

Implemented automated backup strategy using the UNIX shell script and CRON Utility.

Cloned database for development needs.

Worked as Production Support for Oracle based systems and UNIX based Server environments.

Creating users and database links, snap shots on production and development servers.

Designed database tables as per technical specifications.

Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 8.1.7/9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.

Contact this candidate