Oracle Database Administrator Resume

7+ Years of Overall IT Experience with 5+ years in PeopleSoft Experience

ERP Packages: PeopleSoft HRMS 9.0, 9.1 / PORTAL 9.0, 9.1 / FSCM 8.9, 9.0, 9.1 / CRM 9.0 PeopleTools: App Designer, Datamover, App Engine,SQR, C I, Integration Broker , Change Assistant, Process Scheduler on versions 8.44/8.45/8.48/8.49/8.51 Databases Oracle 9i/10g/11gR1, SQL Server 2008 GUI Tools: DBArtisan, TOAD, SQL Developer, OEM Migration and utility tools: Quest Stat , Secure CRT, Dameware Miniremote control Languages: SQL, PL/SQL, C ,HTML,CSS, Java Operating Systems: AIX 4.3.3/DB2, SUN OS, UNIX, HP-UX, Linux, Windows 2003, 2008 . Oracle Tools: SQL Plus, SQL Net, SQL Loader, RMAN, EXP/IMP , Datapump, OEM Middleware: Tuxedo & WebLogic 8.1/9.0/9.2/10.3

Other Tools: Putty, Dameware, WINSCP, Citrix

Peoplesoft Administration experience Includes :

Migrations
Applying Patches
PeopleSoft Compare, Copy and Environment Refresh
PeopleTools Upgrade for 8.51, 8.49, 8.44 and lower
Application Upgrade and Data Conversion for PeopleSoft FSCM / HRMS 9.1, 8.9, 8 SP1 and lower
Working with Change Assistant and Upgrade Assistant
Team lead for the conversion and load team in extracting data from 4 different legacy systems into a single peoplesoft integrated system.
Install, configure, trouble-shoot, performance tuning and administration of PeopleSoft Web, Application and Process Scheduler Servers
Working with WebLogic Admin Console
Customize and implement Process Scheduler Purge SQR process
Develop, customize and implement Application Messaging Archive and Purge Application Engine process
Configure, implement and work with Integration Broker, Change Assistant, Environment Management Hub / Agents, Performance Monitor
Configure Messaging Gateways
Developed and deployed shell scripts for generating monthly PeopeSoft reports.
Configure and implement Data Archive Manager
Portal and Security Administration
PeopleSoft Workstation install and support
Refreshing Peoplesoft lower environment databases with Production using Oracle export/import, automated refreshes, including datamover.
Working with HR taxupdates
Developer and Online Business User support
On-call support for PeopleSoft Production databases
PeopleSoft Trace for issue identification and resolution
Working with PeopleSoft Customer Connection and GSC.

Oracle Database Administration experience includes:

Administered 1.5 Terabytes of databases varying in size and complexity, from 50gb to 350gb and housing thousands of tables and millions of records.
Experienced in Backup and Recovery using Hot backup, Cold backup, Export and Import. Recovery of tables, datafiles, rollback segments, redo log files and control files whenever required.
5+ years of experience in coding and testing PL/SQL stored procedures, functions, packages, triggers, tables, complex SQL queries and views.
4+ years of experience in designing and developing ETL (Extract, Transform, Load) programs for data extraction, data transformation and data loading.
Experienced in database design, data mapping, data conversion, data analysis, data validation, data migration and database administration of complex environments hosted on Solaris, Linux and Windows operating sytems.
Experienced in Cloning, replication of Production database to create Q/A, system test databases in numerous no'of occassions.
Created shell scripts to run statistics every day on 9i databases, daily data refreshing using DBLink
Implemented Table Partitioning of Large PeopleSoft tables by Range and Hash.
Actively participated in Disaster Recovery Exercise by coordinating with System Administrators and Application teams.
Experienced in SQL*LOADER and Datapump.
Applied numerous Patches for Oracle including Security patches, coordinated with Application teams for downtime and smooth rollover.
Woked with TOAD, DBArtisan and Clear Case.

Quest STAT Experience includes:

Implement and support PeopleSoft Object Locking, Object Archiving, Object Versioning and Change Management strategies
Performing PeopleSoft Migrations
Working with Mass Migration, Object Recovery and Object History Wizards
Working with CSRs
Working with Baseline, Interim and Final Archive Sets
User and Developer support.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship