Oracle Manager

Location:

Atlanta, GA

Posted:

October 03, 2017

Contact this candidate

Resume:

Vithal R Lankapalli

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

312-***-****

Summary

Results-oriented IT DBA with experience and proven track record in managing technology delivery and operations teams. Certified Oracle 12c DBA, Over 16+ years of IT experience with the right balance of management and technical skills to work effectively in a team and cross functional groups. Background in strategic planning, business administration, project management, staffing and employee relations. Proven strength in managing off shore resources, meeting goals and producing results oriented team efforts through excellent interpersonal, motivational and communicational skills.

Skills Summary

Oracle 12c,11g,10g,9i

RAC, RMAN, ASM

Oracle Golden gate 12c/11R2

Oracle 12c/11G Data guard

IBM Replication ICDC

Disaster Recovery Solutions

Oracle Exadata x3,x5

Database Patching

Data Modeling

Oracle Apex Installation

Oracle Advanced compression

TOAD, ERWIN, BMC Remedy

Oracle 10g/11g/12c upgrades

MSSQL SERVER 20012/2008R2

Database Reorganization

MySQL Database administration

Unix Shell Scripting

PL/SQL, Java, C sharp

Remedy Change management

Linux, Solaris, HPUX, AIX

Commvault Backup Administration

Oracle Recovery Manager RMAN

OEM 13c,12c,11G

TDE, Oracle wallet encryption

Progressive experience, specializing in high-volume, high-visibility production and development environments. Skilled in database builds and preparing database configurations for complex applications.

Managed team of on-site DBAs and off-site DBAs across global locations. DBA categorized of Administration, Application, Production, Operation, Change Management, On-call support and Optimization.

Managed and administrated database and database applications 24x7 that include Oracle 12c/11g/10g/9i Databases, Mssqlserver,mysql,DB2 application databases, Oracle RAC,Oracle Golden gate, Exadata X3,x5, OEM Grid, High Availability, Data Guard, IBM Change data capture.

Successfully completed cross platform multiple Production database migrations to Linux,AIX,Windows.

Implemented Hot Backup, Cold Backup, Data pump, Export, Import, incremental backups and recovery scenarios.

Successfully implemented Real time replication using Oracle Golden gate on Exadata servers.

Expertize in in Oracle RAC, ASM, RMAN backup and Recovery solution implementations on AIX & Linux.

Experience in Mysql Installation, backup & replication setup which includes tuning of MySQL parameters.

Implemented 12C Table compression on OLAP & OLTP.

Implemented multiple Data Guard/Standby database setup for business critical databases includes switchover and failover operations on demand

Successfully Completed Golden gate version upgrades with minimum down time.

Defined Policy/Standards and process for the database changes migration model flow drafted for the production/Development.

Performed roles as Senior Manager Database for different Client projects for multiple teams.

Managed 90+ Enterprise- level Database systems achieving the goal of 99.9% availability at acceptable level of performance.

Participated in planning for infrastructure setup for off-shore Data center.

Managed Multiple Infrastructure teams DBA, UNIX, and Storage.

Successfully implemented Real time replication in between different rdbms using IBM change data capture.

Experience on configuration and implementation of databases for Health care, Banking and financial Industries.

Extensive experience in implementing Disaster recovery plans for all critical production databases.

Managed Multiple Infrastructure teams which includes DBA, UNIX, Storage & Networking .

Worked as production change manager and part of change advisory board for multiple project teams.

Extensive experience in installation, configuration and administration of SQL Server 2005/2008/2012

Good experience in Oracle Golden gate implementations in between sqlserver.

Experience in Tuning queries, troubleshooting performance issues, root cause analysis

Experience in application fine-tuning and database fine-tuning using Explain Plan, AWR, ADDM, ASH

Wrote extensively on Unix Shell Scripts, PL/SQL Stored Procedures, Functions and Triggers

Wrote Shell scripts for automating Hot backups and RMAN backups

Experienced in CommVault backup tool, good knowledge in ITIL V3 processes.

Education & Certification

Bachelor of Technology B.Tech

OCP DBA Oracle 12c

