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/Technical Architect

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 (Las Colinas), 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