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-