Jerome S. Christopher Email & Phone Number

• Month-end Upgrade: Upgraded AIX-batch job from Oracle 9i to 10g. This month-end program copied production ERP database to the reporting instance for generating management reports.• Mp2-to-InforEAM Data Migration: Migrated MP2 database on Oracle 8i to InforEAM database on 10g. Configured the production, Cognos reporting and testing databases using Jboss AS. Created and impletemented initial procedures for data transport and backup recovery.• Giro Upgrade: Administered Giro/Hastus databases and upgraded GIRO to 10g.• DMS Upgrade: Administered Law databases on Oracle and upgraded from 8i to 10g. These databases were configured for the I-manage document solution product from Intervowen.• Service Desk: Created and configured the database for Service Desk application which uses .net and caters to the need of the service desk and implemented backup/recovery procedures.• GIS Install: Installed and configured oracle 10g database. Imported subset of data from Sun-Solaris into windows.

Oracle DBA/Consultant of self-owned company providing database administration services in the Chicagoland area.

• Administered the databases through performance tuning, monitoring, system resource tuning (CPU, Memory and I/O), resolving tablespace fragmentation issues.• Managed Oracle for PeopleSoft ERP. Improved performance by 30% using Precise SQL and other tools.• Implemented MTS Load Balancing by tuning the listener and server processes, which resulted in faster connections for several hundred end users.• Scheduled jobs on crontab tool to automate various scripts for analysis and performance issues.• Provided 24x7 production support for all databases with 3 other DBAs.• Completed creation and maintenance of multiple objects at various phases of implementation.• Created tablespaces and handled space management.• Set up separate database instances for development, testing, DR and training to provide customers with increased reliability.

• Installed, upgraded and configured Oracle databases [6x-10g]. Applied patches (security) on HP-UX 9k class servers. Configured tnsnames.ora and listener.ora for multiple Oracle homes for windows NT as well as UNIX.• Executed various database builds using a master script with individual DDL scripts for tablespaces, users, roles, tables, constraints, indexes, data changes, etc. • Created scripts for tablespaces, users, roles for various applications and owned them.• Managed tables, indexes, histogram, trace session, stored outline and materialized view.• Handled production deployment for various projects and replicated the application users to other databases.• Copied production databases to development using DBCA.• Used export and import for backup and recovery using export-import and helped configure RMAN to provide faster backup and recovery strategy and flexibility.• Created RMAN backup scripts for nightly backups.• Helped design DDL scripts for loading data through dblinks. Worked on documentation for the various tasks.

• Administered 10 production databases(7x/8x) to provide support for branches.• Carried out new version rollouts after stringent stress testing. Handled temp tablespace/sort segment problems. Tuned queries. Reorganized tables and analyzed tables and indexes.• Used exp/imp to export and import from production database to dev/testing databases.• Solved buffer problem, shared pool problem and redo log problems.• Cloned production databases for testing and reporting.• Created users, tablespaces, roles and assigned privileges.• Performed cold backup, hot backup to provide support for instance crash and recovery purpose.• Used statspack, tkprof, sql trace and bstat-estat to gather the statistics and solve performance problems.• Debugged perl script to handle tuning statistics/database management.