Candidates About

         

            Vamshi Manchikanti               Oracle DBA

SUMMARY:

·         Over 11 years of working experience as oracle database administrator with oracle 8i,9i,10G and 11G, RAC 11g, 12c versions on Solaris, RHEL, HP UX, IBM AIX, OEL, Exadata Platforms, supporting very large-scale database environment (over 100TB) and mission critical OLTP and OLAP systems.

·         Engineering, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC)

·         Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, capacity planning, shell scripting, and documentation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions

·         Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.

·         First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

·         Well experienced in Installation / Configuration / Performance Tuning / Trouble shooting Oracle Goldengate OGG in both homogeneous and heterogeneous environments including Oracle to Oracle and MS SQL Server to Oracle.

·         24x7 on-call production database support, providing L1, L2, L3 support

·         Successfully implemented Shareplex replication (version 8.6.3) between multiple nodes running on linux and windows OS. Also implemented shareplex replication between MsSql server and Oracle databases. Extensive working knowledge on shareplex replication to setup, migrate, upgrade, issue resolution, working and coordinating with Quest (dell) support and oracle support. Working knowledge on upgrading shareplex from version 7.6.3 to 8.6.2

·         Worked extensively on end-to-end project life cycle implementing ORMB (Ver 2.2.4.4) product replacing PeopleSoft billing system. Involved in end-to-end project life cycle, starting from design, capacity planning, implementation, documentation to handing over to Maintenance Team

·         Proficient in writing PLSQL packages, implementing database security triggers, wring SOX auditing packages related to database security

·         Extensive working experience on remediating, standardizing RMAN backup scripts, exp/imp jobs, setting up Autosys jobs

·         Well versed with 12c EM Cloud Control, 11g OEM grid control, managing over 100+ production instances.

·         Involved in a full end to end project implementation for providing DR solutions using EMC AVAMAR, Symantec NetBackup for SUNGARD.

·         Successfully implemented Data center migration – PELICAN for BAT, Australia using oracle streams, RMAN backup, NetBackup. Responsible for requirements gathering, designing, and delivering project deliverables from onsite location

·         Excellent communication skills, effective Project Management skills, worked as Tech Lead, SME for Oracle DB Administration, Project delivery under stringent timelines and high pressure.

·         Exceptional ability to maintain and build client relationships, ddevelopment and design responsibility in a Global Delivery Model system, Communicating the requirements to the team and get the deliverables ready without any Scheduled deviations and ensuring quality.

TECHNICAL PROFILE:

·         Ability to perform Oracle software and 10g,11g Grid RAC, ASM installation, 12c Installation

·         Working experience on Goldengate 11x, Shareplex Installation, migration, and upgradation (7.6.2 to 8.6.2)

·         Working experience as ERP dba on ORMB product.

·         Proficient in PLSQL coding, shell scripting, Setting up of Autosys jobs

·         Well versed with the concept and configuration of Oracle Database Administration, Backup and Recovery

·         Successfully implemented Oracle 10g, 11g Data Guard on Linux environment.

·         Good knowledge on configuring ASM instances and upgrading both clusterware and RDBMS homes by manual method and using DBUA tool.

·         Expertise in Backup and recovery using RMAN, hot backup and good command over utilities like Export, Import, Expdp, Impdp, SQL* Loader.

• Hands on experience on performing backups of OCR & Votedisk files and administration of RAC database using SRVCTL utility
• Experienced in devising backup and disaster recovery (including RMAN) strategies - includes Physical standby DB’s
• Creating Shell and PL/SQL scripts for automation purposes.
• Maintenance and development of database objects like Tables, indexes, Stored Procedure, constraints, triggers, DB links, users, roles, profile and SQL NET and Listener. Configured and managed databases on UNIX and Solaris environment
• Proficient in SQL*PLUS, and PL/SQL programming.
• Good knowledge in SQL Query Tuning, Database Performance Tuning using AWR, STATSPACK, TKPROF reports.
• Review the I/O bottlenecks for the environment and recommend storage modifications to fit the application.

·         Review Oracle configuration to identify performance bottlenecks and provide suggestions to address the same. Suggestions include Database Changes, Configuration Changes, Server parameters etc

EDUCACATION & TRAINING:

• Master of Science in CESP from University of Plymouth, UK – 2006 with Grade A (2:1)
• Bachelor of Technology in ECE from JNTU, Hyderabad, India – 2004 with 73.47%
• DBA Workshops: Oracle Database Administration 10g (2006), RAC, ASM administration (2008), MySql Introduction (2010)
• Certified on Brainbench Oracle 11g Administration

TECHNICAL SKILLSET:

• Hardware/Server           : Oracle X2/X3/X4 full rack Exadata machine, IBM PowerPC, SPARC

·                                                                                 OS       : Oracle Linux, HP-UX, AIX, RHEL 4.4, Solaris 8,9,10, OEL 5,Windows 2000/NT

• LANGUAGES                : C, SQL, PL/SQL, Unix Shell Scripting
• RDBMS                        : Oracle 8i, 9i, 10g, 11g, RAC 10g/11g, 12c
• MONITORING TOOLS   : Indicative, OEM 10g (10.2.0.4), 11g EM Grid, 12c Cloud Control

·                                                                                 TOOLS : BNC Remedy, HPSM, HP Data protector, Triole, SQL*Plus, Toad, SQL Developer, RMAN, SQL*Loader, DBCA, DBUA, Explain Plan, AWR, ADDM, ASH, ERWIN

• Backup & Storage        : EMC Avamar, Symantec Netbackup
• Replication                   : Oracle GoldenGate 11x, Shareplex 7.6, 8.6

MAJOR ASSIGNMENTS:

v  Hartford Insurance, Windsor, CT – Project DBA

March 2015 To Till Date
Project 1:	ORMB – NextGen Billing – App DBA support
Environment:	Oracle 9i, PeopleSoft, Oracle 11g, ORMB 2.4, Exadata
Role:	App DBA, Tech Lead
Tools	HPSM, Toad, PLSQL, Erwin

Client Description: Hartford insurance is a US based investment and Insurance Company with earnings over $30 billion USD that specializes in providing insurance solutions for property, causality, personal, commercial lines of business, group benefits and mutual funds. Hartford product offerings include auto, home owner’s insurance, business insurance, worker’s compensation, and Employee benefits including disability, life, and accident coverage.

 

Oracle Exadata Administration Support:

ü  Participated in analysis and designing of oracle exadata servers for infrastructure and related projects.

ü  Part of the team that set up infrastructure to migrate gold and silver applications to exadata platform, migrating over 100 databases to Exadata.

ü  Provided Infrastructure support to upgrade, patching of both compute nodes and storage nodes

ü  Successfully utilized iLOMs for managing and troubleshooting storage cells and compute nodes

ü  Integrated Exadata server monitoring tools with OEM console.

ü  Developed and implemented Exadata software patches across all components of Exadata database Machine.

ü  Successfully maximized database performance on Exadata using smart scan technologies such as storage index, Hybrid columnar compression and predicate filtering.

ü  Developed golden gate scripts to achieve zero downtime production migration of mission critical systems to oracle Exadata database machine.

 

Project 1: NextGen Billing – PS to ORMB migration

Project Description: Main aim of the project is to migrate Peoplesoft Billing system running on oracle 9i to ORMB on 11g environment Scope also includes converting/migrating 3 years of PS data to ORMB which provides the feed to downstream DW systems.

Responsibilities:

ü  Provided App dba (ERP DBA) support for NextGen billing project. App dba support requires extensive knowledge on oracle Apps (BRM).

ü  Involved in design, planning, setting up of multiple environments for development, testing, QA

ü  Capacity planning and forecasting of db size and procuring storage, system requirements

ü  Install and create databases on Exadata Platform.

ü  Install of ORMB product, setting up, configuring Application, batch servers

ü  Setting up users, roles, access, installing security protocols (db triggers, profiles etc)

ü  Created access points for application schemas, project teams between multiple interfaces that interact with Billing engine.

ü  ORMB activities that include application patches (ORMB related), running oragensec utility, Blueprint extract, upload to synch environments.

ü  Refreshing non-prod environments using best practices, RMAN, exp/imp

ü  Performance tuning of complex queries by introducing additional indexes, running gather stats, table reorg at regular intervals, partitioning of biggest tables, revisiting cpu, server parameters, storage – Resulting in significant improvements of batch runs from 12 hrs to 2 hrs.

ü  Worked on migrating non-prod databases running on Pureflex servers to Exadata.

 

 

Project 2: IRE data optimization – App dba support to automate partial cloning steps

Project Description: Scope of the project is to run/test production batch jobs in PTE environment, which is created by RMAN partial clone using Production backup (approx. 102TB size)

Responsibilities:

ü  Provided App dba support for IRE data optimization project.

ü  Run partial clone (selective tablespaces) using RMAN to create PTE environment. After 1st run of box jobs are completed, tablespace list is revised and updated.

ü  Run DBA steps to setup IRE environment and handover to application team, so they can run the set of box jobs.

ü  Resolved issues related to logon triggers, initial setup.

ü  Automate PII column masking routines using plsql code (packages).

ü  Automate incremental data load steps using plsql code.

ü  Setup Autosys jobs for above written code to run on demand basis.

 

Project 3: Ecos Conversion, ComPAS, ADM evaluation – App dba, Shareplex DBA support

Responsibilities:

ü  Setup shareplex Replication between ECOS and IM DW databases and monitoring of shareplex replication

ü  Shareplex env upgrade from 7.6 to 8.6 version

ü  Setup shareplex replication between Linux and Windows environments, between oracle and MsSql databases

ü  Worked on enabling CDC replication across multiple environments

ü  Worked closely with Dell support and Oracle support, to fix issues that arise due to replication and ORA 600 related errors

