David J. Clark Email and Phone Number

Sole Oracle DBA/PeopleSoft Admin responsible for install, upgrade, patching, tuning and day to day operation for the Oracle Database product, and applications using Oracle DB on Red Hat Linux: PeopleSoft FSCM, HCM, EP, and various other non-PeopleSoft applications (Kronos, Hyperion and Imagenow aka Perceptive content).Install/upgrade/configure/performance tune PeopleSoft (all tiers) and patch/update using PUMs and PSCA.

Support Oracle databases used by Hyperion, MasterTax and Kronos. Upgrade PeopleSoft Financials system from PeopleTools version 8.42.15 to 8.45.18, including required Weblogic, Tuxedo and DST patches. Assist PeopleSoft Administrator apply Tax Updates and Application Bundles to Demo, Dev, Test and Prod environments. Install Oracle 10g for ImageNow. Resolve daily database issues.

DJC Consulting Inc., established in 1998, was a Texas-Based Privately owned Consulting Company providing Oracle Database Administration and PeopleSoft Administration services for the PeopleSoft suite of Applications. This includes installing and upgrading software, planning Disk layout on SAN technologies, and providing database performance tuning services as needed.NOTE: DJC Consulting Inc, was incorporated in Texas and is not affiliated with the Dutch company owned by Taco van der Zandt.

Provided emergency query and batch program tuning for PeopleSoft applications. Identified and implemented additional indexes, statistics gathering and software bundle upgrades to improve performance

Assist IBM contract team at Michelin Tire Company install and configure Secure (SSH) Certificates for Websphere https access, provide direction for performance tuning slow upgrade SQL, provide configuration assistance for running datamover scripts on UNIX.

Backfill DBA position while Client seeking full-time DBA. Apply Tax Updates and Application Bundles to Demo, Dev, Test and Prod environments. Tune multiple on-line and batch processes, including PeopleSoft nVision report books. Assist development team resolve Database related problems, including performance issues related to Kronos upgrade. Support multiple applications at database level, including Hyperion, MasterTax and Kronos. Plan and document database reorg strategy. Implement simple automated alert monitoring and install Statspack. Apply Tuxedo patches. Participate in DBA candidate interviews.

Performance tune Oracle database, Upgrade PeopleSoft HRMS and PeopleTools, establish procedure and schedule for regular TAX update and Application upgrade bundles, configure secure https login for employees from home allowing them to update deduction information, view pay sheets etc., thus reducing printing/mailing costs for the company. Train full-time employees in PeopleSoft administration techniques. Write code to satisfy SOX reporting requirements tracking change control.

Install PeopleSoft. Upgrade Peopletools version. Peoplesoft performance tuning. Assist EMC consultants configure optimal SAN Database layout. Tune Oracle database and SQL tuning. Repeat business: Called back as a consultant on 3 occasions over 5 years to assist with new Performance challenges as the database environment grew.Train on-site support staff in PeopleSoft Administration best practices.

Backfill DBA position while employee DBA on overseas vacation. Provide assistance to various project leaders to assist in planning Archive history project, High-availability hardware configuration and testing, Backup and Recovery planning. Participate in Daily status and planning meetings. Assist 2nd level support team to resolve Database related problems. Build additional databases as required. Tune process for archive data load project to decrease run-time from overnight to under an hour. Provide suggestions for further improvements.

Troubleshoot/support Application Messaging between Peoplesoft Financials and HR databases. Assist development team troubleshoot issues before, during and after ‘go-live’. Recommend performance tuning actions to client DBA’s and development team. Assist Infrastructure team with database refreshes, and re-configuration of Application Servers, Weblogic Web Servers, Process Schedulers and Integration Broker configuration. Identify and diagnose performance bottlenecks and suggest changes to improve on-line and batch response times. Assist with Planning and implementing Peopletools upgrade to 8.18 and 8.41

Daily Oracle DBA services. Assist with PeopleSoft 7.56 to 8.17 upgrade (HR-Payroll 8.3). Configure PeopleSoft Internet Architecture on HPUX servers, NT Report server, Weblogic 5.1 & Tuxedo. Resolve installation and configuration problems. Migrate SAN from HP AutoRAID to Network Appliance and EMC Symmetrix for high-availability and fail-over. Configure new environment for high performance. Develop and implement strategy to virtually eliminate need for database reorganization process. Assist data warehouse team with strategy for physically spreading data across disks to improve data load and response times. Plan/Implement Oracle upgrade from 7.3.4 to 8.1.7.2.1 Assist PeopleSoft development team with general problem solving and performance tuning. Reduce Payroll Batch run times.

Assist Client DBA provide post-production support of Version 8 PeopleSoft financials database. Perform selective database refreshes for test databases. Review current UNIX and Oracle parameters and suggest changes for performance. Identify and diagnose performance bottlenecks and suggest changes to improve response times of on-line and batch processes

Provide temporary DBA support until permanent DBA could be hired. Install PeopleSoft 8 Demo database, Server Express COBOL, SQR and Peoplesoft Internet architecture (PIA). Upgrade Oracle databases from 8.0.5 to 8.1.7. Prepare environment for PeopleSoft upgrade lab. Handover to new DBA. Assist Peoplesoft technical team as required

Upgrade PeopleSoft HRMS from Version 6.1 to Version 7.5. Install and configure new version, create new databases, plan move to production. Run upgrade scripts and other activities. Collaborate with Oracle DBA and HP-UNIX System Admin staff. Configure Tuxedo middleware product and Application Servers and setup Process schedulers. Identify and Apply software fixes required for upgrade.

Install, configure and administer Oracle and PeopleSoft using RAID array on NT with Oracle Fail-Safe Clusters. Configure Tuxedo middleware, Application Servers, Process schedulers and NT services. Establish strategies, procedures and standards for Backup/Restore, change control, migration and versioning, security methodology. Identify and Apply software fixes and upgrades. Train replacement DBA and PeopleSoft administrator. Perform daily DBA tasks and general Peoplesoft problem resolution. Assist in technical interviews of new staff

Automate data load processes from Deltak Accounting system into Microsoft Access. Test and document Oracle Backup and Restore process for PeopleSoft database on Oracle 8.0/NT

Assist client and large software integrator to install, implement and administer Peoplesoft Financials. Assist with configuration planning, strategies and procedures for Backup/Restore, change control, code migration and versioning. Apply software fixes. Train DBA staff in all aspects of PeopleSoft administration. Assist integrator and client staff with PeopleSoft problem resolution. Document common problems and resolutions into Lotus Notes database for easy access.

Oracle DBA/PeopleSoft Administrator for the PeopleSoft HR/Payroll system using Peoplesoft version 5, PeopleTools 5.12 and Oracle 7.3

Consultant for various Software AG Clients, including .. northAmerican Van Lines, Dow Chemical, Sprint, State of Louisiana, Houston Police Dept, Tandy Corporation.

Product Instructor for Software AG products - Natural II, Construct, Adabas.Natural Construct Developer for Standard Bank Project - South AfricaApplications DBA/Developer using Predict/COBOL/DB2 for BMW project - South Africa.

IBM South Africa - Johannesburg.Mainframe Computer Operator (S/370), Applications Programmer(AS 4GL / COBOL), Systems Engineer , DB/2 Product Instructor.