ALHAJI KROMAH

CONTACT: 515-***-****/EMAIL: adhz99@r.postjobfree.com

DATABASE ADMINISTRATOR

I am an Oracle database Administrator with over 8 years IT and related experience. Extensive Knowledge and proficiency in database design, performance monitoring & Tuning, migration, Upgrades,

Backup &Recovery, cloning, replication, and security implementations. I possess exceptional written, verbal, analytical and organization abilities. I also proficient in 10g, 11g, 12c, 18c and 19c databases.

Proven leader with motivational management style, a solid reputation for building and retaining highly motivated terms and development of solutions.

I am an energetic achiever who can efficiently prioritize tasks and perform well under pressure. I have excellent critical thinking skills and enjoy new challenges.

SKILLS TOOLS

DATABASE SECURITY PATCHING TDE, DB VAULT, ACCESS OEM GRID/CLOUD CONTROL

PERFORMANCE MONITORING AND TUNING SQL DEVELOPER

BACKUP AND RECOVERY (CLONING REFRESH) PUTTY/ MOBAXTERM/TOAD

DISASTER RECOVERY (DATA GUARD) RAC WINSCP/FILEZILLA

, DATABASE AUTOMATION

DATA MIGRATION (ETL, DATA PUMP)

EXPERINCE

FEDEX July 2020-PRESENT

ORACLE DATABASE ADMINISTRATOR

. Performing Online and Offline backups (physical and logical) using RMAN and Data Pump

. Proactive Performance Monitoring Reactive Performance Tuning

. Application of Oracle Patches (PSU, SPU/CPU, Bundle and Interim Patches) using Opatch Utility

. Drastically improved the performance of SQL Queries by about 90% through the use of appropriate Indexes and Optimization methods

. Linux/Bash Shell Scripting

. Documented protocols for Migration of data/databases

. Installed and configured Data Guard and Broker for High Availability(HA), Disaster Recovery(DR) and seamless Switchover/Failover

. Installations and Upgrades of Production and Non-Production Databases

. Encrypting sensitive database tables/columns/tablespaces using TDE

. Revised the Backup/Recovery Strategy Manuals/SLAs to implement Block Change Tracking, Parallelism and other RMAN features, significantly reducing Backup and Recovery durations by over 80%

EXPERIENCE

US BANK AUG 2015-June 2020

ORACLE DATABASE ADMINISTRATOR

•Deployed database security policy and installation, using passwords, privileges and user profiles and managed database security by creating,

•assigning appropriate roles and privileges to uses depending on user activity.

•Used Oracle transparent data Encryption to encrypt columns, tables, and tablespaces, I also implemented the triple A(AAA) and database auditing policies as well data redaction.

•Cloned databases using RMAN and DATAPUMP utilities for all database sizes.

•Extensively used AWR, ADDM, ASH and Explain plan for periodic performance tuning.

•Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMA_STATS, trace files, system event log for unusual events & took appropriate action according to company policies of incident reports.

•Experience migrating database objects from development through test & into production environment.

•Involved in 24/7 support while assigned on call role

•

•Capacity planning (planning of tables, indexes, tablespace, and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

•Installed and administered Oracle physical standby, logical standby, and databases for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

•Successfully installed and configured oracle 11.1.7 Monitored different database and application servers using oracle enterprise manager (OEM) 10g grid control.

•Assist in SQL tuning and provide assistance such as creating materialized views, and data normalization.

•Documentation of user-friendly training materials and conducted system’s implantation and workshops.

TARGET CORPORATION FEB 2013-AUG 2015

ORACLE DATABASE ADMINISTRATOR

•Performed database Administration task, such as migration from 10g to 11g and database upgrade from 11g to 12c using oracle DATAPUMP and DBUA utilities, respectively.

•Installed and configured software for 11g, 12c on both LINUX and UNIX platforms. Also Administered and maintained SQL sever instances

•Database monitoring and maintenance activities which includes, checking alert log, space management, gathering database statistics,

•database locking issues, schedule backup jobs, creating users, schemas, and other database objects.

•Involved in 24/7 support while assigned on call role

•Configured to mainly replicate data and ensure high availability, in a heterogenous environment.

•Configured oracle tools like SQL *Net to access the database across the network

•Configure and manage ASM instance on Oracle 11g and 12c.

•Used range, hash and composite table partitioning which greatly reduced the DB time and SQL execution time. Also performed instance tuning and managed SQL server

•Implement restore & recover policies and place a database/ system backups procedure accordingly.

Education

Bachelor of Science

2007-2011

Contact this candidate