Resume

Sign in

oracle Database administrator

Location:
Omaha, Nebraska, 68102, United States
Posted:
December 07, 2017

Contact this candidate

Asunia

Obed NFortsen

(Oracle Database Administrator)

515 ***-****

ac3mta@r.postjobfree.com

(willing To Relocate)

Summary

Accomplished Oracle-certified DBA with over 8 years of experience and expertise in performance tuning, crisis management, and high availability to increase reliability, maximize productivity, and introduce system efficiencies through effective database administration. Technically proficient in implementing and administering oracle RAC databases as well as Single instance. Expert in RMAN backup and recovery, user manage backups, performance tuning, Data Guard, GoldenGate, upgrade, patching, cloning, Data Pump, ASM and flashback. Also have complete understanding of oracle architecture and able to coordinate the designing, coding, testing and supporting of next-generation database solutions in Oracle enterprise and other Server environments to improve system performance and business continuity.

PROFESSIONAL Highlights

RHands on experience in Oracle 10g 11g and 12C

RExpertise in RMAN BACKUP (incremental, Incremental Cumulative and Full Back up)

RHands on experience in Oracle 10g, 11g and 12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)

RPleasant experience in RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, table/index analyze jobs, database backup logs etc.

RPerformed upgrade in RAC environment from 11. 2.0.3 to 11.2.0.4 and perform rolling upgrade using data guard

RExperienced in upgrading standalone databases to 11g RAC environment.

RExperience in taking backup on Oracle RAC database by using RMAN utility in a CDB (Multi-tenant) environment.

RExperience in patching RAC databases in rolling fashion to maintain high availability.

RExpert in implementing database security by creating and managing users, profiles, expiring passwords, implementing auditing as well as Transparent Data Encryption (TDE)

RExtensive experience designing and implementing backup and recovery strategies for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Data Pump as well as conventional Hot/Cold Backups.

RImplemented various backup strategies for Large / Medium sized databases using RMAN

RWorked extensively on Cloning/Duplicating of databases using RMAN as well as manual database cloning.

RExperience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.

RExperience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.

RExperience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

RInvolved in tuning applications for optimal response time using SQL-Optimizer Trace at various levels and events, Explain Plan, TKPROF, or debug and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

RExpert in tuning database using SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, and SQL Baselines

RUsed TKPROF, Advisory framework for Performance Tuning

RExpert in delivering Oracle Database performance-tuning services with 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

RExperience with SQL coding including DDL, DML and fine tuning those SQL's for better performance.

RGood knowledge v$performance views and command line skills to identify information about sessions, wait events, system performance, etc.

RExtensive experience in shell and batch scripting on Red hat Linux 6.x.

RDesign and write T-SQL and scripts to automate database management tasks.

RApplying Patches using the OPatch utility

RExtensive experience in designing Logical and Physical data models for new developments using ERwin modeler.

RSkilled in cross platform migrations from Windows to Linux and Solaris to Linux.

RStrong knowledge on troubleshooting networking issues TCP/IP (Transmission Control Protocol/Internet protocol)

RExtensive experience in installing and maintaining Oracle Data Guard to implement physical standby databases for disaster recovery.

RProficient in setting up standby database using shell scripts and RMAN utility tool, activating and Rebuilding Standby Databases both Physical and Logical supported by Data Guard.

RMigrated databases from Non-ASM file system to ASM file system using RMAN.

RUpgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, Data Pump & Transportable Tablespace

RExperience in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized views for Oracle databases.

RHands on experience with logical backups, hot and cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager.

RExpertise in using recovery CATALOG to manage RMAN backups.

RExperience in disk space management involving managing archives, space allocation to various tablespaces and capacity planning for new applications.

RPlugging the tablespace between different platforms using cross-platform transportable tablespace Utility.

RExperience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation

RMemory tuning by using ASMM (Automatic shared Memory Management), Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.

RRebuilding of Indexes for better performance.

RExpert in maintenance of Oracle Database, User Management, Tablespace management

RHave ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.

RExperience in using GoldenGate to support data replication.

RExperience in GoldenGate upgrade from 10.2 to 11.2. and Installing Oracle patches

RConfigured MANAGER, REPLICAT, PUMP and EXTRACT processes for GoldenGate

RProficient in implementing unidirectional and bidirectional replication using Oracle 11g GoldenGate.

RExpertise in loading data from flat files using external tables, SQL* Loader.

RExperience with SQL, PL/SQL, UNIX Scripting.

RHands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.

RExposure to PostgreSQL databases

REffectively done cross-platform migration from Oracle to PostgreSQL

RCloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

RInstalled ASM environment and migrated database from NON-ASM to ASM.

RExcellent analytical, problem solving, communication and interpersonal skills

Professional Experience

Union Pacific Railroad, Omaha, NE Sept 2015 – Present

Oracle Database Administrator

Worked on installation and maintenance of Oracle 11g, 12C

Responsible for creating users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Involved in tuning applications for optimal response time using SQL-Optimizer Trace at various levels and events, Explain Plan, TKPROF, or debug and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

Performed RAC Administration/trouble-shooting of 3 Node cluster on Oracle 10g/11G R2

Configured Grid Infrastructure, SCAN listeners on 11gR2 and migrating OCR files to ASM.

Involved in 24x7 on-call support for 11g 3 Node RAC production databases using Oracle 12C Cloud Control for Alert Monitoring and Notification

Performed upgrade In RAC environment from 11.2.0.3 to 11.2.0.4 and perform rolling upgrade using data guard

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Involved in tuning applications for optimal response time using SQL-Optimizer Trace at various levels and events, Explain Plan, TKPROF, or debug and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

Utilized strong technical background of the Oracle database to configure and implement Oracle Streams for schema, table level replication and downstream capture.

Configured and backup database with RMAN, hot backups, cold backups and Data Pump Logical backups.

Installed, configured, and maintain Oracle 11gR1, 11gR2, 12c, RAC, physical and logical standby database for Test, Development and Production for customized applications

Configured standby database using duplicate from active primary database of 11g. for disaster recovery

Applied SCN-based Incremental backup to sync standby after loss of archive logs.

Involved in GoldenGate setup and monitoring, troubleshooting replication errors & reading Trail files to identify replication issues and conduct performance/latency test of GoldenGate

Configured parameter files for EXTRACT/DATAPUMP/REPLICAT process to perform Replication/Transformation /exception handling.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control while working on Automatic Storage Management (ASM) with EMC storage for managing data in SAN.

Used import/export utilities for cloning/migration of small sized databases and Data Pump import/export to move data between 10g/11g/12c environments.

Worked extensively on performance tuning of queries by maintaining aggregates, compression, partition, indexing and use of hints, stored outlines, statistics.

Capacity planning Allocate system storage and plan future storage requirements.

Managed ASM storage, ASM cloning, Add/remove ASM disks, tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

Upgraded the databases to version 12c from 11g and 10g

Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.

Experienced in writing UNIX/SHELL scripts for providing the reports.

Performed monthly and annual performance reports for trend analysis and capacity planning

Measured data loss based on latency/lag.

Ensured Cross-platform migration using Data Pump

Applied upgraded patches, maintenance and interim patches on databases.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.

Configured RAC, physical and logical standby database for Test, Development and Production for various home-developed applications

Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors.

Generated AWR reports using OEM 12c from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

Used import/export utilities for cloning/migration of small sized databases and Data Pump import/export to move data between 10g/11g/12c 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 and java calls.

ENVIRONMENT: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL Loader, Oracle Enterprise Manager Grid Control

Delta Dental, San Francisco CA July 2012 - August 2015

Oracle Database Administrator

Critically analyzed and tuned the database to identify potential issues such as response delay, locking contention, etc. using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.

Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, Node RAC Clusters

Applied bug fixes patches, quarterly security patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.

Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Data Guard for DR.

Tested the Data Guard switchover of RAC to RAC Data Guard as part of the migration.

Created new databases/instances on 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.

Performance monitoring and database instance, clustered and application tuning using dictionary views, AWR (Stats pack), 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, etc.

Designed daily, weekly backup and recovery procedures for production, non- production databases using RMAN backups taking periodic complete, cumulative and differential incremental backups.

Data refresh/cloning from PROD 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.

Made optimal use of Oracle Support in resolving the SRs.

Worked with latest 10g/11g features Data pump, flash-back recovery, AWR, ASM, ADDM, Grid monitoring, and recycle bin.

Extensively used AWR, ADDM, and explain plan for periodic performance tuning.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network attached storage (NAS).

Applied necessary patches during installation and also in upgraded databases on Oracle database versions 10g and 11g.

Configured Data Guard broker between the primary and standby databases, perform Switchover/Failover and monitor the Data guard status via DGMGRL and GUI.

Implemented backup and recovery using RMAN, which includes hot backups and cold backups to tape, drives, and disks.

Involved in query optimization and using rule based optimizers and cost based optimizers.

Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

ENVIRONMENT: Oracle 10.1.0.4/10.2.0.4/11gR2, RHEL 5 and 6, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting, TOAD.

TOTAL CAMEROON Ltd, Douala, JANUARY 2009 – FEBRUARY 2012

Jr Oracle Database Administrator

24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Migration of Oracle databases on Linux.

Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF),

Used RMAN for backup and recovery and performed backup validations using RMAN.

Management of schemas, objects partitioning the tables & indexes.

Data load using Korn shell scripting and SQL*Loader.

Responsible for setting and managing user accounts, and granting required privileges to users.

Performed other DBA activities like including space management and performance monitoring.

Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Tools Used: Oracle 10.2.0.1, Oracle 11g, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Education

Bachelor’s Degree in Accounting

Oracle Certified Associate

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c

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, Stats pack/AWR, Top, DBCA, DBUA, ADDM,

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization

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, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

PERSONAL SKILLS

Strong work ethic

Good attention to detail

Excellent team player

Excellent communication skills

Ability to learn in a fast-paced environment

References

Available Upon Request



Contact this candidate