Narendra Allapu

DBA Lead and Principal Technical Consultant,

CoE Application Maintenance and services,

INFOR GLOBAL SOLUTIONS PVT LTD,

Hyderabad, India.

acgjyn@r.postjobfree.com

Mobile: +919*********

Introduction

I am working as a DBA Lead, Principal Technical Consultant with

INFOR GLOBAL SOLUTIONS (2005 Feb till date)

with over all 10 years of experience .Have expertise in database administration, production

support, installation, configuration, upgrades, patches, performance tuning, backup and recovery,

cloning, space management, database security, migration and documentation.

Database Administration: Extensive experience in handling DBA duties such as Creation,

Implementation, Monitoring, Performance Tuning, User maintenance and maintenance of the

Oracle RDBMS v 11g2, 10g, 9.x, and 8.x in large production environments with very good

understanding on Cluster and Storage architecture.

Well versed in UNIX, Windows Operating systems, Oracle, SQL and Informix Database

administration.

Business Continuity & Disaster Recovery including business information analysis and risk

assessment, identifying time to recover, developing action plan with agreed restoration tactics,

negotiating strategies, establishing recovery procedures, policy development and training,

communicating to internal / external stakeholders, documentation and executive reporting.

Operations Consulting including estimate preparation, proposal development, conducting in-

depth organizational and operations reviews, developing findings and recommendations.

Heading DBA team of around 8 people having expertise in Oracle, SQL and Informix databases

Professional Achievements

Cleared OCA (Oracle Certified Associate) certification.

Cleared AIX Foundation.

Cleared Informix Foundation.

Received appreciation award by INFOR for successfully implementing a migration project

Trained people on oracle 10g and 11g2

Delivered presentation on Infor Open Architecture

-1-

Professional Summary:

Expertise in installation, troubleshooting, cloning and maintaining of RAC database in

UNIX and windows.

Upgraded RAC database and cluster ware from 10.2.0.1 to 10.2.0.4 and 10.2.0.4 to

10.2.0.5.

Installation of oracle cluster ware, Configuring public and private network and VIP.

Developing and implementing Disaster Recovery (DR) Plan.

Installation, configuration and up gradation of oracle 9i, 10g and 11g2 versions. Cross

platform migration for oracle database between different operating system

Implemented Data guard for high availability and testing of switchover and failover.

Setup and administration of Oracle Active Data Guard.

Database Cloning using RMAN, Hot backup cold backup. Making necessary changes

in crontab for backups/scheduling of various database related activities/jobs

Implementation of restore procedure for complete and incomplete recovery by RMAN

or Hot backup.

Planning and performance daily weekly and monthly cold backup and hot back.

Planning and maintaining Database Disaster recovery side.

Worked on 24/7 high availability environments.

Applying database patches (OPATCH).

Configuring physical stand by database.

Considering future growth, re-org of database and space management of database as

per the need.

Proactive database monitoring using automated scripts using v$views and shell scripts.

Implemented and applied security Patches.

Tools worked on TOAD, OEM, SQL Loader, RMAN, ADI

Setup of client Database Access monitoring tool for DB monitoring (DDL, DML) for

specific objects.

Coordinating with Oracle support for troubleshooting major issues.

Installed and configured SQL Server 2005, 2008, 2008 R2 and 2012 versions

Configured DR using log shipping and Mirroring.

Configured HA on Windows 2008r2 (two node)

Configured HA and DA together on windows 2008 R2 (two node cluster) using

Availability Groups on SQL Server 2012.

Installed and configured Informix 11.5 on Linux 5.6

Configured DR using Informix 11.5 on Linux Platform.

Having good knowledge on the following INFOR, 3rd party and Open Source products

Infor Enterprise Asset Management (EAM)

BAAN ERP : Baan IV, Baan V and LN

Infor OA (5.1,6.0) Collaboration

Infor Portal Studio 1.1

Databases:

o Oracle 9i,10g and 11g2 and aware of Oracle 12c

o SQL Server 2005, 2008 and 2008R2

o Informix 11.5

Operating Systems:

o MS-DOS, WINDOWS-95/98/2000/NT,

o IBM AIX 5.x, 6.x and 7.x

o HP PARISC, Itanium 11.31

o LINUX 5.x and 6.x

