LEKHARAJU ENNAM

Email ac4jn4@r.postjobfree.com

850-***-****

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 . with AWS and on Linux, extensive knowledge with MongoDB with Docker and AWS.

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, DB2 UDB V6.1/7.x/8.x/9/10/11 & DB2 V4,5,6,7,8,9,10 OS/390/Z/OS,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

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 Data Warehouse Center, IBM Ware House Manager, MicroStrategy,Informatica,Cognos

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

Roles, responsibilities & Skills

PostgreSQL DBA

Design create VPC on AWS, Implementing RDS on AWS

Install, configure PostgreSQL in Linux environment, including cluster setup

Designed, developed and maintained PostgreSQL database architecture, create database and

Migrate database from hosted environment to AWS RDS

Prepared and updated scripts for various administrative tasks.

Maintained documentation of scripts in all source repositories.

Developed scripts for database monitoring and tuning procedures.

Conducted Linux administration activities and managed test databases.

Evaluated database performance and executed table maintenance processes.

Tuning Vacuume

Optimizing the administration,development processes through Chef and Puppet.

Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.

PostgreSQL shiriding using Citusdata with AWS implementation .

Well versed with CItusdata .

Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.

Have knowledge about other open Source DBs like Hadoop Hbase and Couch DB

Migration Service from RDBMS( Oracle, SQL Server ) open Source like MYSQL to PostgreSQL

Backup and recovery, using pg_dump, cluster backup using pg_dumpall, restore using pg_restore, archive log setup using pg_basebackup, PITR, replications.

Comfortable with openscg tools like BigSQL, pgDevOps for monitoring, performance, deployment . pgHA for high availability & load balancing .

Extensive skills on Enterpise Advance tools like

oPostgres Enterprise Manager (PEM),

oBackup And Recovery Tools(BART),

oEDB Replication Server

oEDB Failover Manager (EFM)

oBuild PostgreSQL as DBaaS as per client requirements, build option has 3 options

SMALL 2 vCPU 4GB RAM with 60 GB diskspace

Medium 4 vCPU 16 GB RAM 128 GB Diskspace

Large 8 vCPU 32 GB RAM 512GB to 1024 GB ( 1 TB) Diskspace

With following file system

/edbpg/cluster for PGDATA

/edbpg/data01/02 for Tablespace

/edbpg/temp01 for Temp tablespace

/edbpg/wal for WAL logs

/edbpg/syslog for system logs

Indepth experience & expert knowledge for RDBMS DBA support

Sr. DB2 LUW DBA /Architect

Sr. DB2 Z/OS DBA

Sr. Oracle DBA/Architect

Sr. SQLServer DBA

Indepth experience & export knowdge for ERP solution like

PeopleSOft Admin/Architect ( Install,upgrade & Migration )

SAP Basis Support

Amazon Web Services (AWS)

In depth Knowledge of core AWS Products:

Amazon EC2 Linux,Windows.

Amazon ELB (Elastic Load Balancing),

Amazon OpsWork and CloudFormation (assisting customers with Chef and Puppet).

Identity Access Management (IAM )

AWS single sion using ping Identity

Setup SAML AWS federation access

Amazon RDS Deployement & support for MYSQL, MS SQL Server, PostgreSQL and Oracle .

Amazon CloudFront – Global Content Delivery Network service

AWS Storage services: S3, Glacier, EFS, Storage Gateway and EBS.

Mobile Services: Mobile Analytics, Device Farm, Cognito, SNS.

AWS Application services: SES, CloudSearch, SNS, AppStream, SQS and Elastic Transcoder.

Amazon Redshift,Lambda, DynamoDB

Amazon Route 53 Domain Name System Web Services .

Have good knowledge on AWS security tools and services: AWS Security Model, IAM (Identity Access Management), ACM (Amazon Certificate Manager), Security Groups, Network ACLs, Encryption, MFA (Multifactor Authentication).

Migration Services from client Infrastructure to AWS including Data center, RDS Solutions.

Working with client to migrate Accounting & Financial Solution Software as a Services (SaaS) to migrate into AWS .

Developing Proto type to clients to migrate there application on VB and dot net on SQL Server 2008 windows 2012 to AWS cloud, after proto type tested, accepted clients to migrate is more than 1000 in Middle East ( UAE and around ).

Well versed with Big Data implementation in AWS including MongoDB and Hadoop.

Have good knowledge with other cloud solutions like Microsoft Azure, Google and IBM Softlayer Solution & Services.

Working on Certification on AWS Devops System Admin & Solution Architect .

WORK EXPERIENCE

Sr. PostgreSQL DBA Incisive Technology, Tallahassee,FL since Oct’2014 to till date

Supported following client in this duration :-

BeaconSpy Glasss,Global Foundries, EDB Enterprise,BCBS of AK

Supporting different clients as Integration, migration & supporting and maintening PostgreSQL on Linux, Windows and AWS and docker contrainer services.

One is Beaconspyglass( processing claims for different insurance companies)

doing onging support when required, they didn’t have in house expertise, System DBA work, including install, upgrade and also synce data between BD2 LUW on Linux and PostgreSQL.

Install, configure PostgrSQL on Linux

Work with System team to build server, allocate resource

As per PostgreSQL which is part of EnterpriseDB .

Install pre-required Java, install PostgreSQL/ Advance Server, configure, build cluster, uptimizing parameter of PostgreSQL( postgresql.conf ), configure connectivity, build cluster and database, tablespace, port data from DB2 LUW to PostgreSQL.

Install, configure connection pooling using pgPool and pgBouncer

Install & configure other EnterpriseDB products Poestgre Enterprise Manager (PEM), Backup and Recovert Tool ( BART) centralized backup solution, EDB Replication to replicate data for homoginiuos and heteraginous .

Cloning the environment as per client request, Performance tuning at cluster, DB, Tablespace, table, session, Application & SQL .

I did work with small clients through upwork or integration partners and personnels .

Here is activity for those clients :-

Install, configure PostgreSQL in Linux environment.

Configure EDB Postgres Advance server

Designed, create database, Tablespaces and schema and objects like tables, view indexes, programining units procedures, functions.

Design build security policies, users, roles and grantining required privileges at DB, object level

Prepared and updated scripts for various administrative tasks.

Developed scripts for database monitoring and tuning procedures.

Install, configure connection pooling using pgPool and pgBouncer

Evaluated database performance and executed table maintenance processes.

Tuning Database parameters, Slow running SQL queries

Performance tuning at cluster, database and object level using PEM and OS and SQL statements

Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.

Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.

Monitoring and tuning as per application and environment requirements, including gather statistics, adjust shared,work buffers, adjust Vocuumining Auto and adjust parameters,Reindexing

Postgres Replication Serever with single and muti Master replication between different databases

Setup bi-directional replication for hetraginous environment, well versed with replication tool Citusdata & EDB Replication Server .

Setup backup & recovery using pg_dump, pg_dumpall, restore pg_restore, Pg_basebackup Centralized backup Solution using BART

Build PostgreSQL as DBaaS as per client requirements, build option has 3 options

o SMALL 2 vCPU 4GB RAM with 60 GB diskspace

oMedium 4 vCPU 16 GB RAM 128 GB Diskspace

oLarge 8 vCPU 32 GB RAM 512GB to 1024 GB ( 1 TB) Diskspace

With following file system

/edbpg/cluster for PGDATA

/edbpg/data01/02 for Tablespace

/edbpg/temp01 for Temp tablespace

/edbpg/wal for WAL logs

/edbpg/syslog for system logs

Setup archive logs and replications, Point in time recovery (PITR)

Setup clustering environment with pgCluster and internal and external tools

Migration Service from RDBMS( Oracle, SQL Server ) open Source like MYSQL to PostgreSQL

Massive load data EDB*loader in direct path into PostgreSQL in direct path.

Design, deploye PostgreSQL on AWS with multi Availability Zones .

Migrate database from hosted environment to AWS RDS

Conducted Linux administration activities and managed test databases.

Supportining & maintaining MongoDB environment like Install, configuration MongoDB on Linux .

Automate the process using programing language like Python .

Environment monitoring and maintaining using Postgres Enterprise Manager (PEM).

Integration with other NoSQL DBs MongoDB, Greenplum,Cassandra

Environemnt :

PostgreSQL V9.4, 9.5,9.6 on Linux RHEL, Windows 2012 R2, AWS with Multi AZ

