SUMMARY

• Fifteen (15+) years of strong US experience in Oracle Database Administration inclusive of 8 years’ experience in Administration of People Soft HRMS/Financials/Portals/CRM 7.x/8.x/9.x and Oracle Financials 10.7/11i using Oracle 11g/10g/9i/8.x/7.x People Tools, SQR 4.x, Data Mover, PL/SQL, SQL, Trace, Developer 2000 under IBM AIX 4.3/4.1, Embarcadero DBArtisian, DTStudio, DTEngine, CVS, CQ, PCM, Confidential - UX 10.20/11.00 , Sun Solaris 2.7/2.8/5./9/10 , Linux AS 4x/5x and windows XP/2K/NT/98/95 environments,.
• Extensive experience in Oracle 7.x/8.x/9i/10g/11g/12c, RAC under Sun Solaris 5.8/9/10, Linux, Confidential UNIX and VMS, AWS environments.
• Worked extensively on tuning, optimization, backup, capacity planning, database recovery using OEM, RMAN and production deployments, knowledge in shell scripting, perl.

TECHNICAL SKILLS

RDBMS: Oracle RAC 11g/10g/12c, Oracle RDBMS 11g/10g/ 9i/8i/8.x/7.x, SQL Server, Sybase.

ERPs: People Soft 7.x/8.x,9.x Oracle Financials 10.7 /11i

PeopleSoft: PeopleSoft Financials/HRMS/Portal 9.x/8.x/7.5, People ToolsPeople Code, SQR 4.x, Process Scheduler, Crystal Reports 6.0/5.0

Oracle Applications: Oracle Applications (GL,AP,AR etc.Financials 10.7/11i)

Languages: C, SQR, COBOL Pascal, FORTRAN, SQL/PLSQL, Java

GUI: Developer 2k, Forms 6i/5.0/4.5, Reports 6i.3.0/2.5, Business Objects, Visual Basic 4.0 and HTML

Tools: Export/Import, data pump, sqlbktrack, rman, Trace, tkprof, Enterprise Manager, Server Manager, SQL*LOADER,Toad, SQL Navigator, SQL*PLUS, Embarcadero DBArtisian, DTStudio, STAT, TOAD, SQL Navigator

Operating Systems: Confidential -UNIX, Sun Solaris, IBM, AIX, Linux, Windows XP/2K/NT/98/95

Hardware: Sun SPARC Ultra, Digital, Confidential 9000, IBM RS 6000, S80 DEC Alpha 2000, AIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Folsom, CA

Oracle/PepoleSoft Database Administrator

Responsibilities:

• Monitored and provided day-to-day Production and Lower environments support for Verizon Finanical Applications.
• Worked on DEV, TEST, UAT and Production Oracle databases upgrade from 11g to 12c.and applied patches.
• Worked on UAT refresh from Production, coordinated with development team on post refresh migrations.
• Extensively Performed PeopleSoft Test, UAT, Prod migrations using STAT and involved in automation process.
• Supported database user creations, roles allocation, user accounts maintenance and accounts update, worked with dev team on setting up oracle ids maintenance from PeopleSoft Application to create ids and reset from application.
• Worked on Production Weekly Change Control migrations for VZW, VSO, VDSI and CATs applications.
• Worked on RevRec new app databases setup, built Dev/FUT/UAT DBs, supported code migrations.
• Resolved CMIS tickets related to Oracle DBs, PeopleSoft Application and Unix/Windows space issues.
• Coordinated Oracle Databases and app/web servers migration to AWS and supported Telecom Terra byte databases maintenance and enhancement releases, Involved in Oracle PSU patches and maintenance.
• Supported ABS, CATS, Telecom UAT and Prod Releases and, applied Oracle Quarterly Security patches.
• Worked with Oracle Support and DBA team on database migration to Super Cluster for Test and UAT.
• Coordinated with Unix team on OS patching and worked on stop/start Databases, PeopleSoft Application servers, Web servers, Process Scheduler servers and performed validations. Performed post patch validations.
• Involved with DBA team to migrate teh existing databases and app/web servers to AWS Environment.
• Trained new DBA on CATS, STAT PSoft Migrations, Revenue Recognition application deployments.

