Summary
Overview
Work History
Education
Skills
Certification
Clearance
Timeline
Generic

LANSANA JABBIE

Bowie

Summary

Over 10 years IT experience with troubleshooting skills, administration, installing, upgrade, and patching Oracle software. Additional skills include Oracle Grid Control, ASM, RMAN, RAC, Data guard, Enterprise User Security, Partitioning, and Data PUMP. 6+ years of experience with VMware, Red Hat Linux/Unix and Solaris 11. I have extensive experience with database cloning and data migration; Experience with Oracle 11g, 12c PL/SQL, MySQL, SQL Developer, and Oracle super cluster. Knowledgeable with working in a production, testing, and application developing environment.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Oracle DBA

QSMI
02.2021 - Current
  • Managing several Oracle databases on windows platform and Linux platform.
  • Oracle databases consist of Container/pluggable (CDB), Real applications Cluster (RAC), (ASM), and standalone databases.
  • Migrated Oracle database 19c standard edition to 21c enterprise edition, enhancing system capabilities.
  • Implemented (TDE) transparent data encryption.
  • Doing deployment of front end and backend, building using Eclipse and Jenkins to build and deployed.
  • Updating both application server and database STIGS.
  • Oversaw application user accounts to maintain security and functionality.
  • Managed quarterly patch application on production, test, and development databases.
  • Configuring auditing, granting privileges, and restricting access, creating users, profiles, roles and monitoring quota on tablespaces in line with resource planning guide.
  • Managing, multiple databases and instances using Data Guard, RAC in a real time production, testing, and development environment.
  • Monitored performance, cloned databases, and tuned for optimal performance using Enterprise Manager DB console.
  • Using Oracle Grid control on UNIX to maintain a multi-terabyte database with a group of DBAs in a production environment involving technical proficiency.
  • Establishing capacity planning and resource allocation.
  • Creating and monitoring standby databases to ensure high availability.
  • Installing and patching of DBMS software, upgrades and related products in both production and development for test on various platforms.
  • Using Datapump export/import utility for migration, Remapping, SQL.
  • Loading, importing and exporting of database/schema/Tablespaces.
  • Generating reports and preparing memorandums to communicate progress and provide early alerts for major updates.
  • Using a hot and cold backup and recovery using RMAN.
  • Using Enterprise Manager to schedule backups.
  • Configuring and managing database backups (full and incremental), restoring, cataloguing, and migrations on primary servers and across /servers within a project.
  • Performing SQL tuning and object management.
  • Performing advanced troubleshooting using trace files, alert log, and external links (Metalink/OTN).
  • Maintaining 11g database security using encryption and Fine Grain Access Control.
  • Coordinating training for newly hired DBAs.
  • Used RMAN to backup database and worked daily on incremental backup and weekly on full database backup.
  • Used OEM to schedule backup.
  • Developed, tested, and maintained disaster recovery strategy to ensure data availability and integrity.
  • Cloned and created new databases using EM DB console or DBCA utility.
  • Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges.
  • Configured and monitored the TNS Listener using NetCA, COST parameter.
  • Used Datapump to implement database refresh with the hot backup using DUPLICATE or full export.
  • Designed, implemented, and maintained Oracle 11g and 12c logical and physical databases on UNIX and NT.
  • Patched and installed of Oracle software.
  • Performed tuning using the AWR, ADDM 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.
  • Pentagon. Clearance: Top secret/SCI (DOD) US Army.

Oracle DBA

