We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • Configured Manager, Replicate and Extract processes and implement bidirectional replication using Oracle Golden Gate on RHEL 5 platform.
  • Implemented High availability using Golden Gate Replication. Implanted Bi - directional replication using golden gate.
  • Experience and knowledge with Tibco.
  • Experience with data modeling.
  • Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup on standby databases for OLTP systems
  • Design and Architect End-to-End Oracle Database and Cloud Solutions based on commodity server, storage and network components.
  • Performing Fault Injection Test Cases for verifying High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
  • Expertise in upgrading the databases from Oracle 10g to Oracle 11g and from Oracle 11g to oracle 12c.
  • Installation, Configuration and Administration of Oracle 12c RAC,11g RAC and Oracle 10g RAC databases with Flex Cluster and Flex ASM
  • 24*7 production database support with Support to developers & end-users.
  • Implemented RMAN backup (Full, incremental and cumulative) hot/cold Backup and recovery, Cloning of databases using RMAN.
  • Involved in Design and implementation of oracle Data Guard both physical/logical standby databases for high availability and disaster recovery
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes and Dell Fluid Cache/Fusion IO to improve Oracle database performance.
  • Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.
  • Experience in Database Security by implementing Data Encryption (TDE) and SSL Setup over insecure networks.
  • Data pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases and data refreshes (at database, schema & table level).
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

Databases: Oracle 12c/ 11G/10G

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 2008, 2010

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, ASH and ADDM

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer

WORK EXPERIENCE:

Confidential, Chicago, IL

Oracle Database Administrator

Responsibilities:

  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on Linux.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control and successfully upgraded the databases from 11g to non CDB 12c.
  • Loading data from flat files to database using SQL*Loader, External Tables.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
  • Involved in construction of DR sites for all the Production environments.
  • Configured Manager, Replicate and Extract processes and implement bidirectional replication using Oracle Golden Gate on RHEL 5 platform. Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
  • Worked on Multitenant databases.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
  • Install and configure block change tracking to work with RMAN Merged incremental backups.
  • Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Experience using EXPORT/IMPORT utility for backups and to do table level and full database defragmentation.
  • Schema Refreshes using export/import and oracle Data pump Export (DPE) and Data Pump Import (DPI).
  • Responsible for taking hot backups and logical backups at schema, tablespace and database level.
  • Applying CPU patches, Oracle patches, Release upgrades, ONE-OFF patches.
  • Configured Physical Standby database using Oracle DATAGUARD for Disaster recovery.
  • Implemented table partitioning and sub-partitioning to improve performance and data management.
  • Extensive use of Crontab in UNIX environment for scheduling routine tasks and writing shell scripts to automate the data loading.
  • Extensively used Cursors and Ref Cursors in order to generate various reports and experience writing PLSQL procedures and packages.
  • Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Responsible for the smooth functioning of all ecommerce activities of the organization.
  • Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
  • Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
  • Performing monthly and annual performance reports for trend analysis and capacity planning.
  • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
  • Worked on both VMS and UNIX environments.
  • Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
  • Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
  • Experience in writing UNIX/SHELL scripts for providing the reports.
  • Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC/9i, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Raleigh-Durham, NC

Oracle Database Administrator

Responsibilities:

  • Configured Manager, Replicate and Extract processes and implement bidirectional replication using Oracle Golden Gate on RHEL 5 platform. Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
  • Cloned/Migrated databases using RMAN and traditional Datapumpexport/import utilities in Oracle 10gR2.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
  • Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Provided 24X7support for all the production and development databases.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
  • Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios.
  • Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using DatapumpExport/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
  • Created Oracle Wallets and implemented Tablespace level TDE security.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
  • Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
  • Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Hire Now