Summary:

• Oracle Certified Professional (OCP 8i, 9i,10G DBA) from Oracle Corporation, USA.Having 15 years of strong technical experience in developing information systems applications in the client/server environments under UNIX, NT, Windows and DOS including 13 years of experience as DBA on Oracle (11G,10G,9i,8I, 8,7.x) on HP UNIX, AIX,LINUX and Windows NT operating systems
• Exhaustive experience in PeopleSoft(EPM 8.9 Planning & Budgeting/HRMS 8.8/8.9/Financials8.8/8.9/9.0) Oracle DBA which involves regular activities like application installation, product upgrades, administration, maintenance, backup and recovery, and performance tuning apart from product support and data and user security
• Specialized working with Oracle/PeopleSoft databases on UNIX/Windows environments and has an excellent understanding of new PeopleSoft 8.4x Internet Architecture (PIA)
• Well versed using Oracle Tools (SQL*Loader, Svrmgrl, Export/Import, data pump, srvctl) Oracle Enterprise Manager,OEM Grid control, SQL* Plus, SQLServer Enterprise Manager and variousPeopleSoft Data Management Tools (Data Mover, Upgrade Assistant, Change Assistant, App Designer, Import Manager, Process Monitor, Configuration Manager).
• Experience in Data Warehousing, Data Modeling and in all aspect of Database Management Systems. Worked as a Team Leader, Business Analyst, Technical architect including Client Interaction, gathering business requirements and data analysis. Strong logical and physical data modeling skills.
• Experience in the complete lifecycle (analysis, design, development, unit testing, systems testing, integration testing and implementation and support) of systems using Designer 2000,PL/SQL, SQL*Plus, SQL Loader, UTL_FILE to Convert Legacy System into data warehouse system.
• Possess good analytical, technical and interpersonal communication skills, good leadership abilities and strongly believe in teamwork. Ability to learn very quickly and apply new skills to existing problems.
• Commitment to quality from requirements through design, construction, testing, and installation

Oracle Certified Professional (OCP 8i, 9i DBA, and 10G DBA)

ERP

EPM 8.9 Planning & Budgeting. PeopleSoft 8.16/8.41/8.43/8.48/8.49 (HRMS 8.8/8.9/9.0, Financials 8.9/9.0) including TUXEDO, Jolt, OFSA

Databases

Oracle V7.3.4/8.0.1/8.0.5/8.1.7/9.2.0.5/6/7,MS-SQLServer 6.5/7.0, MS-Access 97,Oracle 10G Release 10.2.0.4,Oracle 11G Release 11.1.0.6.0/11.1.0.7.0

Debugging Tools

PeopleSoft Trace (SQR/Cobol SQL/App Engine)

People Tools

Upgrade Assistant, Maintain Security, Data Mover, Import Manager, PS-Query, Process Scheduler, Utilities, App Designer

Oracle Tools

SQL*Ldr, SvrMgr, OEM, TKProf, Import/Export, SQL *Net, TOAD,RMAN Repository 6i,Spot Light. Data Pump,RAC,Data Guard,ASM,ADDM,AWR

Reporting Tools

Business Objects,SQR 4.3.2.1, Crystal Reports 4.6/5.0/6.0/8.0, nVision, Oracle Reports 2.5

Languages

PeopleCode, C, Java, SQL3.1/3.3,PL/SQL 2.3 Visual Basic 6.0,Shell Script, JIL

Web Servers

Web Logic 5.1/6.1/8.1 SP2/8.1, Microsoft IIS 4.0/6.0

Operating Systems

Windows 2000/NT/9x, Sun Solaris 2.6/2.8, /HPUX ,AIX, RH Linux 5.2

Software/GUI

Designer 2000,People Tools 8.16.04/8.19.06/8.41.09/8.43.03, VB 4.0/5.0, Oracle Forms 4.5, SQL Enterprise Manager, Net Express 2.0, Symantec PC Anywhere, Visual SourceSafe,Autosys, SAS 9.0 BI Tools, Tivoli

Hardware

Sun Enterprise 450 servers, Compaq Servers 6000/3000/1600/800, Sun Sparc, HP/UX-rp8400,HP/UX-9000, ,AIX ,EMC

