EDOE AGBODJAN
**** ********* **, ************, ** 20877 CELL: 267-***-**** ********@*****.***
Career Overview
Oracle DBA 11g certified Oracle Database / Administrator offering around 9 years of experience with over 8 years in IT Oracle 10g, 11g,12c and finance * Enterprise Manager - RMAN- Backup & Recovery -Database Migration, SQL Server installation & Administration - Qualifications Oracle Database Administration oracle database administration – Unix shell scripting-System Administration oracle architecture and database Network Management -concepts Production Database Management Oracle Architecture & Database Concepts Quality Assurance Project Co-ordination.
Qualifications
Account management, ARMED FORCES, ARMY, Responsible for Oracle 11g logical and physical ASM, auditing, Client, database Database design, implementation, and maintenance. Administration, databases, Database, Database Reorganize databases and size database objects to Management,
Dell, documentation, Edge, meet standards and improve performance. hardware support, HP, Linux, managing, access, Administered and managed 20+ RAC production MOS, Windows OS, Network Management, databases of sizes up to 10TB in various network, Oracle Enterprise Manager, Oracle, datacenters. Oracle database, Perl, processes, Proliant, Performed migrations of Oracle 10gR2 databases Quality Assurance, Relationship Management, from LDOMs (Oracle VM) to Oracle 11gR2 ASM scheduling, servers, scripting, Shell, Solaris, databases. SQL Loader, Strategic Planning, Sun, System Monitored daily RMAN reports and created status Administration, Tables, Technical Support, update to the higher management. Troubleshoot, Troubleshooting, Upgrade, VERITAS Performed database refreshes using RMAN and created standby databases.
Accomplishments
MBI PUBLIC TRUST CLEARANCE
UNITED STATES ARMED FORCES 2011-2015
CISA VOLUNTEER -2014
Work Experience
Oracle DBA analyst September 2016 to now
Department of Treasury IRS
-Oracle 12c OEM for database monitoring. -Working on financial database production server. -Monitoring and troubleshooting SQL*Loader/PL/SQL Data Loads for Performance. Working in software development project teams and independently to accomplish the primary function of ensuring the uptime, performance, optimization, and security of all critical systems and ensuring a consistent strategy is used for the design of new systems and hosted environments. -Advising developers and data modelers on design and optimization. In conjunction with the ACA PROJECT at the IRS, Support the development and maintenance of spatial database systems that support development, financial operations, and production and QA activities for Oracle 11gR2 single instances. -Working with pluggable databases in 12c, and security compliance correction.
- Managing Cassandra database, managing database security and encryption through Authenticating, Authorizing and Auditing users. Creating and assigning appropriate roles and privileges to users depending on the user activity.
Oracle DBA 12/2009 to Aug 2016 University Maryland Rockville,
- Responsible for Oracle 11g, oracle 12c, logical and physical database design, implementation, and maintenance.
-Reorganize databases and size database objects to meet standards and improve performance.
Administered and managed 20+ RAC production databases of sizes up to 10TB in various datacenters.
-Performed migrations of Oracle 10gR2, databases from LDOMs (Oracle VM) to Oracle 11gR2 ASM databases.
-Monitored daily RMAN reports and created status update to the higher management.
-Performed database refreshes using RMAN and created standby databases. Managed multiple Data Guard Disaster Recovery and System Replication processes using Streams, ensured synchronization between the primary and standby database, and performed manual intervention when required.
-Configured and troubleshot Grid Control.
-Used customized templates to create the target databases based on the Oracle components installed in the
source databases.
-Performed migrations as per client standards, regulations, security policies and procedures.
-Worked with the migration Team, Team Lead and Sys Admins.
-Coordinated the migrations with the Application Team and the Applications DBA. Performed validation reports
comparing the source and target databases.and for CSSCAN on source databases for change in character set conversion upon migration.
-Create new databases, involving importing and exporting: installing and configure database software for Oracle
application development environment.
-Provided a 24/7 availability and coverage of technical assistance through the use of emails and cell phones for
-mission critical Databases Handle database server tuning, application tuning, maintaining documentation, and
Capacity planning and.
-Provided 24*7 support and report to the Operations Manager and the VP of Operations.
-Installed Oracle 10g cluster, ASM and database on Windows 2008.
-Assisted the application developers with performance issues and database change requests.
Coordinated system maintenance with Support Specialists and System Engineers
Oracle DBA 07/2008 to 11/2009 Cecile tech Colesville, MD
-Used RMAN to backup database.
-Used Cassandra database.
-Worked daily on incremental backup, and weekly on full database backup.
-Used OEM to schedule backup.
-Handled disaster testing.
-Cloning and creating new databases using EM DB console.
-Configured and implemented data warehousing.
-Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges.
-Assist J2EE application developers and project managers in implementing best practice database security features.
-Configured and monitored the TNS Listener using Net CA, cost parameter.
-Used data Pump to implement database refresh with the hot backup using DUPLICATE or full export.
-Used EXPORT/IMPORT to do table level and full database defragmentation.
-Responsible for Oracle 11gR2 logical and physical databases design, implementation and maintenance on UNIX and NT.
-Patched and installed of Oracle software.
-Performed tuning using the AWR, ADDM (‘adam') to guide tuning and maintain high database availability and
reliability.
-Provided direct consultation and support to projects or application developers in the areas of database architectural design, database conversion, independent testing, application development and database administration.
- Documented the procedure for a Data Pump migration of source databases having encrypted data; Oracle Wallet
Business analyst 03/2007 to 07/2008 Bank of Eastern shore Rockville, Maryland
-Identified new value sources by conducting industry and client research and Designed/administered business processes and systems.
-Facilitated deliverable transition between project life cycle stages and ensured that key project deliverables were effectively transitioned and placed under configuration management.
-Implemented quality management processes such as process and product quality assurance (PPQA) and other quality- related reviews (e.g., Quality and Process Improvement or QPI best practice reviews).
-Provided system architecture recommendations to reflect OFA Recommended RAID levels and STRIPE Sets. -Configured UNIX System kernel that is semaphore settings and shared memory. Developed Backup and --Recovery strategies using both RMAN and operating system scripts for Oracle databases supported. Recovered and refreshed databases made up of one terabyte of business data using RMAN.
- Utilized the automatic work load repository and automatic database diagnostic monitor. Configured and maintained data loads in huge Data warehousing systems using the Information Power Center ETL tool. - Supported data warehousing and databases. Performed troubleshooting and fixed Oracle internal database errors with support from Oracle support. Did security update and patch/bug fixes as recommended by Oracle Support.
Financial analyst 01/2005 to 01/2007 BTCI Senegal, Dakar
-Involved in sales activities aimed at retention and growth of a 20 million deposit base branch through aggressive sales Activities cross selling and referrals
-Originated personal, home equity and car loans and lines of credit Opportunities
•Responsible for training, mentoring of financial center personnel on various sales and referral techniques
•Participated in overall branch activities and duties to ensure quality customer experience.
Education and Training
American Military University (US) American Public University MD, US
MBA: Finance, and information technology 2015
School of Management Sup de Co Dakar Business and Commerce
Master of Science: Business and Commerce June 2009
Certificate: logistic 2012
Army Logistic University Fort Lee, VA, US
Certificate in Automated Logistic Specialist 92A
Skills
Account management, SAP FICO, IT Audit, logistic armed forces, ASM, auditing database, redhat Linux Sybase database, SCAN, TAF, database administration, and oracle 12c. Risk management, financial analysis, compliance, and audit risk technology, firm wide stress testing and financial management. Administration, Database, Sybase Database Management, Cassandra database management, Finance, hardware support, information technology, Linux, managing access, MOS, Windows OS, Network Management, network, Oracle Enterprise Manager, Oracle, Oracle database, processes, Quality Assurance, Relationship Management, scheduling, servers, scripting, SQL Loader, Strategic Planning, Sun, System Administration, Tables, Technical Support, troubleshoot, Troubleshooting, upgrade