SEARCH

Oracle DBA Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
HARISON
OKONKWO
Professional Summary
  • I have 6+ years of experience as an Oracle Database Administrator and hands-on knowledge as a PostgreSQL Admin. I possess complete life cycle knowledge including production and project support. Worked on Oracle 12c, 11g, 10g versions and PostgreSQL 9.x – 11.x. Some areas of expertise include backup and recovery, database security, performance monitoring and tuning, upgrades and patches, database migration, dataguard, Goldengate, RAC and database refreshes. Professional Skills
  • Experience in performance tuning using tools like AWR, ADDM, ASH, OEM. Along with Optimizer Statistics, Sql Tuning Sets etc.
  • Design and implementation of Backup andRecovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
  • High Proficiency in data security managing wallet and high-level encryption.
  • Leading skills in data migration using EXP/IMP, Datapump, and Transport Tablespace.
  • Experience on Data Replication using Goldengate.
  • Configured Oracle Data guard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.
  • Upgraded from 10g to 12c while applying security patches as needed.
  • Profound Knowledge in High Availability solution with expertise in RAC implementation.
  • Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
  • Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.
  • Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
  • Proactively monitoring the database's health and taking preventive or corrective actions.
  • Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
  • Experience in scripting and automation using crontab and PowerShell.

Talented Database Administrator with 6 years of diverse experience in database design and administration, data modeling, data warehousing, Enterprise Systems Architecture and Business Intelligence (BI). Extensive technical skills and advanced understanding of Oracle, SQL Server, Postgresql and administration. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.

Skills
  • Operating Systems
  • Linux Redhat 7, Windows server 2016, 2012.HP-UX 10.x, 11.x. Sun Solaris 9, 10. AIX 5.3,
  • RDBMS
  • Oracle 10g, 11g, 12c and 18cPostgreSQL 9.x – 11.x
  • Languages
  • SQL, PL/SQL
  • Tools
  • TKPROF, STATSPACK, TOAD, SQL DEVELOPER, OEM 13c
  • Database Utilities
  • SQL
  • Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL
  • Loader, RMAN, DataPump, Export, Import
  • Cloud Computing
  • AWS and AZURE
  • 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.
  • Provided 24X7 support 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”.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/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.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace file
  • AIX 5.3, Network attached storage, Scripts
  • ASM, Enterprise, Sun Solaris 9
  • C, Networks, Sun Solaris
  • Capacity planning, Operating Systems, Microsoft SQL Server
  • CPU, Operating system, SQL
  • Client, Oracle 9, Switch
  • Database Management, Oracle, Tables
  • Database, DEVELOPER, TOAD
  • Databases, Oracle Enterprise Manager, Troubleshoot
  • DBMS, PL/SQL, Troubleshooting
  • Disaster recovery, Peak, Unix
  • HP-UX, Perl, Upgrade
  • Linux, Processes, Upgrading
  • Managing, RDBMS, Utilities
  • Memory, Redhat, VM
  • Windows, Redhat 7
  • Migration, SAN
  • NAS, Scheduling
  • Implementing security measures
  • Linux operating system
  • Database development
  • Relational Database Management
Education
B.SC: Political Science and Public Administration
AWS Architecture AssociateOracle cloud infrastructure Database ManagementSQL FundamentalsOracle Certified AssociateOracle Certified Professional.Oracle Autonomous DatabaseMicrosoft SQL Server 2012/2014
Work History
Brontech Solutions, RESPONSIBILITIES- Oracle DBA
Greenbelt, MD04/2017 - Current
  • Upgrading 11g to 12c and migrated data successfully in production, development and test environments depending on project requirements.
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications.
  • Configured and Managed Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC).
  • Design and Maintained Physical standby maintenance (Switch over - using Data Guard Broker).
  • Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification.
  • Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
  • 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.
  • Responsible for Logical backups EXPDP/IMPDP and worked with conventional EXP/IMP for migrating data from 10G to 12c.
  • Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.
  • Defragmentation of tables and indexes for improved performance and effective space management.
  • Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM.
  • Monitored and troubleshoot database issues with OEM grid control.
  • Performed database recovery using GRP (Guarantee Restore Point).
  • Very comfortable in using ASM for creating disk groups, adding additional storage (DISKS) and troubleshooting ASM issues.
  • Setup the unidirectional replication on oracle 11g databases using GoldenGate.
  • Monitoring and troubleshooting the gaps between source and target databases configured with GoldenGate.
  • Created Oracle Wallets and implemented Tablespace level TDE security.
  • Managed Database Maintenance Activities to achieve optimum database uptime.
  • Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments.
  • (Sun Solaris, Linux Redhat.
JP Morgan Chase- Oracle Database Administrator
Irving, TX05/2015 - 04/2017
  • Performed Installation and configuration of Oracle 12.1.0.2 database on Linux Redhat platform.
  • Successfully performed migrations from Oracle 11g/12c to 11gR2 RAC (Real Application) Database.
  • Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
  • Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
  • Supported off-hour on call support for database related issues.
  • Created logical and physical design installed and upgraded databases.
  • Implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard).
  • Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
  • Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
  • Configure Data Guard on both standby and primary for 45 production databases.
  • Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Experience in working with virtual machine (VM Ware) and oracle virtual machine (OVM) under different operating system like Linux, sun Solaris and windows:.
  • Performance tuning issues using VM sphere client.
  • Installing oracle software and creating standalone databases on.
  • Migrating from multiple Oracle 11gR2 database to oracle 12cR1.
  • Taking snapshots and rebooting the server's and performance monitoring for Oracle databases.
  • Configuration and administration of Data Guard (Physical/Logical standby Databases).
  • Applied patches 11.2.0.1 and 11.2.0.3, 10.2.0.4.
  • Used to run the 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.
  • 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 24X7 support for all the production and development databases.
Horace Mann Insurance, RESPONSIBILITIES- Database Analyst
Addison, TX07/2014 - 04/2015
  • Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
  • Storage area Networks (SAN) and Network attached storage (NAS).
  • Documented the Standard Processes for peers to follow.
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:

  • Brontech Solutions, RESPONSIBILITIES
  • JP Morgan Chase
  • Horace Mann Insurance, RESPONSIBILITIES

Job Titles Held:

  • Oracle DBA
  • Oracle Database Administrator
  • Database Analyst

Degrees

  • B.SC : Political Science and Public Administration
    AWS Architecture AssociateOracle cloud infrastructure Database ManagementSQL FundamentalsOracle Certified AssociateOracle Certified Professional.Oracle Autonomous DatabaseMicrosoft SQL Server 2012/2014

Similar Resumes

View All
Oracle-DBA-resume-sample

Oracle DBA

Germantown, Maryland