-2-

Configuration Management Tools like Visual Source Safe, Rational Clear Case

Web logic 8.x, WebSphere 5.1/6.0 and Jboss 4.0

Application Servers

Programming Languages such as C, C++, PL/SQL

Key Projects Summary

Key Projects Involvement include the following

1. Organization : Infor Global Solutions India (pvt) Ltd.

Client : HAVI Logistics Asia

Role : Principal Technical Consultant – CoE Application

Management Services

Duration : Sep 2013- Till Date

HAVI Logistics is using Infor’s SCE 10.2 Application. SCE is a Warehouse Management

Application. This project is to configure both HA and DR for HAVI. To provide both HA and DR we

configured windows cluster on Windows 2008R2 and for DR we configured Availability Groups on

using SQL Server 2012.

Roles & Responsibilities:

Installing Application server roles

Installing MSDTC Service

SQL server 2012 Installation

o Installing SQL server Failover Cluster installation

o Install SQL server to the existing cluster Group

o Test Failover on both nodes

o Enable Always on Availability feature

Adding Node3 virtual machine to the existing cluster

Installation of SQL server in NODE3 machine

o Enable Always on Availability feature

Creating High availability group

o Test Failover

o Create Always on Listener to the Availability Group

Monitoring Cluster services

Monitoring DR Server Synchronization

Creating backups

o Weekly Full Backup

o Daily Differential Backup

o Transaction log backups on every half an hour

Monitoring backups

Restoring backups to Development /Test environments

User Creations

Assigning roles to users

Creating Maintenance plans

-3-

2. Organization : Infor Global Solutions India (pvt) Ltd.,

Client : BELDEN (Sending all the right signals)

Role : Principal Technical Consultant – CoE Application

Management Services

Duration : Aug 2011- Till Date

BELDNE is the Broadcasting Company. Infor is maintaining Belden Database.

Infor configured DR for Belden using log shipping. They are using SQL Server 2005 SP2.

Recently we upgraded their database from SQL Server 2005 SP2 to SP4.

Roles & Responsibilities:

DR configuration

Monitoring DR Database server is sync status.

Reconfiguring failed DR with the Production backup

Backup configurations

o Full back up on weekend

o Incremental backup on weekdays

o Transaction log backup on every half an hour

Monitoring database jobs

Monitoring database locks

Generating Rebuild Index as scheduled.

Database Upgrade.

Refreshing Development Database with Production Database backup

Maintenance Plan Creation

User Creations

Grant/Revoke roles

3. Organization : Infor Global Solutions India (pvt) Ltd.,

Client : Air International Thermal Systems (AITS)

Role : Principal Technical Consultant – CoE Application

Management Services

Duration : Aug 2012 - Till Date

AITS develop thermal systems to automotive OME’s. They deliver heat ing/ventilation/air

conditioning (HVAC), powertrain cooling, and electric vehicle & Hybrid battery thermal

management systems. They are using Infor ERPLN in maintaining their business, recently we

upgraded their database from Oracle 8i to oracle 11g2 version.

Roles & Responsibilities:

Installing, configuring & maintaining Oracle Database 11G2

Installing Patches (OPatch) on top of 11g2 to go for particular version

Managing Users and Securing the Database

Managing Table spaces, Data files, Archived Redo L ogs, etc

Multiplexing of Redo Logs, control files

Trouble shooting & resolving Listener issues

Database maintenance activities including shutting down database, taking cold backup &

then bringing up the database

Taking logical backup using traditional export (exp) & Datapump (expdp)

Restoring database using traditional import (imp) & Datapump (impdp)

Implementing Database Backup & Recovery Strategies

-4-

Configured RMAN level 0 & level 1 backups

Recovering database using RMAN backups in case of environment fai lure

Analyzing database performance issues by taking AWR, ASH and ADDM reports

Performed database migration using exp/imp, expdp/impdp

4. Organization : Infor Global Solutions India (pvt) Ltd.

Client : Aditya Birla Chemicals India Limited (ABCIL)

Role : Senior Technical Consultant – CoE Application

Management Services

Duration : Aug 2011- March 2013

ABCIL is a chemical Industry approached Infor for the Disaster Recovery solution for the ERPLN

application on the Windows cluster environment and maintenance of both of their Production and

DR Environments.

We proposed manual DR for this customer as the production server is on Windows Cluster

(Active/Passive). But based on the customer request we implemented Data Guard for this

customer.

Roles & Responsibilities:

Installing, configuring Oracle Database 11gr2

Installing Patches (OPatch) on top of 11gr2 to go for particular version

Managing Users and Securing the Database

Managing Table spaces, Data files, Archived Redo Logs, etc

Multiplexing of Redo Logs, control files

Trouble shooting & resolving Listener issues

Configured DR using Data Guard

Database maintenance activities including shutting down database, taking cold backup &

then bringing up the database

Taking logical backup using traditional export (exp) & Datapump (expdp)

Restoring database using traditional import (imp) & Datapump (impdp)

Maintaining windows cluster

Switching cluster nodes based on the customer request

Moving resources to different node when we have problem wi th the existing node

RMAN backup configuration

Maintaining RMAN backups.

5. Organization : Infor Global Solutions India (pvt) Ltd.

Client : Questa’s Corporate

Role : Senior Technical Consultant – CoE Application

Management Services

Duration : Aug 2010- March 2014

QUESTAS is an Australian owned group operating through diversified and distinct industrial

product and service companies. They are using ERP LN to meet their business requirements.

They approached Infor for Disaster Recovery solution and Maintenance of their Database Servers

and HPUX Administration support.

Roles & Responsibilities:

Degrading of Oracle Enterprise to Standard Edition of 10g

Managing Users and Securing the Database

-5-

Managing Table spaces, Data files, Archived Redo Logs, etc

Multiplexing of Redo Logs, control files

Trouble shooting & resolving Listener issues

Configuring Manual DR server

Written scripts for the transfer of archive logs and apply of the same to the DR server

Database maintenance activities including shutting down database, taking cold backup &

then bringing up the database

Taking logical backup using traditional export (exp) & Datapump (expdp)

Restoring database using traditional import (imp) & Datapump (impdp)

Maintaining windows cluster

RMAN backup configuration

Maintaining RMAN backups.

6. Organization : Infor Global Solutions India (pvt) Ltd.,

Role : Senior Technical Consultant – CoE Application

Management Services

Duration : Aug 2010-2011

This is a Data Migration Project from Oracle 10g to Oracle 11g2 from AIX to HP-UX Itanium

11.31. During this migration project I moved around 50 ERP environments across 4 servers from

AIX to HPUX.

During this project we moved around 5 TB data from AIX to HPUX Itanium servers across the

environments.

Roles & Responsibilities:

Installing, configuring & maintaining Oracle Database 11G2

Installing Patches (OPatch) on top of 11g2 to go for particular version

Managing Users and Securing the Database

Managing Table spaces, Data files, Archived Redo Logs, etc

Multiplexing of Redo Logs, control files

Trouble shooting & resolving Listener issues

Database maintenance activities including shutting down database, taking cold backup &

then bringing up the database

Taking logical backup using traditional export (exp) & Datapump (expdp)

Restoring database using traditional import (imp) & Datapump (impdp)

Implementing Database Backup & Recovery Strategies

Configured RMAN level 0 & level 1 backups

Recovering database using RMAN backups in case of environment failure

Analyzing database performance issues by taking AWR, ASH and ADDM reports

Performed database migration using exp/imp, expdp/impdp

7. Organization : Infor Global Solutions India (pvt) Ltd.

Client : Frigo Glass Corporation

Role : Senior Technical Consultant – CoE Application

Management Services

Duration : Aug 2009 Till date

Frigo Glass is the leading player in the Ice-Cold Merchandisers market using ERPLN and different

locations worldwide.

They approached Infor for the maintenance of 7 critical databases across the world.

Infor fine-tuned their database server and configured RMAN backups at each locations

-6-

Roles & Responsibilities:

Managing Users and Securing the Database

Managing Table spaces, Data files, Archived Redo Logs, etc

Multiplexing of Redo Logs, control files

Trouble shooting & resolving Listener issues

Data base fine-tuning

Generating AWR and ADDM reports

Database maintenance activities including shutting down database, taking cold backup &

then bringing up the database

Taking logical backup using traditional export (exp) & Datapump (expdp)

Restoring database using traditional import (imp) & Datapump (impdp)

