Vithal R Lankapalli

ac2ko8@r.postjobfree.com

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.

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 #6

Employer : Telesource Management ConsultingPvt Ltd Hyderabad.

Clients : VIVO Replication System

Duration : May 2005 to April 2006

Role : Senior Database Administrator

Environment : RedHat Linux Advanced server 4, Windows 2000, Oracle 10gAS Portal. Oracle Database 10g Release 10.1.0.3.0 – Production

Description: Vivo system has one Database as a Data center which keeps all the Data from all the Databases with are regionally distributed over the different countries. The data of one gym will not be available to other gym. One way to make Gym database only has its own set of data is using Materialized view Replication, materialized view can contain a complete or partial copy of a target master table in the data center. It's an integrated fitness system automation, providing centralize storage to track and plan fitness activities

Roles & Responsibilities:

Installation of Oracle 10g on RH Linux Advanced server 3.0/4.0

DBA support for QA and Development team.

Using Visio 2003 prepared the ER diagrams for each module.

Prepared replication scripts form new releases of database for production QA servers.

Writing pl/sql procedures and Triggers

Applying/creation/modification of new upgrade scripts.

Replication monitoring for automated refresh jobs remotely.

Taking online Automatic scheduled backups for all Remote databases.

Preparing database scripts for complete replication schema setup.

Creating R/W and Read only materialized views for production DB.

Prepared the test cases for Update Conflict resolutions to the single table in the Materialized view replication for testing Team.

Prepared the Delete/Insert conflict resolution methods for the entire replication system.

Prepared the data patches for the data center as well as gym servers.

Prepared the complete replication schema setup scripts

Written scripts for the recompiling the invalid objects for each upgrade of the production/qa servers.

Written the stored procedures, functions against the read/write snapshots.

Prepared the automatic backup plans in the regular time intervals using Oracle Enterprise manager.

Established the test environment for the advanced replication for two servers using Linux and oracle10g.

Raising the Tar’s for the production related problems and solve the problems by explaining to the Oracle support team.

Added separate non-systemtablespace to indexes and dynamic tables and created the temporarytablespace groups.

Installation: Installation of Oracle 9i/10g Enterprise Edition on RH Linux Advanced Server 3.0/4,WinNT/Win2K server and Apply patches

Project #7

Employer : CellExchange India Pvt Ltd. Hyderabad

Clients : Handleman Inc. USA

Duration : April 2004 to May 2005

Role : Senior Database Administrator

Environment : Oracle 9i, RedHat Enterprise Linux 3.x, WinNT/Win2K Server

Sales Force Automation 2 (SFA2): Windows CE, SQLSERVER CE 2.0, Microsoft Access 2000, C#. Net, XML, Pocket PC Handleman Inc. USA is one of the largest supply-chain companies in the USA. The SFA2 application enables Handleman’s field employees to provide accurate, comprehensive and real-time views into the supply chain to track product location and availability. In addition, the application would also help accomplish store maintenance, provide an accurate inventory count and capture rapidly changing local and season variations by providing a medium to push alerts, tasks, surveys down to the field representatives. The application also provides a mechanism to view MIS reports based on the data sent by the field representatives.

Roles & Responsibilities:

Installation: Installation of Oracle 9i Enterprise Edition on RH Linux Advanced Server 3.0, WinNT/Win2K server and Apply patches.

Created Oracle9i Data Warehouse database on Red hat Linux for simulating the Client environment to test the online database problems locally.

Storage Management: Creation of non- System Table spaces separately for table data and table indexes and Large Intermediate indexes creation.

Setup/configuration/administration of Oracle 10g Application Server and Developed Oracle database OLTP systems.

Responsible for application performance and Involved in Logical and physical database design/development for multiple databases.

Perform ERD changes per new releases and Data loads.

Work with development Team on writing more effective SQL / PL/SQL code.

Day-to-day management, monitoring, performance tuning, and troubleshooting.

Security Administration: creation of users, public synonyms Roles and granting appropriate privileges.

Created exclusive Databases for qc and development teams for checking the

Functionality of Daily running packages, sequences, jobs and db links.

Written packages, triggers & stored procedures based on the requirements.

Prepared daily scheduled jobs.

Created Materialized views using remote database links.

Recommend and implement improvements for performance and tuning for SQL statements and Coded stored procedures to support software development.

Query optimization is done through optimizer mode changes in parameter file.

Work as part of a team and provide 7x24 support when required.

Project #8

Employer : JavasoftechPvt Ltd Hyderabad

Clients : Parliament House Delhi India, BSNL

Duration : Dec 2000 to April 2004

Role : Senior Database Administrator

Environment : Oracle 9i, RedHat Enterprise Linux 3.x, WinNT/Win2K Server, OEM, SQL*PLUS, SQLNAVIGATOR, ERWIN Tool

PARLIAMENT HOUSE: This project is designed for Parliament House New Delhi. This involves the capturing the details of the persons and vehicles along with the photographs and signatures to issue the paper cards and plastic cards for Lokhsabha and Rajyasabha members. Here user privileges are more important. Issuing /entering passes for different categories of persons based on the different security phases. Restriction of entrance gates based on the access permission of that user. This project contains 16 modules and 100 reports.

Roles & Responsibilities:

Installation of Oracle 9i Enterprise Edition on RH Linux /WinNT/Win2K server.

Storage Management: Creation of Table spaces and Data files with storage characteristics by estimating the table’s sizes.

Security Administration: Creation of Users, Public synonyms, Roles and granting appropriate privileges.

User management: Creation of users, Granting and revoking roles. Privileges, creation of profiles, assigning quotas.

Backup and Recovery: Implementing Strategies for taking Offline and Online backups and also logical backups using Export and import utilities.

Experience with Networking: Configuring Tnsnames.ora, Listner.ora. Troubleshooting local area networks (usti9ng TCP/IP, IPC protocols), user hardware and Software, Installing, configuring WinNT, Win2k, and Linux.

Based on the Categories and device permissions pass-issuing authority will be decided.

Contact this candidate