Environment: Oracle 12c,11g, Oracle 10g RAC, AWS, Sun Solaris 5.8/9/10, Linux, windows 2008/NT, PeopleSoft - PT8.53, PeopleSoft 8.4-9.1 Financial ERP, STAT, CM/DM, sqlbacktrack, OEM,RMAN.

Confidential, Reston, VA

Database Administrator II

Responsibilities:

• Monitored ERM daily reports and fixed database tablespaces, invalid objects/indexes, and Unix file systems.
• Planned and Upgraded Oracle Databases(Dev/Test/Acpt/Prod) from 11.2.0.2 to 11.2.0.4 for ERM applications
• Implemented EDBCON standardization setups for databases schema backups, restores and DB deployments
• Applied Oracle PSU patches, Dev/Test/Acpt/Prod databases and implemented Oracle Security Listener Patch.
• Worked on new databases setups and post DB tasks for Risknet, CRT, ER and Capitol Market Applications.
• Performed ACPT DBmods, prepared scripts/instructions, coordinated with Levl One Support for Production.
• Worked on Automated Database Schema restores including NPI masking and provided demo to DBA team.
• Provided DBA support on PLAD schema data copy to SCALPS schema using sqlldr and PLSQL procedure.
• Resolved Production performance issues for late running jobs and taken care of teh monitoring reports.
• Analyzed and worked with App/Dev teams and developed procedure to collect stats on stale data tables,
• Worked on schema stats additional jobs setup in OEM for dev/test/acpt/prod DBs to resolve performance issues
• Extensively worked with Application teams and performed Database restores and DB Release deployments..
• Coordinated with SANSUPP/Unix teams to added LUNs & create new file systems and resolved space issues.
• Worked on Risknet Dev/App teams with PeopleSoft interface system and other maintenance tasks.
• Worked with Application Support teams, opened SRs with Oracle Support Metal ink and resolved teh issues.
• Worked on Application Overview, Database Schemas Restore, and password documentation for ERM Apps.
• Involved in documentation, knowledge transfer teh DSM Infrastructure DBA work to IBM outsource team

Environment: Oracle 11g/10g, Sun Solaris, Linux AS 4x/5x, windows XP/2k/NT, EMR, CVS, SOL, OEM Embarcadero DBArtisian

Confidential, Rockville, MD

Database Administrator

Responsibilities:

• Provided regular DBA support and fixed Unix shell scripts, cronjobs and database tablespace issues.
• Designed new servers architecture for PRICES/FFSS2 applications on new data center Triple-me for migration.
• Installed Oracle 10g/11g Software Target servers and migrated Test and Prod databases using export/import.
• Completed OAS 10.3.1 install on new target Unix servers and deployed FFSS2/PRICES applications.
• Completed RMAN backup setup and archive log and old backups cleanup scripts and scheduled cron jobs
• Worked on new TSL certificate setup for PRICES application for both Test/Production Apache web servers
• Worked on Oracle databases, listeners and Oracle Application Servers auto stop/start during server reboot maintenance.
• Performed Test database refreshes from Production on monthly basis to test PRICES month end close
• Worked on server logs extraction from PRICES database, web and OAS servers for audit purpose
• Worked on interface accounts setup, modified Unix shell scripts on target servers after teh migration, resolved Perl script issues with11g oracle 32 bit library install and completed cron jobs setup to load interface files
• Worked on database & oracle application server migration and operation documentation for PRICES/FFSS2.

Environment: Oracle 11g/10g/8i, Sun Solaris 5.8/5.9/5.10 , windows XP/2000/NT, TOAD, OAS 10.1.3

Confidential, Herndon, VA

Database Administrator

Responsibilities:

• Worked with DSM team for demo environment setup and database upgrade to 10g to 11g RAC.
• Performed new Schema Design & Setup, Production data restores with NPI masking in lower environments.
• Worked on SOL/PCM change tickets for Unix, oracle shared access and completed role/privs access.
• Prepared scripts for DBmods and implemented in Dev/Test/ACPT & Production environments.
• Involved in data modeling for Snapshot & QAS apps, implemented both logical & physical models.
• Compared database schemas and fixed both logical & logical models to sync up database objects.
• Worked with oracle on ORA-600 TARs, resolved teh issues, applied oracle security & CPU patching.
• Loaded Flat files to Database using SQL Loader and developed teh scripts and tested.
• Developed PL/SQL Procedures for Data Extraction from CSV files and loaded Staging & Base Tables.
• Designed database build process and release change implementation, DB deployment scripts.
• Worked with CLM & CR dev/test teams and involved in full life cycle release implementations.
• Check-in/Checked-out both logical and physical Data Models, release scripts to CVS repository.
• Extensively used Oracle Grid Control, OEM and performed RMAN backups and data pump backups..
• Provided DBA support on Production replication process setup, autosys jobs and maintenance.
• Worked with Unix Team to create teh new file systems and increase teh existing file systems.
• Supported Psoft dev, test, acpt, prod environments, refreshes, patches, upgrades and Production deploy.
• Scheduled oracle DBMS jobs & ETL jobs for snapshot, performed CLM releases impact analysis.
• Setup new environments for ACPT & Prod, both database and Unix setups including sudo group access.
• Worked on automated schema backup & restore DB deployment in both ACPT/PROD environments.
• Provided DBA support for Sybase ACPT/PROD servers, dbmods, Production backup and restores

Environment: Oracle 11g/10g/9i, Oracle 11g/10g RAC, Sun Solaris 5.8/5.9/5.10 , Linux AS 4x/5x, Windows XP/W2K, ClearQuest, CVS, SOL, Remedy, Embarcadero DBArtisian, DT Studio, DT Engine, DT Designer

Confidential, Folsom, CA

Oracle/PeopleSoft DBA

Responsibilities:

• Migrated Databases to teh new Server and upgraded Oracle Database from 8.0.5 to 9.0.2.7 and 9i to 10g.
• Upgraded Psoft Financials Databases from 9.2.0.5 to 9.2.0.7 and 10g to 10/11g, applied CPU patches.
• Modified & fixed Tablespace, disk space, memory, file system cleanup, alert log monitoring scripts
• Performed PeopleSoft projects migrations and applied application, People tools patches and upgrades.
• Performed backups and Refreshed Dev and QA environments from Production using sqlbacktrack.
• Supported for UAT & Prod Change Controls, PeopleSoft patches, bundles and people tools upgrade.
• Fixed teh issues in Backup scripts, recovered teh schema from teh backup using sqlbktrack.
• Cleaned up teh file system and re-organized teh Instances to avoid teh day-to-day disk space issues.
• Used OEM alerts for database tablespaces, db status, listeners etc., db monitoring and fixes issues.
• Supported 170 systems, Test Directory, Foglight Upgrade DBA Support, involved in DR testing.
• Involved in Psoft 8.x/9.x Financial ERP Application setup with Oracle RAC (10/11g) on Linux Cluster.
• Designed Dev/Test/Prod environments vision diagrams, data/process flow diagrams
• Fixed ASM, Data guard, Oracle Instances and database disk space and tablespace issues.
• Worked with Security team on security tables refresh, coordinated with QA team on refresh validations
• Supported Unix/NT teams on patching change controls and cluster fail-over and maintenance.

Environment: Oracle 8i/9i, Oracle 10g RAC, RAID, Sun Solaris 5.8/9/10, Confidential -UX, AIX, Redhat Linux, windows 2000/NT, PeopleSoft PT8.48 - PT8.50, PeopleSoft 8.4-9.1 Financial ERP, STAT, CM/DM, sqlbacktrack, SQL Navigator

Confidential, Washinton DC

Development DBA Support

Responsibilities:

• Loaded teh Flat files to teh Database using SQL Loader, developed teh Unix Shell scripts and tested.
• Developed UNIX and PL/SQL scripts, Data load from CSV files to teh Staging and Base Tables.
• Created Deployment script for teh build scripts and setup Autosys for teh automated load.
• Tested Data Load scripts and developed test scripts for loading teh data in different combinations
• Completed teh Project first build and co-coordinated teh dev, test and DBA teams for teh build.
• Updated teh Technical Documentation per teh Business Requirements and documented teh RFA Process

Environment: Oracle 9i, Confidential -UX 11.00, Sun Solaris 2.7/2.8, windows 2000/NT, & TOAD, RMAN, SQL Navigator.

Confidential, Pittsburg, VA

PeopleSoft DBA

Responsibilities:

• Supported Production Oracle cum Psoft Apps DBA tasks HR/FINANCIALS 8.4/8.9
• Refreshed DEV/TEST/TRN environments from Production using RMAN developed teh automated refresh scripts for HR/FINANCIALS applications. Migrated teh Projects from UAT to Production.
• Monitored and resolved teh Memory issues on teh Database, Apps and Web Servers. Created scripts to capture teh memory utilization. Perfomed Tax Updates patches and fixes, created 10g Demo Database.
• Created and setup cronjobs for Database, Web and Apps Servers bounce for teh weekend maintain ace.
• Implemented Monthly Production Releases and documented teh procedure.
• Provided support on DEV/TEST/PROD databases, worked with Dev Team on teh Database load issues.
• Redesigned and resolved Disk Space issues on Dev Database Servers for Dev and Test Instances.
• Fixed SQR/App Engine/Crystal Reports issues and debugged teh problems in back end oracle databases

Environment: Oracle 9i/10g Confidential -UX, Sun Solaris, windows 2K/NT, People Soft HRMS/FINANCIALS 8.x &, DM

Confidential, Mclean, VA

Oracle Financials/PeopleSoft DBA

Responsibilities:

• Installed Oracle Client 9i and Oracle Financials 11i on Application and Database Tiers and configured.
• Supported Oracle OFA 10.7 Oracle instances running on Confidential and upgrade from 10.5.3 to 10.5.6 and 11i
• Supported Oracle Financials 10.7/11i Test/Prod and. upgraded Oracle databases from 8.17.1 to 8.17.4
• Applied OFA Application patches on Apps and DB Tiers and fixed teh issues raised during Upgrade.
• DBA support on database, application, web, concurrent processing, report, form & admin servers.
• Provided Financial Global Users Support and fixed teh Problems and worked with Oracle on P1 TARs.
• Supported Clearing House Billing Module for Confidential Inter Company Invoicing and ADP payroll system
• Supported Concur Expense Application for Confidential Employees and involved in Upgrade from 5.x to 6.x
• Commissioned Hyperion Application devl/test servers and Supported Global Fixed Assets System.
• Installed Oracle 9i and People Soft 8.4 on Unix and Win2k servers and configured
• Installed People Tools, oracle client on user Desktops and performed configurations, resolved teh issues.
• Involved with Dev Team in resolving Production Database load issues and day-to-day Production Fixes.
• Worked with teh Sr.Developer to setup Training database and set up automated refresh from Production.
• Generated DD & SYS Audit Reports in QA and Prod DBs and developed SQL scripts to fix teh issues.
• Performed Hot & Cold Backups, exports and imports for Oracle 8i and 9i databases and schema refresh.
• Installed Oracle 9i and upgraded Psoft Oracle Database from 8i to 9i and implemented in Production.
• Involved in SP, Re-org data loads, resolved rollback segment, Temp tablespace issues, analyzed STATS.
• Cloned various databases and renamed and configured psoft apps/web servers, applied 9.2.0.6 patch.
• Prepared teh SIF and involved in teh Prod App Server switch to a new Unix Server with data center.
• Worked with teh Development Team in resolving PL/SQL packages fixes and supported Database issues
• Created and supported Materialized views in HR, Financials and other Databases for Data Integration.
• Applied Unix and windows server OS, Security and Oracle Financials 11i Application patches
• Worked on P1 TARs with Oracle Support, resolutions on Metalink and resolved Financials Prod issues.
• Supported, STEP Application. Centra Training Application, upgrade from 5.x to 6.x and DB upgrade.
• GOALS Application support, DB upgraded from 8.1.7.0 to 8.1.7.1 and character set conversion to UTF8.
• Documentation on Mviews, Migrations, Backups, Upgrades, PSJobs, Database Refreshes, cronjobs,

Environment: Oracle 9i/8i, Confidential -UX 11.00, Sun Solaris 2.7/2.8/5x, windows 2000/NT, People Soft HRMS 8.x, Oracle Financials 10.7/11i & Configuration Manager/Data Mover, SQL* Net; MS SQL Server

Confidential, Falls Church, VA

PeopleSoft/ Oracle DBA

Responsibilities:

• Installed Oracle Client 8i and People Tools, upgraded Upgrade from and configured.
• Configured App Server, Web Server and Process Scheduler Domains and performed testing.
• Performed cold backup of teh Oracle Database 8i and prepared teh scripts and performed refreshes.
• Created scripts and setup cron jobs for Database Refreshes, imports, exports, startup and shutdown Envs.
• Fixed Environmental infrastructure issues and resolved Test and Production issues with development team.
• Documented DB Upgrade, Environment creation, migrations, DB refresh, Application Ports, architecture.

Environment: Oracle 8i, Sun Solaris, Confidential -UNIX, Windows NT/2K, PSoft 8.x HRMS, Portal and Financial Applications.

Confidential, Pleasanton, CA

Oracle/PeopleSoft DBA

Responsibilities:

• Involved in Upgrade of People Tools from .06 and applied Oracle Monitoring patches.
• Performed exports from source Sun Servers and imports on Target Confidential Servers for UAT and Production
• Created new databases and done imports on target servers and performed Schema compares.
• Prepared Audit reports for teh E-center instances for various PeopleSoft E-center applications.
• Monitored and checked alert logs, traces, free spaces, file systems, performed database refreshes.
• Transferred Application Server/batch files and Web-server related files from Windows to Unix server.
• Configured BEA/Tuxedo 6.5, Process Schedulers on NT/Unix. PIA setup with Weblogic 5.1 and 6.1,
• Compiled COBOL programs and relink them, install SQR on Unix and Crystal Reports on NT servers.
• Checked basic reports like SQR, Cobol, Crystal Reports, and nVision reports on Unix and Windows.
• Updated html pages to reflect changes for Apache, and Web logic web server Load balancing.
• Setup teh splash page using Apache Server and resolved issues during implementation.
• Migrated Full drive and psoft code trees from source NT servers to target Windows 2k servers.
• Resolved App Messaging, SMTP & Port issues and fixed People books issues for customer applications.

Environment: Oracle 8i, OEM, Sun Solaris Confidential -UNIX, Windows NT/2000, PSoft 7.x, 8.x HRMS, Financials, Portals, CRM.

Confidential, Sterling, VA

Oracle DBA/Psoft DBA

Responsibilities:

• Installed and configured Unix/W2k Servers for People physical 3-tier architecture for PeopleSoft 8.3
• Installed and configured Oracle 8.1.7(64 bit) on Database and Application Servers
• Created teh Portal database on database server and loaded teh psoft data using data mover.
• Restored databases from taps to new Confidential Unix Boxes duly creating file systems and mounting,
• Created database and app servers stop/start, export/import scripts, backup scripts and scheduled.
• Designed and implemented disk space allocation on Database, Application Servers and File servers
• Installed and configured PeopleSoft HRMS, Financials and Portal 8.3, configured kernel peraments.
• Installed SQR, Tuxedo, Cobol, Crystal Reports, ODBC Drivers on File Server and Application Servers
• Installed & configured Web Server, Internet Architecture on File Server and assigned WSL/JSL Ports.
• Installed people books, verity & chart server and applied OS, Application and Oracle patches
• Created and Configured Process Schedulers, Apps servers on Batch Server and Application Servers.
• Tested 2-tire, 3-tier, n-tire connectivity for all databases, Cobol, crystal, sqr reports, sysaudit, ddaudit and fixed.

Environment: Oracle 8i, Confidential -UX 11.00, Sun Solaris 2.7, W2K//NT, Psoft HRMS, Financials & Portals 7.x/8.x, CM/DM

Confidential, Mountain View, CA

DBA/MTP Coordinator

Responsibilities:

• Performed MTP coordinator forMBA System, developed MTT & MPT Unix scripts and documented teh Process.
• Involved in Dev, Test, and Acpt and Production Schema setups for MBA customer applications.
• Worked with Development team and resolved teh environmental issues and fixed.
• Worked on Production DRP environments and applied teh changes to sync-up with Production.
• Ensured all production databases are operational and available with minimal unscheduled downtime.
• Involved in MBA migration to Confidential Service Bus and worked on HA (High Availability) scripts testing.
• Prepared Password maintenance, MTT & MTP, DRP environments process documentation.

Environment: Oracle 8i, Confidential -UX 11.00, Sun Solaris 2.7, windows 2000/NT/98/95, TOAD, SQL Loader