SEARCH

Oracle Database Administrator Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
DA
ORACLE DATABASE ADMINISTRATOR
Summary
  • Proactive Database Administrator with over 6 years' experience n database development and production environments. Proven skills in security management, database maintenance and establishing backup and recovery processes to safeguard data.. Over the years, I have successfully configured and managed Oracle databases 10g. 11gR1/R2 and 12C multitenant databases. My experience includes but not limited to Replication, Database Security, Memory Management, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, and performance tuning. Managed Database on AIX, Linux and Windows environments. Experienced in configuring and managing Oracle Real Application Cluster (RAC) 10g/11g, Data Guard and Golden Gate for Oracle High Availability. I have supported multiple environments spanning Finance, IT, Insurance and Tech sectors. I have the ability to work both as an individual contributor and as a member of a team. Professional Summary
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
  • Expertise in Oracle's Data protection, high availability, and performance technologies such as Oracle RAC, Oracle Data Guard, ASM, and Oracle goldengate.
  • Experience in administration and tuning of Oracle databases running on Windows and all types of UNIX platforms.
  • Experience in Oracle Grid Infrastructure implementation, administration, & performance tuning on ASM and implementing Third party clusterware file systems.
  • Experience in Data guard for different types of Standby Databases such as Active for reporting, Physical, Logical, and Snapshot standby on implementation, administration, & performance tuning.
  • Experience in implementation, configuration, troubleshooting, and performance tuning of Oracle Goldengate replication between
  • Unidirectional, bidirectional, and cascaded Oracle Databases.
  • Experience in Performance Tuning Oracle Databases with respect to all aspects of IT Infrastructure such as Network, OS, Storage, and Application.
  • Experience in using various performance tools or utilities like EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ASH, and ADDM, and analyzing reports for tuning recommendations.
  • Experience in implementing Oracle Enterprise Manager Grid Control (11g) and Cloud Control (12c) for database monitoring/performance/diagnostics.
  • Experience in writing/modifying UNIX Shell Scripts for various scenarios and requirements.
  • Experience in upgrading Oracle Databases from 10g & 11g, to 11g & 12c.
  • Knowledge and experience on managing very large Data Warehouse databases.
  • Experience in implementing Oracle Flashback Technology and utilizing it for various rollback purposes such as Critical Application bug fixes, Load Testing, and QA Testing.
  • Experience in Capacity Planning and Benchmarking.
  • Extensively worked on Oracle 12C multitenant databases; creating, migrating, patching and upgrading pluggable databases.
  • Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
  • Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.
  • Knowledge in maintaining Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage
  • Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
  • Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
  • Experience in SQL Tuning using tools like Explain Plan, SQL
  • Trace, TKPROF and OEM.
  • Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
  • Experience in Database capacity planning, monitoring object growth and Storage Management.
  • Performed data migration from flat files into an Oracle database using SQL
  • Loader.
  • Experience in performing Cloning and Refresh using RMAN and Data Pump.
  • Experience in Oracle Advanced Compression techniques.
  • Experience in Online/Offline Re-Organization of database objects.
  • Experience in Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
  • Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
  • Experience working with database security tools TDE, DB Vault / VPD.
  • Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
  • Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.
  • Used Service Now to report, manage and resolve tickets related to one off Incidences, Problems, Requests and Changes.
Skills
  • OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP RDBMS: Oracle 12c/11g/10g SOFTWARE/
  • APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp, impdp), SRVCTL, SQL
  • Plus. TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM 2
  • WEB TOOLS: HTML, XML
  • Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms such as Oracle, windows and postgreSQl
  • Experienced in using 10g and 11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Control Monitoring and Recycle Bin.
  • Expert in SQL Loader, export/import and data pump to load data into tables.
  • Upgraded Oracle 10g/12C to the Oracle 11g R2 database version.
  • Implemented the Golden Gate Replication
  • Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS)
  • Data guard Broker configuration and Managing Physical Standby databases using Oracle Data Guard Broker.
  • GoldenGate replication implementation.
  • GoldenGate Unidirectional and Bidirectional replication.
  • AIX, ORACLE, VMS
  • ASM, Oracle Enterprise Manager, Windows Server
  • Backup, DB
  • C, Oracle Database
  • Capacity planning, PL/SQL
  • Client, Organizing
  • Clients, Peak
  • Data modeling, PostgreSQl
  • Data Warehouse, Problem solving skills
  • Databases, RDBMS
  • Database, Read
  • Database design, Red Hat Linux
  • Delivery, SAN
  • Disaster Recovery, Servers
  • Erwin, Scripts
  • XML, Sun Solaris
  • Features, Sql
  • Flash, SQL server
  • HTML, SQL Loader
  • Managing, Statistics
  • Windows, Tables
  • Windows XP, TOAD
  • Migration, Translating
  • Navigator, Type
  • NAS, Upgrading
  • OPERATING SYSTEMS, Upgrade
  • Oracle 9, Utilities
  • Oracle database
  • Oracle database management
  • Database updating
  • Database creation
  • SQL database
