Data Manager
Resume:
FON ADE NEGO ASA’A
301-***-**** Gaithersburg, MD 20882 *******@*******.***
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
• Oracle Analytics Cloud (OAC), Oracle Data
Integrator (ODI)
• 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. Oracle(Autonomous OAC/RDC) Setup Users, OCI Object Storage/DB Cloud Service/OBIA Financials Implementation, OBIEE custom rpd, dashboard and report development, ODI Data Integration Custom design and development. ODI 11/12g migration to OAC, Topology, Operator, Design, OBIA knowledge modules, Peoplesoft HCM and Financials source data, Financials, Supply Chain, Procure to Pay, Project and Human Resource Analytical Packages.
51. Reorganized databases and sized database objects to meet standards and improve performance by 30% 52. Compiled periodically DB invalid objects and creating DB links 53. Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch 54. Configured the Oracle Data Integrator ODI software tool in a three-tier Environment and performed periodic upgrades, performed source-to-target mappings, storage capacity planning, developing ETL 55. Worked on ODI 11g and ODI 12c studios.
56. Using Data Warehousing DWH tools like OBIEE, ODI and Jdeveloper. 57. 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 58. 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours
59. 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, SQL server, MSSQL, PostgreSQL Database
Tools
Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Quest Toad & Spotlight on Oracle, OAC, ODI, OCI, ADW, 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)
• Oracle Database Training
Contact this candidate