Oracle Database Administrator

KONRAD EWALU

add5p1@r.postjobfree.com

(904) -732-0696

6+ years of experience as an Oracle Database Administrator, I have worked on complete life cycle support, from development to test and production.

Extensive hands-on experience in Installations, configuration, Cloning, Security, Patching, Upgrades of Oracle installed and configured on different platforms like Windows, Linux, RHEL, Oracle Solaris, HP-UX., IBM-AIX, providing 24x7 production support and development support

Experience in Installation of 12C Grid Control and experienced in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 11g/12c.

Also, vest in implementing and planning backup and recovery strategies using Recovery Manager (RMAN) . Recovery of data files and databases using RMAN with point-in-time recovery option.

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM and SQLPLUS.

Installation and configuration of Oracle 10g &11g RAC using Cluster ware and ASM.

Strong experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC

Experience in very large scale database environment and mission critical large OLTP and OLAP systems.

Migration of large number of databases from 10g to 11g and implemented ASM on RAC and stand-alone databases and Applying PSU Patch also Migration of non ASM database to ASM database.

Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)

Enabling Load Balancing in a Multi-Tier Architecture

Performed data movement using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.

Strictly enforced security measures on system monitoring by adding and revoking users privileges and also configuring quotas, auditing, and analyzing security issues.

Setup procedure for Database statistics gathering frequently, during favorable hours of the day to execute stats gathering jobs.

Monitored and configured Targets using TOAD to do the daily tasks regarding the performance and database maintenance.

Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.

Developing shell scripts and SQL scripts to carry out routine database checks such as monitoring tablespace growth and thresholds.

Troubleshooting for slow running SQL by utilizing STATSPACK, TKPROF, EXPLAIN PLAN and SQL TUNNING ADVISOR.

Utilized SQL* Loader to EXTRACT, TRANSFORM and TRANSFORM data.

Extensive experience in SQL tuning using Explain Plans and Hints for better performance and monitoring database on different levels such as - Application Tuning, Instance Tuning, and Tuning Disk Usage.

Worked on different types of storage structures (SAN/NAS)

Periodically installed patches using O-patch utility and expertise in applying quarterly Oracle PSU and CPU patches.

Multiple upgrades of Sun Solaris and Linux servers from 9i to 10g, 10g to 11g and 11g to 12c.

Experience with Technical Oracle Support Service Requests(SR) follow up using My Oracle support account.

Experience in using SQL, PL/SQL procedures, functions, triggers and packages.

Self-motivated, Great team Player, ability to work independently and willingness to work weekends and on-call rotations for support and late nights maintenance activities. Keep track of calendar meeting, follow SLA timing, ability to learn any technology and become productive.

Motorola Solutions - Schaumburg, IL

September 2016 – Present

Oracle Database Administrator

Created Physical Standby databases using RMAN, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Table refreshes and schema refreshes logically using Datapump - expdp and impdp utility.

Database refreshes using conventional exp, imp utility and also RMAN Duplicate for cloning.

Used RMAN Duplicate and HOT/COLD backups to migrate data from 11.2.0.1 to 11.2.0.3.

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on Red Hat Linux 5.3. Database sizes range from 40GB to 3TB.

Provided 24X7support for all the production and development databases.

Configured deployed and administered 2 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 5.2.

Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.

Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, ADDM and AWR reports.

Planning Backup/Restoration Strategies, scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Designed, developed, and implemented database security management by creating users, granting roles and privileges based on the principle of least privilege.

Applied critical PSU patches to Oracle databases systems and application servers in collaboration the application team.

Installed Oracle Clusterware Software to set up 2-nodes in a production environment.

Manage agents using emctl utility and creating incident rules in enterprise manager 12c

Configuring administration groups, and creating template collections in OEM 12c.

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).

Enhanced and enforced advanced security measures such as TDE on sensitive information.

Worked closely with the developers for the better performance of Applications in executing Procedures, Packages, Functions, Triggers and Indexes on tables.

Installed RAC 12c on 2 node cluster for large production system and migrated the system from Non-RAC environment to RAC 12c cluster database.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Responsible for capacity planning, database security, recovery planning and installing patches

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. Explored 12c features by doing POC, including multi-tenant features

Responsible for setup and implementation of 2 Node RAC on Linux in 11g and 12c R2.

Hands on experience on database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Table spaces.

Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.

ETL and DW, design and develop high volume data ETL process via Oracle SQL and PL/SQL and Unix shell scripting, Data warehouse solutions design and implementation (ROLAP, Star Schemas).

Database refresh from Production to Non-PROD.

Create database Objects, Tablespaces, Schemas as needed.

Schema migrations from Development to Production.

Attend weekly meetings and participate on weekly on-call rotation to ensure 24/7 production support.

Attend in house trainings from vendor consultants.

Bank of Oklahoma - Tulsa, OK

March 2013 – August 2016

Oracle Database Administrator

Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.

Worked extensively on monitoring Targets on Oracle Grid Control Cloud databases, configuration of error notifications, installing listeners, and adding them to the OEM grid control.

Scheduling Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs

Managed disk group in ASM while installing 11gR2 RAC.

Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).

Ensured that oracle database systems operate securely and efficiently by minimizing down time.

Managing databases from planning and testing stages through implementation and support.

Implemented recovery strategies when required and successfully recovered databases from crashes and also performed media recovery using RMAN.

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 “opatch” utility.

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 10g, 11g.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances

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.

Completed upgrade of databases from 11g to 12c non CDB.

Successfully migrated 12c Non CDB databases to pluggable databases(PDB).

Created Oracle Wallets and implemented Tablespace level TDE security.

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.

Used JIRA to keep track of projects like upgrades implementation, Dataguard, TDE and Oracle RAC ASM Grid Infrastructure.

Proactively multi-tasked using tools such as SQL Developer, SQL Navigator, TOAD for script execution and OEM of monitoring tablespace growth and performance.

Make sure to document every task and always update daily status report in order to meetup with date lines.

Bachelor in Computer Software Engineering

Databases

Oracle 10g, 11g, 12c

Database Tools

SQL Loader, DB Configuration Assistant) TOAD, OEM Grid, RMAN, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy

Operating Systems

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

Skills Summary

Work Experience

Education

Key Skills

Contact this candidate