We provide IT Staff Augmentation Services!

Oracle Dba Resume

Norcross, GA

PROFESSIONAL SUMMARY:

  • Installed databases using silent install
  • Designed and Build 2 - node RAC Cluster on RHEL
  • Designed and build Data Guard
  • Designed, developed, installed and maintain and administer bureau-wide Enterprise Production Oracle database running on 2 Nodes on virtualized RHEL6 using ASM on Shared Storage
  • Performed administration and engineering for multiple Production, Quality Assurance, and Development databases in a 24/7 environment and multiple locations with direct reports.
  • Administered, Patched, Upgraded Oracle 10g and 11g databases in a RAC. Also performed performance monitoring, reporting and tuning of these databases utilizing Oracle OEM grid control to apply patches(s) to the RAC infrastructure.
  • Responsible for fast-paced complex distributed database environments supporting primarily OLTP on a UNIX/Linux platform (IBM Z10 infrastructure/RHEL6), with the ability to rapidly troubleshoot complex technical problems under pressure.
  • Monitored and maintained database security and database software Developed, defined, and/or oversaw database organizations, standards, controls, procedures, and documentation.
  • Reviewed, designed and developed data models in conjunction with the application development teams using ERWIN and TOAD Data Modeler
  • Mentored oracle developers/DBAs on SQL and PL/SQL development skills and good oracle code writing skills.
  • Experience in utilizing performance tools to include Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), Remote Diagnostic Agent (RDA) and SQL Performance Analyzer (SPA).
  • Advice on configuring and/or tuning the RAC clusters for optimal performance.
  • Designed and configured Data Guard configuration for Disaster Recovery.
  • Converted several databases to UNICODE AL32UTF8
  • Performed various tasks to include user management and access, backup and recovery of databases, performance tuning, and SQL scripting to automate standard jobs.
  • Poses advance knowledge of Oracle RAC deployments on UNIX platforms with Physical and Virtual configurations using EMC or SAN storage.
  • Post knowledge in Golden Gate
  • Worked with offshore DBAs
  • Applied patches.
  • Provided 24/7 support
  • Cloned databases using RMAN, export import and Data Pump.
  • Overall 7 plus years in Oracle Database Administration.

TECHNICAL SKILLS:

Operating System: UNIX, RHEL, Sun Solaris, AIX, Windows 2003/2008/2012, HP UX

Scripting: SQL, PL/SQL, Unix Shell Scripting / Bash / Korn

RDBMS: Oracle 9i to 12c R2 SQL Server 2005, 2008 and 2012

Documentation Tools: Sharepoint MS Office, Visio, Wiki

Tools: sqlplus, splldr, exp, imp, expdp, impdp, TOAD, OEM, DB console, rman, lsnrctl, srvctl, crsctl, orcconfig, ocrconfig

PROFESSIONAL EXPERIENCE:

Confidential, Norcross, GA

Oracle DBA

Responsibilities:

  • Build multiple 2 node RAC Clusters on Linux.
  • Provided day to day support for three applications.
  • Provided support in refreshing schemas
  • Provided support in cloning databases
  • Used data pump, RMAN duplicate database and export/import for data moment.
  • Set up grid control alerts and thresholds.
  • Written shell scripts to automate database monitoring tasks.
  • Constant monitoring of database space and space management
  • Setting up Oracle Standby Data Guard.
  • Support HA databases and resolved gaps in physical data guard environments.
  • Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
  • Performance tuning of SQL statements using Explain Plan, SQL tracing and tkprof.
  • Perform Backup and Recovery thru RMAN.
  • Strong experience in Installing, configuring, maintaining Data Guard environment.
  • Strong experience in patching databases.
  • Worked on locking and issues with latches
  • Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
  • Used ASH, AWR & ADDM tools to troubleshoot performance
  • Used TOAD, Grid Control, SQL Developer as GUI tools aside from terminal.
  • Installed, migrated, configured and tested Oracle 11g databases in various environments.
  • Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.
  • Worked with offshore DBA and Developers
  • Export and Import of User, Tables and Database using exp/imp and Data Pump.
  • Provided my support during off hours and weekends.
  • Helped coordinating jobs with offshore team.
  • Provided on-call 24/7 support

Confidential - Rosemont, IL

Oracle DBA

Responsibilities:

  • Build Data Guard
  • Configured and Managed ASM disks and disk groups
  • Build 2-node cluster using Oracle RAC
  • Conducting Installations of Oracle 10g, Oracle 11g on standalone servers
  • Worked on Migration Projects.
  • Upgraded Databases from 10g to 11g R2.
  • Fully documented 11g GoldenGate installation for internal DBA team members
  • Build database servers on VMWare.
  • Performed work on Capacity planning
  • Applied patches
  • Worked on 11g grid control
  • Create and maintain multiple databases.
  • Create multiple 11g databases on RHEL5 in development.
  • Schedule backup in 11g using db console.
  • Worked on SQL Tuning and instance tuning
  • Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
  • Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
  • Generated and analyze ASH, AWR and ADDM reports
  • Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
  • Written shell scripts
  • Worked with RAC implementation team. Added nodes.
  • Refreshed multiple databases for Development and Testing upon short request.
  • Performed database cloning/exp/imp to setup identical databases in the production and development environments.
  • Created and maintain users, roles and privileges.
  • Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
  • Diagnosed Oracle bugs
  • Performed Export/Import through Data Pump.
  • Worked on basic replication through Materialized Views.

Confidential, Chicago, IL

Jr DBA / Desktop / IT Support

Responsibilities:

  • Provided user support via phone and email
  • Worked on LAN
  • Worked on Access DB
  • Written SQL Queries to fetch data
  • Worked on Client/Workstations.
  • Troubleshot issues via phone and email with phone back-ups Assist in Windows7 deployment to include peripheral setup, data migration, and software installations.
  • Recognized for outstanding work on special projects, Created and edited documentation

Hire Now