Experience
Oracle Database Administrator / NIH, PRIORITY ONE SERVICES - BETHESDA, MD09/2018 - Current
  • Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
  • Upgraded database in DEV/PROD databases from 11.2.0.3 to 12.1.0.2 so that business applications can take advantage of the newly enhanced oracle features in 12c.
  • Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
  • 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.
  • 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.
  • Handle all Client Requests, Work closely with Clients for New Projects from Initiation to Production cutover Identify cost saving opportunities & implement innovative DB solutions for clients (collaborate with Infrastructure Delivery team as needed).
  • Involved with installation and maintenance of ORACLE 11g RAC/oracle 12cRAC and Standby databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
  • Good knowledge on all incident, change, problem management process & compliance process.
  • Responsible for installing, upgrading and configuring the Oracle environment by creating databases, database backup and recovery, monitoring and optimizing database performance.
  • Superior communication, presentation, analytical and problem solving skills.
  • Work well with all levels of business.
  • Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
  • Identified and reduced/ eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits.
  • 24X7 support for all the production and development databases.
Oracle Database Administrator / Stark Associates IT & Healthcare Services - Morristown, NJ03/2016 - 08/2018
  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment.
  • Load balancing of RAC instances.
  • Monitoring space, wait events, locks and long operations running on the database.
  • Implemented RAC databases and ASM, Toad.
  • Logical and physical data modeling using Erwin tool and Demonstrated experience translating logical models into physical models, Database design in a multi-terabyte Data Warehouse environment.
  • Tuning Experience - AWR, ADDM, ASH, SQL Tuning Advisors, STATSPACK, EXPLAIN PLAN, SQL Trace with TKPROF, Toad.
  • Monitoring the database for growth and added space to the table spaces as per demand.
  • Generating AWR/stats pack reports on a regular basis to identify the database performance at peak load.
  • Tuning the SQL statement by analyzing the explain plan and ADDM reports.
Oracle Database Administrator / Media Oean - Chicago, IL03/2014 - 02/2016
  • Experience on working with data guard physical/logical standby databases.
  • Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
  • Expert in Performance Tuning i.e.
  • Tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
  • Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Used Data Pump for export and import.
  • Wrote scripts for Backup of databases, maintenance of archive logs for databases.
  • Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
  • Database Refreshing / Replication from production to testing using Exp/Imp.
  • Created logical and physical design installed and upgraded databases.
  • 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 10g/11g RAC VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
  • Successfully installed and configured Oracle 11.2.0.3, Oracle 12.1.0.2 databases on AIX platforms.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
  • Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
  • Experienced in cloning the databases using HOT and COLD backups.
  • Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
  • 24 X 7 Production & Development database support and administration.
  • 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.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Education and Training
Bowie State University - Bowie, MDSome College (No Degree): Computer Information System
Eleanor Roosevelt High School - Greenbelt, MD05/2013High School Diploma
Certifications

AWS Solutions Architect

Sequel Query Language

Oracle Certified Associate

Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • NIH, PRIORITY ONE SERVICES
  • Stark Associates IT & Healthcare Services
  • Media Oean

School Attended

  • Bowie State University
  • Eleanor Roosevelt High School

Job Titles Held:

  • Oracle Database Administrator

Degrees

  • Bowie State University - Bowie, MD Some College (No Degree) : Computer Information System
    Eleanor Roosevelt High School - Greenbelt, MD 05/2013 High School Diploma

Similar Resumes

View All
Oracle-database-administrator-resume-sample

Oracle database administrator

Elite Transporation Group, Inc

Jacksonville Beach, Florida