Ramesh Otturu

704-***-****/ ad2e33@r.postjobfree.com/ (Public Trust Clearence)

www.linkedin.com/in/rameshh96/

Summary:

Over 10+ years of experience as an Oracle Database Administrator on 19c, 12c, 11g, 10g database versions with RAC, ASM, Data Guard, Golden Gate and Grid Control experience

Proficient in database administration, installation, configuration, upgrades, patches performance tuning, backup and recovery, cloning, space management, troubleshooting, physical and logical database design.

RAC:

Hands on experience in Oracle 10g/11g/12c/19c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).

Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.

Experience in Installation and administrations of Oracle 10g RAC, 11g RAC.

Golden gate & Dataguard:

Overall, 6 years’ experience in using Golden Gate to installation, configuration, support data replication monitoring, tuning and capacity planning.

Experience in setting up oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data reflection with conflict detection and resolutions

Implemented and configured Data Guard setup with Primary and Standby Databases

Experience in Configured and maintained physical standby databases using Oracle DATAGUARD to perform quick disaster recovery.

Deep understanding oracle GoldenGate internal mechanism, OGG new features such as integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate.

Implement Oracle Streams for Replication between RAC nodes. Troubleshoot various Streams conflict resolutions and data issues sync issues.

Performance Tuning:

Worked on Performance optimization of large objects (LOB, BLOB, CLOB) by monitoring redoes generation, increasing log buffer size, blocksize and changing archiving procedures and Query tuning using Statspack, Tkprof and OEM.

Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better performance.

RMAN:

Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).

Experience in taking backup and performing recovery.

Experience in performing point in time recovery at times of necessity.

Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.

Migration & DataPump:

Migrated DB2/MYSQL databases to Oracle 10G (R2) version using data migration tools such as DB Artisan, Oracle Developer, SQL Loader and Toad.

Experience in Migration of Database from 9i to 10g, 10g to 11g.

Good experience in resolving the issues related to installation, upgrades and patches.

Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.

Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.

Expertise in creating and scheduling jobs through OEM.

Performed Export/Import through Data Pump.

Build Grid control for Monitoring 40+ database.

Provided technical troubleshooting and give consultation to development teams.

Performed Database Refreshes and Database Copies for Development, Test and Production databases.

Implemented basic replication through Materialized Views.

Expertise in cross platform data migrations using Transportable Table spaces.

Excellent Troubleshooting skills in OS level and Database level.

Experienced in using 10g features like Flash-Back Recovery Area (FRA)

SQL, Script & Oracle Database

Written KORN shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling.

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

Expertise in SQL, PL/SQL, and developing various Data Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.

Proficient in SQL, PL/SQL, Perl Scripting, Shell Scripting, Erwin Data modeling, Oracle Data Dictionary – meta data, Logical and Physical Database Design.

Has good experience in SQL Server Clustering and MSSQL Server 2000/2005 Log Shipping, Database Mirroring.

Technology:

Operating Systems

HP-UX 10.x/11.x, AIX 4.3x/5.1/5.2, WINDOWS NT/2000/2003 Server, Red HAT Linux 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10

RDBMS

Oracle Server 10g/11gR2/12c/19c, MySQL, SQL Server 200.2005

DB Management

TOAD 7.6/7.5, OEM 9.2/10g (10.1/10.2), Grid control (RAC), TOAD, Tortoise, ERWIN

Programming

SQL, PL/SQL, C, C++, UNIX shell scripting, PERL, Bourne, Korn, AWK-SED, PHP, JavaScript, HTML

Tuning/Monitoring

TKPROF, EXPLAIN PLAN, STATSPACK.

Replication

DataGuard, Goldengate, Streams 11g

PROFESSIONAL EXPERIENCE

USDA (United States Department of Agriculture) KS August 2016 – Present

Sr. Oracle DBA

Responsibilities:

Part of a 4 members DBA team which was involved in the maintenance of the Oracle 10g/11g/12c/19c database for the Production as well as the development environments. Managing, troubleshooting and resolving oracle database, RAC and applications issues.

Performed database upgrades from 12c (12.2.0.0) to 19c (19.8.0.0.0)

Installed and configured 19c databases on standalone server

Upgraded Oracle Cluster ware from 10g/11gR1 to 11gR2 (11.2.0.x) and also to 12.1.0.x (12CR1/R2)

Performed database upgrades from 11gR1/11gR2 to 12CR1(12.1.0.x)

Installed/Upgrade and configured Oracle Grid Control 12cR1/R2/R5

Oracle Golden gate installation, upgrades, Patching, High Availability (HA), configuration, troubleshooting GG issues.

Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

Implemented Golden Gate for replication and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.

Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.

Experience in configuring Golden Gate director for alerts monitoring.

Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.

Setting up high availability oracle GoldenGate (OGG)systems on oracle 11Gr2 RAC environments

Oracle Installation/Migration of various versions from 10g and 11g.

Conducted migration across various platforms like Sybase to oracle and SQL server to Oracle

