EXPERIENCE SUMMARY:

Oracle DBA/Developer with over 30 years of experience. My background includes: Extensive experience with PL/SQL and Oracle database administration/ Experience with database migration/ Experience in Database Modeling using Erwin/Excellent communication and problem solving skills

SKILLS SUMMARY:

• Oracle 9i - 12c RAC; SQL Server 2005 - 2012; Shell Scripting; ERwin; PL/SQL; COBOL;
• DataGuard; SAP Data Services; Crystal Reports; TOAD; Cron; Performance Tuning; FORTRAN;
• Pl/1; Corba; Project Management; Data Warehouse; SAP Business Objects; Solaris;
• HP-UX; Grid Control; Microsoft Project; Disaster Recovery; Manufacturing;
• Financials; Insurance; Marketing; Direct Mail; Linux, HP/UX, Windows, AIX

PROFESSIONAL EXPERIENCE:

Confidential, Toledo, OH

Database Administrator

Responsibilities:

• Database Administrator MySQL 5, 8 Pe;rcona
• Optimize, implement SQL from development
• Support Production, Stage, and Development Environments (Linux)
• Backup/Implement code to production
• Support data/code migration for merger activities from iPayx to Confidential
• Agile methodology

Confidential, Romulus, MI

Sr Database Engineer

Responsibilities:

• Migrate Oracle 11g production databases from HPUX to Linux Rhel 7.3 (major project)
• Implement OEM Cloud 12c on Linux
• 3rd level support help desk
• Database tuning, rman and datapump backups, refreshes.
• Database design.

Confidential, Detroit, MI

Database Engineer (Consultant)

Responsibilities:

• Database Administrator (Oracle 11g/12c), HP/UX, RHEL
• Retiring, Upgrading, Installing, Migrating Oracle databases
• Database tuning and PL/SQL optimization
• 3rd level support

Confidential, Detroit, MI

Sr Database Administrator

Responsibilities:

• Database Administrator/Developer for Health Care System (Oracle 11gR2)
• Model and develop SAP Business Objects universes for Crystal Reports
• Create SAP Data Services jobs to process and exchange data from Oracle 11g, SQL Server 2012, Excel, XML, and external flat files
• Database Design and Modeling using ERwin
• Database Administrator for Health Care Databases on SQL Server 2012
• Mentor for the developers using PL/SQL (optimization and strategy)
• Member of the solutions architect team (strategy and vision)
• HP/UX, Windows 7, RHEL

Confidential, Palo Alto, CA

Database Engineer

Responsibilities:

• Database support and development (Oracle 11g r2, SQL Server 2008 r2) for state and local government
• Model, map, install, develop, tune, Oracle 11G for the Massachusetts Registry of Motor Vehicles (Custom)
• Data conversion for Microsoft CRM for Early Childhood Development of the state of Florida (new system install) Data modeling. PL/SQL. Design. Application DBA for DELPHI Deeds(Automotive) project, ETL programming
• Map, Model, and design database for MRP scheduling tools using ERwin
• Provide performance tuning and benchmarking for Oracle 11g RDBMS on HPUX and RHEL
• Upgrade RAC 10g to 11g RDBMS. Create Standby databases for disaster recovery
• Provide third level support using Service Manager for Confidential and Confidential
• Provided performance tuning and benchmarking for Oracle 11g RDBMS on HPUX and RHEL
• Upgrade RAC 10g to 11g RDBMS. Create Standby databases for disaster recovery
• Provide third level support using Service Manager for Confidential Insurance
• Operating System Environments: Windows 7, Linux, HPUX

Confidential

Sr. Database Administrator

Responsibilities:

• Provide performance tuning and benchmarking for Oracle 11g RDBMS on HPUX and RHEL
• Upgrade RAC 10g to 11g RDBMS. Create Standby databases for disaster recovery
• Provide third level support using Service Manager
• Operating System Environments: Windows 7, Linux, HPUX

Confidential

Sr. Database Administrator

Responsibilities:

• Provided performance tuning and benchmarking for Oracle 11g RDBMS on HPUX and RHEL.
• Upgrade RAC 10g to 11g RDBMS. Oracle Streams. Create Standby databases for disaster recovery
• Provide third level support using Service Manager
• Operating System Environments: Linux, HPUX

Confidential

DBA Specialist

Responsibilities:

• Perform upgrade of Oracle9i RDBMS to Oracle 10g RDBMS on HP-UX operating system
• Support Senior Market users with respect to performance tuning, benchmarking, schema changes, and package implementation
• Created a physical standby database (Dataguard). Assist developers with code design and optimization
• Database design and Modeling for Billing system using ERwin
• Participated in the development and testing of disaster recovery. Implemented RMAN backup and recovery
• Implemented Grid Control for centralized monitoring of production, stage, and development databases
• Operating System Environments:, HP/UX, Sun Solaris

Confidential

Senior Oracle DBA

Responsibilities:

• Implement Oracle 10g RAC on Sun Solaris for JD Edwards migration from AS400 DB2 RDBMS
• Implement and administer Oracle Application Server
• Supported EDI for Lowes
• Provided performance tuning and benchmarking
• Develop packages and procedures for the data migration
• Implemented Dataguard and RMAN for backup and recovery
• Set up Metalink for problem resolution and patching
• Attended training for 11i RAC implementation and Oracle Application Server implementation
• Database design and modeling for DB2 migration to Oracle using ERwin
• Provided performance tuning and benchmarking for Oracle 10g RDBMS on Windows 2003 servers for the Educational Loan systems
• Provided backup support for SQL Server. Responsible for developing a data warehouse
• Developed packages, procedures, functions and triggers as required (Amarr Garage Doors, Inc)
• Provided performance tuning and benchmarking for Oracle 10g RDBMS on Windows 2003 servers for the Educational Loan systems
• Developed Materialized views for performance enhancement. Provided backup support for SQL Server. Responsible for developing a data warehouse
• Developed packages, procedures, functions and triggers as required. (Campus Partners)
• Install Oracle Grid Control for centralized monitoring of over 150 Oracle (8i, 9i, and 10g) RDBMS
• Provided partitioning for performance of Volvo Link Truck tracking system
• Provided benchmarking and performance tuning for databases
• Used Metalink for problem resolution and tracking
• Wrote shell scripts (AIX) and packages, procedures, and triggers (PL/SQL) as necessary
• Used BMC backtrack for backup and restore. (Volvo Trucks of North America)

Confidential

Oracle DBA

Responsibilities:

• Installed and supported Oracle 8i, 9i, and 10G RAC databases
• Provided performance tuning and benchmarking
• Used Metalink for problem resolution and patching. Attended training for Oracle Forms and Reports
• Developed Oracle Forms and Reports (6i)
• Provided custom application development and administration 9i Oracle Application server
• Created Oracle instances on Sun Solaris and Windows 2000 (NT) servers
• Provided Oracle financials application database support. Created views for interfaces from custom Oracle Project systems (PRESTO) to UK Oracle Financial apps
• Implemented security and data integrity procedures to support Sarbanes-Oxley regulations
• Provided Project Management of PTO (paid time off) and was responsible for the Database design and modeling using ERwin
• Designed and Supported data warehouse (dimensional modeling, ETL coding PLSQL)
• Wrote ETL packages and procedures
• Created data partitioning for large market demographics tables
• COLDFUSION/MX web interface (9 web servers load balanced) T1, T3, Cisco, EMC CX600 with cloning for rapid crash recovery. Raid 10 data Raid 5 archive. Created Standby database (Dataguard)
• Wrote RMAN scripts to perform backup/recovery
• 24/7 support for the production environment
• 10G RAC installation and support (OCFS and ASM)
• Attended Kimball University (San Francisco) for warehouse training

Confidential

Systems Analyst/Oracle DBA

Responsibilities:

• Implement Oracle 8i RDBMS on UNIX AIX RISC 6000. Provided performance tuning, monitoring, and benchmarking
• Informix and PeopleSoft support
• Provided PL/SQL programming as required (packages, procedures, triggers)
• Received certificates in Oracle Manufacturing, Purchasing/Financials application for release 11
• Supported Oracle applications
• Engineered PCARD (purchasing card system) to interface with our web-based procurement system and ultimately fed Oracle Purchasing and GL
• Project Leader for Oracle Purchasing and A/P team
• Participated as Six Sigma member for IS