Professional Experience 

Confidential, Lexington, KY JUNE 2009 TO TILL DATE 

PeopleSoft Upgrade/ New implementation Lead PeopleSoft/Oracle DBA (Architect)

Confidential is implementing FSCM 9.0/PROTAL 9.0 and upgrading HRMS to 9.0 to replace their business by replacing the aging software solutions with a process driven PeopleSoft based solution thereby taking advantage of integrated software, new technology, enhanced functionality, and creating and opportunity for technology to help drive the business to further excellence. The project covered the following Objectives:

• Support Confidential process improvement initiative by automating and improving business process
• Evaluate and recommend to Confidential third party hardware/software to fill gaps in PeopleSoft
• Validate and upgrade of HRMS application to version 9.0 for those modules already owned by EKPC and implementing e-apps applications and upgrading People tools
• Install Oracle database software on RH Linux 5.2 and convert database for HRMS from Informix to Oracle 11G
• Install new modules for the following functions: HR, Finance & Accounting, Treasury, Supply Chain and ALM
• Development of necessary customizations interfaces and reports to support new environment.

Role:

• Install PeopleSoft application FSCM 9.0/Portal 9.0/HCM 9.0 on Window/Linux environment as part of the new PeopleSoft implementation of HRMS, Financials/PORTAL. Applied People Tools and application patches, bundles, bug fixes and various service packs.
• Configured Web server/App server/process scheduler for the entire DEV/TEST/PROD environment.
• Performed migration of projects/compare of databases/Tax updates/maintenance pack/patch to PeopleSoft env
• Installed Oracle 11g software on RH Linux 5.2.Installed and configured all the required RPM for oracle. Upgraded the database version from 11.1.0.6.0 to 11.1.0.7.0
• Converted the HRMS database from Informix to Oracle 11g on Linux
• Installed and configured the OEM Grid control/Agent/OMS on Linux for a central Monitoring system. Configured all the metrics for monitoring and thresholds for alerts.
• Implemented Backup and Recovery strategy using RMAN backup. Performed various restore/clone/refresh of databases as and when required during the project phase. Created scripts for all backups using RMAN
• Performed proactive database and system maintenance, proactive monitoring, security, research and development, all levels of performance tuning, architecture and design, mentoring, and support. Performed load Test, prepare Performance Test environment: i.e. run statistics, finalized DB parameters, database System settings to help maximize system performance for best performance, size tables & tablespaces, sizing of SGA/PGA and few undocumented oracle parameters. Analyzed/tuned adhoc queries, SQRS/DMS scripts, AE program and custom built view .Implemented Materialized view, histogram for stat gathering for improving performance. Ran AWR/ADDM/ASH for overall system health check and monitoring.
• Configured Physical and Logical Standby databases for Disaster recovery and reporting using DATA GAURD

Environment: Oracle 11.1.0.7.0, RH Linux 5.2, PeopleSoft Tools V 8.49, HCM (9.0), Financials (9.0), PORTAL(9.0),Web Logic 8.1, Tuxedo, Load runner, Windows NT server

Confidential, COLUMBUS OHIO JULY 2008 JUNE 2009 

Sr PeopleSoft/Oracle DBA/Performance Tuner

Confidential, is a project in which Ohio\'s state government is viewed as an enterprise, replacing numerous decaying and fragmented systems around the state with one integrated computer system for performing some of the State\'s primary administrative tasks. Scope of this project was implementation of HCM 8.9(Core HR, Payroll, Base Benefits, Time and Labor, ePay) Enterprise Performance Management (EPM 8.9), Financials(AP,GL,PR,AR) 8.9, CRM and Data Warehouse.