ü  Provided App dba support to highly critical DW databases having size over 50 TB.

ü  Proposed and developed automated solutions for data copy requests between prod and nonprod environments, including PII masking steps. This was a major achievement in terms of reducing no of tickets to DBA team, enabling quick turnaround times and processing times to synch non-prod environments

ü  Carried out user, role, dblink remediation activities across Hartford network and tightened database security.

ü  Performed numerous production release activities, coordinating with application teams by enforcing change management processes

ü  Lead a team of 20 members from offshore effectively to provide 24x7 support to 100+ databases

ü  Implemented various value add suggestions and policies to strengthen database security and quality of db administration work

 

v  Johnson & Johnson, Raritan, NJ – Project Lead for BRP

Aug 2014 To Feb 2015
Project:	Backup Remediation and Correction
Client	Johnson & Johnson, USA
Environment:	Oracle 8i to 11g versions running on various HPUX, Linux, Windows OS
Role:	Production Support, Project Lead
Tools	Service Now, Toad, Tidal, Netbackup

Project Description: BRP – Main scope of the project is to configure and implement new standard backups for all ITS managed oracle databases. Scope also includes correcting existing backup scripts and configuring new backup scripts as per ITS standards.

Responsibilities:

ü  Gather requirements, such as Current backups, storage, for Production, QA, Dev instances.

ü  Prepare and update decision making table as per environment, Business Requirements.

ü  Gathering Pre-requisites such as creating netbackup policies, Installing Tidal agent, Setting up scripts under /usr/local/bin/.oraback

ü  Sending global communications to TAO’s, business to request digital approvals and recording TAO responses.

ü  Implementing new backup scripts RMAN for Prod and QA, Metadata export bkp for Dev and Test

ü  Configuring new backup jobs in Tidal and monitoring job run history through hyper care period

ü  Disabling old jobs scheduled through Tidal or Maestro.

ü  Preparing status updates and regularly tracking project milestones and updating share point folders with project related documents

ü  Cloned development databases from PROD using RMAN plus configured and scheduled RMAN Backups as per business requirements

 

v  Union Bank of California, Monterey Park, CA – Production Support Analyst

Sep – 2013 To July 2014
Project:	UBOC – DBA Support
Client	Union Bank of California, USA
Environment:	Oracle 10g,11g R2 on IBM-AIX, RHEL, HP-UX
Role:	Production Support, Project Lead
Tools	HPSM, Toad, EM Grid Control

Project Description:

The Oracle Database servers at Union Bank of California (UBoC), one of the largest banks in California, are mainly the data warehouse components which include information from various systems throughout the bank, with many interfaces. There are over 300 and 90+ production DBs databases on Oracle10g, Oracle11g and Oracle9i to set and meet the bank’s functional business units.

Provide level 1, level 2 and level 3 support. Create daily, weekly and monthly reports for highlighting critical and major incidents reported and resolved.

Oracle s/w installation, Database creation, Dataguard / standby server, RAC and ASM support, RMAN backup with MMS support, Database cloning, Oracle patch apply, Working with Oracle Support, EM Grid Control support, Remote connection using Name Server and LDAP, Real time query performance resolution, Supporting ETL issues and other general database administration.

Role in Project: Project Lead, Production Support

Responsibilities:

ü  24x7 on-call production database support, providing L1, L2, L3 support

ü  Oracle software installation and database creation

ü  Capacity Planning and bench marking

ü  Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of optimizer settings, Hints, Stored outlines, Statistics for the same.

ü  Dataguard / standby server setup

ü  RAC instances with ASM using Oracle clusterware

ü  EM Grid Control provisioning and setup

ü  Maintenance and management of Names servers and LDAP for remote connection

ü  CM implementation on production servers

ü  Maintenance, Monitoring, Management and Administration of database infrastructure

ü  Standardized IT operations by Implementing SOPs, process flows

ü  Provisioning and implementation of Oracle s/w installation, database creation, database upgrade, applying patch and patch set, data guard / standby database, EM Grid Control, database cloning

ü  Implementation and automation of RMAN backup and restoration strategy integrated with MML

ü  Working with oracle support to resolve database issues such as ORA 600, ORA 7445

ü  Solution offered and implemented for new project requirement, large volume data management, data purging and archiving

ü  Real time performance resolution for DW loads

ü  Automation of DBA activities along with alerting

ü  Security policy and data access control implementation

ü  Other tools are EM Grid Control, HP Service Center, OTRS, Outlook Mail, Automation Scripts, MKS, Putty, XManager

 

 

 

 

v  SUNGARD Availability Services, Phoenix, AZ – DR Solutions Engineering Team DCO

Nov – 2012 To Aug 2013
Project:	Backup and Recovery Solutions
Client	SUNGARD, USA
Environment:	Oracle 11g R2, 2 node RAC, DR Solutions, Solaris 10 SPARC 64 bit – Dell t54401,t52402
<p class="MsoNormal" style="text-align: