Oracle Database Administrator

KEMFAC ELIAS

Tel: 346-***-****

email:adcd0e@r.postjobfree.com

Preference : Full Time/ Remote

PROFILE

I am an Oracle Certified Database Administrator, MS SQL server, PostgreSQL, Splunk admin with 7+ years of experience in high end Oracle database administration. I have a wealth of experience in oracle database design, analysis, modelling, implementation and development of oracle database. I am a critical thinker and have extensive experience in trouble shooting, Data Guard, RAC, Golden Gate, Patching and Upgrade and also, I have been able to install and configure Grid ASM. I am a great team player and an excellent communicator.

Skills Summary

Experienced Oracle DBA with 7 +years’ of experience in Oracle Database Administration and PostgreSQL, MS SQL Server, in large-scale production environments across multiple platforms.

I managed Oracle and PostgreSQL databases supporting many different applications. Great knowledge in PostgreSQL database architecture, experience assuring the availability, performance, integrity, and security of Oracle and PostgreSQL databases for both

OLTP and OLAP environments.

Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.

Providing the performance tuning of slow running queries in Production Murex application.

Installed a new Oracle 13c Enterprise Manager Cloud Control for database monitoring.

Implemented OEM 13c Alert Email System. It monitors databases, cluster, hosts, etc

Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.

High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

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)

Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

Worked on large-scale databases with size around 10TB in large system environments.

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.

Created indexes to facilitate easy user interface implementation and tuning.

Involved in construction of DR sites for all the Production and IST environments.

Performed Database Refresh from Production to IST, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

Cloned Database from Production to Test and Development.

Exporting and Importing of dumps using expdp and impdp.

Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption, DBMS CRYPTO, etc

Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.

Install/deinstall RPM to match exact dependencies for Exadata image version.

Experience in oracle migration to Exadata machines.

Exadata-extensive experience on Exadata full-stack patching (QFSDP).

GoldenGate implementation on Exadata and zero downtime migration from legacy systems to Exadata.

Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

Experience in installing, configuring, planning, testing MS SQL Server 2016,2014,2012,2008R2,2008,2005 and associated database tools updating with latest service packs, hot, fixes and security patches.

Successfully implemented capacity planning for different servers.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Expertise in maintaining Database Security using auditing.

Experience in development of dashboards/reports, alerts and Splunk integration.

Experience in designing, development and implementation of Service Now Platform.

Splunk Administration and analytics development on Information Security, Infrastructure and network, data security, Splunk Enterprise Security app, Triage events, Incident Analysis.

Experience in using Splunk DB Connect 2.0 to index the data from various database types.

Expertise in Fetching the data from databases using "DB Connect Application"

Efficiently fixed Event breakings and Time zone issues.

Experience in using flexclone for backup and refresh.

Migration- 8i to 10g,11g to 12c databases plus applications across platforms using Dataguard,data conversation.Maintain performance across all phase.Consolidate SQL server and DB2 to oracle by migration workbench.

Configure SMTP server for Database Mail setup and received alerts for the threshold values and also migration from SQL server to AWS.

Work Experience

TCF Bank – Tomball, TX June 2017 – Present

Oracle Database Administrator

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux and Windows environments.

Setup New databases on Clustered and Non clustered environment and Implemented Maximum Availability Architecture using RAC, DATAGUARD and Golden Gate

Upgrade 11G RAC to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL and applied patches in rolling fashion.

Worked on 12c RAC new builds and administering 12c RAC and managed ASM on RAC

Creating Volume and Configured ACFS on ASM diskgroup and Extensively worked on creation oracle Databases with ASM filesystem

Configured diskgroups with different redundancy levels and created fail groups and managing and tuning ASM parameters

Configuration & Troubleshooting the Oracle DataGuard & GoldenGate environment in Oracle 11g & 12c versions.

Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Set performance Tuning Parameters in the PostgreSQL database including auto-vacuuming for BLOAT and other performance related issues. Perform advanced health check (ACH) and performance tuning for PostgreSQL databases.

Major and Minor Upgrades on PostgreSQL, Setup Security baseline for PostgreSQL server and Setup Streaming Replication.

Proficient with PostgreSQL, EDB's PostgreSQL Enterprise Manager (PEM), EDB's Backup and Recovery Tool (BART)

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

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements

Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.

Installation of 12c OEM and customize it to our needs.

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.

Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and Data Pump Export/Import and perform database Refresh and RMAN Cloning.

Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.

Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Statspack for best performance.

Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.

Installed OEM 10g grid agent on servers and configured to OEM 10g Grid Control.

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Implemented and administered Oracle Golden Gate (v12c) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.

Implemented Data Pump, Export and Import on day to day basis as per development and test servers.

Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices

Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).

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.

Alert management, Created and setup alerts to send notification to Users from application wherever necessary.

Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.

Proficient in troubleshooting Node Eviction in Oracle RAC Environment

Applied PSU patches and other database related patches.

Have a good experience in administering Oracle Clusterware components.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.

Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

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

UPS Logistics Group - Scottsdale, AZ April 2013 – May 2017

Oracle Database Administrator

Setup data guard, create physical-standby database using hot backup. Troubleshoot errors on standby. Manually register archivelogs.

Setup & test backup on databases. Writing RMAN scripts embedded in shell scripts. Recover full database by applying archive and redo logs. Duplicate database by RMAN on remote host. Optimize backup on RAC.

Imp/exp used for load data into users on daily bases. Import schemas as part of recovery process in times of logical corruption. Export statistics from production to test.

Tuning of instance, database with help of system views and init parameters. Partition of tables, indexes to improving performance. Used partition pruning, wise-join.

Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.

Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints

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.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.

Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC.

Setup, reconfigured and monitored 2, 3 Node RAC

Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.

Redesigned table and index partitioning strategies, using HINTS to improve the query performance.

Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.

Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.

Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.

Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.

Migrated data to a new ASM Diskgroup to improve the IO performance of the database.

Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.

Data aggregation and replication setup using Oracle Streams and Materialized views for reporting.

Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.

Education

University of Buea

Chartered Institute of Marketing (UK)

Regina Pacis Higher Technical and Commercial college

SQL Fundamental 12c

OCA 12c

Splunk Fundamental

Technical Summary

Databases

Oracle 10g, 11g, 11gR2,12c, PostgreSQL, MS SQL Server,Splunk Admin.

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,Snow

Operating Systems

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

Contact this candidate