Supply Chain Db2 Dba
Resume:
Lekharaju Ennam
Email *********.*****@*****.***
Certified Oralce10G, DB2 UDB V9, PostgreSQL9.6 DBA & AIX System Admin.
SUMMARY:
More than 27 years of experience in Software Analysis, design, development, testing and implementation.
Specializing in developing Application Software using IBM Mainframes, RDBMS and Client /Server environment.
For more than 19 years, I am being involved in managing the database administration including Oracle7/8/8i/9i/10g/11g, DB2 UDB 6/7./8.X/9,10.5/11.x & DB2 on RDBMS’s on HP UNIX, Sun Solaris, and AIX & Z/OS.
Experienced in Infrastructure Deployment Installation, Configuration and Administration of ERP Applications such as PeopleSoft 8.3 HRMS 8.8, FIN8.1x/8.44, and PeopleSoft 8.1 x Supply Chain Management, EPM, Portal, Student Admin 8.21, and CRM 8.8/9.0/9.2 with Oracle 9i/10g/11g/12C DB2 UDB /DB2 V6/7/8 on OS/390 as backend in multi-platform environments.
Around two year experience on Amazon Web Services (AWS), have experience with PostgreSQL Admin .
Migration from onPrem to cloud AWS, Azure
Build DB2 LUW on AWS EC2 instance and RDS
SKILLS:
Hardware
RS/6000 SP & Pseries, E Series, Power 5 Servers, SUNW sparc,ESS-800, DS4800,DS6800,DS8000,Ultra-Enterprise,HP Tru64, EMC CLARiion CX series. Dell 1650,6650, Dell PowerEdge 1950,2900, Blade Servers HS20-21
Operating Systems
Windows NT/2000 to 2012,MVS, Z/OS,AS/400, HP/UX 10.0, Sun Solaris 8/9/10, AIX 4.3/5.3,6.x/7.x, Linux 4 to 7
RDBMS
Oracle 7/8/8i/9i/10g/11g/12c,18c,19c, DB2 UDB V6.1/7.x/8.x/9/10/11 & DB2 V4,5,6,7,8,9,10 OS/390/Z/OS, DB2 i Series,SQLServer2000/2005/2008/2012, Informix, SYBASE
OSRDBMS
PostgreSQL
RDS
Oracle,MYSQL,PostgreSQL,SQL Server
Cloud Solution
Amazon Web Services (AWS ), Microsoft Azure, Google & IBM SoftLayer
Big Data
MongoDB, Hadoop
ERP
PeopleSoft 8.14 (Supply Chain Management), PeopleSoft8.3, HRMS 8.8/8.9,Student Admin 8.42,9.0, EMP,Portal 8.4,9.0, 9.1 CRM PeopleSoft design tools, PSADMIN, Data mover, query, upgrade Assistant, Seibel V7.x,SAP V 3/4.6, DBACockpit,SAP DB2Admin, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT, and BRTOOLS Utilities, Lawson HCM
Clustering Tools
IBM HACMP 5.1, TSA, Xkoto GridScaleServer, EMC, Veritas Clustering,Flash Copy, Peer to Peer remote Copy(PPRC), Oracle RAC ( Real Application Cluster),DataGaurd,ASM, Quest SharePlex for Oracle, DataGuard
Disaster Recovery
VMWare Tools, IBM Tivoli Storage Management(TSM), Flash Copy, Peer to Peer Remote Copy(PPRC)/, EMC SnapView,MirrorView, Sun's StorageTek Virtual Storage Manager (VSM). VERITAS
WebServes
IBM Web Sphere, BEA WebLogic,IIS, iPlanet, Oracle 10G application Server
Connectivity Tool
IBM DB2 Connect, Relational Connect, Oracle Gateway
Replication Tool
Data Propagator,DB2 Replication Center (SQL Replications, Q Replications), WebSphere ( information integrator), Oracle Streams,IBM InfoSphere Replication, GoldenGate, IBM CDC
DBA Tools for Oracle
Platinum DBvision, Tsreog, BMC Patrol, SQL Backtrac, Oracle, Enterprise Manager, RMAN, Import, Export, Oracle Data Guard, Flash Back, Automate Storage Management(ASM), Grid Control, DBCA,DBUA,SQL*Loader, SQL*DBA, Replication Manager, Quest Database Admin Tools, Oracle Ware House Builder
DB2 OS/390 tools
Platinum Database Analyzer, Plan Analyzer, Subsystem Analyzer,
SQL Easy, RC/Migrator, RC/Security, Log Analyzer, CA Unicenter, CA7
DB2 UDB tools
BMC Patrol for DB2 UDB, IBM Relational Connect, DB2 Connect, Data Propagator, Quest Central for DB2 UDB/, BMC Web DBA,
DGI SQL Guy, Wise Guy, MQ Series,IBM Data Studio .
Data Warehousing
Oracle Discoverer, Oracle Express, IBM InfoSphere,Informatica Power Center & Cloud, MicroStrategy, Cognos, Snowflake
Design
Designer 2000, Erwin, ER - Studio
Front End
Developer 2000 - Forms 4.5, Reports 2.5, Graphics 2.5, Power builder 5.0
Languages
COBOL, C, Pro*C, JCL, Perl, Python
CERTIFICATION:
Oralce10G, DB2 UDB V9, PostgreSQL DBA & AIX System Admin.
INDEPTH EXPERIENCE AND EXPERT KNOWLEDGE
RDBMS DBA support
Sr. DB2 LUW DBA /Architect
Sr. DB2 Z/OS DBA
Sr. DB2 DBA AS/400
Sr. Oracle DBA/Architect
Sr. SQLServer DBA
Sr. PostgreSQL DBA on AWS, Azure / for migration
ERP solution
PeopleSoft Admin/Architect ( Install, upgrade & Migration )
SAP Basis Support
WORK EXPERIENCE
DB2 LUW DBA CITI from 2020 Jan to till date
Install, fix pack apply for DB2 LUW from version 10.5 to 11.5 on AIX and Linux.
Build and automate HADR using DB2 cluster Manager (db2cm), that also called as pacemaker .
Build scripts to monitor DB health check, memory and CPU usage, locks, long running application, expensive SQL schedule as cron job on AIX, also using ContrlM scheduleling utilities
Build and schedule cron job
Database maintenance monitoring and alert automation including fragmented tables and indexes send notification
DB2 LUW, Z/OS and Oracle DBA for Health interactive Cloud for multiple states May’18 to 2019 Dec
Deploy Health Interactive Cloud on IBM cloud ( SoftLayer) Linux 7.2 DB2 V10.5,V11, including DB2 Docker container, DB2 warehouse.
Build environment automation using Jenkins automation, this including install binaries, instance creation, DB cloning from source backup using db2relocatedb and redirect restore
Deploy Backup as per SLA Retention policies, DB health check, alert automation( Instance, DB status, resource usage, memory,long running SQL, db2dia.log critical, severe, error message )
Deploy Data Encryption at transits ( TLS 1.2) Data at rest using DB2 native encryption for standalone and HADR environments.
Automate DB maintenance ( RUNSTATS, REORG, rebind, object validation ) using shell scripting and store procedures
Performance tuning, troubleshooting & user supporting .
Database Architect in Health care industry DB2 LUW V10.5/11 on Linux IBM cloud .Which includes getting the requirements from the client, estimate required resource, build plan, work with infrastructure team, build the environment, automation of deployment, as per
Health care SLA design backup & recovery plan.
Setup 99.99 to 99.999 availability, 3 hours RPO and 15 RTO DR plan.
Build health care solution deployment for 10 states, which including OH, WY,VA,KY,MI,MT states
Building SQL standard for development team
Analyze SQL and program units procedures and function and triggers, make sure SQL written optimized way
Optimizing and tuning old procedures like replace UNION and UNINION ALL with case statements, avoid not condition, reduce outter join as much as possible.
Conduction knowledge sharing session with development to build code with best optimized way, avoid cartesian join and full table scans.
Environment :
DB2 LUW V10.5/11.1/11.5 Fix pack 10, DB2 Z/OS V11, Oracle 11g and 12c on IBM cloud SoftLayer and RHEL V7.2.
DB2 LUW DBA & Oracle DBA for Different Clients June’16 to April’18
Global Foundries, Tyco, FLBCBS
DB2 LUW DBA On AIX & Linux
Gathering Hosting Data center details.
Build scripts extract following details at hosting data center
Server Configuration
Based on extracted details, estimate required resource hardware, memory, disk space
Build scripts build environment from extracted details from hosting data center.
Re-catalog instance node from hosting hostname to client hostname
Migration of 2000 DB2 instance - some of them as lift and shift, change hostname, change network change from hosting to client network. Re-catalog node with new hostname .
build servers, software, create instance, build database from hosting database backup, catalog instance & DB with new hostname .
Migration from DB2 V9.7/10.5 on AIX 7.1 to Linux V7.1
Configure HADR & HACMP for different application as per nature of the application.
Support and maintenance DB2 LUW environment from V9.5 to 10.5 on AIX V6/7 and on Linux .
Setup DPF environment 4 Physical 6 logical nodes
Create maintaining MDC, Partition tables in DPF environment.
Setup “Q” and SQL Replications single & bi directional for different source and target on AIX and Linux environment.
Upgrade DB2 from V9.7 to 10.5 /11 on AIX V7.1
Design, setup Backup and Recovery using TSM.
DR site with flash copy and using snapshot backup.
Build Scripts to automate environment monitoring & maintenance using db2pd, db2batch, db2advisor, db2diag and admin view ( SYSIBMADM)
Maintaining including RUNSTATS, REORG
Design Backup incremental, Delta and full back up as per SLA, design DB archive, purging.
Building SQL standards for devilment team to write code best optimized way
Tuning programing units procedures, function, triggers SQL statements by running explain, run index advisor ( db2advis), use global temporary tables instead in sight views, avoid sorting as much as possible, reduce I/O, keep most frequently used lookup tables in buffer .
Did Multiple migration DB2 Z/OS environment to DB2 LUW on RHEL
Environment :
Oracle10gR2 on Aix 5.3, Oracle12c on Red Hat Enterprise Linux,Baan ERP V5
SiView, DB2 Z/OS 10, DB2 LUW V9.5 to 10.5 on AIX V6 & V7, HARD, HACMP, TSM
IBM xSeries & pSeries Serves DS6400 storage, Cisco Unicenter with EMX Vmax storage.
Beacon Spyglass, Indianapolis, IN Feb’14- Jan’16 (support Multiple Clients)
DB2 DBA
Performance tuning by analyzing snapshot of DBM, DB, BP, TBS, Table, Application and locks and expensive SQL statements.
Based on record length, activity of the table moves tables into bigger page size, its own tablespaces
Build scripts to automate database maintenance like RUNSTATS, REORG, bind packages, validate & recompile programing units (Procedures, Functions, Triggers)
Create 12 logical node database with 4 BP and 4 tablespaces with 20 tables, load data into tables up to 20M records into tables
Implemented incremental & delta backup
Merger all delta backup instead of taking full backup
Install & configure DB2 high performance unload design test case & tested
Unload large table from tablespaces, extract data from DB backup, recover drop table from DB backup
Migrate whole database from one server to another.
Design and implementation of backup recovery strategy
Setup HADR
Setup and build DPF environment, install, configure & testing merge backup, high performance unload and recovery expert.
Build, Supporting & maintaining Pure Scale clustering environments
Setup 2 node Purescale environment on AIX with TSA and DS series storage
Work with System & storage team to design & build GPFS volume groups
Configure & setup
Reliable Scalable Cluster Technology (RSCT)
Resource monitoring and control (RMC) subsystem
RSCT core resource managers
RSCT cluster security services
Topology Services subsystem
Group Services subsystem
Configure & work with Cluster Cache Facility (CF)
Environment :
DB2 V10.5 on Linux, DB2 V10.5 DPF, Fix Pack 5 on AIX, Tomcat, Websphere, SAP
IBM xSeries & pSeries Serves DS6400 storage, Merge Backup, High Performance Unload,Purescale
Oracle 10gR2, 11gR2 on Linux with RAC 3 nodes.
University of Texas, Arlington, TX Jan’12 to Oct’14
PeopleSoft Oracle DBA/ System admin
PeopleSoft modules HCM, CRM, Financial, EPM PeopleSoft tool upgrade to 8.51.15
Applying PeopleSoft Bundles, patches, TAX update to update using change assistant .
Web logic upgrade to 10.3.5
Oracle upgrade from 11.2.0.2 to 11.2.0.5, apply critical patches
As part of consolidation all campus of the environment and upgrade building all new environments for all PeopleSoft modules.
Setup Integration Broker Gateway server and agents and single sign on for all environments.
Environment re-fresh environment to environment, production to test and development as per user requirements using RMAN duplication and file system level
Automated Environment monitoring for PeopleSoft and Oracle database, disk spaces and resource usage, alerts .
Building scripts startup and shutdown the environments including database, application, batch and web server.
Database backup and recovery strategy and implementing physical and logical backup using RMAN and data pump.
Managing Oracle RAC with 2 nodes for all production database on Linux Dell PowerEdge R7 and Qlogic storage .
Maintaining and supporting non- production environment.
Performance tuning at database, application side and SQL tuning using Oracle GRID control, AWR, ADDM, tuning packages .
Implemented horizontal slicing of an Oracle Exalogic machine quarter rack for Oracle Solaris and Oracle Linux physical environments.
Environment :-
PeopleSoft FSCM, HCM, CRM, EMP 9.1 and Campus Solution 9.0/9.1, tools 8.51.05/8.51.15 on Oracle 11gR2 Linux and AIX People, IBM P575 Servers and VMware ESX4.1 and Qlogic storage, TSM for tape managements, Quest STAT for change management, Exalogic 3.2, CA WA ESP
Agrex Inc, Overland Park, KS March’11 – Dec’11.
PeopleSoft SysAdmin/Architect.
Environment :
PsoftSoft FCM 9.1, tools 9.51 on DB2 V9.7 on Windows 2008 R2, WebLogic 10.3
IBM x series Serves DS3400 storage, VMware ESX4.1
DST System –Oracle Consulting Jan’11 to Feb’11
Senior Consultant Oracle USA, Inc.(Advanced Technology Services).
Environment :-
PeopleSoft FSCM 8.9/9.1 People tools 8.49/8.50 on DB2 LUW V9.5 bits on AIX 5.3 P570, spark servers (880,480).
College of Lake County,Chicago, IL Feb’09 to Dec’10
Sr. PeopleSoft DB2 DBA
DB2 upgrade from V7.2 to V9.5 and PeopleSoft upgrade from 8.8 to 9.0
Environment :
PeopleSoft HRSM 8.8, EPM 8.46, People Tools 8.46
DB2 V7.2/9.5 on AIX 5.3 on IBM DS4700 storage with SVC, P5 and P6 servers
University of North Dakota, Grand Forks, ND Jan 2008 to Jan’09
System Architect/Sr PeopleSoft Oracle DBA
Environment :
Oracle10g/11g,SQL Server 2005 on windows 2003 for PeopleSoft Student Admin 8.21/9.0, People Tool 8.43/8.49, Tuxedo V8/9, Change Assistant,Data Mover, PS Query, PeopleSoft Application designer, WebLogic V8/9,VMware ESX,DS6400 storage, with IBM TSM
University of Florida, Gainesville,FL June 2007 to Dec ‘07
System Architect/Sr. PeopleSoft DB2/Oracle DBA
Environment :
PeopleSoft Financial, HRMS, EPM 8.8/9.0 people tool 8.46/8.48,WebLogic version 8/9,Oracle 10g Application Server, Informatica, Cognos,tuxedo 8.1, DB2 UDB version 8.2/9.1,Oracle10g release 2.03, Oracle Gateways, SQL Server 2000/2005 on Win 2003, SuSE Linux version 10,IBM BladeServer HS20-21,DS4800,DS8000,EMC CLARiiON CX300/700 3-40, SnapView,
SnapMirror, SnapCLone, SnapCopy, IBM P650,P630 servers,
Scholastic Book Fairs, Lake Mary, FL Jan 2007 to May’07
PeopleSoft Oracle/DB2 /SQL Server DBA
Environment :
PeopleSoft CRM version 8.8/9.0 people tool 8.46/8.48,Web Sphere version 5.x/6, Oracle 10g Application Server, tuxedo 8.1, DB2 UDB version 8.2,, Oracle10g release 2.3, SQL Server 2005, DB2 V5.1 on AS/400,AS/400,Windows 2003, SuSE Linux V10,Dell 1650,6650, PowerEdge 1950,2900
Florida A&M University, Tallahassee,FL Jan 2004 to 2006 Nov
Sr. PeopleSoft Oracle /DB2 UDB DBA / System Architect
Environment :
RS 6000 ESS 800,DS8000,pSeries 690, 650,630s, AIX 5.2/5.3,DB2 on OS/390,WIN Tivoli storage Manager, HACMP, IBM Flash Copy, Peer-to-Peer Remote Copy,DB2 UDB V7/8.2.x, Oracle 9i/10g,SQLServer2000/05 PeopleSoft Student Admin V8.21, Financial 8.43, HRMS 8.9,Portal 8.44, EPM, CRM, Seibel V7.X, App designer, Data Mover, upgrade assistant, WebLogic V5/6/7/8.
YUM Brand, Louisville,KY Sept 2003 to Dec’03
Verizon, Irving,TX Jun 2003 to Sept’03
Sun Solaris V8, WebLogic 6 & 7, IPlanet Admin, Oracle 8i/9i & DB2 UDB V8 DBA
World Savings, San Antonia, TX Oct 2002 to May 03
DB2 UDB DBA & Data Warehouse Architect
Belk Inc., Charlotte, NC June 2002 to Sept’02
Environment:
DB2 7.1 on OS/390, PeopleSoft HRMS 8.3, People Tools 8.118, AIX 4.3 on RS/6000, DB2 Connect Enterprise Edition 7.2 PK 7, DB2 Connect personal edition 7.2, Web Server IIS, Bea WebLogic, Win2k Load Balancing Cluster, TUXEDO
Sprint North Supply, Garner, KS, USA Jan 2001 to March 2002
DB2 UDB EE DBA on PeopleSoft8 Primary,
DB2 UDB DBA EE for CRM Seibel & WebLogic as secondary
DB2 UBD EEE for Data warehouse Project
EDUCATION
B.Sc. 1989 from Venkateshwara University, Tirupati AP, India
PGDCA 1991 from Nagarjuna University, Nagarjuna Nagar AP, India
Contact this candidate