Liedos
01.2018 - 12.2020
  • Configuring auditing, granting privileges and restricting access, creating users, profiles, roles and monitoring quota on tablespaces in line with resource planning guide.
  • Managing multiple databases and instances using DataGuard, RAC in a real time production, testing, and development environment.
  • Utilized Enterprise Manager DB console to monitor performance, clone databases, and optimize database tuning for enhanced system reliability.
  • Using Oracle Grid control on UNIX to maintain a Multi-terabyte database with a group of DBAs in a production environment involving technical proficiency.
  • Facilitated resource allocation to optimize database performance and efficiency.
  • Created and monitored standby databases, ensuring high availability for critical applications.
  • Installing and patching of DBMS software, upgrades and related products in both production and development for test on various platforms.
  • Using Datapump export/import utility for migration, Remapping, SQL.
  • Loading, importing and exporting of database/schema/Tablespaces.
  • Generated reports and prepared memorandums to communicate project progress and provide early alerts for significant updates.
  • Using Enterprise Manager to schedule backups.
  • Configuring and managing database backups (full and incremental), restoring, cataloguing, and migrations on primary servers and across /servers within a project.
  • Performing SQL tuning and object management.
  • Using Oracle SQL Developer, and SSH Putty, PL/SQL, Command-line tools to accomplish projects.
  • Performing advanced troubleshooting using trace files, alert log, and external links (Metalink/OTN).
  • Maintaining 11g database security using encryption and Fine Grain Access Control.
  • Coordinating training for newly hired DBAs.
  • Used OEM to schedule backup.
  • Implemented, tested, and maintained disaster recovery strategy.
  • Cloned and created new databases using EM DB console or DBCA utility.
  • Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges.
  • Configured and monitored the TNS Listener using NetCA, COST parameter.
  • Used Datapump to implement database refresh with the hot backup using DUPLICATE or full export.
  • Designed, implemented, and maintained Oracle 11g and 12c logical and physical databases on UNIX and NT.
  • Patched and installed of Oracle software.
  • Performed tuning using the AWR, ADDM 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.
  • Office Of Navy Intelligent Clearance: Top/SCI (EOD) Home Land Security.

Oracle DBA

CSRA
Arlington
01.2016 - 03.2018
  • Configuring auditing, granting privileges and restricting access, creating users, profiles, roles and monitoring quota on tablespaces in line with resource planning guide.
  • Oversaw multiple databases and instances with DataGuard and RAC across production, testing, and development environments.
  • Monitored performance, cloned databases, and tuned systems using Enterprise Manager DB console to ensure optimal database performance.
  • Maintained multi-terabyte database using Oracle Grid control on UNIX, collaborating with a team of DBAs in a production environment.
  • Creating and monitoring standby databases to ensure high availability.
  • Installing and patching of DBMS software, upgrades and related products in both production and development for test on various platforms.
  • Using Datapump export/import utility for migration, Remapping, SQL.
  • Loading, importing and exporting of database/schema/Tablespaces.
  • Using a hot and cold backup and recovery using RMAN.
  • Using Enterprise Manager to schedule backups.
  • Configuring and managing database backups (full and incremental), restoring, cataloguing, and migrations on primary servers and across /servers within a project.
  • Performing SQL tuning and object management.
  • Using Oracle SQL Developer, and SSH Putty, PL/SQL, Command-line tools to accomplish projects.
  • Performing advanced troubleshooting using trace files, alert log, and external links (Metalink/OTN).
  • Maintaining 11g database security using encryption and Fine Grain Access Control.
  • Arlington, VA.

Oracle DBA

IMTS
Arlington
05.2013 - 12.2017
  • Led the design, implementation, and maintenance of Oracle 11g and 12c logical and physical databases on UNIX and NT.
  • Executed RMAN for daily incremental and weekly full database backups to ensure data integrity and availability.
  • Implemented, tested, and maintained disaster recovery strategy.
  • Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges.
  • Performed tuning using the AWR, ADDM to guide tuning and maintain high database availability and reliability.
  • Used Datapump to implement database refresh with the hot backup using DUPLICATE or full export.
  • Cloned and created new databases using EM DB console or DBCA utility.
  • Used OEM to schedule backup.
  • Consulted with projects and application developers on database architectural design, conversion, testing, and administration to enhance project outcomes.
  • Specified work location in Arlington, VA.

Oracle Database Administrator (Junior)

