Senior Oracle Dba/architect Resume
Phoenix, AZ
SUMMARY:
- I currently possess an active top secret security clearance with over eighteen years of Oracle DBA experience.
- I am capable of handling complex environments and architectures currently serving as a Senior Oracle DBA and Oracle Applications DBA with expertise in handling large projects with tight deadlines.
- I am a strong team player with good work ethics, communication skills, and ability to work independently with excellent customer service skills.
TECHNICAL SKILLS:
Operating Systems: Oracle VM server 3.0.1, Linux - Oracle Enterprise Linux 5.5, Red Hat 6 Linux 2.6-9, UNIX - Solaris 5.x, HP UX, AIX LPARs and Windows NT/2008, VM/CMS, OS/MVS (TSO, IMS, CICS, ENG, CMS, Batch)
RDBMS: Oracle, V7.3.4, V8.0.5, V8i, V9i, 10g, 11g, 12c and Microsoft SQL Server 6.5, 7.0, 2000
Applications: OEM Grid Control 11g, Oracle ERP Applications 10.7, 11.0, 11i, 12R Financials and Manufacturing, SAP R/3-4.5, SAP CTS
Hardware: IBM XIV Model 2812 A14 Enterprise SAN, SP, F5 BigIP LTM, 3900 Load Balancer, HP 9000 Series, Sun Ultra 6500/10K, IBM S/390Tools: BSM, ServiceNow, CommVault RMAN utility, IBM XIV, Device-Mapper Multipath, Kpartx, SQL*Plus, SQL*Loader, DataGuard, RAC, ASM, RMAN, Veritas Net backup, Remedy, StatsPack, Explain-Plan, AWR, Scheduler, Shell Scripting, ASH, REXX, JCL, Jscript, ABAP
PROFESSIONAL EXPERIENCE:
Senior Oracle DBA/Architect
Confidential, Phoenix, AZ
Responsibilities:
- Administer and configured 11g and 12c RAC AIX, Linux two node clusters with Active Dataguard Disaster Recovery RAC environments.
- Converted over one hundred Oracle DB environments running on Solaris and AIX servers over to VMware running Redhat Linux 2.5 - 7.
- Upgraded 10g-11g Oracle DB environments over to 12c.
- Installed and configured numerous replication environments utilizing Dataguard and GoldenGate configured with F5 LTM virtual networks.
- Perform numerous Dataguard disaster recovery scenarios utilizing parallel disaster recovery tests with Failover, switchover and snapshot standbys.
- Installed and configured APEX Development environment in support of Mobile application development. I created APS Oracle Runbook Application using APEX development language.
- Installed and c onfigured 12-13 c OEM Cloud Control in support of monitoring and administration of Oracle DB and WebLogic environments.
- Configured and Performed numerous RMAN backups and restores using Netbackup and Data Domain media managers.
Senior Oracle DBA
Confidential, Phoenix, AZ
Responsibilities:
- Worked on various internal company projects focused on deploying Oracle DB environments in support of Billing, Spatial and Workforce management systems. Administer Oracle 10g through 12c DB environments running on Solaris and Redhat Linux VM environments with RAC, ODA and stand-alone DB environments.
- Implemented a monitoring solution utilizing 12c Cloud Control to monitor and administer ninety Oracle DB and Weblogic application environments. Configured 12c environment to interact with Tivoli, Single-Sign-on and BMC Remedy ticket notification and escalation.
- Implemented a replication solution from Oracle DB environments to Microsoft SQL Server for internal and external customers utilizing Oracle Golden Gate 11g-12c.
- Implemented a Disaster Recovery and Reporting solution for our Production Oracle DB environments utilizing 11g Active and Logical Dataguard environments.
- Installed and administer Oracle Data Appliance X 4-2 in support of billing 11g Oracle DB environments.
- Implemented PCI compliant DB audit environment certified by Price-Waterhouse.
- Installed, configured and administer 11g Spatial DB environments in support of Synchronoss/SpatialNet environments.
- Installed, configured and administer 12c RAC two node DB environments in support of SingleView billing DB environments.
- Installed and deployed Delphix Appliance to create virtual test copies for deploying Oracle production copies for project team members on demand.
Senior Oracle Applications DBA (10.7NCA,11.0,11i,R12)
Confidential, Tempe, AZ
Responsibilities:
- County of San Diego Consultant administering Oracle Application 11.5.x environments
- Installed Oracle applications with single and multi-node configurations 10-R12
- Upgraded Oracle Applications Financials from 11.0 to 11.5.2
- Patched Oracle Applications Financials from 11.5.x to 11.5.10 using AD utilities
- Implemented Multi-Org and Multi-Currency modules for international customers
- Cloned Oracle applications 11.0 non-Rapid Clone and 11i using Rapid Clone
- Created disaster recovery and high availability DB environments using Dataguard
Consultant
Confidential
Responsibilities:
- Principal consultant to the City of Chicago managing their 311 environment which consists of administering twenty Oracle database (8i,9i,10g,11g) environments running on Unix Sun servers .
- Provide 24-7 on-call support 365 days a year including vacation and holiday coverage for internal staff
- Yearly contract renewed for the last seven years providing Motorola with an external revenue stream
- Upgrade Oracle database environments as requested (8i to 9i, 9i to 10g, 10g to 11g)
- Provide pro-active monitoring of DB environments and diagnosing Oracle alerts, opening Oracle Service Requests as needed
- Setup performance and tuning scripts, Statspack provide performance and tuning recommendations
- Verify DBMS JOBS are processing scheduled jobs, RMAN backups are completed
- Providing daily DB administration tasks such as adding RAW partitions to tablespaces as needed
Senior Oracle/VM Linux Administer
Confidential
Responsibilities:
- I worked on Infrastructure Architect team responsible for building and administering over one hundred Oracle VM 3.1 servers running Oracle Linux and Windows Operating systems.
- Configured virtual network servers using F5 BigIP System LTM 3900 configuring Load Balancer SSL certificates and termination configurations
- Administered the F5 server performing system upgrade from 9.4.8 to 10.2.3
- Configured networks and registering system domain names for physical and virtual distributed environments
- Configuring and administering Device-Mapper Multipath XIV disk allocation pools using kpartx
- Administered Guest VM’s utilizing XEN and Oracle 11g Grid control, performing various administration functions (Live migrate, VM creation, VM start/stop, shared disk allocation and volume/resource management)
- Provide on-call support for enterprise guest VM environments
- Created Virtual Server pools and allocated virtual servers to OEM 11g Grid Control
- Configured various file system configurations using local and SAN using LVM
- Attend daily agile scrum meetings with enterprise user groups to address and resolve issues
- Successfully set up two-node ASM/OCFS2 cluster and Oracle RAC configurations
- Successfully upgraded Oracle VM from 2.2.1 to 2.2.2 and upgraded IBM HAK 1.5 to 1.7
SAP R/3-4 Basis Administrator
Confidential
Responsibilities:
- Performing related DBA and SAP Basis administration functions including system monitoring, Transport Management System and backup/recovery, client copy, system refreshes, OSS and DB administration.
- Correction and Transport (CTS) Administrator
- SAP Oracle DB Administrator
Mainframe Systems Analyst
Confidential
Responsibilities:
- Providing support in an international 24x7 365 days Datacenter supporting various hardware architectures running IBM S/ 390 309 0, IBM SP, Sun Cyclones, HP, Tandem, VAX, StorageTek STK Silos running (TSO, CICS, Oracle, IMS, ENG, VM/CMS) environments.