We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

4.00/5 (Submit Your Rating)

CaliforniA

SUMMARY


Oracle Database Administrator with more than ten years of experience managing support for mission critical, 24x7 databases on multiple, diverse platforms. Skilled in developing enterprise solutions, and implementing/configuring application requirements; initiates database upgrades and enhancements to ensure scalable, sustainable solutions. Maximizes database availability, reliability, performance, and security; consistently meets project management deadlines.

Areas of Expertise
Database Architecture & Implementation ? Data Models ? Database Design ? Preventive Maintenance
Performance Monitoring ? Diagnostics & Tuning ? Shell Scripting ? Backup & Recovery Planning ? User & Security Management

Notable Projects

  • Coordinated with system administrators and application support team on disaster recovery planning, ensuring full restoration and functionality of application/database; performed testing to ensure system operability.
  • Facilitated configuration and testing of Oracle Data Guard High Availability solution; successfully verified primary and standby role transition to ensure data security.
  • Implemented transparent data encryption and fine grain audit in Oracle databases to protect customer sensitive data as part of payment card industry compliance project.
  • Integral in transition from Vantive legacy system to Peoplesoft CRM, establishing new Oracle databases and application servers, performing data migration, leading application troubleshooting and performance tuning, and collaborating with developers to identify resource intensive SQLs and tuning recommendations.
  • Increased storage and computing capacity use via historical data archiving with partitions and transportable tablespaces.
  • Configured GoldenGate data replication between Oracle and MySQL databases using Oracle redologs on ASM.
  • Experience
    Confidential,CALIFORNIA 2012-Present
    Oracle Database Administrator [contract]

  • Integral in TriZetto Facets Upgrade project, Oracle database duplications to new hardware and upgrade from 10g to 11g,
  • Application code deployment, data transfer, replication setup utilizing logical standby databases,
  • Performance troubleshooting
  • Confidential,Oracle Database Administrator [contract] 2011-2012

  • Facilitated Portfolio warehouse project for Thomson Reuters, ensured database functionality and performance,
  • Managed OEM grid control 11gR1 installation on Oracle Linux and agents 11g and 10g on Sparc Solaris,
  • Upgraded RAC from 11gr1 to 11gr2. Moved OCR and voting disks into ASM.
  • Confidential,Oracle Database Administrator 2002-2011

  • Direct design, modeling, and performance testing on Oracle platform; assessed application requirements and executed capacity planning; led database installation, configuration, and maintenance.
  • Oversaw database security and health, writing scripts to automate functions and implementing fixes to application issues as well as spearheading backup and recover procedures.
  • Supported 30 databases on Solaris platform with 24x7 on-call service, from simple to complex designs, for development, quality control, performance testing, production, and disaster recovery.
  • Spearheaded cost-saving initiative by researching use of open source Tomcat java web server for user management application versus Sun Java Web Server, then implementing and configuring Tomcat solution to match requirements.
  • Confidential,Oracle Database Administrator 2000-2002

  • Managed AT&T contract to provide database design, development, and support utilizing Oracle technologies; contracted role was transitioned to AT&T internal position to continue project launch and enhancements.
  • Confidential,Oracle Database Administrator | System & SAP Administrator 1996-2000

  • Executed Oracle, HP UNIX, and SAP/R3 database administration and held integral role in companywide SAP implementation.
  • Led installation, configuration, and maintenance of UNIX servers, Oracle databases, and SAP applications in development, testing, and production environments; provided user support to technical and non-technical personnel.
  • Education

    Bachelor’s Degree in Telecommunications Engineering [Bachelor’s equivalent]

    Technical Skills

    Database: Oracle Enterprise Edition 11g/10g/9i and lower, SQL, PL/SQL, High Availability Veritas Cluster Server, Oracle
    Data Guard, DG Broker, RMAN with Netbackup/TSM, ASM, RAC, OEM Grid Control, AWR, ADDM,ASMM, ASSM,SQL Tuning Advisor, outlines, Data pump, SQL Loader, SQL Net, JDBC, flashback, partitioning, transportable tablespaces, transparent data encryption, fine grain auditing, parallel query, online table redefinition, materialized views, GoldenGate Replication

    Operating Systems: SPARC Solaris, AIX, Linux, HP-UX, Windows, Oracle Enterprise Linux, Oracle VM Virtual Box, VMware

    Applications: PeopleSoft CRM, Vantive, SAP R3 and ATT internal applications (customer billing and DSL member profile systems)

    Languages: UNIX Shell Scripting, Perl, JSP, HTML

    Monitors: BMC Patrol for Oracle, Symantec I3 Indepth/Precise for Oracle/PeopleSoft

    Webservers: iPlanet, Tomcat, Weblogic, Tuxedo, JDK

    Software Revision Control Systems: CVS, Continuous, ITIL Configuration Management, Change Management, Problem
    Management and Release Management processes

    Professional Development

    ?Oracle Database 10g: Performance Tuning
    ?PeopleTools
    ?HP-UX Troubleshooting
    ?SAP R/3 Basis Technology
    ?Oracle Web Server Administration
    ?Oracle7 Server Administration
    ?AT&T Oracle on-site Support Trainings
    ?Skillport – AT&T specific training website
    ?Oracle 11g Database Architecture and ASM
    ?Installation of Clusterware and RAC
    ?RAC Database and Oracle Clusterware Administration
    ?High Availability in RAC
    ?Diagnosing Oracle Clusterware and Node Management
    ?Configure, Manage, and Use Services in RAC
    ?RAC Performance Tuning
    ?Oracle 11g Using RMAN for Recovery

    We'd love your feedback!