Narsing Rao Vatnala

(Sr Oracle Apps DBA)

acufw3@r.postjobfree.com

669-***-****

PROFESSIONAL SUMMARY:

A highly accomplished DBA overall 9 years of experience with expertise in overseeing the streamlined operation of DBA Services utilizing the ITILv3 model while ensuring business objectives of the organization are met. As an Oracle Apps Database Lead, having hands on expertise in database administration, production support, installations, configurations, upgrades, migrations, releases, patches, performance tuning, backup/recovery, cloning, space management, database security, auditing, troubleshooting, database design, high availability, oracle metalink support, disaster recovery, Unix shell scripting and documentation.

A strategic planner with competency in efficient Database strategy and executing the same with a view to achieve highest availability and performance.

Experienced with Oracle Enterprise Manager, RMAN, ticketing system, Kintana Tools

Experience on Highly Integrated Telecom, Health care industry database systems, managing large Oracle databases

Expertise with Oracle Apps R12 and 12c Databases

Expertise in Oracle Applications upgrade from 11.5.10.2 to R12.1.3 and Oracle Database upgrades from 10.2.0.5 to 11.2.0.3, 10.2.0.5 to 11.2.0.4 & 12C

Experience in Oracle Security Levels, Audit Vault, Database Vault and database Firewall

Experience with 12C EM Grid home and knowledge on database monitoring through EM Grid Control

Expertise on end to end administration of Oracle EBS 11i / R12.1 on RAC/ASM

Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operation.

Expertise on PCP and middle tier Load balancer setup / troubleshooting

Expertise in proactive patch management, cloning, code migrations, release management

Expertise in troubleshooting Oracle EBS issues related to Concurrent Manager / OPMN / Workflow.

Expertise in Golden Gate replications, defining software for tasks associated with the developing, debugging or designing of software applications or operating systems.

Specify, design and implement modest changes to existing software architecture to meet changing needs. Oracle Golden Gate (OGG) provides a complete solution in high availability, real-time data integration, transactional change data capture, data replication, transformations, and verification.

Expertise in performance tuning of both Apps and DB layers.

Expertise in working on Production Support issues of WebLogic & SOA middleware Administration.

Experience with installing and upgrading E-business suite R12.2.

Experience in Web logic and Fusion Administration.

Implemented ASCP, Demantra and ODI in multiple R12 environments.

Implemented Oracle Ware house management in R12 environments.

Experienced with SOX, FDA audit and compliance procedures.

Experienced with system roll-outs and change management during project implementation.

Proven ability to combine project and staff management with technical expertise to consistently exceed corporate goals.

Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skills.

TECHNICAL SUMMARY:

RDBMS

Oracle 11g,10g,9i,8i

Tools & Utilities

SQL* Loader, RMAN,EXP,IMP, expdp, impdp, TOAD, Oracle Enterprise Manager, OAM

Operating Systems

UNIX, Sun Solaris 8,9,10,11 AIX 5.1,5.2,5.3,6.1,7.1 HP-UX 10.x,11.x and Red Hat Linux 9

Languages

SQL, PL/SQL programming, Unix Shell Scripting, Java, HTML, J2EE

Web Technologies

HTML, XML, Dreamweaver, Flash, AJAX,XHTML

GUI

VB 9.0, Developer 2000 Forms 5.0/6i/9i/10g, Reports 3.0/6i/9i/10g

Network Concepts

TCP/IP, FTP, HTTP

Applications

MS-Office, Eclipse, VMware, JBuilder, Net Beans, MS Project 2003

Hardware/Storage

IBM TSM, VERITAS NetBackup7.0, NetApp, HP Omniback

WORK EXPERIENCE:

STRYKER ORTHOPADEICS, MAHWAH, NEWJERSEY

ROLE : ORACLE APPS DBA LEAD

DURATION : Feb-17th, 2015 TO Till Date

ENVIRONMENT : Oracle 11G AIX 6.0, Oracle Apps 11i, R12, Windows XP,

SQL*Plus, SQL * Loader, OEM, PL/SQL Developer,

Import, Export, Toad

Management

Head DBA group for one of largest division of Stryker, Orthopedics. Responsibilities include people management, offshore vendor selection and SLA management. Strategic consulting to management on Technology Trend, on Project Management and on improving operational efficiency of Support Team.

Technology and Architecture

Managing 4 Oracle ERP systems of versions 11i and R12. Architected or improved the architecture for all of these ERPs. Responsible for Non-Enterprise Oracle Databases running varied applications like DW, Clinical Trial Management, WindChill, Prisym, Track Wise, Master Data Management to name few.

High-level Responsibilities:

Leading implemented DR Solution for Oracle E-Business.

Leading DBA team operational support and Migrations.

Supporting Demantra implementation & R12 upgrade for APS System.

R12 implementation for applications

Strategic Support for MDM, SOA, CTMS and Aurgus rollouts.

Strategized, designed, vendor selected and implementing Global Support Team under offshore Model.

Coordinating offshore team on daily operations support

High Visibility on Database Audit model with business to ensure database systems meet with IT Quality as per standards

Roles & Responsibilities:

ONSITE Support Model/Leading Offshore team,Responsible for 24*7 supporting 500+ Oracle databases (11g/10g/9i) wherein the major chunk of the databases hold data of enterprise applications as a Database,PLM,WINDCHILL Process applications and ORTHO Spine

Implemented, administered, reorganized and subsequently tuned all Oracle databases (development – production) databases

By Implementing the Advance Security Wallet Manger on oracle 10g database, solve many audit and application connectivity issue.

Successfully migrated Oracle 10g databases to Oracle 11g databases

Responsible for analyzing and designing the process to implement the oracle patch sets available in Oracle.

Responsible key member in designing/testing/implementing enterprise level move from user-managed backups to RMAN on Oracle 10g environments.

Configured database cloning to copy production to other prod copy (for adoc report purpose) using Business Continuity Volumes (BCVs).

Responsible for Validating Database integrity, security, auditing through SOX twice years to ensure the databases are FDA compliant.

Involved in performing Disaster Recovery drills twice a year for all production systems using BCV splits of remote standby databases and tape recovery for non-BCV enabled systems.

Maintaining strong working relationship with customers (UNIX, storage, developers and team leads).

Prepare validation documents for database setup (installation, configuration, operation, etc.) in a FDA regulated environment.

Strictly followed Change Control/Change management procedures as laid down by the organization in a highly qualified environment.

Strongly involved in daily meetings with business in terms of growth, organizing more systems to improve quality on databases

Followed compliance policies, monthly/quarterly/yearly Audit requirements & maintained standard metrics delivered as per SLA

Implemented and worked in organized structure to troubleshoot on Critical concurrent programs performance issues, long running jobs & maintained good rapoo with users to ensure there are no issues from database

Involved in creating, maintaining and refreshing required Oracle instances/databases for development, test and production environments.

Provided DBA support to the application development and acceptance team, both onsite and offshore for loading and testing data in 10g databases.

Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes

Was responsible for setting up standards for database maintenance and monitoring.

Responsible for Report generation, monitoring disk usage, keeping systems healthy for the production environment.

Implemented changes into the existing cron jobs as per the business needs.

In conjunction with the security administrator established and managed user access, along with designing and implementation of user environments, also establishing enterprise level security standards.

Extensively used metalink for resolving technical issues, opening SR and use collaborative support for database related issues.

Responsible for documenting important scripts and administration of server environment.

Responsible for conducting weekly meeting, tele/video conference with clients, development teams both onsite as well as offshore.

CISCO SYSTEMS, SANJOSE, CA

ROLE : ORACLE APPS DBA

DURATION : OCT 26th, 2014 TO FEB 17th, 2015

ENVIRONMENT : Oracle Application 11i & R12). Sun Solaris 5.9 Generic_118558-06. Windows 2000.

Responsibilities:

Upgraded oracle applications from 11.5.10 to R12 on RHEL5.

Involved in Cloning and patching of oracle applications 11.5.10/R12.

Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.

Responsible for Installation of 11g database on 2 nodes RAC, Grid Infrastructure with ASM file systems.

Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.

Provided Database Administration support (24x7) for 8TB production oracle 11g Databases.

Responsible for installation, creation of 11g RAC databases for Development and user acceptance test.

Responsible for Upgrading the Database from 10.2.0.3 to 11.1.0.6.Configured ASM file system and administering ASM Instances and Disk Groups in RAC.

Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.

Responsible for undo rollback management. Created database objects, users, roles and profiles

Responsible for implementing Load Balancing in RAC Database.

Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.

Excellent in depth understanding of Oracle automatic Undo Management.

Refresh/Cloning of Database from production environment to test environment and application of patches.

Updated development databases by using import/export and SQL loader utilities.

Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.

Responsible for configuration and implementation of backup and recovery using RMAN.

Installed and configured Recovery Manager Catalog Database.

Configuration of Shareplex (Dell Support) between two databases.

Responsible for automation of startup and shutdown on all production and development databases.

Involved in scheduling transaction log backups and notifications.

Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.

Extensively used LVM on both AIX and RHEL, created VGs, LVs, Filesystems and disk mirroring.

Setup and configured network TCP/IP on LINUX and AIX servers including RPC connectivity for NFS. Created mount points for Server directories, and mounted these directories on the Servers.

Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.

CISCO SYSTEMS, BANGALORE, INDIA

ROLE : ORACLE APPS DBA

DURATION : JAN 25th, 2010 TO OCT 26th, 2014

ENVIRONMENT : Oracle Application 11i, R12. Sun Solaris 5.9 Generic_118558-06. Windows 2000.

Responsibilities:

Providing 24X7 Oncall DBA support for 500+ Production instances

Installation, maintenance cloning, patching and post Go-Live support of Production and development environments.

Experience in Installation and configuration of Oracle Applications E-Business suite 11i

Licensing the new Oracle application products

Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users

Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during implementation

Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data

Work with Oracle support in resolving bugs, bug fix patches, multiple sev 1 SRs etc

Implement oracle standard procedures for purging, archiving solutions.

Created the new custom top on Oracle application tier

System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets

Handling issues related to concurrent manager and performance of concurrent manager

Performed multiple clones from Production to Test environments

Performed tracing for various user sessions and for various concurrent Programs

Managing backups of the apps instances & maintaining daily hot backups of database of dev/test and involved in recovery of database

Regular checking alert log and trace files for errors

Expertise in configuring Workflow Mailer, troubleshooting and rebuilding workflow queues as and when necessary.

Worked on PCP, shared APPL_TOP and various APCC modules in oracle EBS R12.

Licensing the new Oracle application products.

Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.

Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.

Implement oracle standard procedures for purging, archiving solutions.

Created the new custom top and configured with EBS on Oracle application tier.

Deploy the application custom developed code following the corporate code deployment and data migration processes like Kintana and FNDLOADER

System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets

INFOSYS, PUNE, INDIA

ROLE : ORACLE DBA

DURATION : April 21st 2008 TO OCT 19th, 2009

Environment : RHEL, Sun Solaris, Oracle 10g, 9i, ASM, RMAN, Dataguard, SQL, PL/SQL, UNIX Shell Scripting, OEM Grid Control, Informatica MDM, Quest Toad, Putty, exp/imp, datapump, Java.

Responsibilities:

Applying high priority, security patches, patch sets to oracle using OPatch Utility, runInstaller.

Data Refresh/Cloning from production to setup test (QA) and development environments.

Planned and implemented Disaster Recovery (DR) solutions using Oracle Standby Database/Data Guard.

Had very good experience with SQL, PL/SQL and UNIX Shell Scripting, writing stored procedures, functions and database triggers for maintaining data integrity in the databases.

SQL Query tuning, Database instance tuning, application tuning using sql trace, explain plan, hints, tkprof, AWR reports, Statspack reports, ADDM reports, initialization parameters, etc.

Partitioned the large tables and indexes by determining the suitable methodology to improve performance and manageability, Extract, Transform and Load (ETL) data from flat files into database using SQL* Loader.

Defining and implementing Backup and Recovery Strategies on production, test, development databases using RMAN, VERITAS Net backup, and RECOVERPOINT, Hot and Cold Backups.

Recovered tablespaces, datafiles on Oracle 10g using Recovery Manager (RMAN).

Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS).

Crontab jobs and UNIX Shell scripts to automate backups, exports/imports, analyzing table’s indexes, monitor tablespace growth, alert logs, startup, shutdown of databases, gathering statistics.

Excellent day to day administration in every means and monitoring alert log files and trace files.

EDUCATION:

BTECH in Electronics & Communications Engineering

Contact this candidate