DBA on Oracle and DB2 Resume

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

DBA on Oracle and DB2

Responsibilities:

Turn ERD into DDL
Responsible for DB install, configuration, upgrades and migration of all Prod Databases
Responsible for 2 DBAs' that work for me.
Responsible for Backup and Recovery plans
Responsible for database security: authentication, authorization (setting permissions), and auditing
Responsible for Storage and Capacity planning
Responsible for Performance monitoring and tuning - Proactive tuning
Implemented DB2 HACMP
Implemented replication on DB2 and Oracle
Interfaced with TSM to backup databases on DB2 and Oracle
Oracle Rman experience
Install DB2 Fixpaks and Oracle Patches
Upgraded DB2 to V6, V7, V8, V9, and V10
Upgraded Oracle to V6, V7, V8, V9, V10 and V11
Disaster Recovery testing yearly - DB2 and Oracle
Maintain 50+ production databases
Maintain 100+ test databases

Confidential

Manager of Systems and Programming

Responsibilities:

Confidential

System Analyst

Responsibilities:

Implemented a Material Requirements Planning system for Laclede's manufacturing of Steel Pipe.
Teh system included order entry, forecasting, inventory tracking, bill of material, machine scheduling and shipment scheduling.