RMAN backup configuration

Maintaining RMAN backups.

8. Organization : Infor Global Solutions India (pvt) Ltd.,

Role : QA

Duration : Aug 2007-2008

Enterprise Asset Management (EAM) is a Web-Architected, Internet-based Application.

EAM helps companies incorporate Asset Performance Management into every aspect of their

operations and manage capital assets with unprecedented efficiency.

EAM provides life Science, Facilities Management, Manufacturing, Public Sector and other

Organizations solutions they needed.

Roles & Responsibilities:

Test Plan preparation

Test Scenario’s preparation

Performed Functionality, Integration and Regression Testing’s

Maintenance Patch Installations

Test Report Preparation for each Phase

Database Testing.

9. Organization : Infor Global Solutions

Role : QA

Duration : Aug 2005-2006

SSA OA (5.1, 6.0) -Collaboration provides a platform for companies and their business partners to

share business documents and send alerts. Collaboration makes information more accessible and

enables business partners to interact online. This decreases cycle times, improves the accuracy of

communication, and reduces the overall cost of doing business.

Roles & Responsibilities:

Participated in Test Plan preparation

Test Scenario’s preparation

Test report preparation for Each Phase

Performed Functionality and System Testing

-7-

10. Organization : Infosys

Client : State Street Bank

Role : Software Test Engineer

Duration : Aug 2003-2005

SSB is a financial institution that holds stock certificates and other assets on behalf of a

corporation or individual. Global Corporate Action Processing System (GCAS) covers the collection

and consolidation of corporate action data from various information sources.

The system then uses this information to generate and send corporate action

notifications to investment managers.

The responses are received from the investment managers and appropriate instructions

are built.

Upon release of an instruction or on the applicable posting date, posting to custody,

accounting and other systems are made.

Finally, settlement corporate action confirmations ar e captured and matched on to the custody

and accounting systems

Roles & Responsibilities:

Involved in the preparation of test plan

Performed Functionality and UAT Testing

Involved in Test case writing and Execution

Participated in DP Analysis

Oracle Real Application Cluster (RAC)

Installing oracle 11G cluster software

Configuring shared storage

Creating the oracle groups & user accounts

Installing the required OS patches

Installing the required cluster ware specific patches(on both nodes)

Configuring ssh for user equivalence(both nodes)

Installing the cluster ware & ASM in to single home

Installing the database software

Database creation using ASM

Managing Redo log groups in RAC

Managing Voting Disk & OCR

Backing up & Recovering Voting Disks

RAC administration through srvctl

Managing backups & recovering the OCR using OCR backup files

Client side & Server side load balancing

Transparent Application Failover(TAF)

Configure OEM DB control for an existing DB using EMCA in RAC

Adding new node to Oracle RAC 11g Cluster on Linux

Deleting a node from the cluster

Database Migration from Non-RAC to RAC using RMAN

-8-

Soft skills:

Strong written and oral communication skills, including the ability to efficiently

communicate with any level of hierarchy in an effective manner.

Capable of working under pressure with determined hard work, possession of

excellent organization skills in order to meet challenges and tight deadlines.

Extremely organized, with demonstrated communication, sound technical cred entials

and leadership skills and ability to contribute to business growth.

Committed and hard working with a Quest and zeal to learn new technologies and

undertake challenging tasks.

Ability to have a detail oriented plan and prioritize multiple time sensitive projects

with in short span of time.

Past Work Summary

Worked as a QA in Infosys, Mysore between 2003-2005 through Khodays Technologies Limited

Education/Professional Background

- Master of Computer Applications from JNTU University, India – 2002

- Bachelor of Science from JNTU University, India – 1999

Certifications:

- OCA - Oracle Certified Associate

Courses:

- Oracle 11G Database Administration

- AIX Foundation

- Informix Foundation

- Oracle Real Application Cluster (RAC)

Personal Details:

Name : Narendra Allapu

Date of Birth : 11th May, 1977

Sex : Male

Nationality : Indian

Marital Status : Married

Passport No : J3425205

Languages Known : English, Hindi & Telugu

Address : Flat No 102, Amrutha Sai Residency,

Eshwaar Villas Road,

Nizampet, Kukatpally,

Hyderabad 500090.

-9-

Contact this candidate