ITT Excell
02.2011 - 03.2013
  • Configured software and hardware requirements for the Oracle Database in partnership with the system administrator.
  • Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through the phases of System Development Life Cycle.
  • Worked with application developers to address and clarify data requirements to resolve technical and functional issues by enforcing corporate business rules through adequate user/resource/object management.
  • Resolved functional and technical issues through client interaction, conducting research to identify problems and testing solutions to confirm effectiveness.
  • Installed, created and configured Oracle 10g and 11g Oracle Databases (Windows and UNIX) platforms using Oracle Database Configuration Assistant or manually by using Oracle Database Dictionary, table spaces.
  • Established capacity planning of table spaces, tables, indexes, and databases to allow for growth potential.
  • Established, designed, tested and implemented backup and recovery solutions including automated daily hot/cold backups depending on criticality of the Database - (RMAN, EXP/IMP PUMP and shell scripts) and database migration.
  • Provide frontline support for Oracle 8i, 9i and 10g production and development OLTP databases running on Windows NT/2000, Sun Solaris and others.
  • Monitored, tuned performance, reorganized indexes and tables, gathered statistics using STATSPACK, and maintained security through fine-grained access control, while executing database upgrades, migrations, exports, imports, cloning, and backup and recovery using RMAN.
  • Highly available (OLTP) e-commerce and web logics database solution supporting over 1000 concurrent users in a VERITAS Cluster on Sun environment.
  • Maintain a near real-time disaster recovery and failover solution, based on Shareplex Uni-directional replication and replication using Oracle Standby with Data guard.
  • Documented procedures for restore, recovery, and failback to ensure operational continuity.
  • Goals achieved ranged from I/O minimization, improved hit ratios, contention reduction, high database availability etc.
  • Reorganized databases: defragmentation, Index rebuild, resolution of chained and migrated rows.
  • Used Tablespace Manager, Oracle Expert and STATSPACK to monitor performance bottlenecks, database response time, instance workload and operating system resource usage.
  • Migrated an OLTP complex-web database from Oracle 10g to Oracle 11g using the data pump Utility, allowing for database re-organization and defragmentation.
  • Implemented a 600 GB DSS environment running Oracle 8.1.6 on HP-UX 11.00 in a Sun VERITAS Cluster environment.
  • Designed and implemented a two-tier production Oracle 11i Financials database on HPUX 11.00 and a single-tier development instance for over 1100 users.
  • Analyzed data growth trends for capacity and resource planning.
  • Designed, tested, implemented and documented database migration procedures involving the use of the export/import and migration utilities.

Education

High School Diploma -

Ahmadiyya Secondary School
Sierra Leone
09-1994

Skills

  • Oracle Database 9i
  • Oracle Database 10g
  • Oracle Database 11g
  • Oracle Database 12c
  • Linux
  • UNIX
  • Netscape Navigator
  • Cute FTP
  • TOAD
  • OEM
  • TCP/IP transport stack
  • Backup and Recovery Packages
  • Microsoft Project
  • SQL
  • Repository Administration Utility
  • Net Configuration
  • UNIX System
  • Sun Solaris
  • Linux scripting
  • Korn
  • Bash
  • Red Hat
  • PL/SQL
  • Cross Platform Migration
  • J2EE
  • Data Guard
  • Oracle Critical Patch Update

Certification

  • Oracle Certified Associate (OCA)
  • Oracle Database 11g: SQL Fundamental I
  • CompTIA Security+ Certification

Clearance

Top secret/SCI with C1 polygraph. DHS (EOD) And DOD

Timeline

Oracle DBA

QSMI
02.2021 - Current

Oracle DBA

Liedos
01.2018 - 12.2020

Oracle DBA

CSRA
01.2016 - 03.2018

Oracle DBA

IMTS
05.2013 - 12.2017

Oracle Database Administrator (Junior)

ITT Excell
02.2011 - 03.2013

High School Diploma -

Ahmadiyya Secondary School
LANSANA JABBIE