We provide IT Staff Augmentation Services!

Oracle Dba Resume

Peoria, IL


  • 7 years of experience in Oracle database administration, system Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions
  • Proficient in maintaining 10g, 11g and 12c databases.
  • Proficient in oracle dictionary and oracle dynamic views.
  • Managed and administered databases from command line and 12c/13c OEM
  • Expertise in Installation, Configuration, Patching, Migration, Trouble shooting and Performance
  • Tuning of oracle databases on UNIX, LINUX and Windows environments
  • Upgrade databases to 11g and 12c
  • Managed databases on Exadata
  • Build, configured and managed multi node RAC Cluster on RHEL.
  • Experience with setting up and managing standby database using Data Guard
  • Intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases
  • Tune queries using SQL Plan, SQL profiler, Baseline etc.
  • Build RAC Clusters from scratch including deployment of Linux operating system.
  • Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, SQL Navigator, and SQL* Loader, Data Pump
  • Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
  • Experience in datacenter migration.
  • Supporting development 24/7 production systems. Providing on call support for mission critical applications.
  • Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
  • Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
  • Maintained databases on Exadata X5
  • Proficient in writing UNIX Shell scripts to automate business process and daily backup.
  • Vast Experience with RMAN to implement Backup/Recovery strategies
  • Clone databases using RMAN Duplicate.
  • Implemented data replication through materialized views.
  • Refresh database objects using Data Pump
  • Good experience in SQL, PL/SQL, Shell Scripting
  • Experience in Data Modeling using Data modeling tools such as Erwin and Toad.
  • Skilled in setting up/Installation and configuration of release 11g RAC R2 with ASM and Raw Devices
  • Worked on SQL Server 2008 and 2012
  • Experience with installing and maintaining Oracle 13c Cloud Control
  • Build and managed ASM Disks and Diskgroups
  • Migrated non - ASM database to ASM.
  • Experienced in RAID, storage technologies and backup solutions
  • Supported the system 24x7. Ability to work beyond regular hours.


Confidential, Peoria, IL

Oracle DBA

Environment: Oracle 11g, 12c, Exadata, AWS, GoldenGate


  • Supported database on Exadata X7
  • Performed Silent installation on Exadata.
  • Applied patches on computer nodes, Exadata home and storage cells.
  • Migrated standalone databases to Exadata
  • Implement disaster recovery with use of Exadata
  • Involved in 24x7 support for production RAC databases with on-call pager
  • Supported production, development and testing databases of Multi Terabytes DB sizes.
  • Configuration, troubleshooting GoldenGate issues
  • Setup Uni-directional GoldenGate setup.
  • Setup and managed replication using Oracle GoldenGate
  • Worked on Data Migration project.
  • Migrated databases from Windows platform to Linux.
  • Upgraded from 11g to 12c.
  • Migrating database from NON-ASM to ASM.
  • Migrated databases to AWS
  • Build new servers on AWS
  • Worked on project to migrate databases to AWS instance
  • Set up oracle instances on AWS cloud
  • Maintained databases and alerts from 13c cloud control (OEM)
  • Migrated standalone databases to RAC on Exadata
  • Oracle DBA in 12c, 11g, with 9+ year's professional IT work experience
  • Worked on 12c Multitenant databases
  • Setup unidirectional GoldenGate replication
  • Rolling install oracle patch in Oracle RAC 11g and 12c
  • Upgraded database from 11g to 12c R2
  • Cloned databases using RMAN Duplicate
  • Installation of 11g, 12cclients/databases on Solaris and Linux.
  • Complete Build of 4-node 12c RAC Cluster on RHEL
  • Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
  • Performed database cloning to setup test and development database.
  • Migrated databases to different data datacenter.
  • Handled RAC Node hangs and node eviction issues.
  • Maintaining schemas and partitioning tables.
  • Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
  • Index management for better performance, maintenance of Oracle Database
  • Developed RMAN scripts for database backup and recovery
  • Responsible for administration and supporting oracle 11g, 12c databases
  • Performed large batch jobs and tuning of SQL queries and database systems.

Confidential, Chicago, IL

Oracle DBA


  • Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
  • Maintaining databases from all the environments from all pre-production to production whichare on RAC and monitoring the Analytics environment using Oracle Streams.
  • Have a good knowledge in Exadata.
  • Experienced in ORACLE 11g installation, configuration, and upgrading.
  • Experience with rolling upgrade to Oracle 11g RAC.
  • Installation, Configuration, Upgrading, Migration and Maintenance.
  • Configure, maintain and deploy the DataGuard and grid control.
  • Installing and maintaining Oracle GRID CONTROL
  • Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
  • Worked extensively on Oracle Streams.
  • Troubleshoot OCFS2 install issues and working with Enterprise Manager.
  • Design and implement Auditing and other security features for the existing Productionsystems.
  • Raised SR and TAR with Oracle Support.
  • Used Oracle Enterprise Manager (OEM) for administering several databases
  • Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
  • Restore and Recovery of database in case of database crash, disk/media failure.
  • Applying patches and works closely with Oracle to make Application environment up todate.
  • Backups & Recovery Maintenance, Databases Performance Tuning.
  • Typically involved in database Designing, creation and maintenance.
  • Good working knowledge of SQL, PL/SQL, and shell scripting.
  • Created users and grant privileges according to the requirements.
  • Working knowledge on UNIX administration on AIX server.
  • Provided System support for both development and 24*7 production environments.
  • Performed automated backups and scheduling using scripting.
  • Responsible for migration of databases.
  • Involved in designing logical and physical data models using Erwin.
  • Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • Performed administrative maintenance, monitoring on Oracle database systems in a global
  • Provided 24x7 operational supports.
  • Involved in gathering requirements from end users.

Hire Now