Sarasota, Florida, United States
Senior Oracle DBA with 20+ years Oracle experience from version 4 to 19c working in the Health Care, Pharmaceutical, Defense, State/Local Government, Mass Transit and Finance Industries Manage high volume data environment in a variety of operational database ranging in sizes up to 30Tb Responsible for migrating databases between servers, Oracle version upgrades, creating standby environments. Provide performance engineering by analyzing instance to identify tuning opportunities and recommend solutions Develop Data Purge process to manage the removal of aged data from operational and secondary databases Apply Oracle patches in RAC as well as non RAC environments Developed partitioning schemes (range, hash, list, & composite) to tables/indexes as required for improved performance Tune statements for optimal execution plans to improve performance Configure/Manage Oracle's Virtualbox VM environment with Redhat Linux and Oracle's Enterprise Linux Experienced with Toad, Spotlight on Oracle RAC, Space Manager, SQL*Navigator, SQL*Developer, and Oracle Enterprise Manager Specialties: SQL, PL/SQL, Oracle Dictionary, Tuning, Partitioning, Toad, Spotlight on Oracle RAC, Space Manager, SQL*Navigator, SQL*Developer, OEM, ServiceNow
DOD Secret Security Clearance Status:ACTIVE Date: 2/28/2022 • ADG with Physical/Standby/Standby-RO/Snapshot • XTTS migration/upgrade from Big-Endian 12c to Small-Endian 19c • Manage pre/post masking activities after database refreshes • Remediate vulnerabilities identified by Tenable security scans • Work within Service Now for Changes, Incidents, Requests • Perform Senior DBA duties in a hybrid AIX, HPUX, Linux (Redhat/OEL), Exadata environment. • Supporting mix of DOD classified and non-classified databases up to 30Tb. • Versions from 8i thru 19c (RAC/Non-RAC/Multitenant) • Experienced in ASM/File System management. • Migrating 11g/12c databases to 19c (GRID/ASM and Database) • Monitor RMAN/DataPump backups • Utilize DataPump for schema level refreshes • Apply install/upgrades/patch in RAC and Non-RAC environments • Migrate databases as required for server upgrades RMAN duplicate • Utilize AWR objects to generate detailed historical performance reports and tuning suggestions • Manage Oracle SRs to completion • Participate in meetings and make presentations as required • Utilize crontab to automate custom shell scripting for management • Experienced with Service Now for processing Changes, Incident, Requests and reporting • Mentor Junior DBAs • Participate in On-Call rotation.
• Perform Senior DBA duties in a hybrid Linux, Solaris, Exadata environment. • Apply install/upgrades/patch in RAC and Non-RAC environments • Utilize OEM for operational tasks (dev refresh, alerts, backups, etc) • Manage operational software patch process • Perform constant analytical reviews of production databases to proactively identify performance and environment issues to various business units senior management • Utilize AWR objects to generate detailed historical performance reports and tuning suggestions • Recommend Tuning suggestion on problematic logic to business units to include indexing, stats, and baselines • Generate/edit numerous packages/procedures in an Oracle12c/18c/19c environment • Modify/Create database objects employing partitioning, views, indexes as required • Detailed reporting on space utilization to show fragmented tablespaces with recommendations on recovering free and bubble space • Assist development team members on optimizing objects • Interface with all business units to facilitate production DDL/DML deployments utilizing GIT & Jenkins or SQL*Plus as required • Participate as part of Incident Management Team • Manage Oracle SRs to completion • Utilize VirtualBox to create VMs for test bedding prototype processes. • Participate in meetings and make presentations as required • Train Junior DBAs in best practices • Participate in On-Call rotation
• Perform constant analytical reviews of production database to proactively identify performance and environment issues to various business units senior management • Utilize AWR objects to generate detailed historical performance reports and tuning suggestions • Utilize OEM for real time analysis • Recommend Tuning suggestion on problematic logic to business units to include indexing, stats, and baselines • Install/Upgrade/Patch RAC/Database/Client software as required in a 12c,18c,19c environment • Detailed reporting on space utilization to show fragmented tablespaces with recommendations on recovering free and bubble space • Assist development team on optimizing objects • Interface with all business units to facilitate production DDL/DML deployments • Participate as part of Incident Management Team • Manage Oracle SRs to completion • Participate in rotational on-call support • Utilize VirtualBox to create VMs for test bedding prototype processes. • Participate in meetings and make presentations as required • Train Junior DBAs in best practices
• Senior Oracle 12c SE DBA in a Windows 2K12 environment • Apply installs/upgrades in Grid Restart environment • Utilize Toad and Spotlight on Oracle to manage environment • Manage/implement operational software patch process • Insure daily backups via RMAN are functioning • Develop validation process to insure the RMAN backup documentation is complete • Implement DR validation process to insure recoverability planning is functioning • Manage clone/refresh via RMAN • Manage/Report on storage for databases and applications • Monitor table space I/O and modify data file layout for optimum performance • Recommend/apply database performance improvements • Report on underutilized indexes • Manage APEX 5.1 environment • Install/Configure Apache Tomcat • Install/Configure ORDS • Develop/Implement data masking process to protect PII data in Dev/QA • Create/monitor users/roles • Assist development team on optimizing objects • Manage/Report on storage for databases and applications • Manage Oracle SRs to completion • Participate in rotational on-call support • Utilize VirtualBox to create VMs for test bedding prototype processes.
• Senior Oracle DBA in a Windows 2K12 environment and Linux v5 environment • Supporting PeopleSoft HCM/Financials • Manage operational software patch process • Configure/validate RMAN processes for DR/Clone processes • Manage/Report on storage for databases and applications • Monitor table space I/O and modify data file layout for optimum performance • Recommend/apply database performance improvements • Manage Oracle SRs to completion • Participate in rotational on-call support