CHRISTIAN DOBGIMA FOTACHWI

Email: acxyeg@r.postjobfree.com

Phone: 240-***-****

Professional

Experience

Associated Bank - Green Bay, WI

Role: Oracle DBA August 2014 – Present

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g

Responsibilities:

Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.

Performed Hot Backups, Cold Backups.

Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.

Experience on working with data guard physical/logical standby databases.

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.

Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.

Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Extensive experience in RMAN recovery testing, RAC and stand alone database

Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)

Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.

Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.

Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers.

Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.

Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.

Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.

Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.

Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Successfully implemented Backup & Recovery using RMAN and SQL Backtrack which includes hot backups and Cold backups.

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

Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)

Installed the Oracle software using silent feature and also created databases

Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

Writing SHELL SCRIPTS for the system and database for effective functionality and report generation

Supported & maintained the Production/Development databases on various servers

Extensively worked on setting up auditing in many databases we supported

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Installed ASM environment and migrated databases from NON-ASM to ASM.

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

Sedgwick CMS - Memphis, TN Jan 11 – August 14

Role: Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.

Responsibilities:

Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.

Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.

Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.

Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).

Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.

Ensure sound database definitions, structures and documentation.

Creating and cloning database from PROD to DEV, UAT and QA.

Presenting and analyzing database performance reports and improvement recommendations to client company's senior executives.

Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.

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

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

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

Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.

Worked with application developers to address and clarify data requirements to resolve technical and functional issues.

Enforced corporate business rules through adequate user/resource/object management.

Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.

Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Professional

Summary

Over 5 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows.

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

Good at Data Dictionary views, User Security and Auditing.

Team player with excellent interpersonal, analytical and communications skills

Experience in Multitenant Databases (Oracle 12c Container and pluggable databases).

Consolidated database creation in oracle 12c using multiple PDBs.

Implementation of EM12c installation for multiple data centers, POC of OEM 11g grid control and OEM12c.

Configure and support Linux servers (RHEL and OEL) to host Oracle 11g and 12cRAC technology stack supporting both OLTP and DSS (data mart/data warehouse) databases.

Create High Availability 11g and 12cRAC Linux clusters (ranging from 2 to 6 nodes) utilizing Data Guard in compliance with Oracle's Maximum Availability Architecture (MAA).

Implement Enterprise Manager GridControl (11g and 12c) to provide monitoring and management of the Oracle database estate.

Implemented Disaster recovery for production databases using Data guard and creating physical standby databases, and involved in converting physical to snapshot standby, and also Active Data-guard

Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.

Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.

Monitored and managed various database components (logical & physical) like tablespaces, segments

Worked extensively on Shell scripting for backup, recovery and maintenance for databases

Experienced in full life cycle of database administration in Oracle. Worked as a Development Support DBA in Oracle.

Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS

Data transferring with export/import utilities and Data Pump and SQL* Loader.

Performing complete and incomplete recovery during disasters, failures and user errors.

Configuring user creation, their roles and privileges profiles to control access over database objects.

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 as well as database upgrades

Setting up Hugepages - Calculated the recommended values and setup hugepages on Linux severs.

Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.

Installed 12c pluggable databases and upgraded from 11g to 12c and managed fusion middle ware products

Performed Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.

Deployed Standby databases using Data Guard 11G (Maximum Performance).

Technical

Summary

Databases: Oracle 11G/10G/12C

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

Education

Full Name:

Christian fotachwi

Current Location:

9141 lanham severn rd, lanham md 20706

Work Authorization:

No police clearance

IBM job consideration

United stated citizen

Able to obtain

Not any at a moment

Earliest Available date to start:

As soon as possible

Date and times available to interview:

Open to interview Monday to Saturday

From 10am – 11pm

Hourly rate on W2:

$45-50 per hour but open for negotiable

Two Professional References:(Preferably Supervisory references):

Patrice tuatsop

202-***-****

MGR. Associated Bank - Green Bay, WI

Joseph B. Kamara

Business / program manager

ResCare

Cell: 202-***-****

Work: 301-***-****

Contact this candidate