PostgreSQL tools pg_dump, pg_dumpall,pg_restore, PgCluster, pgAdmin, Postgres Enterprise Manager (PEM),EDB Replication, ( Bart Backup and Recovery) BART, Psql,

3rd part tools Citusdata, openSCG tools BigSQL, pgdevops, pgHA,Python

University of Texas, Arlington,TX Jan’12 to Sept’14

PeopleSoft Oracle DBA/ System admin

PeopleSoft modules HCM, CRM, Financail, EPM PoepleSoft 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 compus of the environment and upgrade building all new environments for all PeopleSoft modules.

Setup Integration Broker Gateway server and agents and single sigon 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.

PeopleSoft FCM 9.1, tools 8.51 on DB2 LUW 9.7 Windows 2008 R2 Install stabilization and citification .

Sizing and estimate resource ( CPU, Memory and Disk space ) for DEV, TST environments and build from SYS on IBM x series Servers with VMware ESX 4.1 DB, Batch server on one virtual servers, Web and Application Server another virtual server.

Build PRD environment with 2 cluster 2 web servers, 2 application Servers and Database with HADR.

Apply PeopleSoft application and tools patches, TAX update .

Migrate PeopleSoft external and internal objects.

Environment cloning from environment to environment.

Database performance tuning at Instance, Database, Bufferpools, Tablespaces and SQL tuning .

PeopleSoft application module and process based performance tuning

Maintenance and monitoring with performance Monitor.

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).

PeopleSoft upgrade assessment fro FSCM from PeopleSoft V8.9 to 9.1 and People tools from 8.49.10 to 8.50 SP3 following areas

Storage ( EMC and 3Par storage)

System

Servers Database on Oracle11g on AIX V5.3 ml 11 on P570

Application, batch Server, Web Server on Solaris 10 64 bits Sparc Sun-Fire-880, 480 servers

Convert Web server from Oracle Application Server to WebLogic 11g (10.3.2)

Upgrade best practice

Environment :-

PeopleSOft FSCM 8.9/9.1 People tools 8.49/8.50 on Oracle 11g 64 bits on AIX 5.3 P570, sparc 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, PeopleTools 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

PeopleSoft Student Admin migration from SQL Server 2005 to Oracle10gR2 on windows 2003 .

PeopleSoft Student Admin upgrade from 8.21 to 9.0 along with tools upgrade to 8.49.09 by using Change Assistant .

Involved as part of upgrade by running compare report, DDD Audit to sync object between database and PeopleSoft tools tables, Sys Audit report to validate PeopleSoft objects, Project migration from environment to environment .

Applying PeopleSoft patches, Bea WebLogic upgraded to V9 to service pack 2.

Setup RAC 2 nodes with ASM environment on IBM DS6400 storage with VMware ESX for PeopleSoft Campus Solutions applications.

Building Application Server, Web Server using Bea WebLogic and batch server .

Environment re-fresh (Database,Application Server,PRCS,WebServer)

Automate the Database maintenance using AWR,ADDM,, Performance tuning .

Setup job to get top10 SQL, high wait events, Objects with SQL statements, I/O activity with dbms_workload_repository package.

Setup database backup jobs using RMAN, RMAN configured to TSM for tape backup.

Database and environment re-fresh using RMAN and IBM hardware utilities Flash Copy .

Also I involved in Setup Oracle streams from Solaris to windows for Oracle RAC environment with down streams ( one source and multiple targets ).

Environment :

Oracle10g/11g,SQL Server 2005 on windows 2003 for PeopleSoft Student Admin 8.21/9.0, PeopleTool 8.43/8.49, Tuxedo V8/9, Change Assistant,Data Mover,PSQueqy, 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

Oracle10GR2 on Linux

Setup Oracle RAC with two nodes on IBM Blade Servers, SuSE Linux V10, Oracle GRID.

Development on IBM Blade Server rac-3 and rac-4, production rac-5 and rac-6 for PeopleSoft Student Admin V9.0 and EPM V9.0.

Develop Backup and Recovery strategy, implementation.

Database cloning from environment to environment by using RMAN, SRVCTL.

Build RMAN scripts for Backup,

Database monitor & performance tuning

Setup scripts for Database cloning by using RMAN., Configure RMAN with TSM