Supported Business, Post go-live by Cloning/refreshing Production to DEV, UAT, TEST and PREPROD Database instances, for testing at Scheduled intervals.

Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

Monitoring Scheduled jobs of the daily activities for the performance of all the databases.

Implement Hot, Cold and Logical backup plans

Designed backup and recovery procedures for Data ware system

Generated scripts for daily maintenance activity like analyzing the tables/indexes and monitoring their growth rate

Data loads using SQL loader

Experience in space management

Experience in schema management and monitoring alert log of various databases

Automation of startup shutdown on all production and development databases

Configured the Hardware to install the Sun Solaris

Created multiple database instances for HA environment. Applied the updated latest patches to oracle and Sun Solaris

Partitioning Tables by determining the suitable methodology to improve performance and manageability.

Applied patches, keeping applications software bug free and improving data integrity

Checking Alert logs, Archive logs, and Trace files

Creating and managing users, roles and profiles, auditing and monitoring databases and user access

Activities like applying RDBMS patches, security patches, proactive monitoring of databases

Knowledge of using EXP and IMP utilities

Troubleshooting DB related issues and providing scripts for taking regular backups

Estimated current and future requirements in terms of storage and other resources including capacity planning

Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.

Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 10g/11g/12c and 19c

Strong experience in installing and administering Oracle database using tools OEM, TOAD

Experience in Implementing and configuring 10g OEM Grid Control.

Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.

Conducting sizing and capacity planning for Oracle databases.

Designing the logical and physical database structure and upgraded development and test databases to Oracle 11g.

Cloned/ Refreshed Oracle Databases and Oracle Applications for development and testing.

Oracle RMAN configuration for backups to disk and tape. Implemented Backup & Recovery strategies and performed Disaster & Recovery drills

Data Loading using SQL*Loader, External Tables. Writing PL/SQL procedures for Extraction Transformation and Loading (ETL) data

Proficient in SQL, PL/SQL, Perl Scripting, Shell Scripting, Erwin Data modeling, Oracle Data Dictionary – meta data, Logical and Physical Database Design.

Optimizing the SQLs for maximum performance EXPLAIN PLAN

Creating SR (Oracle Support request), follow up with Oracle support, running diagnostic scripts and upload output files to oracle support

Implemented Golden Gate for Standby Configuration and developed procedures for Replication.

Logical backups were scheduled for Development, QA and UAT databases using export/import and Data Pump.

Performed documentation for Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation.

Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.

Expertise in Job Scheduling environments like AutoSys & Cronjobs

Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.

Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.

Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.

Implemented Backup and recovery strategies using export/import, RMAN and online backups.

Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring, for custom scripts troubleshooting using SQLTRACE utilities

Automated several scripts to monitor various processes, sessions and taking back up’s using crontab.

Analyzed the user requirements and designed partitioned tables for improving performance.

Performing the daily Maintenance tasks and interacting with Oracle Customer service when required.

Used Oracle Streams for Basic and Advanced Data Replication between oracle database servers.

Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.

Used oracle 10g Data pump and export/import for data migration.

Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT.

Refresh databases from Prod to Test and Dev environments for Application testing using RMAN.

Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.).

Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.

Actively supported database maintenance needs by creating and dropping of users, granting and revoking rights as and when required.

Experienced with all kinds (Status, Performance, Trend Analysis) of DB MONITORING.

Experienced with SRVCTL for monitoring and configuring RAC Environment.

Working alongside programmers and contributing to the development process; Enabling and analyzing trace files.

Environment: Oracle 11g RAC/10g RAC/9i, Sun Solaris, HP-UX, IBM AIX, Red Hat Linux, Windows, OEM (Grid Control), RMAN, ASM, SQL*Loader, Oracle Data guard, Streams, Golden Gate, TOAD, Informatica PowerCenter 8.1, Autosys

Wells Fargo, Charlotte NC Feb 2015 – July 2016

Sr Oracle DBA

Responsibilities:

Installed, configured & maintained Oracle 10g RELEASE2 RAC on Red Hat Linux 4.0.

Oracle Data Guard for maintained oracle disaster recovery and OEM for database monitoring, performance and diagnostics are been configured.

Monitored and Tuned database to optimize the performance and satisfy the availability.

Installing new software releases, upgrades, evaluates and installs patches and resolves software related problems.

Performance Tuning by using Oracle utilities like Stats Pack, Tkprof for addressing performance bottlenecks are performed.

Taken Backup & Recovery by using RMAN.

Analyzed and monitored that data got by ADDM performed logical database using Export utility

Created, tested OID entries & APS implementation on different platforms

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

We taken Export and import of different databases using Oracle DATA PUMP Export / Import utilities.

Table fragmentation tuning, partitioning the large table by date.

Used Materialized Views for Replication and synchronization data with other branches.

Provided all kinds of DBA support to development teams as well as production support to various tasks.

Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.

Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, Tkprof, TOAD and Oracle Enterprise Manager

Trouble shooting and resolving any database and/or application issues or errors that occurred

