We provide IT Staff Augmentation Services!

Oracle Dba Resume

St Louis, MissourI

CAREER SUMMARY:

  • Over 8 years of experience of Oracle Database Administrator including 10g, 11g and 12c
  • Managed databases on Linux, Solaris, Windows, AIX and HPUX.
  • Refreshed data using exp/imp and data pump on a regular basis.
  • Upgraded databases from 10g to 11g R2 to 12c
  • 12c Cloud control / OEM / TOAD / SQL Developer
  • Created documents to speed up future builds
  • Database Patching
  • Build RAC Clusters.
  • Set up grid control alerts and thresholds
  • Excellent troubleshooting skills and quick learner.
  • Build Linux servers and build 12c standalone database server.
  • Moved database from one data center to another using data guard.
  • Configured / Managed ASM disks and disk groups
  • Worked with Different teams to completed Build tasks
  • Created documents to speed up future builds.
  • Worked with Different teams to completed Build tasks
  • Build Disaster Recovery sites using Oracle Data Guard.
  • Installed and configured databases using silent install, OMF and via scripts.
  • Has extensive knowledge in dynamic views and dictionary tables.
  • Applied CPU and PSU patches.
  • Extensive experience in OS space and tablespace management.
  • Worked on database security and Fine Grain Auditing.
  • Extensive work on shell scripting and documentation.
  • Excellent Experience as Production DBA with 24X7 supports.
  • Extensive experience in backup and restores using RMAN
  • Database replication using snapshot, materialized views and advance replication methods
  • Strong in writing shell scripts to setup cron jobs for checking Adaptive server's availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.
  • Flexible and excellent team player. Ready to work in any shift.
  • Set up grid control alerts and thresholds
  • Excellent troubleshooting skills and quick learner.
  • Build Linux servers and build 12c standalone database server.
  • Moved database from one data center to another using data guard.

TECHNICAL SKILLS:

Operating Systems: RHEL, HPUX, AIX, Sun and Windows

RDBMS: Oracle 12c, 11/10g, SQL Server

Tuning Tools: ASH, AWR, ADDM, SQL Profile, SQL Baselines, Execution Plan, OEM

Languages: SQL, PL/SQL, UNIX Shell scripting, T - SQL

Tools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, TOAD, DBConsole, asmcmd

High Availability: RAC, Data Guard, ASM

PROFESSIONAL EXPERIENCE:

Confidential, ST Louis, Missouri

Oracle DBA

Responsibilities:

  • Responsible for administration and supporting oracle 12c, 11g, 10g and 9i databases
  • Performance tuning of applications and the databases Oracle 11g/10g
  • Build 2-node RAC Cluster on Linux.
  • Build Data Guard for RAC Cluster.
  • Documented procedures.
  • Proactive database monitoring using 11g grid monitoring tool.
  • Install Oracle supplied tools to assist in database and SQL Tuning like SQLT
  • Performing tuning of application with RBO, CBO, using Trace, tkprof, Explain plan, statspack, AWR, ASH and ADDM.
  • Worked on slow running queries to optimize databases performance.
  • Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
  • Worked on Performance Tuning tasks to reduce the query response time.
  • Remove unnecessary histograms in highly volatile schemas.
  • Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
  • Performed tasks on setup users accounts, passwords, roles, profiles and quota
  • Monitored data files, logical data storage and data growth activities
  • Perform capacity planning required to create and maintain database environments.

Confidential

Oracle DBA

Responsibilities:

  • This project pertains to installation of oracle 10g RAC and later converted to 11g upgrade.
  • Responsible for administration and supporting Oracle 10g/11g.
  • Provide ON-Call 24*7 Production Database Support having 5-6 TB in size.
  • Implemented Data Guard for maximum availability.
  • Responsible for restoring and recovering database as required for Oracle.
  • Upgraded the database from Oracle 10g to 11g, configured on ASM, and applied oracle patches on need basis.
  • Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
  • Installed, Configured, Upgraded and Performed Trouble Shooting for oracle Golden Gate 10g/11g Version.
  • Proactively monitored the database and database access, and maintained the database security.
  • Extensively worked under UNIX environment to provide DBA support.
  • Ran the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
  • Configured Oracle tools like SQL*Net to access the database from the network.
  • Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
  • Implementation of nightly logical backup. talink with Oracle Corporation and installation of patches
  • Created Triggers for multi-master replication
  • Worked with client on regular basis.
  • Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
  • Installed and configured database management system software.
  • Developed and implemented backup and recovery strategies.

Hire Now