We are working on Oracle database backup also by using EMC SnapView,SnapMirror.

Automate the Database maintenance using AWR,ADDM,, Performance tuning .

Setup job to get top10 SQL, high wait events, Objects with SQL statements, I/O activity with dbms_workload_repository package.

DB2 UDB on AIX

Build scripts and Setup monitoring jobs for Top 10 SQL, Tablespaces space usage, LOCKS, Database,bufferpool activity.

Performance tuning SQL, database, instance level.

Database cloning by using EMC SAN utilities SnapClone, SnapCopy, DB2 utilities DB2relocatedb, re-direct restore process.

Right now backup windows is 2 -3 hours, that effecting PeopleSoft Financial and HRMS batch processing and online processing .

By get ting familiar with EMC storage technology like SnapView, SnapView software leverages the power of EMC CLARiiON networked storage systems to create local point-in-time copies of data that can be used for testing, backup, and recovery operations. And SnapView now features consistent split capabilities to ensure data coherency for all your local replication needs. With the flexibility to create pointer-based, space saving snapshots and highly functional, full-volume clones, you're able to meet a mix of service levels with minimal operational impact.

Take EMC SnapShot ( same as IBM FlashCopy) of file system of production LUNs mount it in stand by server, take as regular TSM backup.

Implementation of Zero down ( less than minute ) time backup plan using EMC SnapView and SnapClone for DB2, we use same for data clone and or replications, by using DB2INIDB DB2 utility as snapshot ( for cloning, ) mirror ( backup) .

Production database cloning into Reporting database using EMC SNAP View every night, taking snap from production filesystem into Reprting server, rollforward into point in time.

DB2 UDB Upgrade from V8 to V9 on AIX.

Applying DB2 fix pack for Database and application,batch servers, and also for Cognos, informatica

System monitoring, performance tuning for AIX, Linux.

PeopleSoft Admin :

Upgrade from PeopleSoft Financial from 8.8 to 9.0 and migration from DB2 UDB V8.2.7 on AIX to Oracle10g on Linux .

PeopleSoft Performance tuning using Performance Monitor (like PeopleSoft ping, Queries PPM_COMP_BUILD_CACHE, PPM_COMP_BUILD_CACHE_ARCH,PPM_TIMEOUT_SQL_REQ

PPM_TIMEOUT_SQL_REQ_ARCH,PPM_APPSRV_START_COUNTS ), Performance Trace

PeopleSoft trace (COBOL,SQL trace)

Setup PeopleSoft Web Server using Bea webLogic, and batch Server

Setup Oracle Streams, configured Oracle Gateways between Oracle 10g to DB2 V8 .

Build SQL Server instance/sub system on SQL Server 2005 on Win2003 server., setup ELT, DS from DB2 Z/OS to SQL Server.

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

Install People Tools, configure Appserv, Process Scheduler, WebServer using IBM Web Sphere, Oracle 10g Application Server, Upgrading People soft CRM from version 8.8 to 9.0 . People tools upgrade from 8.46 to 8.48 migrating PeopleSoft CRM from DB2 V8.2 on Windows to Oracle 10g release 2 on SuSE Linux 10. I create my won scripts to create tablespaces,schema, load data from DB2 to Oracle,by using DB2 Stored procedures, SQL, Oracle SQL*LOADER.

setup Data Guard, RAC for new PeopleSoft application, RMAN scripts for Backup, monitor, export, database cloning by manually, RMAN.

Automate the Database maintenance using AWR,ADDM,, Performance tuning .

Setup job to get top10 SQL, high wait events, Objects with SQL statements, I/O activity with dbms_workload_repository package.

PeopleSoft application, Appengn,SQR,COBOL process, Database, Instance, SQL performance tuning for Oracle 10g release 2 ( 10.2.03).

Maintaining existing PeopleSoft CRM 8.8 on DB2 UDB V8.2.2 Windows 2003 server.DB2 PeopleSoft database replicate from AS/400 by using Vision Solution software Symbiator. Scheduling backup, database maintain utilities, moving data to and from AS/400 to and from DB2 UDB by using AS/400 extract utility and DB2 Load utility, schedule job by using Microsoft job scheduler. Every day will take online backup of production, re-fresh standby/reporting database by using production online backup, roll forward logs, Database cloning for DB2 environment by using re-direct restore process, purging data.

Setup Symantec NetBackup for Oracle RMAN and for file system backup.

Install SQL Server 2005, configuration, setup DTS from AS/400 to SQL Server, Migrate from MS access to SQL Server 2005

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. PoepleSoft Oracle /DB2 UDB DBA / System Architect

Involved in DB2 UDB ESE binary installation, database file system designing, estimating size. Instance, database creation, database cloning using re-directory restore, db2relocatedb, export, load utilizes /methods based on user requirement.

Splitting tables to different tablespaces, based on table accessing activity, to avoid time out, lock contention.

Designing backup & recovery strategy for development & Production databases, setup cron jobs for Backup, database maintenance utilities .

Upgrading instance & databases from DB2 UDB V7 to V8.

Configuring database partition, setting High Availability Cluster Multi-processing (HACMP)/HADR (High Availability Deserter Recovery) for Unix AIX V5.x for DB2 UDB V8.x

Implemented IBM FLASH Copy backup strategy for Production DB2 UDB,Oracle database backup.

Take FlashCopy of Production file system, mounted in reporting server, take backup from reporting database.

PeopleSoft Admin

Install WebLogic, Tuxedo, COBOL compiler, People Tools upgrade from 8.20 to 8.21 for Student Admin, from V8.8 to 8.9 for HRMS .

Automated SQR ftp from NT to UNIX, environment to environment.

PeopleSoft application server configuration creating appserver domains, process scheduler setup & managing .

Configuring Application Server, Web Server, Process Schedulers, application performance tuning,

maintaining application & database integrity, applying patches,Controlling application user security

Building PeopleSoft projects, migrating projects, PeopleSoft internal & external objects from environment to environment, people tools upgrade,applying patches,Tax update by using upgrade assistant

Environment Cloning ( web, Application Servers, Process Scheduler for NT and Unix )

Continued Tuning/Monitoring/Support of production and development domains

Ongoing application program troubleshooting including tracing via application designer, process scheduler, app server, web server, app messaging, COBOL compilation issues

Ongoing response to several Development and Production pages – includes but not limited to fixing paging problems, excessive CPU utilization, Load Balancer issues

Ongoing Developer and Functional workstation configuration – Application Designer

Resolved issue regarding the maximum seat license issue for COBOL Application Server for Production SA. Installed the new Micro Focus Server Express 4.0 SP2 on all three production application server boxes. Regenned all Production application servers and recompiled all production COBOL on said application servers.

Working with developers to tune SQL by giving advise to the development team, changing SQL effective way, adding indexes, to speed up the processes.

AIX System Admin

Perform routine operational AIX 5L system administration duties to include troubleshooting of hardware and AIX operating system issues, daily monitoring of system health, backups and optimization as required.

Expertise is focused on installing, configuring and maintaining distributed AIX operating systems on IBM Pseries(630,650,690), P5 and RS/6000 hardware platforms.

Proficient in establishing and maintaining HACMP in a large enterprise environment- Partitioning of disks, space allocation and maintenance of servers.

Configuring TSM for AIX, NT for Backup & recovery for DB2, Oracle,

Database monitoring,maintenance & performance tuning, Trouble shooting & user supporting

Oracle DBA

Database monitoring,maintenance & performance tuning, Trouble shooting & user supporting.

Install Oracle,upgrade from V9 to 10g, create new, maintaining existing environment .

Splitting large tables into portioned tables.

Migrate from DB2 V8.2 On AIX to Oracle10g.

Set up stand by, failover,load balancing by using Oracle RAC, ASM, Data Guard.

Automate the Database maintenance using AWR,ADDM,, Performance tuning .

Setup job to get top10 SQL, high wait events, Objects with SQL statements, I/O activity with dbms_workload_repository package.

Setup TSM for Oracle RMAN for backup and restore.

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 FlashCopy, Peer-toPeer 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, Appdesigner,Data Mover, upgrade assistant, WebLogic V5/6/7/8.

Education: B.Sc 1989 from Venkateswara University, Tirupati AP, India

PGDCA 1991 from Nagarjuna University, Nagarjuna Nagar AP, India

Contact this candidate