• Installed High Availability multiple 10g RAC clusters on HP-UX/Linux as part of the new PeopleSoft implementation of HRMS, Financials, CRM and Data Warehouse for State of Ohio. Installed and cloned PeopleSoft applications on multiple servers. Applied People Tools and application patches, bundles, bug fixes and various service packs. Upgrade People Tools from 8.46 to 8.49 and Financials from release 8.8 to 8.9
• Designed and implemented HA solutions for production databases (10g RAC clusters: Production-4 nodes, QA-3nodes, Testing-3nodes & Development-standalone) on HP-UX platform on EVA 8000 SAN storage array.
• Installed and configured 10g databases with new feature including CRS, OCFS, ASM, ADDM, flashback, FRA technology. Installed and configured OEM Grid control, agent and OMS for monitoring various databases and resources within the enterprise
• Upgraded the oracle databases from 9i to 10g, 10gR1 to 10gR2, apllied various patches, bug fixes and quarterly CPU’s Patch. Worked with Oracle support for resolving various CRS issue.
• Created PeopleSoft databases for new application upgrades/ testing. Refreshed DEV/QA databases from Production using RMAN duplicate. Implemented backup and recovery strategy using RMAN – developed RMAN scripts to take full and incremental backups of databases.
• Performed proactive database and system maintenance, proactive monitoring, security, research and development, all levels of performance tuning, architecture and design, mentoring, and support. Performed load Test, prepare Performance Test environment: i.e. run statistics, finalized DB parameters, database System settings to help maximize system performance for best performance, size tables & tablespaces, sizing of SGA/PGA and few undocumented oracle parameters. Analyzed/tuned adhoc queries, SQRS/DMS scripts, AE program and custom built view .Implemented Materialized view, histogram for stat gathering for improving performance. Ran AWR/ADDM/ASH for overall system health check and monitoring.
• Developed, planned, and implemented full multi-site disaster recovery and high availability solutions for OAKS project using DATA Guard(physical and logical stand by database)
• Production support 24*7 for all PeopleSoft databases. Developed scripts to monitor tablespace utilization, file system utilization, trace file cleanups. Assisted Management in DASD requirement/capacity Planning and estimating future growth of databases.

Environment: Oracle 10.2.0.4, HP-Unix, PeopleSoft Tools V 8.48, HCM (8.9), Financials (8.9), EPM(8.9),CRM, Data ware house, Web Logic 8.1, Tuxedo, Load runner, Windows NT server

Confidential, ATHENS AUG 2007 to JUNE 2008 

PeopleSoft/Oracle DBA/ Consultant

Confidential which has 35 production oracle databases for different university college supporting PeopleSoft applications (HRMS 8.9, Financials 8.9, ELM) .The project consisted of upgrading the HRMS and Financials PeopleSoft applications to version 8.9 and upgrading the databases to 10.2.0.3 on HP-Unix.
Role:

• PeopleSoft/Oracle DBA in support of different PeopleSoft applications (HCM V8.9 Financials, ELM and Portal) that reside on HP UNIX. Configured in physical n-tier architecture for both production and development purposes.
• Support PeopleSoft implementation/integration/migration including Database administration support and application support and responsible for overall management of databases and data integrity of the PeopleSoft HCM, Financials, ELM and Portal databases.
• Install oracle 10.2.0.3 across different servers for UAT/SYSTEM testing. Build the database for test moves during the application and database upgrade, Clone and refresh the various test/UAT databases as and when required by the upgrade team
• Install and configure PeopleSoft, Oracle, and other related software components on physical n-tier architecture. Configured appsever, web server and PIA.Changed and tuned various parameters during the load test and performance tuning.
• Performance tuned web, app and process scheduler servers, Changed various tuxedo/web logic parameters to provide better performance, stability and throughput
• Develop UNIX shell scripts and Windows batch scripts for creation/cloning of databases as well as for monitoring PeopleSoft/Oracle processes.
• Implemented Data pump for import and export. This allowed significant reduction in exp/imp time and provided better handling and manageability.
• Assisted the Performance/load Test team, prepare Performance Test environment; i.e. run statistics, finalized DB parameters, database System settings to help maximize system performance for best performance , size tables & tablespaces,sizing of SGA/PGA and few undocumented oracle parameters
• Analyzed adhoc queries, SQRS/DMS scripts and custom built view for performance tuning. Worked with upgrade team/Performance Test team to analyze Performance Test results and identify tuning opportunities
• Implemented Materialized view for various adhoc long running SQLs so that it can make use of Query Re-write for better performance.
• Install and configured OEM Grid control, agent and OMS for monitoring various databases and resources within the enterprise so as to manage from web and one window. Ran ADDM and AWR for tuning and analysis of system performance.
• Time to time analyzing tables and indexes for gathering performance related statistics and identifying problem causing objects, memory areas and SQL statements. created custom scripts for gathering statistics utilizing histograms on few tables
• Applied security patch and quarterly patch to all oracle databases. Configured OID for user administration
• Configuring the RMAN and taking the backups using RMAN. Develop and validate backup strategies, devise and implement reliable backup procedures, and schedule and monitor the daily backups.
• Monitor alert logs, system performance and troubleshooting network and application errors.
• Provide consultation to the senior management on strategic decisions relevant to the database and the PeopleSoft and third party applications.

Environment: Oracle 10.2.0.3, HP-Unix, Solaris, PeopleSoft Tools V 8.48, HCM (8.9), Financials (8.9), Web Logic 8.1, Tuxedo, Load runner, Windows NT server

Confidential Jan 2007 to Aug 2007 

Database Architect/Data Analyst/ Sr. Oracle DBA

Confidential Systems Corporation is a software firm providing sophisticated automotive dealer sales management system. Deal Snap is revolutionizing the retail automotive industry by making the car sales process dramatically faster, more accurate, easier to manage thus saving customers’ time and money and completely integrated system for selling cars providing Comprehensive Lead Management, CRM (Customer Relationship management), enhanced with direct marketing capabilities, Showroom control, Powerful desking,Menu based F & I, Inventory Management, Flexible, powerful reports and alerts, Marketing campaigns driven by DMS (Dealer Management Systems) lead mining.
Role:

• Responsible for working with Oracle-based analytical tools to resolve production issues, as well as developing customized commercial database methodologies for integrating different products to fit specific needs.
• Developed Project Time and Cost estimates when architecting new databases and its data models, as well as planning, coordinating and implementing security measures to safeguard database information against accidental or unauthorized damage, modification or disclosure.
• Implemented Oracle HA architecture and solutions to ensure overall database performance, as well as implementing viable back-up and recovery options for business continuity and disaster recovery.
• Configured Logical/Physical stand by databases for high availability and switch over operation
• Upgraded the oracle databases from 9.2.0.7/10.1.0.4 to 10.2.0.3.Upgrading the database from 32 bit to 64 bit enterprise edition.
• Implemented backup and recovery strategy based on Oracle Data Guard, RMAN and EMC,VPD,FGA.
• Led performance tuning effort for mission critical databases that involved hardware architecture changes and storage allocation improvements.
• Configured and administered jobs, alerts and events on OEM central repository that manages 18 database instances.RAC with 3 nodes, ASM, ADDM, AWR.
• Implemented Materialized View to make use of Query Re-write for data warehouse complex queries. Implemented Advance Queuing and streams
• Implemented change management methodology between development, test and production environments for database related applications, middleware, and web pages. Prepared change management scripts, utilizing version control, to coordinate upgrade and installation of new code for smooth transition or complete recovery.
• Applied security patch and quarterly patch to all oracle databases
• Monitoring LINUX server, memory usage, kernel configuration, capacity planning and I/O distribution

Project: SMART- People soft EPM 8.9 Planning & Budgeting Implementation 

July 2006 to Dec 2006 Client: Confidential, Los Angeles, CA 

People soft/Oracle DBA - EPM Planning & Budgeting 8.9/Business Objects

Confidential was created to implement and support enterprise-wide applications, enabling Countrywide to operate more efficiently and achieve company strategies. The PeopleSoft Planning & Budgeting (EPM 8.9) and Business Objects Reporting applications were rolled out for use in this year Confidential’s budgeting process. 
Role:

