We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Austin, TX

SUMMARY

  • Certified Oracle Database administrator with over 7+ years of hands - on technical experience.
  • Comfortable in Full SDLC including Productions, Application & Project Support.
  • Experienced in Oracle 9i, 10g, 11g, 12c, RAC, DG, ASM, PL/SQL, Shell Scripting, RMAN, TOAD & OEM GC on various platforms including AIX, UNIX, and LINUX & Windows Servers.

TECHNICAL SKILLS

  • Database Management
  • Oracle 10G
  • Oracle SQL
  • ORACLE 11G
  • RAC
  • Data guard
  • Pl/sql
  • Microsoft Office
  • Datapump
  • OEM
  • ORACLE 12C cloud control
  • RAT

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

Oracle Database administrator

Responsibilities:

  • Provided project & production support for 10g, 11g, & 12c, Data Guard environments utilizing ASM on AIX, UNIX & Linux platforms. Experience in Exadata.
  • Performed Platform migrations from AIX to Linux & Windows servers using Data Pump.
  • Installed Database upgrades from 9i to 10g, 11g & 12c & configured both PSU & CPU patches.
  • Implemented Change Requests using SERVICENOW system.
  • Heavily utilized OEM Grid Control & TOAD for administrative, monitoring, & diagnostic tasks.
  • Tuned performance with AWR, ADDM, ASH, SQL tuning advisors, indexes, partitions, etc.
  • Provide 24/7 on call rotation
  • Does database refresh using delphix engine
  • Compare workloads between two environment through the use of RAT (real application testing)
  • Familiar with servicenow ticketing system
  • Datagaurd management using the datagaurd broker
  • Security through audit vault and granting of privilege, auditing, VPDB as well as creating users

Confidential - Chicago, IL

Oracle Database Administrator

Responsibilities:

  • Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
  • 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.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • RMAN point in time recovery and Instance recovery done on 11g.
  • Developed compliance reports and performed auditing at higher levels.
  • Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
  • Experience in writing UNIX/SHELL scripts for providing the reports.
  • Applied PSU Patches (11.1.0.3, 11.2.0.4) as a part of maintenance activity.
  • Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Extensive experience in RMAN recovery testing, RAC and standalone database
  • Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)
  • Experience in setting up Oracle ASM storage for Oracle RAC databases
  • 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.
  • 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.
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. 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 in 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 .

Confidential, Greenbelt-MD

Oracle Production Support Database Administrator

Responsibilities:

  • Successfully installed and configured Oracle 11.1.0.3, Oracle 10.1.0.3 databases on AIX platforms.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid 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 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 10g 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).
  • Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
  • Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels.
  • Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility.
  • Performed Database upgrade from Oracle 10g (10.1.0.1) to Oracle 10g (10.1.0.3) and to Oracle 11g (11.1.0.3) 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.
  • Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system.
  • 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.
  • 24 X 7 Production & Development database support and administration.

Confidential

Oracle Production Support Database Administrator

Responsibilities:

  • Installed and configured ORACLE 10g on Linux - UNIX environment.
  • Performed Up gradation of databases from Oracle 8i to Oracle 10g.
  • Planned and implemented physical backup (both hot and cold) & recovery procedures for the database using RMAN utility of Oracle 10g.
  • Creating the users and assigning them the required privileges.
  • Provided 24x7 on-call support as needed.
  • 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, SQL*Trace, AWR,ADDM,ASH,SQL tuning advisor etc. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
  • Prepare the documents of the process and knowledge transferring about the project to the new team members.
  • Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.
  • Separated the indexes, data, rollback segments and redo log files on separate disks to minimize contention, Monitored the buffer cache hit ratio and the dictionary cache miss ratio. The DB BLOCK BUFFERS and SHARED POOL SIZE were increased, resulting in tremendous improvement in performance.

Hire Now