We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

San Jose, CaliforniA

SUMMARY

  • Oracle DBA and developer since Oracle Version 7.3.
  • Oracle RAC DBA since Oracle Version 10.2.
  • Several years as SAN storage administrator of Confidential ’s SAN Volume Controller and DS8000.
  • Have written several white papers detailing best practices for running Oracle on Confidential ’s SAN storage, including: designing storage layout for optimal
  • Oracle performance and availability the usage of Confidential SAN block storage Snapshot technologies for backup/recovery and Disaster Recovery
  • Oracle databases the effective usage of thin provisioning for Oracle databases the monitoring of all aspects of infrastructure performance
  • Including at the database level, the server level and the storage level the effective usage of both storage - level and Oracle-level benchmarking tools
  • Oracle performance tuning tools and methodologies - SQL execution plans, tracing, Automatic Workload Repository (AWR), Active Session History (ASH) and Wait events.
  • Oracle backup and recovery and Disaster Recovery - RMAN, Data Guard, User-Managed Recovery.
  • Confidential SAN block storage configuration.
  • Confidential ’s storage monitoring product Tivoli Storage Productivity Center 5.2.7.
  • Storage-level and Oracle-level benchmarking tools.

TECHNICAL SKILLS

DATABASE: Oracle RDBMS since Version 7.3

LANGUAGES: SQL, PL/SQL, Korn, C, and Bourne shells, Python, Perl, C, Java, Pro*C

OPERATING SYSTEMS: Many years as a System Administrator and end - user on Open Systems, including Linux, AIX, Solaris and HP-UX.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

Senior Oracle DBA

Responsibilities:

  • Worked extensively in determining best practices for running Oracle RAC, Versions 10.2 - 12c, on Confidential ’s SAN block storage, including the SAN Volume Controller and the DS8000.
  • Used freely available storage-level and Oracle-level benchmarking tools for proof-of-concept configurations.
  • The storage-level benchmarking tools included Vdbench, fio and Orion. The Oracle-level tools included Swingbench, Hammerdb and SLOB.
  • Wrote white papers detailing the results of the proof-of-concept testing.

Confidential, San Jose, California

Senior Oracle DBA

Responsibilities:

  • Working in support of a health services client of Confidential . Supported 24x7 web-based application which entailed performance monitoring, backup/recovery, and Disaster Recovery via Oracle 9i Data Guard. Responsible for upgrades from Oracle 9.2 to Oracle 10.2.

Confidential, Plano, Texas

Oracle DBA

Responsibilities:

  • Responsible for deployment of Avantis Asset Manager on Oracle 9i and HP-UX 11i (capacity planning, security setup, development support).
  • Maintained Oracle Financials 11.0.28 installation. Applied patches and supported the development team. Streamlined the production-to-test cloning procedure reducing time required by 50%.
  • Supported Replication environment which was used for reporting on subset of Financials data.

Confidential, Dallas, Texas

Lead Oracle DBA

Responsibilities:

  • Upgraded and consolidated backup and recovery architecture to address problems with data loss.
  • New setup accommodated rapidly growing databases and allowed eventual nightly backup of several TB’s of data.
  • Implemented first installation of Sun's High Availability Cluster architecture in a TI wafer fab.
  • Trained developers in SQL performance tuning techniques.
  • Mentored and trained other Oracle DBA's.

Confidential, Irving, Texas

Lead Oracle DBA

Responsibilities:

  • Performed all AIX host operating system, database, and 3rd-party software installation and configuration.
  • Set up backup and recovery architecture for all database and middle-tier hosts.
  • Installed and administered Oracle Transparent Gateway for Confidential DRDA 4.0.1 to allow direct Oracle connection to a DB2 database running on MVS Confidential mainframe.

Confidential, Dallas, Texas

Primary Oracle DBA

Responsibilities:

  • Deployed a new implementation of Oracle Financials Accounts Receivable which was being migrated from a mainframe application. Deployment was achieved on time and under budget.
  • Revamped backup and recovery strategy for all databases, including changing from periodic offline backups to nightly online backups.
  • Cross-trained Sybase and DB2 DBA's to be able to perform maintenance tasks on Oracle databases.

Confidential, Dallas, Texas

Oracle DBA

Responsibilities:

  • Regularly addressed performance tuning issues for SQL and instance-level configuration.
  • Performed periodic large-scale tablespace Confidential 's.
  • Automated via shell script the production-to-development cloning process.
  • Installed and maintained Oracle Financials 10.4.

Hire Now