ITIL® Foundation Certificate in IT Service Management

AWS Certified Architect associate level

Work History

Project # 1

Role : DBA consultant

Clients : COX Communications Inc. Atlanta

Duration : MAY 2016 to Till Date.

Environment : Oracle Exadata X3,X5,Oracle RDBMS 12c/11g/10g, Goldengate Version 11G 12C 12.1.0.16, Linux Enterprise server 4.x, 5.x, 6.x (Xeon), OEM 13C, 11g,12c

Regular DBA activities like database auditing, space management, database issues, locking, managing user groups, tuning, re-organization, re-building of Indexes.

Provided on-call support regarding production-related database performance issues and outages.

Implemented partition table purge process based on the database retention polices(daily, monthly yearly) for different customer OLTP production database servers.

Established standards, policies and procedures for Oracle Database Installation and database setup

Successfully implemented downstream Oracle golden gate replication between two Oracle data stores.

Successfully implemented replication between MSSQLSERVER TO oracle using Oracle goldengate.

Implemented bidirectional and unidirectional goldengate replications for multiple production databases.

Successfully Completed All versions of Oracle (11g,11G,12C) Databases along with Latest PSU.

Implemented shell scripts for golden gate alerts and tablespace usage, failure RMAN backup alerts.

Planned and implemented high availability solutions using Oracle 12c RAC, Standby Database using Oracle Data Guard.

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

Automatic database backup schedules through corn jobs(Daily, weekly, monthly)

Hands on experience on changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server

Created and implemented Oracle database xml template for creating brand new database for 12c & 11g.

Upgraded Oracle Cluster ware from 11gR2(11.2.0.x) to 12c

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

Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.

Performed initial data load for Golden Gate and supported ongoing issues with golden gate

Oracle Golden gate installation, upgrade, configuration, troubleshooting GG issues.

Setting up Physical Standby Database Data Guard for Disaster recovery.

Designed and implemented backup and Disaster recovery strategies with RMAN. Performed logical backup using traditional export/ import and Data Pump.

Identified bugs and applied required patches like PSU, CPU and Interim Patches as per the oracle recommendations.

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

Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM and ASH.

Managed and monitored grants, roles, privileges to users, analyzed tables to generate and gather stats including verifying daily backup logs and alert logs.

Performed few Character Set Migration using CSSCAN and CSALTER.

Assisted developers in getting database connection from the client using SQL *net.

Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.

Proactively managed the databases, set up notifications/ alarms using shell scripts for managing any exceptions in day-to-day management of the databases.

Project #2

Employer : DST World Wide services (Subsidiary of DST systems Inc.)

Role : DBA Senior Manager

Clients : Lincoln Finance Group, Noah’s Ark, InTotal Health Care, Anova, Arise HIP, IFDS

Duration : MAR 2014 To Feb 2016.

Environment : Oracle 12c/11g/10g, ASM, RMAN, PL/SQL, TOAD,Mysql, SUSE Linux Enterprise server 4.x, 5.x, 6.x (Xeon), AIX 5.3 and 6.1, HP-UX, BMC Remedy.

Implemented Best backup policy for all production databases using Commvault tool based on the application availability.

Implemented Automatic job alerts for critical databases based on space usage & locks.

Remedy Ticket distribution to all the teams based on the priority and monitoring remedy request queue for assigned teams.

Prepared database check list for new builds to make sure zero tolerance in Delivery of new database builds.

Database backup schedules has been configured based on the database non-peak hours to make sure the database performance does impact with the backup schedules.

Implemented Change control templates to meet organization goals for operation teams.

Participated on Data center DR activities on monthly basis.

Designed and Implemented RMAN Repository for all exiting production database backup using commvault tool.

Installed OEM GRID repository and registered all the production databases for critical alerts to on-call DBA.

Supported 24X7 on-call support for complete oracle data center.

Participated in majority of project design review meetings

Upgraded more than 30 databases from 10gR2 to 11gR2.

Implemented 128 bit encryption for selected tables using oracle wallet and also developed key rotations scripts for the application admins.

Managed and monitored grants, roles, privileges to users, analyzed tables to generate and gather stats including verifying daily backup logs and alert logs.

Successfully completed multiple oracle 11g data guard setups for new clients based on high availability.

Installed Oracle 11rR2 RAC on two node cluster for kana databases.

Configured and Supported IBM ICDC from As400 database to oracle and mssql server

Good experience in Oracle apex Installation and upgrades.

Project #3

Employer : DST World Wide services (Subsidiary of DST systems Inc.)

Role : DBA Manager.

Clients : Amerigas, Wadell and Reed, Total Care, Mt. Carmel, Symponix Market Prominance, Core Source Health Solutions, Universal American FIDA

Duration : APR 2012 TO MAR 2014

Environment :Oracle 11g/10g, Oracle Clusterware 10g/11g, ASM, RMAN, PL/SQL, TOAD, SUSE LINUX Enterprise 4.x, 5.x, 6.x (Xeon), AIX 5.3 and 6.1, HP-UX, Shell scripting, BMC Remedy.

Supporting more than 30 Development and Production Databases on HP Unix operating system.

Configured oracle 11g data guard physical stand by database at client location.

Implemented Database change Request standard template to submit the to end customers for any intermediate change requests.

Good experience With CVS version control utility on linux server.

Done multiple database migrations from oracle lower versions to higher versions without any data loss.

Wrote multiple triggers and stored procedures to support Cobol routine to implement business logic.

Implemented data model for the new customers using reverse engineering with the help of Toad & ERWIN.

Established Oracle Materialized views for selected columns refresh to support partial replication.

Implemented shell script to refresh Materialized views on a daily basis.

Upgraded all production databases from 10.2.04 to 11.1.0.1.

Installed Oracle application express on Aix database server.

Project #4

Employer : DST World Wide services (Subsidiary of DST systems Inc.)

Role : DBA Lead

Clients : DirecTv, Medical Advantage, Health First Health Plan, Prime West, Gunderson

Duration : Feb 2010 to April 2012

Environment :Oracle 11g/10g, Oracle Clusterware 10g/11g, ASM, RMAN, PL/SQL, TOAD, Red Hat Enterprise Linux 4.x, 5.x, 6.x (Xeon), AIX 5.3 and 6.1, HP-UX, Shell scripting, BMC Remedy.

Supporting more than 50+ Production Databases on Aix/Linux operating system.

Configured oracle 11gR2 databases on Vmware which includes installation and migration.

Installed multiple oracle clients(10gr2 32/64 bit) on Red hat linux servers.

Implemented Oracle 11gR2 data guard stand by database on ASM.

Hands on experience on Oracle RMAN Restorations/recovery using point in time.

Implemented RMAN backups for all production databases to take full/incremental backups.

Supported 24/7 On-call on weekly rotation.

Installed and configured OEM Grid control.

Involved in upgrade/migration of the oracle databases from Oracle 9i to 10g on Aix and Linux servers.

Implemented back-end logic for business applications for example Views, procedures, functions and triggers.

Writing shell shell scripts for managing day-to-day activities and automation of backups.

Usage of partitions for improve the query performance and manageability.

Implemented the script for truncation the table partitions and index rebuilds on production

Maintenance windows.

Project #5

Employer : DST World Wide services (Subsidiary of DST systems Inc.)

Role : Senior Database Administrator.

Clients : Frontier E-billing system, Amisys Advance, Citicorp, Amisys, Costco, Assurant, CG-Metro Plus Health.

Duration : April 2006 To Feb 2010

Environment : Oracle 11g/10g, Oracle Clusterware 10g/11g, ASM, RMAN, PL/SQL, TOAD, Red Hat Enterprise Linux 4.x, 5.x, 6.x (Xeon), AIX 5.3 and 6.1, HP-UX, Shell scripting, BMC Remedy.

DST World Wide services (Subsidiary of DST systems Inc.) – DST is a product based company in Financial sector and Health Insurance Sector and it is one of the leading database hosting companies for Financial, Credit card processing, Health Solutions, General Insurance, Bank databases. The clients include CitiCorp, Amisys, Costco, etc.