Rama Bathula

937-***-****)

adlcpn@r.postjobfree.com

SUMMARY

Over the last 14 years, I have provided services to companies as a Sr. Database Administrator which enriched my experience in building, implementing and supporting oracle database technologies.

My expertise includes:

Designing and documenting standard processes to implement various Oracle technologies

Adhering to Standards designed for various aspects in database implementations

Installing and configuring Oracle databases to suit business requirements on various UNIX, Linux and Windows platforms

Experience in successfully implementing Multi-Terabyte very large data-warehouse databases

Implementing High Availability using Oracle RAC, Exadata Machines, Data-guard, Golden Gate and Server level HA technologies like HACMP and GPFS

Planning and Implementing Disaster recovery(DR) solutions using Oracle DataGuard

Implementing Backup and Recovery strategy using Oracle Recovery Manager(RMAN) and evaluating recovery procedures

Experience in database upgrades using DBUA and Data Pump from previous versions to latest versions

Experience in Database Migrations & Cloning using RMAN, Transportable Tablespaces(TTS)

Implementing advanced security using transparent data Encryption(TDE)

Implemented Oracle GoldenGate technology in a distributed database environments for cross-site replication

Setup Goldengate Bi-Directional active-active replication across various databases.

Extensive Knowledge in Troubleshooting/debugging Goldengate

Experience in setting up the Veridata and Agents and implementing connections, groups and jobs using the custom procedures

Configuring, Monitoring and maintaining Oracle Streams to replicate databases

Providing support for developers by building lower environments, assisting in schema design and writing efficient SQL

Implementing Oracle grid control 13c, 12c to generate Alerts, Incidents, and Reports, Monitor Databases.

Expertise in database tuning by employing tools like ADDM, AWR, ASH, OEM Console and Unix Tools like Perfstat, OSWatcher etc...

Using Advanced tools like SQL Analyzer, TKPROF to troubleshoot and tune complex SQL statements

Experience in using tools like Swingbench, SIO, and SLOB to evaluate, troubleshoot and benchmark server hardware used for databases

Working experience with Job schedulers like Autosys, Unix CRON, and DBMS_SCHEDULER

Working experience in Backup storage technologies like Veritas NetBackup, IBM TSM and NetApp SnapVault

Collaborated with cross-functional and diverse Infrastructure, networking, database administration, project management, and engineering business units to communicate project updates, insights or solutions/functionality improvements for advancing shared organizational goals.

Having strong analytical, logical, Communication and problem solving skills. Ability to adapt to new technologies by self-learning

Education: M.S. in Engineering

CERTIFICATIONS

Oracle10G Certified (OCP)*

Certified GoldenGate 10 Implementation Specialist

Oracle Autonomous Database Cloud 2019 Specialist

Oracle Cloud Infrastructure 2019 Architect Associate

Oracle Cloud Infrastructure 2019 Cloud Operations Associate

Oracle Cloud Infrastructure 2019 Architect Professional

TECHNICAL SKILLS

Databases

Oracle 19c,18c,12c,11g, 10g, 9i, 8i, SQL Server, DB2, AWS RDS, PostgreSQL

Technologies:

Oracle RAC, ASM, DataGuard, GoldenGate, Streams, Goldengate, Exadata

Application Servers

Oracle WebLogic Apache

Operating Systems

Sun Solaris 8, 9, 10. RHEL 7.x,6.x,5.x HP-UX 11, Windows NT

Scripting

SQL & PL/SQL UNIX Bash, K Shell Perl Python

Tools

Oracle Enterprise Manager (OEM ) 13c, 12c, 11g, 10g, Toad, SVN, Commvault, Net Backup, CHEF, Puppet 3.x, GitHub, Apache Hadoop, BI publisher

Scheduling Tools

Autosys, Crontab

Change Management

Clear Case, Clear Quest, Remedy, HP Service Manager, ServiceNow

SDLC Expertise

System Analysis and Architecture Plan Requirements Analysis Performance Tuning Change Management

PROFESSIONAL EXPERIENCE

CITI – Minnetonka, MN May’17 — Present

Application Support Sr. DBA:

Onboarding training and some Trading application skills

Working with Oracle 19c/18c/12cR2 Standalone, RAC, Standby databases

Currently Supporting Database with Trading Activity

Setting up new databases environments as per the Application and Enterprise requirements.

Upgrade & Migrate Critical Production databases from 11g to 12c/18c/19c standalone and RAC databases

Coordinate with UNIX, San and Networking teams for OS upgrade, San storage migrations and network upgrades

Applying latest patches to GI, RAC, standalone database

Working with Query performance issues within database

Monitoring and fixing any issue that are alerted using OEM 13c

Addressing Issues with respect to Daily Database refresh Jobs

Created custom Users, Groups, Roles, Profiles as per the audit team requirements

Monitoring RMAN Backups and resolve any issues

Performed Explain Plan analysis for Query Optimization and SQL tuning

Deploying scheduled releases and fix Code when required

Secure and monitor connectivity to the database via IP, wallet etc

Maintaining databases environments and look forward to see any other featured that can be employed with in current database Environment

Work close to developers and application team members and address any performance issues facing with database or any queries they are running

Environment: Oracle 19c/18c/12cR2, Oracle 18c/12cR2 RAC, Linux, Oracle wallet, DATAGUARD, RMAN, OEM 13c, Shell Scripting, Incident manager, ServiceNow.

Thomson Reuters – Eagan, MN Nov’11 — Apr’17

Worked With in 3 Different teams during this tenure

Lead Database Engineer:

Lead Dev DBA Responsibilities:

Experience in working with Exadata Machines and Database with GoldenGate environment

Experience Working with Cloud (AWS) environments with respect to Oracle and MYSQL databases

Experience in playing around with 12c databases

Working close to Business and address any issues they are facing with respect to database and resolve the issue by coordinating with respective team

Experience in Moving Database from G8 servers to Exadata machines and configuring DataGuard and Goldengate for complex multisite design

Working with Query performance issues on Exadata, RAC and standalone database

Work close to developers and application team members and address any performance issues facing with database or any queries they are running

Expertise in writing stored procedure and complex PL/SQL

Installation, Configuration and administration of Veridata Server and Agents

Customization of Veridata environment to fit the business rules and get the data in sync

Customized Creation of Connections, Groups and Jobs for schema comparison in a distributed database environments using GoldenGate and/or Streams

Experience in syncing up data to day OOS rows, check root cause and fix the issue using Veridata and some in-house python scripting tool

Design & Engineering Responsibilities:

Implementing Oracle High Availability using Oracle RAC, DataGuard and GoldenGate technologies

Expertise in configuring and managing Bi-directional replication using Streams and GoldenGate in a multi node Oracle RAC cluster environment

Setting up Logical, Active Physical and Snapshot standby databases using DataGuard for HA and DR

Expertise in Database upgrades and migrations by employing DBUA, TTS, Data Pump and GoldenGate.

Advanced knowledge of Linux operating systems and storage sub-systems to troubleshoot performance and availability issues

Working on Exadata machines to copy Huge data from one environment into another using DataPump

Using benchmarking tools like SIO, Swingbench, SLOB to stress test Storage and OS resources to identify performance bottlenecks

Experience in working with OEM 12c and 11g Grid Control for database monitoring and performance tuning

Implemented RMAN backups for a very large data warehouse and thoroughly tested multiple recovery scenarios

Experience in migration oracle streams to Oracle GoldenGate replication

Extensive experience working on Log dump utility in Goldengate.

Zero Downtime migration for mission critical applications.

Expertise in using NetApp SnapVault to backup & recover oracle databases

Effectively working with developers & Business teams in Schema design, providing capacity estimates, and offering suggestions on efficient SQL

Advanced knowledge in tuning SQL with Tracing, Analyzing Plans, SQL Advisors etc.

Troubleshoot the database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)

Effectively communicating in a highly process oriented work environment to resolve critical issues rapidly and finding solutions and root causes to stop future failures/issues

Environment: Exadata X5-2 Quarter Rack, Oracle 12c/11gR2/R1, 10g & 9i RAC, Oracle Clusterware, ASM, Shared Filesystem, AIX, Linux, Oracle GoldenGate 11g / 10g, Oracle Streams 11g / 10g, DATAGUARD 11.2, RMAN, OEM 12c & 11g Grid control, Shell Scripting, Incident manager, HP Service manager, Solution design tools.

Cargill – Hopkins, MN Jan’11 — Nov’11

Responsibilities:

Worked on a series of on-going development projects within implementation and development teams

Installation, configuration and administration of Oracle 11g, 10g, 9i RAC and standalone database using Oracle ASM

Worked on implanting disaster recovery solution using Data Guard Broker to manage both Physical and logical standby

Implemented Table partitioning, Materialized Views and Secure LOBs

Experience in supporting SAP database environments by using BR*Tools to manage SAP instances and backups

Experience in setting up of automated jobs through OEM grid control for backups, database refreshes and scheduler jobs

Migrated a multi-terabyte database from HP-UX to Linux platform using Oracle RAC

Cloning and refreshing databases using Data Pump, TTS and RMAN

Experience in upgrading Grid Agent from 10g to 11g Agents on Linux, HP and Windows servers

Effective communication and collaboration with technical and business teams and also providing 24x7 support for production databases

Environment: Oracle 11g RAC, 11g R2/R1, 10g, 9i, ASM, Sun Solaris, HP-UX, Linux, Windows, SQL*Plus, PL/SQL, SQL*Loader, RMAN, Putty, Citrix, Erwin, TOAD, OEM 11g Grid control, Perl.

HP Tech. - Agilent Tech. – HCL America – Colorado Springs, CO Mar’09 — Jan’11

This project involves Oracle 9i, 10g and 11g databases on multiple UNIX platforms (HP-UX, Solaris, AIX, and Linux) using Oracle RAC with ASM and DataGuard Standby for disaster recovery. My primary focus is to upgrade older versions of databases and implement OEM 11g Grid Control to replace age-old monitoring tool DBAmon.

Responsibilities:

Responsible for the Design and implementation of the OEM 11g Grid Control to monitor and alert Oracle database, Oracle WebLogic server,

Documented OEM 11g installation and OEM agent distribution processes and also wrote scripts to maintain OEM infrastructure

Expertise in installing and configuring Oracle RAC and DataGuard to provide high availability

Upgraded Oracle 9i databases to Oracle 10g and also worked extensively to resolve performance issues

Expertise in managing oracle databases in Oracle RAC and UNIX clustered environments

Experience in scripting for Customized Monitoring using Perl and Bash Shell

Experience in fixing block corruption issues using DbVerify, RMAN and Data Pump

Implemented auditing for oracle databases to monitor user session’s database activity

Expertise in working with RMAN and Veritas NetBackup for database backup and recovery

24x7 production support and being a critical member of the team to support critical database issues

Environment: Oracle 11g, 10g, 9i Linux, Sun Solaris, HP-UX, Windows, RAC, ASM, SQL*Plus, PL/SQL, SQL*Loader, RMAN, Putty, Citrix, Erwin, TOAD, OEM 11g Grid control, Perl & Bash Scripting

United Health Group - Plymouth, MN Oct’07 — Mar’09

Responsibilities:

Installation and configuration of Oracle 10g/9i and Creating Databases based on specifications.

Applied patches to Oracle databases accessed by various applications.

Performed upgradation of the databases and software to the new releases.

Installation and configuration of Real Application Cluster (RAC) database using Automatic Storage Management (ASM)

Experience in Addition/Deletion of node from RAC Cluster.

Create and configure ASM Instances and database.

Oracle Real Application Clusters database administration, Backup and Recovery and troubleshooting.

Monitoring Database Activities, Checking for tablespace Availability, Checking the Alert Log File for errors, and monitoring the Hit Ratios.

Created procedures, functions and triggers, DDL and DML queries.

Creation of users with passwords and assigning them tablespaces like user data and temporary, granting privileges (system and object) through roles and profiles

Planning Backup & Recovery procedures, Performing Backup and Recovery activities (both in archive & no archive mode) using RMAN

Database Migration from Oracle 9i to 10g and from Server to Server

Application Query tuning on all modules using Tkprof, Explain plan & Statspack

DB Cache, SGA Tuning, Optimizing using Cost Based Optimizer (CBO), analyzing Tkprof & AWR reports

Give administration and tuning consultation to the customers.

Experience in Oracle Security Administration

Used SQL * Loader for converting legacy databases to oracle formats

Experience in Managing the Clone database

Experience in writing Shell Scripts as per the requirement

Tuned SQL and PLSQL code using hints and outlines when needed

Experience in Disaster Recovery Solutions – Oracle 10g/9i Data Guard, Standby Databases

Implemented nightly Corn jobs to maintain the backup and for other administrative works

Formulating Backup Policies, Monitoring Performance issues, setting up coding standards

Tuning for I/O Contention, Memory contention, Row Migration, Block Contentions, etc.

Lead efforts for problem identification and resolution at the database tier

Provide Oracle support to the Application Developers in answering questions, database changes and review of application design

Provided 24x7 on call support

ENVIRONMENT: Sun Solaris 5.8, AIX/V5.1, OPS, RAC, Oracle 10g / 9i/ 8i, Stored Procedures, Functions, Database Triggers, SQL, SQL*Loader, Data Pump, Exp/Imp, RMAN, Oracle Enterprise Manager (OEM) 10g

Verizon – Dallas, TX May’07 — Oct’07

Responsibilities:

Installation and configuration of Oracle 11g/10g/9i binaries and databases.

Real application cluster (RAC) 11g/10g/9i Installation, configuration, managing Nodes, node addition deletion and monitoring.

Experience in Building 10g R2 (10.2.0.3) Physical RAC Dataguard for RAC Primary Database.

Installation, creation and administer the ASM databases.

Experience in database Upgradation and Migration from 9i to 10g.

Experience in Migration of Oracle Databases residing on File system to Automatic Storage Management (ASM)

Experiencing in the Database Decommission.

Experience in Backup and Recovery using RMAN with TSM as media manager layer and used Autosys as the scheduler.

Experience in Refreshing Pre-Prod, Development and Test Environment using Production data.

Involved in refreshing lower environment schemas with production data periodically using EXP/IMP and Data Pump

To develop logical and physical design of the database and estimate size of the database objects.

Implemented Data Guard – both Physical and logical standby, performed switchover/Failover.

Generated SQL and PL/SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

Application Query tuning on all modules using Tkprof, Explain plan & Statspack.

Responsible for applying Oracle Patches using the OPatch utility.

Experience in working with partitioned database environment.

Experience in Audit Validation.

Experience in Monitoring of the database using the Grid Control.

Provided 24x7 On-call Support for all the Production databases.

ENVIRONMENT: AIX, Linux, Sun Solaris 5.10, Oracle 10g / 9i / 8i, RAC, Stored Procedures, Functions, Database Triggers, SQL, SQL*Loader, Data Pump, Exp/Imp, RMAN, Oracle Enterprise Manager (OEM), Toad, Autosys, Data Guard

Contact this candidate