SUMMARY

• Confidential is a senior Oracle DBA with over 20 years of database consulting experience encompassing multiple companies and industries.
• His expertise rests in multiple Oracle database versions including Oracle 6, 7, 8i, 9i, 10g, 11g12c and 19c.
• He also has experience utilizing RAC and DataGuard and in several flavors of Unix including Linux (RedHat, SuSe, Fedora), Solaris, SunOS, HP/UX and AIX, SCO - Unix, TSO.
• He has successfully completed numerous projects involving new database deployments, upgrades, platform migrations, complete and partial database recoveries, data recoveries and patching. He has also performed several Oracle RAC installations and upgrades and database migrations to AWS cloud and Oracle OCI .

TECHNICAL SKILLS

DBMS Systems: Oracle (19c, 12c, 11g, 10g, 9i, 8i, 7, 6), RAC, Data Guard, Oracle Financials 11.5.9 iAS, AP (9.4, 10.5)

ERP Tools: ERwin, S-designer, Oracle Designer 2000, Oracle Forms, Oracle Developer, Oracle Financials

DBA Tools: Oracle Enterprise Manager/Grid Control/Cloud Control (10g, 11, 12C, 13c), BMC Patrol, HP OpenView, RMAN, ASM, TOAD, SQR Workbench

Middleware: WebSphere, Tuxedo (TP Monitor)

Hardware: Sun Fire Series, Sun Sparc (10, 20, 2000), IBM P690, IBM P670, IBM RS/6000, IBM SP2, SAN, NAS, EMC HP 9000, Compaq Proliant, RAID, EMC, NetApp

OS, Networks: Solaris, AIX HP/UX, Red Hat Linux, VMware, Fedora, Windows NT, X Windows (Motif), Veritas Cluster Software (VCS) TCP/IP, IBM HACMP, Windows (10, XP, 2000, 7)

Languages: UNIX Shell (Korn, Bourne, Bash), AWK, SED, C, Pro*C, SQL*Plus, PL/SQL, Pro*Cobol, exposure to Python

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Assist in developing basic infrastructure tasks/procedures/scripts for DBA Practice/Client support
• Provide Oracle database/environment support for various clients. National Geographic, Galderma, Fortegra, SPE, Mercer, TRAC Intermodal, GameStop, G6/Hospitality, GlenRaven, Maritz
• Perform OEM/Cloud Control installation, configuration, maintenance, monitoring rules/notification
• Develop install Linux O/S scripts to monitor and report client and internal database issues, application and O/S events and issues.
• Database migrations from on-premise to AWS and Oracle OCI environments
• Configure RMAN backup to AWS S3 storage
• Provide database maintenance/patching, Oracle CRS infrastructure patching
• Develop and schedule for periodic execution scripts to monitor DR readiness and StandBy Database status Provide Oracle Dataguard support for DR execution and functionality

Confidential, Dallas, TX

Consultant/SR Oracle DBA

Responsibilities:

• Maintain, Tune, Support Oracle 11g databases running in EMC/NetApp RAC environment on Solaris 8 O/S and RedHat
• Application migrations through full life-cycle (Development to QA to Production)
• Database troubleshooting, performance monitoring and tuning
• Application troubleshooting and performance tuning
• 24x7 Production on-call rotation
• UNIX Shell scripting to support Enterprise database and cluster monitoring, CRON processes, database creation and automated database reporting
• Daily monitoring of database backup, space utilization, performance and OS utilization.
• Oracle CRS upgrades(11g)
• Utilize 12C OEM in database monitoring and support
• SAN space management to support numerous databases
• Remote database work performed as needed for scheduled procedures and 24x7 On-Call support
• Install 12c CRS, upgrade 11g CRS to 12c CRS

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Install Oracle 11g databases to Linux RedHat environments
• Database troubleshooting
• RMAN Backup and recovery
• Performance monitoring, tuning and problem resolution
• Application support
• JD Edwards upgrade database migration and support
• SQL Script execution to meet user requests
• Configuration of Oracle OEM 12c,patch as needed
• Application team interface for problem resolution
• Project/database documentation creation
• Oracle SR submission
• RMAN / Export backups and recovery
• SQL query tuning to support applications
• Database replication, migrate data copies from/to databases environments
• 24x7 Production on-call rotation

Confidential, Irving, TX

Consultant/Oracle DBA

Responsibilities:

• Install Oracle 10g and 11g databases to Solaris/AIX environments
• Database troubleshooting
• Performance monitoring, tuning and problem resolution
• SQL Script execution to meet user requests
• Database monitoring and admin from GRID
• Application team interface for problem resolution
• Project documentation creation
• Oracle SR submission
• Physical database migration from datacenter to datacenter
• RMAN backups and recovery
• Database standby testing
• Database patching
• Database failover, switchover and flashback testing

Confidential, Dallas, TX

Consultant/SR Oracle DBA

Responsibilities:

• Install Oracle 10g and 11g EE software to Linux servers (SuSe, RedHat)
• Create RAC databases in Oracle 10g RAC (SuSe) environments and 11g RAC environments (SuSe, RedHat)
• Maintain, Tune, Support Oracle 11g, 10g and 9i RAC databases running in Fujitsu/Siemens RAC environment on Solaris 8 O/S, and SuSe and RedHat
• Application migrations from 9i to 10g databases, from 10g to 11g
• Application migrations through full life-cycle (Development to QA to Production)
• Interaction with third party vendors and internal management to coordinate and assist in third party application installation, tuning and troubleshooting
• Database troubleshooting, performance monitoring and tuning
• Application troubleshooting and performance tuning
• 24x7 Production On-Call rotation
• OEM and GRID configuration
• UNIX Shell scripting to support Enterprise database and cluster monitoring, database creation and automated database reporting
• Daily monitoring of database backup, space utilization, performance and OS utilization
• Install local agents and configure GRID to help monitor RAC databases and OS environments
• Oracle Database and Cluster installation on Linux (SuSe and RedHat)
• Data migration/refresh from production to QA/SAT and development.
• Remote database work performed as needed for scheduled procedures
• SAN space management
• Created a backup and refresh/update process for all CRON configurations on development, QA and Production UNIX machines using native shell scripting and a centralized repository

Confidential, Fort Worth, TX

Consultant/Oracle Apps DBA

Responsibilities:

• Database cloning, upgrades, machine migrations (AIX and Windows 2003)
• Proprietary application and database migrations
• Database troubleshooting
• Develop and document process and procedure to migrate Oracle v8 databases and applications to Oracle v9 databases (using UNIX shell scripts, SQL*Plus, PL/SQL)
• OEM configuration

Confidential, Carrollton, TX

Consultant/Oracle DBA

Responsibilities:

• Data migration using Oracle export/import, Oracle DataPump
• Utilized Dataguard to maintain the standby databases in the RAC cluster
• ORABPEL installation and support
• Oracle Application Server support and maintenance
• Tier 1 Production support, on-call support, 24/7
• Data and Database Backup and recovery
• Support of multiple large 10g terabyte databases and applications in a RAC environment
• Development support in an Oracle 10g environment
• Query/Code evaluation for performance tuning and lock contention resolution
• Code Migrations
• Data loading, purging using SQL or PL/SQL
• Database cloning in Sun Solaris environments (UNIX)
• Oracle database problem resolution with Oracle Metalink
• Tuning database, application, SQL and PL/SQ
• Capacity Planning
• OEM installation configuration

Confidential, Richardson, TX

Consultant/Oracle DBA

Responsibilities:

• Development Support of numerous databases of various versions and sizes (8i, 9i, 10g)
• Database creation, upgrades, cloning, tuning, troubleshooting, daily monitoring and security
• Migration of Non-ASM databases into ASM
• Application debugging and tuning
• Development and Production database lifecycle testing
• Installation and configuration of Oracle Enterprise Manager (now part of Oracle Fusion Middleware) on HP*UX to monitor and manage 30+ databases.
• Configuration and management of parallel Oracle Application Server, allowing SQL access from the application server web interface.
• Creation of various PL/SQL packages, procedures, scripts, functions, triggers to automate some DBA tasks and provide users restricted access to some DBA responsibilities such as killing sessions.
• RMAN to manage files within Oracle ASM
• Code and Data migrations
• Data Conversion
• SQL Server data to Oracle conversion

Confidential, Dallas, TX

Consultant/SR Oracle DBA

Responsibilities:

• Evaluation and performance tuning of Confidential application modules and database code (PL/SQL, SQL*Plus scripts, Packages, Procedures and Triggers)
• Oracle error resolution in application and database
• Correction of application modules errors
• Evaluation of in-house and client databases for tuning improvements in support of Confidential Application software
• Production and development support (database and application)

Confidential, St. Louis, MO

Consultant/Oracle DBA

Responsibilities:

• Evaluation of application modules (PL/SQL, Pro*C, etc.) for tuning improvements
• Evaluate physical databases for potential issues and tuning improvements (Windows, Unix environments)
• Assist developers with code design, development, testing and implementation
• Provide management with physical/logical perspective of application databases at client sites and suggest tuning and installation improvements
• Troubleshoot and resolve existing application problems (tuning, Oracle errors, etc.) at various client sites
• Provide developers and support technicians with direction to identify and resolve Oracle Forms, PL/SQL, SQL/Plus related issues

Confidential, Richardson, TX

Consultant/Oracle DBA

Responsibilities:

• Modified as needed database triggers, stored procedures, Oracle Forms (6i) to support modifications to Banner application
• Created and tuned new code (PL/SQL, triggers, stored procedures, SQL*Plus scripts, Shell scripts, Pro*C and Pro*Cobol) to meet design project requirements and acceptable performance standards
• Made tuning recommendations for database and applications when warranted.
• Production Support of Banner Application
• Database and application troubleshooting and problem resolution
• Direct interaction with client to resolve database and application issues

Confidential, Ft. Worth, TX

Consultant/Oracle DBA

Responsibilities:

• Developed database triggers, stored procedures, Oracle Forms (6i) to support modifications to Banner application
• Created and tuned new code (PL/SQL, triggers, stored procedures, SQL*Plus scripts) to meet design requirements and acceptable performance standards
• Designed, created new database tables to support modifications to Banner
• Made tuning recommendations for database and applications when warranted

Confidential, Richardson, TX

Consultant/Oracle DBA

Responsibilities:

• Troubleshoot and correct reported problems with PL/SQL, Pro*C and Oracle Forms (6i) programs supporting SCT Banner Application
• Tuned existing PL/SQL and Pro*C programs
• Created new PL/SQL, PL/SQL Packages and Procedures, Triggers, Pro*C and SQL*Plus programs in support of the SCT Banner application and Oracle 8i database
• Made tuning recommendations for Oracle 8i databases when tuning issues are recognized
• Utilized UNIX shell scripts or commands to manipulate large input/output data files Details on additional projects prior to 2004 are available upon request.