We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Salt Lake City, UT

SUMMARY:

  • IT professional with over 5 years of general experience as an Oracle Database Administrator. I support complete SDLC life cycle.
  • I have extensive knowledge in Installation and configuration, production support, database upgrades and patches, migration, performance tuning, cloning, backup and recovery, logical and physical space management and database security.
  • Worked on Oracle 12c, 11g, and 10g versions.
  • Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
  • Experience in installing and patching Oracle RAC with ASM on AIX, Solaris and Linux platforms.
  • Expertise in setting up Data Guard Fail - Over/Switch-Over/Read-Only scenarios. Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.
  • Hands on experience on Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases and Grid Infrastructure.
  • Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
  • Experience in using transportable tablespace, materialized view, RMAN incremental backup and bitmap indexes in data warehouse environment.
  • Experience in Oracle Golden Gate 10.x/11.x installation, configuration, and troubleshooting Golden Gate issues.
  • Zero downtime migration using oracle data pump and Golden Gate between Oracle 10g and 11g with Linux, Solaris, and Windows platforms.
  • Experience in configuring Golden Gate replication between OLTP to OLTP, and OLTP to data warehousing environments.
  • Installed Oracle 11g with ASM and OCFS2 File systems.
  • Highly experienced in performance monitoring/tuning/troubleshooting.
  • Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
  • Supported 400+ databases including RAC production database, a Data warehouse database and a lot of Development and Test databases and upgraded from 10g to 11g.
  • Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
  • Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX 6.1.
  • Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC.
  • Installed and configured 6 node oracle 11gR2 RAC for production environment.
  • Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
  • Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.
  • Managed 11+ TB Oracle 10g & 11g databases in Data warehousing environment.
  • Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
  • Experience in installation of Oracle RAC with ASM and manage RAC instance using Crsctl and Svrctl utility.
  • Involved in migrating production databases single instance to RAC environment.
  • Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
  • Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard and Have hands on experience on Active Dataguard.
  • Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • 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”.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 12c) allowing users to quickly move a user Tablespace across Oracle databases.
  • Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas.
  • Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
  • Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
  • Experience in Upgrading databases, applying patches.
  • Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
  • Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
  • Performance Tuning of the database (Memory Tuning, I/O Tuning)
  • Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
  • Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database. Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
  • Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
  • Expertise in maintaining Database Security using auditing.
  • Experience in Data Migrations.
  • Checking and resolving Database corruptions using DBVERIFY utility. Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE:

Confidential, Salt Lake City, UT

Oracle Database Administrator

  • Development of policy and procedures as they relate to database maintenance, security and archiving.
  • Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
  • Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
  • Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
  • Creating, granting and monitoring user access rights and privileges through roles and profiles.
  • Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.
  • Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
  • Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
  • Applying upgrade patch, maintenance and interim ( opatch ) patches on all the databases.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Defining the standards, to maintain the health of the server. RAC to RAC physical standby configuration of data guard for Disaster recovery requirement.
  • Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
  • Configure Oracle Data Guard as disaster recovery approach.
  • Use Active Data Guard feature to offload reporting duty from production database.
  • Implement Oracle Golden Gate (OGG) to replicate data from front-end OLTP databases to back-end Data Warehouse systems.
  • Troubleshoot typical OGG technical problems, such as unique key violation and long transaction, by using GGSCI/ Logdump /discard file analysis etc.
  • Create database services for distributing the applications across multiple nodes by extensively using all command line utilities, such as SRVCTL, CRSCTL, ADR, and ASMCMD.
  • Set up test databases for development team by using RMAN duplicate tool.
  • Schedule RMAN backups, purge jobs, maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and Crontab.
  • Support development teams for all the database-related issues and help to manage the ASM diskgroups.
  • Performed Replication using materialized views with a complete refresh/Fast refresh.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Generated and automated Statspack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth .
  • Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
  • Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
  • Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.
  • Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
  • Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
  • Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer, Fog light.
  • Monitoring rollback segment and temporary table space use.
  • Performing housekeeping tasks like checking log and trace files.
  • Performing database refreshes, migration and performance tuning of PeopleSoft application environments.
  • Setup and maintenance of Physical Standby Database using Data Guard Broker and active Data Guard for faster Disaster Recovery.
  • Installed and Configured OEM grid control for maintenance administering the databases.
  • Daily Health Checkup of all the Databases using Oracle Enterprise Manager 12c.
  • Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.
  • Performed full and incremental backups using RMAN for development and production databases.
  • Database cloning from Production to Test and Development environments.
  • Extensively worked on applying patches (CPU&PSU) whenever required.
  • Schema Refreshing of databases using normal copy method and exp/imp utility.
  • Cloning database and schemas using Data pump for 10g and 11g versions.
  • Cloning 10g and 11g databases using RMAN duplication (with and without backup).
  • ASM Disk storage and user Management
  • Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.
  • Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ADDM.
  • 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/12c RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Aurora, IL

Oracle Production Support Database Administrator

  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.
  • Loading data from flat files to database using SQL*Loader, External Tables.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • Implementing Data pump, 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 Data pump import/export to move data between 9i and 10g/11g environments.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network attached storage (NAS).
  • Documented the Standard Processes for peers to follow.
  • Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
  • Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
  • Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
  • Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
  • Implemented data guard for the critical production databases and tested switchover and failover. Logical standby databases for the real time DML apply in the remote databases. Disaster recovery plan for the production to standby database to check the data consistency.
  • Maintain databases build database backup and recovery routines (RMAN), monitor database activities and conducting performance monitoring. Clone Development, test and UAT databases using RMAN.
  • Handling multi-terabyte databases and the capacity planning for the data and application growth and recommend partitioning strategies for very large tables.
  • Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility.
  • Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
  • Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Used TOAD for database management.
  • Made optimal use of Oracle Support in resolving the SRs.
  • 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Hire Now