We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Lombard, IL

SUMMARY:

  • 10+ 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, 12c, 18c databases.
  • Proficient in oracle dictionary and oracle dynamic views.
  • Tuned SQL Queries SQL Access Advisor
  • Worked on tuning using SQL Performance Analyzer
  • Tuned SQL using SQL Plan Manager
  • Worked on Table compression enhancement
  • Managed Active Data Guard
  • 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, 12c to 18c
  • Managed databases on Exadata x7
  • 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* 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 X7
  • 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 Disk groups
  • Migrated non - ASM database to ASM.
  • Experienced in RAID, storage technologies and backup solutions
  • AWR Baseline Enhancements
  • Automatic Memory Management.
  • Automatic SQL Tuning.
  • Data Recovery Advisor.
  • Read-Only Tables
  • Flashback Enhancements
  • RMAN Enhancements
  • Table Compression Enhancements.
  • Worked on Tablespace/Extent/Segment Management
  • Worked on Backup and recoveries using user managed and RMAN.
  • Setup Oracle Enterprise Manager (OEM)
  • Maintain Oracle failover databases (Physical and Logical standby databases- Data Guard)
  • Oracle Tuning Pack. Oracle RAC Good knowledge of Flashback technology in Oracle 10g, and 11g.
  • Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
  • Automated Storage Management (ASM) for 10g/11g databases.
  • Installed and Administered Grid Control.
  • Worked with Oracle on open issues.
  • Discoverer Administration including the design and administration of Business areas.
  • I have worked on virtual machines and created few in Aws

TECHNICAL SKILLS:

  • Oracle 11g, 12c, 18c,
  • 13c Cloud Control
  • Oracle Automatic storage Management
  • Real Application Clusters (RAC)
  • Performance Tuning
  • Security Administration
  • Replication
  • Partitioning
  • Disaster Recovery Solutions
  • Database Design
  • SQL Server
  • AWS
  • Amazon Web Services (AWS)
  • Recovery Manager (RMAN)
  • Standby Database Solutions
  • Oracle 9i, 10g, 11g Data warehousing
  • Oracle Enterprise Manager (OEM)
  • Data pump, RMAN, Shell Scripting
  • SQL, PL/SQL
  • UNIX, Solaris, HPUX, Tru64, AIX
  • Windows Server 2003, 2008, 2012
  • Golden Gate
  • Exadata
  • Data Guard

PROFESSIONAL EXPERIENCE:

Confidential, Lombard, IL

Senior Oracle DBA

Responsibilities:

  • 24x7x365 administrative support staff.
  • Manage offshore team on day to day to tasks.
  • 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 Golden Gate
  • Worked on Data Migration project.
  • Migrated databases from Windows platform to Linux.
  • Upgraded from 11g to 12c.
  • Migrating database from NON-ASM to ASM.
  • I have worked on virtual machines and created few in Aws
  • 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, 12c clients/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.
  • Designed, configured and maintained backup and recovery policies including RMAN backups.
  • Monitored database space requirements and adjusted for future needs.
  • Performed version upgrades and patch installs.
  • Perform database administration tasks as part of a scheduled change management task.
  • Proficient in communicating directly with internal resources daily.
  • Configuration, maintenance and tuning of 10g RAC
  • Setup of Disaster Recovery databases (Data Guard)
  • Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
  • Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Involved in Database sizing, Capacity Planning.

Confidential, Seattle, WA

Oracle DBA

Responsibilities:

  • 24x7x365 administrative support staff.
  • Configured Data Guard to provide high availability by implementing Physical stand by database.
  • Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
  • Cluster Installation and Configuration, Administering databases in RAC for high availability.
  • Installation, Configure, setup of 11g RAC on Linux.
  • Add new nodes to RAC 11g Cluster to distribute the load.
  • Installed and implemented 10g RAC with 4 nodes with ASM.
  • Upgraded Databases from 10g to 11g and applied patches as per requirement.
  • Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.
  • Responsible for installing and configuring Golden Gate on Oracle Servers.
  • Database migration from 9i to 10g to 11g.
  • Designed, configured and maintained backup and recovery policies including RMAN backups.
  • Compared and contrasted multiple snapshots using AWR.
  • Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
  • Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
  • Recovered databases and clone applications Using RMAN.
  • Performed RMAN restores and recovered database.
  • Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
  • OEM Grid Control installation and configuration for monitoring and performance tuning.
  • Proactive performance monitoring, and capacity planning for future database and server growth.
  • Applied CPU/PSU Patches
  • Performed Cross platform migration using transportable tablespaces and RMAN.
  • Performed Import and Export using Oracle Data pump utilities
  • Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
  • Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
  • Used external tables and SQL*Loader to import data from flat files.
  • Monitored database space requirements and adjusted for future needs.
  • Performed version upgrades and patch installs.
  • Perform database administration tasks as part of a scheduled change management task.
  • Proficient in communicating directly with internal resources on a daily basis.
  • Able to work effectively with multiple teams at once.
  • Good understanding of ticketing system and change control process.
  • Solid discipline in providing end-users timely updates on their problems. Installing server software.

Confidential, Naperville, IL

Oracle DBA

Responsibilities:

  • Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
  • Used RMAN to backup database.
  • Review alert logs and dump files to check for any problems related to the database.
  • Used Export Import and Data Pump
  • Used Database Partitioning
  • Provided 24/7 Online support
  • Create and maintain users, roles and privileges.
  • Written Shell scripts
  • Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
  • Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Involved in Database sizing, Capacity Planning.
  • Perform Space Management & Troubleshooting the database issues.
  • Generated ASH, AWR, ADDM reports from Grid Control and command line.
  • Setting up privileges to create local and remote objects
  • Worked on Materialized Views
  • Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
  • Applied CPU patches

Hire Now