We provide IT Staff Augmentation Services!

Oracle Dba Support, Resume

3.00/5 (Submit Your Rating)

Troy, Mi

PROFESSIONAL EXPERIENCE

Oracle DBA Support

Confidential, Troy, MI,

Responsibilities:

  • Performed the daily checks as part of a predefined routine while supporting the database projects related activities.
  • Performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, audit trail monitoring.
  • Administered all database objects, including tables, indexes, views, sequences, procedures, and packages.
  • Performed database physical redesigned from one tablespace to another dat enhance database performance.
  • Supported and maintained databases instances on two nodes RAC environment on AIX.
  • Researched, evaluated, test and new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
  • Worked wif and train existing on - site DBAs on new technologies to coordinate any overlapping activities.
  • Oracle 11g performance tuning. (Explain plan, AWR, ADDM)
  • Upgraded (20) databases from 10.2.0.4.0 to 11.1.0.7
  • Database physical redesigned from one table space to another dat enhance database performance.
  • Applied CPU quarterly patch January 2011and April 2011 to all (60) databases in the environments.

Environment: Oracle 9i, 10g, 11gR2, RMAN, Grid Control, Platform: IBM AIX 5.3.0.0, Red Hat Linux 2.6, Windows 2003, 2008, Front-end Applications: Apex, SSO, data warehousing (informatica).

Oracle DBA Consultant

Confidential, Mayfield, OH,

Responsibilities:

  • Worked wif and trained existing on-site DBAs on new technologies to coordinate any overlapping activities.
  • Performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, audit trail monitoring.
  • Administered all database objects, including tables, indexes, views, sequences, procedures, and packages.
  • Installed Oracle 11gR2 Grid Infrastructure software on Windows 2008 and Red Hat Linux 2.6 and created databases for new development and production in a data warehousing environments.
  • Installed and Configured of Oracle 11gR2 Grid Infrastructure RAC. Supporting and maintaining databases instances on two nodes RAC environment on Windows 2008,
  • Migrated (6) Oracle 9i databases to Oracle 11gR2 to a new windows server 2008 platform,
  • Migrated (5) Oracle 10.2.0.4 to Oracle 11gR2 2 nodes RAC Windows environment,
  • Applied CPU quarterly patch October 2010 to all the database environments.

Environment: Oracle 9i, 10g, 11gR2, RMAN, Database Control, Grid Control, Platform: Red Hat Linux 2.6, Windows 2003, 2008, Front-end Applications: ArcSight

Oracle DBA Consultant

Confidential, Chicago, IL,

Responsibilities:

  • Performed the daily checks as part of a predefined routine while supporting the database projects related activities.
  • Performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, audit trail monitoring.
  • Researched, evaluated, test and new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
  • Scheduled and coordinated database maintenance activities including such items as database reorganizations and restructures.
  • Installed, configured, Supported, monitored and maintained oracle 10g data guard
  • Participated in on-call and off-hours production problem resolution activities.
  • Evaluated all systems for enhancements designed, developed and maintained databases dat interact wif software applications.
  • Administered all database objects, including tables, indexes, views, sequences, procedures, and packages.
  • Database Security: account permission
  • Installed Oracle 10g and 11g software on Windows and created databases for new development and production environments.
  • Performed routine CPU Patch and advised in-house DBAs on scheduled server tasks regarding database auditing.
  • Involved in the Design of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data Guard.

Environment: Oracle 10g, 11g, RMAN, Grid Control, Platform: Solaris, Linux, Windows 2003.

We'd love your feedback!