Oracle Project
Resume:
Tyrone Adeyemi
Mobile: 860-***-****
Land:
Email: ********@*******.***
Core Skills:
ORACLE DBA 8i, 9i, 10g, 11g:
12+ years
Unix: AIX, HPUX, Solaris:
12+ years
PS HRMS/HCM 2.x to 8.9/8.48Tools: 12+
years
PS FSCM 9.0/8.49 Tools:
12+ years
PS FSCM 9.0/8.50 Tools
PS STUDENT ADMIN 8.0/8.22Tools 2+
years
PS CAMPUS Solutions 9.0/8.48 Tools
3+years
PS EPM 9.0/8.48Tools
2+ year
Applimation Informia 5.3
2+ years
Ascential: DataStage, MetaStage
3+ Years
summary
Successful Independent Consultant with over 15 years of experience covering
database administration, architecture and design, specializing in Oracle
RDBMS with ERP and Enterprise Archiving applications. Software products
experience includes PeopleSoft HRMS/Payroll/Financials, EPM and Applimation
Informia on Oracle Unix platforms. More than an Oracle DBA, Project
implementation functions include: PS Administration, Upgrade Specialist,
architecture and infrastructure design, project planning and initiation and
project team leadership. Excellent communication skills both written and
oral, guided projects from concept and design to construction and
implementation stages.
Technical Summary
Database: Oracle DBA 9i, 10gR2, 11gR1, DataGuard, RMAN, Oracle10g RAC and
OEM GRID
Operating Softwares: Linux OS: AIX 5.3L, HPUX 11, Solaris 8/9/10.
Softwares: Ascential: DataStage, MetaStage
Informatica: PowerCenter, PowerMart
Applimation Informia 5.3
AMDOC CRM/Clarify
Backup Softwares: Tivoli, Enterprise Backup, HA Software: Veritas
ORACLE Database Administration:
Oracle RDBMS Install from version 7.x to 11gR1
Apply Oracle Critical Patches to Oracle 10gR2, 11gR1
Oracle Database/Instance creation and maintenance
Performance and tuning: Quest database Tools, BMC Tools
Database Design: logical and physical models
Database objects creation and maintenance: Tables, indexes, views etc.
SQL Optimization, Index efficiency
Backup/Recovery setup and planning
Space allocation and management
Database management: Migration/cloning.
Disaster Recovery.
Peoplesoft Administration: HRMS/Payroll/Ben. v3.x - 8.9, PS Financials V3
- 9.0, Current PeopleTools 8.49, Application Designer, DataMover,
PeopleCode, Change Assistant, Upgrade Assistant, Process Scheduler,
application server setup, PeopleSoft internet architecture, BEA: WebLogic,
BEA Tuxedo and SQL/SQR.
. Install Ascential DataStage server: Platform Unix AIX 5.3L
. Install Peoplesoft HRMS/HCM from: v5.x - 8.9, Latest install 8.9,
Tools 8.48
. Install Peoplesoft FSCM from: 9.0, Tools 8.49
. Install EPM 9.0 with PTools 8.48
. Install and Apply Peoplesoft fixes, patches, bundles and MPs
. PeopleSoft Upgrade Experience: HR v3.x to 5.x, 7.0 to 8.9
. PeopleSoft FSCM Financials V8.4.x to 9.0/PT8.49
. Maintain overall responsibility for database analysis, design and
building.
. Database Configuration: Maintain database creation, setup, cloning,
refresh etc.
. PS PIA Server Administration and Setup: Configuration and setup: Two
and Three Tiers
. PS Application Server Setup: Administration, Performance: tuning and
troubleshooting
. PS Data Management Tools: Change Assistant, Upgrade Assistance
. PeopleSoft Online Performance: Application Development management
. PeopleSoft Batch Performance: SQL, Cobol, SQR, Data Conversion
. PeopleSoft Security - OPRID/ACCESSID/CONNECTID, SYMBOLIC_ID
. Process Scheduler/Batch Server setup, monitoring and Troubleshooting
. PeopleSoft Upgrade Experience: Financials V8.4.x to 9.0/PT8.49
. Peoplesoft database migration Experience: from DB2 s390 to Oracle 7 HP
Unix, Oracle 7 to DB2 s390 v5
. Quest STAT Code Migration Tool
Software/Tools: Unix Shell Scripting, Perl Scripting, CA: Erwin, ModelMart,
Quest: Spotlight, SqlTuning, FogLight, STAT, DBArtisan, ER/Studio, Rational
Rose.
Work Experience
07/2008 - Present: The Hartford Financial Services, Senior
Oracle/Peoplesoft DBA Consultant
. Install PTools 8.50, Migrate Parallel test environment to PT 8.50
for shakeouts.
. Upgrade Weblogic 9 to WL10
. Upgrade/Migrade PTools 8.49.23 to PTools 8.50
. Upgrade Oracle 11gr1 to 11gR2 on Solaris 10
. Upgrade 9 databases (2 Prod) to Oracle 11gR2 version
. Install Websphere MQ Series 7.0 on Linux
. Provide Production support Oracle 10gR2 databases on Linux
. Install PS FSCM 9.0, Tools 8.49, Tuxedo 9
. Create and Maintain PIA infrastructure.: Application Servers, Web
Servers, Batch Servers, Windows 2003 server, Peoplebooks 8.49
. Support and maintan current Prod PS FSCM Application 8.4, Tools
8.45, Tuxedo 8, Create and Maintain PIA: Web Servers 8.45,
Application Servers 8.45, Batch Servers and Windows 2003 server.
. Install Informatica Applimation 5.3:
. Implement Applimation Archive tool for 600gb database
. Install and maintain Oracle 11gR1 on Solaris 10 Unix platform
. Upgrade Oracle 9i to 11g, Solaris 10
. Upgrade FSCM 8.44 to 9.0, PTools 8.49
. Provide Prod Support for FSCM 8.44/PT 8.45
. Implement Peoplesoft Directory Interface with LDAP
. Troubleshoot problems with Oracle RDBMS and Peoplesoft software in
development, test, and production platforms
. Lead Performance and tuning efforts on UNIX and Oracle RDBMS
. Consult with Unix System Admin on AIX issues
10/06 - 6/2008: University of Connecticut, CT. Oracle Peoplesoft
DBA/Infrastructure Architect
. Install HCM Application 8.9, Tools 8.47, Tuxedo 8, Create and
Maintain PIA
infrastructure.: Application Servers, Web Servers, Batch
Servers, Windows
2003 server, Peoplebooks 8.47 on AIX 5.4.
. Install EPM Application 9.0, Tools 8.48, Tuxedo 8, Create and
Maintain PIA: Web Servers 8.48 on AIX 5.4, Create and maintain
Application Servers 8.48: AIX 5.4, Create and Maintain Batch
Servers on AIX 5.3 and Windows 2003 server, Created Peoplebooks
8.48 on AIX 5.4.
. Install Ascential DataStage, MetaStage on AIX 5.3L, Windows
. Install and maintain Oracle 10gR2 on AIX 5.4 Unix platform
. Administer and maintain all Oracle databases in an OFA compliance
environment
. Troubleshoot problems with Oracle RDBMS and Peoplesoft software in
development, test, and production platforms
. Lead Performance and tuning efforts on UNIX and Oracle RDBMS
software.
. Consult with Unix System Admin on AIX issues
. Other responsibilities Verity search Setup, Report repository,
LDAP integration, SSO integration
. SSL integration, Application messaging setup and Crystal 9
installation and setup
9/05 - 10/2006: UCONN Health Center, CT. Snr. Oracle Peoplesoft DBA
. Oracle Peoplesoft DBA/Infrastructure Architect: AIX 5.3L, Oracle
10gR2 Platform
. Install HCM Application 8.9, Tools 8.46, Tuxedo 8, Create and
Maintain PIA: Web Servers 8.46 on AIX 5.4, Create and maintain
Application Servers 8.46: AIX 5.4, Create and Maintain Batch
Servers on AIX 5.3 and Windows 2003 server, Created Peoplebooks
8.46 on AIX 5.4.
. Install and maintain Oracle 10gR2 on AIX 5.4 Unix platform
. Install Ascential DataStage, MetaStage on AIX 5.3L, Windows
. Administer and maintain all Oracle databases in an OFA compliance
environment
. Troubleshoot problems with Oracle RDBMS and Peoplesoft software in
development, test, and production platforms
. Lead Performance and tuning efforts on UNIX and Oracle RDBMS
. Consult with Unix System Admin on AIX issues
. Other responsibilities Verity search Setup, Report repository,
LDAP integration, SSO integration
. SSL integration, Application messaging setup and Crystal 9
installation and setup
. Other software includes: Informatica PowerCenter; Source
Object/Target Object definitions; Workflow: Mappings.
9/2004 - 9/2005 UnitedHealthCare, Ingenix DataWarehouse Group, CT
Senior Oracle DBA Consultant: Solaris UNIX, and Oracle 9i. Duties included;
Project management, database tuning, SQL statement tuning, performance and
diagnostics: waits/latches, general troubleshooting, fire fighting, script
development, documentation and DBA training. Responsible for installation,
upgrades, patches, TAR support, database tuning, database creation,
database tuning/reorganization, SQL statement tuning, backup/recovery,
general troubleshooting, fire fighting, Script development and
documentation.
2/2000-9/2004 Pfizer Inc., Groton, Ct.
Senior Oracle DBA Consultant, Sun Solaris Unix (Oracle 7.x, 8.x, 9.x),
Ariba Procurement system, PeopleSoft Financials 7.x, 8.x. Responsibilities
include: Oracle 8i & 9i Installation, Database Migration from 7.x to 8i to
9i, Performance and tuning, Backup and recovery, Oracle license Compliance,
Unix OS monitoring, Production on-call support, PeopleSoft 8.x Installation
and Upgrade, Ariba database Installation and Upgrade including:
. Oracle Server installation versions: 7.x, 8.x, and 9.x on Solaris/HP
platforms.
. Installation and setup of Oracle database.
. Database management: Database creation: startup/shutdown, Backup and
restore: cold/hot, Objects maintenance: tables, indexes, Store
procedures, triggers, views etc.
. Database version upgrade and migration: Oracle 7.x to 8.x to 9.x.
. Database migration from Novell NetWare to Solaris, Solaris to RedHat
Linux, WinNT to Solaris
. Database Performance and tuning: Quest Central: QCO, OEM, DB
buffers/cache, Memory cache, waits, parameter settings, control files,
Rollback segments, File/Disk systems monitoring, I/O balancing, Index
usage and Program efficiency, Index usage and Program efficiency etc.
. SQL Tuning and Optimization, SQL Trace, tkprof, 9i Statspack.
. Backup/Recovery and Fail-over: export/import, OS backup, SQL Loader,
Arch/Log.
. RMAN recovery, Standby database, OPS: 8i Oracle Parallel server, 9i
RAC Linux, Veritas Clustering/Fail Over.
. Define approach and model using CA Erwin products to collect, document
customer business and data requirements. Determine transition strategy
from current to new architecture: Embarcadero: ER Studio, CA:
ModelMart, CaseWise: Corporate Modeler.
Skills: Oracle 7.x, 8.x, 9.x, SQL Loader, Arch/Log, HP, Sun Solaris Unix,
Ariba, 9i RAC Linux, RedHat, Veritas, ERWIN.
6/93 - 1/00 Crown Database Technology, LLC (Contractor)
2/99-1/00 Washington Gas Light, DC: DB2 DBA for PeopleSoft HRMS and
Financials Project implementation including regression and capacity testing
on S390.
6/98-1/99 Prudential Insurance, NJ: Oracle/DB2 DBA for PeopleSoft HRMS
Project. Functions included Stress and Performance testing of 200K Employee
Payroll.
2/97-08/98 Coastal Corp., Houston, Texas: Senior DB2/Oracle DBA for
PeopleSoft Financial project. Functions included: Team Lead for
migration of PS Fin 3.x on Oracle HP-UX to DB2 OS390, Installed
and benchmarked SAP.
4/96-2/97 Harris Bank, Chicago, IL: Senior DB2 DBA for PeopleSoft 5.x
HRMS project implementation.
8/95-4/96 Beth Israel Hospital, Boston, MA: Team Lead/Oracle DBA, Sun
Solaris Unix for PeopleSoft HRMS 3.1 implementation with Oracle
Parallel Server.
10/94-8/95 Bradlees, Inc., Braintree, MA: Senior DB2/Oracle DBA for
PeopleSoft HRMS and Financials conversion from S390 to Oracle
Unix with Oracle Parallel Server.
6/93-10/94 New England Electric, Westborough, MA: Senior DB2 DBA: WIS
Financial Package. Functions included: Team Lead: Database
creation and setup, application performance, backup and
recovery, disaster recovery, parallel and system testing, stress
and volume test.
4/90-5/93 Travelers Insurance Co.: Senior DBA: Provided DB2, IMS Database
and Teradata administration support for Data Warehouse Managed
Care Benefit systems. Other functions include: CASE TOOLS,
Information modeling, Information/data architecture, JAD/RAD
design, Erwin, PowerDesigner.
5/88-4/90 Aetna Life and Casualty: DBA/Software Specialist: Provided
DB2 and IMS/DLI/CICS DBA support for Commercial Claim Financial
Systems.
Certification: Preparing for Oracle 11g certification 5/2010
Education: Candidate for Ms (Management) Dec. 2010
Contact this candidate