• Support PeopleSoft implementation/integration/migration including Database administration support and application support and responsible for overall management of databases and data integrity of the PeopleSoft EPM Planning & Budgeting 8.9/Business Objects.
• Was brought specially to tune the different staging process and fine tune the database before going live. Worked for the performance tuning at the database level and to Tune all Business Objects reports. Identified and resolved existing issues with application to insure a smooth and on time go live production environment.
• Assisted in troubleshooting any functionality gaps with the Budgeting module/Business Objects. Worked closely with the Functional Lead to make the different processes run faster and smoother.
• Implemented Materialized View to make use of Query Re-write so Business Objects reports runs faster.
• Implemented Histograms at the database level so as to use the better execution plan for slow running queries. Implemented changes to the database level to as to avoid LATCH free event
• Perform system maintenance including disk space management; maintain backup and restore procedures and formulate more effective strategies for future needs (hot backups, standby database, reporting database etc.).
• Performed DBA activities including monitoring lock levels, contention possibilities, conducting explain plans as necessary, Running Stat Packs, Monitor alert logs, system performance and troubleshooting network and application errors and etc.
• Implemented Oracle Partitioning for very large tables to utilize partition pruning.
• Created and cloned the databases across different environments, refreshed databases as on when need basis, running stats for tables and indexes using DBMS_STATS package, gathering performance related statistics and identifying problem causing objects, memory areas and SQL statements
• Provide consultation to the senior management on strategic decisions relevant to the database and the PeopleSoft and third party applications.
• Implementing RMAN backup and recovery for production and test databases,VPD,FGA.
• Applied security patch and quarterly patch to all oracle databases
• Monitoring AIX server, memory usage, kernel configuration, capacity planning and I/O distribution

Environment: Windows 2000/2003, Oracle 9.2.0.7/ Oracle 10G, IBM AIX (UNIX), Solaris, People soft Tools V 8.46.10. EPM 8.9

Database Architect/Data Analyst/ Sr. DBA 
Confidential is a natural gas and electric utility serving northeastern and central Wisconsin and an adjacent portion of Upper Michigan. Have been involved in supporting Power Plant, AMR, Fuel Works, Aquolla merger and conversion and different project Implementations.

Responsibilities:

• PeopleSoft/Oracle Database Administrator in support of different PeopleSoft applications (Financials V8.8 Supply Chain Management V8.8) that reside on multiple environments configured in physical n-tier architecture for both production and development purposes.
• Provide PeopleSoft/Oracle database administration and UNIX systems support in the areas of configuration management, establishment of high availability, performance measurement and tuning, capacity planning, contingency planning, recovery, security and production control.
• Configure Application Server / Process Scheduler / Web server domains and perform tuning and load balancing as necessary.
• Perform PeopleSoft implementation including application support and responsible for overall management and data integrity of the PeopleSoft Financials and Supply Chain Management database management system.
• Perform data conversion load processing sequence from legacy system to PeopleSoft system in support of implementation requirements.
• Database implementation and maintenance - Analyze business requirements to create and maintain logical data models. Create, tune, document and maintain physical databases and database applications.
• Implement purchased software - identify infrastructure necessary to have the software perform at optimum levels. Collaborate with team members to procure needed software and hardware. Install software and upgrade systems as needed.
• Perform planning and analysis - Identify, plan and manage project activities. Analyze and evaluate methods of improvement. Develop and document alternatives, recommend solutions and implementation strategies.
• Experience with system/server and database administration with complex systems including applying patches, configuration and installation, capacity planning, troubleshooting system performance, disaster recovery planning and testing, and monitoring server hardware and operating system performance and applying patches on all database servers
• Perform Oracle DBA activities on Development databases; create schemas, tablespaces, referential integrity, data quality assurance, table creation, views, backups, etc.
• Worked on Database Security, Performance Tuning, Database Optimization
• Implemented SOX compliance security and server Lockdown
• Implemented Autosys as Job Scheduler to meet the SOX compliance
• Worked on resolution of various Database Recovery scenarios using RMAN
• Implemented Physical standby database using data guard, Partioning of Big tables.
• Performance and tuning of long running queries and allocations
• Worked on Oracle Streams replication for reporting databases
• Upgraded database for different application and server move to improve performance.

Environment

PeopleSoft Financials/HRMS, Oracle 9.2.0.7/8.1.7/Oracle 10G,UNIX (AIX), SQL Server, PL/SQL Developer, Oracle Enterprise Manager, SQL Navigator, TOAD, RMAN, TDP for Oracle, Autosys

Client: Confidentialn, Columbus, OH Jul 2003 to Nov 2005 

Peoplesoft/Oracle DBA/Migrator Consultant

Upgrade of Peoplesoft HR and Payroll implementation and also migration of existing Applications/Databases from Windows 2000 OS platform to IBM AIX.Handle day-to-day production control tasks including monitoring availability, processing software version control, production change requests, and security change requests, migration of PeopleSoft objects across multiple development, QA and production environments, and cloning of database instances within and across servers. Assist with frequent project developers’ needs/requests for system configuration and database administration, and institute standard guidelines to streamline resource management and to standardize operating procedures that impact the technical infrastructure
Role:

• PeopleSoft/Oracle DBA/Migrator in support of different PeopleSoft applications (HCM V8.8, Payroll) that reside on multiple OS environments (Windows2000/2003/IBM AIX) configured in physical n-tier architecture for both production and development purposes.
• Install and configure PeopleSoft, Oracle, and other related software components on physical n-tier architecture.
• Develop UNIX shell scripts and Windows batch scripts for creation/cloning of databases as well as for monitoring PeopleSoft/Oracle processes.
• Perform system maintenance including disk space management; maintain backup and restore procedures and formulate more effective strategies for future needs (hot backups, standby database, reporting database etc.).
• Created and cloned the databases across different environments remotely on and as needed basis.
• Time to time analyzing tables and indexes for gathering performance related statistics and identifying problem causing objects, memory areas and SQL statements.
• Configuring the RMAN and taking the backups using RMAN. Develop and validate backup strategies, devise and implement reliable backup procedures, and schedule and monitor the daily backups.
• Monitor the production database growth daily and make adjustments as when necessary.
• Apply bundles, patches, fixes and tax updates to the HCM/Payroll systems.
• Monitor alert logs, system performance and troubleshooting network and application errors.
• Conduct research and development to establish more effective and robust strategies in anticipation of a large scale, worldwide implementation.
• Provide consultation to the senior management on strategic decisions relevant to the database and the PeopleSoft and third party applications.

Environment: Windows 2000/2003, Oracle 9.2.0.5/6, IBM AIX (Unix), Peoplesoft Tools V 8.44.13.

Data warehouse Architect/Data Analyst/DBA 
OFSA is a highly integrated financial management information system that is used to deliver enhanced views of organizational, product and customer performance, including consistent allocation methodologies, hierarchies and report formats .The product is used by the National City Bank to report the profitability of its various banking products such as credit cards, loans, mortgages etc. Top-level management for the assessment of product profitability uses this application. OFSA application consolidates the data from various systems into a proprietary database, which is then used for slice-n-dice analysis. 

Responsibilities:

• Data modeler and systems integrator services to the data warehouse project within NCC with a focus on customer data extraction, data integration, key generalization, data scrubbing, and preparation for loading into the data warehouse. Responsible for collecting and documenting business requirements, developing normalized relational data models, modeling processes, writing program specifications, designing physical databases, and writing SQL queries for adhoc reporting.
• Loading data form the different extracts into the OFSA database using SQL*loader.
• Importing and restoring tables across different generations
• Develop a strategy for PeopleSoft Maintenance Plan at ACE.
• Apply patches, fixes and update to the FDM/HRMS systems.
• Assisted in the redesign and redeployment of PeopleSoft Infrastructure at ACE.
• Create SQR tuning document to assist the developers in their SQR performance improvement.
• Perform Oracle DBA activities on Development databases; create schemas, tablespaces, referential integrity, data quality assurance, table creation, views, backups, etc.
• Worked on Database Security, Performance Tuning, Database Optimization
• Modified Control File for database cloning, reset logging and default archiving.
• Implemented hot and cold backups, online backups, export backups and restorations
• Loaded non oracle data into Oracle tables by using SQL-LOADER utilities
• Worked on resolution of various Database Recovery scenarios using RMAN
• Performance and tuning of long running queries and allocations
• QA reviews for the small projects as part of Project Life Cycle
• Analyzing the changes from the interfaces that may impact OFSA application

Environment

Oracle 9.2.0.5/8.1.7, UNIX (Solaris), SQL Server, PL/SQL Developer, Oracle Enterprise Manager, SQL Navigator, TOAD,RMAN

Education
Bachelor of Technology in Electrical Engineering