Performed database tuning by using various tools, like Oracle Enterprise Manager and STATSPACK

Developing shell scripts and using various tools monitored the various database activities.

Utilizing OEM SQL Analyze, OEM performance manager, STATPACK, SQL Trace, TKPROF etc.

Utilized OEM Replication Management Tool to share data between multiple sites.

Opatch is used for Patched Oracle Database Server 9i and 10g.

Established database backup/recovery strategy for different databases

Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.

WE Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.

Performed daily alert log files, trace files check, and general data consistency & data integrity check.

Developed scripts to monitor the storage usage, object status for daily job.

Oracle support and Metal ink are utilized to troubleshoot the problems and issues.

On-call supports regarding production-related database problems are performed.

Environment: Sun STOREDGE 6140, 6130, 3500, Red Hat Linux x86, OID EMC Storage, VERITAS Net backup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, SUN SPARC, Dell Power edge, 11g OPS center.

Accenture Federal (Healthcare.gov), Reston VA Aug 2014 – Jan 2015

Sr Oracle DBA

24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues during Pre & Post GO-LIVE period. Daily Health Check Up of the Database.

Installation and creation of 10g and 11g databases in Dev/Test environment.

RAC: Installation, Configuration and Administration of Oracle 11g RAC.

In depth knowledge of Oracle 11g RAC, RAC internals and RAC tuning.

Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing.

Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Structures

Knowledge of the Oracle Golden Gate installation, configuration. Proficiency using Oracle Golden Gate replication monitoring, tuning and capacity planning.

Performed bi-directional replication from source to target Database using Golden Gate.

Participate in disaster recovery exercises using Oracle DataGuard technologies including Fail-over and Switch-over operations.

Proficient with 11g new features: Active DataGuard, configuring Snapshot standby database.

Upgrading production and development databases to Oracle 11g.

Applied patches to Oracle Databases and Oracle Applications.

Migrating databases from existing 10g environment to the Oracle Database Appliance (ODA).

Environment: Oracle 10g, 9i, RAC, Red Hat Enterprise Linux, OEM, Explain Plan, SQL Trace, Tkprof, STATSPACK, PERL & Korn Scripting, Metalink, Opatch, PL/SQL, Data Pump, Replication Management Tool.

Wells Fargo, Charlotte NC May 2013 – July 2014

Sr Oracle DBA

Responsibilities:

24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Installation and creation of 10g R2 databases for Testing, Development and Production

Upgrading to new versions, co-coordinating with hardware changes and applying database patches.

Installed, configured and maintained 11g R2RACdatabase (2 node instances) with ASM on LINUX platform

Installed and Maintained 10g R2 RAC using ASM cluster file system on Oracle Enterprise Linux 5 with oracle Clusterware

Efficiently managed disks by using Automatic Storage Management

Configuring Oracle 10g R2 Data Guard Physical Standby to ensure high availability, data protection and disaster recovery for enterprise data

Worked on Oracle’s data protection solution, Data guard, to detect and stop the corrupted data propagation to the target systems

Implemented schema replication using Oracle streams

Implemented Physical and Logical standby database and schema replication using Oracle streams

Installed and configured OEM Grid control and intensively used Diagnostic&tuning packs along with AWR & ADDM reports

Backup plan designing and implementation using RMAN backup technology

Worked extensively on Oracle 10g R2 RMAN cloning for promoting data to lower environments from production.

Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding

Work as the subject matter expert in the matters of performance issues, major reorganizations, auditing the required down times and the effect on the business applications between the developers, System Administrators and the end clients

Re-organizing the database architecture to work efficiently and for better response time.

Installed and configured Oracle RDBMS on UNIX and Solaris environments

Developed PL/SQL packages, stored procedures, functions, Cursors, triggers

Developed strategy to protect highly sensitive T012 data

Managing table spaces, data files, redo logs, tables and its segments

Installation of Oracle Database and Oracle products.

Creating users and maintaining database security.

Testing of Backup’s and Documenting backup strategies.

Writing UNIX shell scripts for backup and recovery.

System tuning for better performance.

Converting flat files, non-Oracle files which come from Mainframes systems into Oracle database by using SQL*Loader

Writing SQL, PL/SQL Coding database triggers, packages, stored procedures & functions

Managing Users, Privileges and Roles

Coordination with developers in designing complex queries

Help users in creating database objects, and enrolling users

Prepare and maintained documents of database backup and Oracle database operations.

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

Applied High priority, security patches downloaded from Metalink

Creating stored procedures, packages and database triggers.

Writing SQL Loader control files for data loading.

Start up and shut down databases, to check for locks, monitor and kill user sessions, monitor database performance and other day-to-day tasks.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, STATSPACK, TKPROF, UTL_SMTP, EMC ERWIN, SQL*LOADER

EDUCATION

Master of Science (MS) (August 2010 – Dec 2012)

University of North Carolina at Charlotte, NC

Bachelor of Technology (July 2006 - May 2010)

Sri Venkateswara University, India

Contact this candidate