We provide IT Staff Augmentation Services!

Oracle Dba Consultant Resume Profile

5.00/5 (Submit Your Rating)

GA

Hire Now

Summary

Confidential is an Oracle DBA with 17 years of DBA experience, 8 years as an Oracle DBA OCP 11g, OCP 10g . His experience includes database creating, upgrading, monitoring, performance tuning, backup and restore, implementing security, documenting, and the application development cycle. Ron has excellent verbal, written communication, and interpersonal skills as well as the ability to work well in a team environment. Experience with Oracle, SQL Server, and Sybase.

Skills/Tools

  • Hardware: Sun, hp, ibm, dell, unix servers, pc's
  • Software: Oracle Database 11gr2, 11g, 10g, 9i, 8i, 8, 7.3 Sybase Adaptive Server 15 - 10 Microsoft SQL Server 2008, 2005, 2000. 7, 6.5 Sybase Replication Server 11.51, 11.
  • Operating Systems: Linux, Unix, HP-UX, Solaris, AIX, Windows.
  • Others: Oracle oem grid control 11g, oem database control, rman, remedy, sqlplus, sql developer, sql loader, datapump, dbartisian, erwin, Sybase tools, Microsoft enterprise manager.
  • Language: SQL, PL/SQL, Transact-SQL, unix shells bash, korn, bourne, adabase natural.
  • Professional Training: Oracle Database 10g R2: RAC for Administrators 5 day class
  • SAP HANA E-Learning HA100, HA200, HA300

Professional Experience

CONFIDENTIAL

  • Supported SAP ECC 6 ecosystem oracle 11g databases on HP Unix and linux with database sizes up to 20 TB.
  • Supported 100 sql server databases on versions 2008, 2005.
  • Provided rotating 24/7 support to sap basis team.
  • Worked with basis team to troubleshoot and improve sap performance.
  • Performed performance and tuning using awr, ash, addm, spa, advisors.
  • Performed database backup and duplication using rman.
  • Used Oracle Grid Control to monitor databases.
  • Used and maintained korn shell scripts to monitor databases.

CONFIDENTIAL

Supported over 500 Oracle databases on 11gr2, 11gr1, 10gr2 on AIX Unix.

  • Databases included prod, test, dev rac one node on asm storage data guard physical standby, goldengate replication.
  • Monitored databases using OEM Grid Control 11g, remedy, and shell scripts.
  • Backed up databases using rman to unix fs, emc data domain and emc avamar.
  • Performed performance and tuning using awr, ash, addm, spa, advisors.
  • Installed database and application patches.
  • Refreshed lower environments with datapump and export / import.
  • Copied databases using rman duplicate database and physical standby.

CONFIDENTIAL

Oracle DBA Consultant

  • Evaluated client's oracle warehouses and made recommendations for performance improvement.
  • Focused on parallel query, partitioning, compression, bitmap indexes, star transformations, init parameters, tuning individual queries, ETL data loading, balanced configuration, optimizer statistics, and testing warehouse performance in database 11gr2.

CONFIDENTIAL

Oracle DBA

Supported AHLTA Databases military health care application

  • Supported over 100 Oracle 10g databases on windows 2003.
  • Supported main AHLTA 50 terabyte database.
  • Installed database and application patches.
  • Monitored databases using OEM, shell scripts.
  • Monitored oracle standby databases.

CONFIDENTIAL

  • Supported SQL Server Production databases on version 2005, 2000
  • Supported Sybase Production databases on version 15, 12.5, 12, 11.92, 11.5, 11
  • Supported Oracle Production databases on versions 11g, 10g, 9i, 8i, 7.3
  • Installed, patched, configured database software.
  • Monitored, maintained, tuned databases.
  • Configured and monitored database backups.
  • Assisted developers in troubleshooting sql performance issues.
  • Duplicated production db's to lower environments using snapshots.
  • Used Oracle OEM Grid Control, toad, sqlplus to manage databases.
  • Monitored space usage, performance tuning.
  • Created oracle servers, configured rman and oem database control.
  • Managed daily tasks using unix scripts via cron.
  • Proactive real-time monitoring with oem grid control and cron based unix shell scripts.
  • Supported application development cycle using clearcase and clearquest.
  • Installed procedures and data in accp, dev and test environments.
  • Migrated data to lower environments using data pump export / import.
  • Data warehouse database size in hundreds of gigs with partitioning.
  • Used Oracle OEM Grid Control, OEM database control, sql developer, sqlplus to manage databases.
  • Monitored space usage, performance.
  • Created tables, sequences, indexes, other database objects.
  • Carried rotating pager 24/7 as part of coverage team.
  • Worked with data modelers on converting logical model to physical model.

CONFIDENTIAL

  • Supported Production and test Sybase servers version 10, 11, 11.5, 11.92 using unix shell scripts, cron, Dbartisian, Erwin, bcp, sql backtrack, replication server on solaris and hp-ux
  • Responsibilities included server builds, upgrades, backup and recovery, performance and tuning, create database objects, dbcc checks, update statistics, ebf bug fixes.

CONFIDENTIAL

Mainframe Developer Analyst fulltime employee

  • Worked with users to determine automation needs and wrote new applications.
  • Developed and maintained existing applications using natural / adabas.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship