Page * of *

FON ADE NEGO ASA’A

+447********* * PEMBURY ROAD, WESTCLIFF-ON-SEA, ESSEX, Postcode: SS0 8DS adham8@r.postjobfree.com

PROFESSIONAL SUMMARY

Database Administrator (Cloud DBA) with over 5 years’ extensive knowledge and proficiency, on premises and in the cloud (AWS & OCI) in database design, Management, monitoring & proactive tuning, security implementation and risk analysis, as well as backups and recovery in Windows, Unix, and SQL Server environments. Extensive experience on Oracle Database Administration on 24x7 critical production and large databases. Possess good work ethics, dynamic and detail oriented. Excellent communication and troubleshooting skills as well as a cohesive team member. Flexibility to adapt to and excited in learning new concepts and technologies. KEY SKILLS

• Autonomous Database Specialist - ATP & ADW

• Oracle 10g, 11g, 12c, 18c & 19c Database Admin

• Knowledge and experience on Amazon Web

Services(AWS) Technologies like: EC2, S3, RDS,

Route 53, ELB, CloudWatch, AMI (Amazon

Machine Images), IAM, VPC, Subnets.

• Oracle Database SQL statement tuning with

EXPLAIN PLAN, TKPROF, STATSPACK, SQL

TRACE; SQL tuning Advisors

• Backup & Recovery using RMAN & Datapump

• Installation and implementation of OEM and

Oracle Grid Control for Monitoring

• Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)

• Implement and optimize queries and stored

procedures

• RAC installation/administration for High availability and Optimal Performance

• Performance monitoring & Tuning: OEM 13c,

SQL Developer, Toad, Spotlight, TFA, Splunk

• Implementation of Flashback Technology, Log

Miner, Automatic Database Diagnostic Manager

(ADDM)

• Handling Security Technical Implementation

Guidelines (STIG) & Compliance Standards

Violations; user management

• Database security (Auditing, data access,

profiles) as per STIG Rules

• Data encryption; Data Redaction (Masking), TDE

• Patching - Patch set, Critical Patch Updates

(CPU), Patch Set Updates (PSU) Security

patches (SPU) using “Opatch” & OUI.

• Database & System Admnistration

• Migration & Upgrade from Premises into Clouds

• Cloud Migration: premises to AWS & OCI with

Datapump, GoldenGate, DBMS_CLOUD, SQL

Developer, MAA, Data Pump, SQL*Loader,

MV2ADB; AWS DMS & Schema Conversion Tool

• Software life cycle (SDLC) including requirement gathering, technical design, development, system

integration phase, quality assurance phase

• Database Cloning and Refreshing pre-prod/Dev

databases with Prod/pre-prod databases

• Data Replication: Oracle Golden Gate, Oracle

Streams, Dataguard, DG4MSQL (Database

Gateway for MS SQL Server), DG4ODBC (Oracle

Database Gateway for ODBC)

• Hypervisor & Virtualization: Oracle Virtual Box & VMWare

• Capacity Planning & Monitoring

• Extensive knowledge and experience on Data

Warehouse using ETL tools like Informatica.

• Languages: SQL, PL/SQL, Unix Shell scripting

• Automation using Crontab, AT scheduler

• SQL server Management studios (2008,2012)

AWS Services, focusing on RDS, Aurora, Redshift

& DynamoDB

• Root cause analysis of production-related database issues

• Experience working in an Agile/Scrum

environment

• Data Modeling - ERD - Reverse/Forward

Engineering logical data elements into physical

database design.

• Ability to work across cultures and timezone

Page 2 of 4

PROFESSIONAL EXPERIENCE

Bereans Information Technology, College Park, MD, USA. 05/2015 – 09/2020 Senior Oracle-AWS Cloud Database Administrator

Bereans Information Technology (BereansIT) is a technology services company that provides businesses and governments with business solutions that focus on growth, productivity and change. BereansIT’s hybrid portfolio of services includes DB administration services in-house, and remote or cloud Data Centers, applications and business process outsourcing, System Implementations, consulting and staffing. Responsibilities include, but are not limited to 1. Installation & configuration of Oracle 10g, 11g, 12c, 18c & 19c on Windows & UNIX/Linux platforms following OFA

2. Create physical and logical database designs (ERD) based on system requirements 3. Proactively monitored and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success of production db and application. 4. Splunk installation & configuration to analyze security and system operations in real time and for correlation of database events with events from other applications in the technology stack often ignored by other commercial monitoring tools, and hence resolving the multi-layer data flow issue with a single view

5. Proactive Monitoring & Tuning with Splunk as it ingest logs such as backup logs, Sensitive data access, Audit trail logs, database object changes, DB performance, alert log, trace files, listener logs, Storage, application logs, OS logs, Network Logs

6. Oracle Change Management Pack, integrated in OEM’s Database Lifecycle Management Pack, used to track and make changes to database object definitions. Aids in consolidation, enforce standardization and deploy automation.

7. Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities ESTAT/BSTAT, STATPACK, End-user tuning and troubleshooting using various tools like EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, v$ Dynamic performance views 8. Heterogeneous ecosystems on premises and clouds - AWS, Azure & OCI 9. Extensive knowledge and experience on Amazon Web Services(AWS) Technologies like: EC2, S3, RDS, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), IAM, VPC, Subnets 10. Provide installation, configuration, maintenance and troubleshooting support for database application software both on premises and in the Cloud.

11. AWS RDS configuration and management: Oracle, SQL Server, PostgreSQL 12. Database Migration across multiple platforms of Oracle 10g to 11g and11g to 12c, using the Oracle Datapump and the old Exp/Imp utilities including Oracle Middle Tier technologies such as Oracle SOA suite, Oracle Weblogic, Oracle BI Publisher, EDQ, ODI and Oracle Identity Management (OID, SSO, and Oracle Access Manager).

13. GoldenGate implementations for data replication, DR, ETL, Zero downtime upgrades & migrations, data distribution, query offloading;

14. Materialized Views & Oracle Streams.

15. Data Modeling to translate logical data elements into the physical database design. 16. Backup/recovery strategist: (RMAN), Import/Export & Datapump, Capacity Planning, Replication

(Streams) standby databases, Oracle configuration management, Dataguard, database cloning, refresh and patch management and Oracle Exadata Database Machine. Page 3 of 4

17. Identify system enhancement and automation opportunities for installing/maintaining database technologies, building, deploying and monitoring applications as well as alerting and remediating system outages.

18. Work in a cross functional team that oversaw the Oracle RAC & Data Guard installations and configurations for Linux environments.

19. Supported daily administration, proactive monitoring and tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 2019 (Database sizes range 10GB to 2.3TB) 20. SQL Tuning to optimize database using TKPROF, SQL Trace, and performance advisors, SQL Tuning Advisor (SQL Access, etc), Memory Advisors)

21. Build complex entity relationship models (ERD) - both logical and physical database design. 22. Capacity planning and monitoring to meet the demands of the dynamic aspects of storage and memory for the databases

23. Database documentation during project planning, project execution and project maintenance phases 24. System Documentation - typically a required deliverable after a client’s database design and implementation with documentation generators or tools such as SQL Developer, Dataedo. 25. End-User Documentation – to help users in creating understanding the database for ease of queries and report writing

26. Design Reviews Documentation including ERDs and diagrams to facilitate understanding of design review to non-database personnel.

27. Data masking to minimize risk of data breach or leak. Masking sensitive data in non-production databases 28. Database security policy creation and implementation, using passwords, privileges in user profiles, basic data encryption, network security

29. Redaction (Masking) policies implementation: transformation of data using partial, random, and full redaction to limit/restrict exposing sensitive data to unauthorized applications/users 30. Auditing - tracking who did what and when in the database 31. Enforce Change Management processes in each environment 32. When needed, provide support to data center personnel who are responsible for backups, recovery, patching, upgrades, and restarts of Oracle software running on ExaData and ExaLogic platforms 33. Implemented a backup strategy following company SLA; Implementation of backup schedule for both logical and physical backups using RMAN and DATAPUMP utilities respectively 34. Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

35. Configured and managed the DataGuard broker and Observer 36. Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN 37. Conduct backup integrity and disaster recovery exercises or drills 38. Installed, Administered and Maintained SQL Server Instances. (Installing SQL Server 2008) 39. Performed database Refreshes from production environments 40. Installed and configured the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication

41. Tuned PL/SQL scripts for triggers, batch files, scheduling on Windows AT Scheduler and Crontab in Unix/Linux

42. Participated in change management board meetings for new releases, change implementations, removal, retirement and/or decommissioned of old services 43. Performed instance tuning by changing init.ora parameters and managed region parameters such as shared_pool_size and db_cache_size

44. Monitored (ADDM, Alert log, dynamic performance views, DBMS_STATS) and Tuning including capacity planning, report creation / distribution

Page 4 of 4

45. Applied Oracle's quarterly Critical Patch Update(CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances 46. Upgraded Oracle binaries and databases from 11g to 12c to 18c to 19c 47. Worked on multiple Oracle database projects in a fast paced and dynamic environment 48. Cloned databases using RMAN and DATAPUMP utilities for all database sizes 49. Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture

50. Conferred with internal department managers regarding problems with and the capabilities of various internally-used databases

51. Experience migrating database objects from development through test and into production environments

52. Inspected Alert logs Files, Trace Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports

53. Reorganized databases and sized database objects to meet standards and improve performance by 30% 54. Compiled periodically DB invalid objects and creating DB links 55. Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch 56. Worked on 12c Grid Control to setup central alerting system for monitor targets to be proactive to ensure high availability while getting the best performance 57. 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours

58. Lead DBA team occasionally on specific projects such database upgrades, database/schema migration and database patching

TECHNICAL SKILLS

Databases

Oracle 10g, 11g, 12c, 18, 19c

Database

Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Quest Toad & Spotlight on Oracle, OEM Grid, RMAN, Exp/Imp/Data Pump, Log miner, Statspack/AWR, OUI, DBUA, ADDM, Oracle Migration Workbench, Remedy Operating

Systems

Redhat & Oracle Linux 6.2,7, MS Windows servers (2008/ 2019), Centos 5.3, AIX 5.3 EDUCATION & TRAINING

• UNIVERSITY OF PORTSMOUTH - MSc PETROLEUM & GAS ENGINEERING (2019)

• CATHOLIC UNIVERSITY OF CAMEROON – B.Eng PETROLEUM ENGINEERING (2018)

• Oracle Database Training

Contact this candidate