P S Resume Example Brontech Solutions - Windsor Mill, Maryland

P S

Accomplishments

I am a bilingual (French & English) finance practitioner, turned Oracle DBA with a track record of delivering & exceeding corporate goals & objectives.

Professional Summary

I possess a large spectrum of experience in commercial banking, financial markets, corporate finance, strategic/ relationship management, international trade & project management… Within the last 5 years I have also acquired top IT skills and professional experience in Oracle (11g,12c) database administration. I consider myself to be a highly competent person who thrives on the intensity needed for trouble-shooting. I am a highly motivated, well-organized team player with a positive ‘can do' attitude. I have good planning & prioritizing skills & have experience in managing teams with a varied & pressurized workload. I can undertake difficult mandates & meet tight deadlines.

Skills

Remote Tools: Cisco VPN, VNC, WinSCP, Putty Remote Admin, , Remote Desktop A+CompTia: fully conversant.
Key Oracle skill set: Planning, installation, configuration, management and troubleshooting of Oracle 10g,11g and 12c databases on Linux and Windows OS
Expertise in the creation of databases, table spaces, tables, indexes and other database objects.Installed and manage Oracle Enterprise Manager.
Install and configure relevant network components to ensure database access as well as database consistency and integrity
Troubleshoot and resolve various Oracle connectivity problems.Provide network troubleshooting and administrative support for the development staff.
Installation and management of Oracle database using database control Create and manage documentation on the configuration and support of the Oracle databases Perform bulk load into the database using SQL Loader Perform standard and fine grain database auditing. Documented database structure, changes, problems, issues for future reference Administer database user accounts.
Create, modify and deactivate user accounts; assign and monitor user access rights Created Testing and Development databases following OFA compliance rules.
Provide database administration on production, testing and development database servers.Managing Schema Objects local and remote using database link
Regular Monitoring Alert log Files and trace files on Day to Day Basis.Identifying and removing Fragmentation, row migration/chaining of database objects

Analyzing the Tables and Indexes on performance base regularly Monitoring Tables paces and Data files utilization.
Managing Undo Tables paces, Redo Logs, Control files and Archive logs. Implemented multiplexing control files and redo log files
Configuring various RMAN parameters as per the requirement.Performing physical backups using RMAN utility.Identify and recover the corrupted db blocks using Block recover option in RMAN utility
Performing Complete Media Recovery of Database depends on the nature of failure.Configure and implement the use of Oracle
Recovery Manager (RMAN) for cold and hot backup to the databases
Extensively using DATAPUMP and Export /Import utilities for logical backups.Performing database cloning using RMAN.
Monitoring the user sessions and take appropriate action to kill the inactive sessions
Creating and rebuilding indexes as necessary.Performed various performance goal oriented database tuning.Use explain plan, AWR, ADDM and various Oracle Advisors to tune the database.Created and tuned various materialized views.Tuned various slow running query
Performed instance tuning, memory tuning query tuning and complete database tuning.Creates and implemented various table partitions for large tables
Resolved various complex issues with the database.Apply quarterly CPU patches to different version of databases

Work History

P S,

DBA, 03/2012 to Current
Brontech Solutions – MD USA

Performed Installation and configuration of Oracle 12c in a Virtual Environment on RedHat Enterprise Linux Platforms
Created Oracle Databases on these servers Performed database upgrades from 11.2.0.1 to 12.1.0.1
Configured Enterprise Manager for the Oracle Database Servers
Part of a team that came up with a backup strategy and scheduled this strategy for the production databases about 1TB in size
Successfully performed migrations from 11g to 12c RAC (Real Application Clusters) Databases to ensure high availability and business continuity. · Created users, groups, profiles and granting least privilege resources to relevant users and groups
Created a Refresh Database for the Testing Environment Using Cold Backups
Configured and Implemented Dataguard to significantly reduce data loss and downtime Technical documentation of all configurations, installations, implementation and testing of projects for future utilization.
RMAN for backup performing backup (full, incremental – cumulative and/or differential, level 0, level 1, deletes etc) according to SLARMAN point in time recovery and Instance recovery done on 11gDeveloped compliance reports and performed auditing at higher levels.
Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab
Applied PSU Patches […] […] 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.
Monitoring and optimizing the performance of the database/application using OEM.
Capacity planning: Allocate system storage and plan future storage requirementsWorked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL
OptimizerInstallation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU)
Performing monthly and annual performance reports for trend analysis and capacity planning
Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst othersWorked on both VMS and UNUX environments
Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL,database design, database tables, indexes, Instance, memory and operating system
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP
Experience in writing UNIX/SHELL scripts for providing the reports.
Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA,for performance testing and future 10g production implementation

Account Relationship /Database Admin: , 08/2004 to 11/2011
Union Bank of Cameroon – Yaounde Cameroonmanager

Account Relationship Manager:

Analysis of financial information, credit reference agency data, payment history & various non-financial elements to sanction trade finance limits with a personal approval authority of up to £0.5m.
Managing relationships with clients & their customers to achieve a high level of client satisfaction.
Ensure team maximizes opportunities to help achieve core objectives
Drive forward the business objectives & deliver solutions to support the team achieving the targets set
To effectively solve problems & manage risk to ensure achievement of KPIs & for contingency planning
To proactively manage, processes & workflow of all communication flow to & from the bank in a timely fashion. Database /system Admin
Daily backups and night runs
Retrieving and archiving all transaction data following corporate policy ·
Training and supporting employees with ERP
Creating and granting system privileges to employees
Procuring IT system stationary according to department needs Guarantee Officer for Contingent Liabilities, Union Bank of Cameroon
Establishing of Bid bonds, advance payment bonds, retention bonds, customer call reports & surveys
Factoring public contracts for the bank on behalf of customers
Trade Finance Officer / Relationship Manager, Union Bank of Cameroon ·
Securing Letters of Credit, facilitating instruments for shipments & international terms of trade in compliance with ICC regulations & UCP 600.

01/2013 to 03/2014
DUCATION

Education

MBA: Finance, 2014
London school of Commerce - London UK

University of Wales Finance

The LSE Department of Finance (formerly part of the Department of Accounting and Finance) has grown in recent years to become one of the largest and most highly-regarded finance groups in the UK and Europe. It is closely associated with the LSE's Financial Markets Group which regularly hosts a wide variety of seminars, conferences and public addresses by leading academics and practitioners. With over 200 post-graduate students selected from a pool of top applicants world-wide, a faculty recruited from the top departments internationally, and a steady flow of distinguished visitors, we have a stimulating environment for research and learning that is on par with the best in the world

Bachelor of Arts: Economics and Commerce, 2011
University of Buea - Buea, Cameroon
Bachelor of Arts: Economics

Certifications

DBA Certificate 1
DBA Certificate 2
DBA Certificate 3
DBA Certificate 4

Resume Overview

Companies Worked For:

Brontech Solutions
Union Bank of Cameroon
DUCATION

School Attended

London school of Commerce
University of Buea

Job Titles Held:

P S
DBA
Account Relationship /Database Admin:

Degrees

MBA : Finance , 2014
Bachelor of Arts : Economics and Commerce , 2011

P S Resume Example

Resume Score: 70%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes