Resume

Sign in

Oracle Developer Dba

Location:
Bowie, MD
Salary:
120K
Posted:
January 26, 2022

Contact this candidate

Resume:

DAX MOKONYA

Phone: +1-301-***-**** Email: adp094@r.postjobfree.com

Clearance: MBI

SYNOPSYS

As a certified (AWS) Amazon Web Service Solutions Architect - Associate and an Oracle Database Administrator with over 15 years of experience in Information Technology, Mr. Mokonya has assumed the roles of a Senior Oracle Database administration, AWS Solutions Architect and served as the SME (Subject Matter Expert) within various fast-pace large organizations. Within these roles he has consistently demonstrated effective technical and leadership skills and delivered high quality results.

KEY TECHNICAL SKILLS

AWS (Amazon Web Services)

Demonstrated ability to build and manage servers and services in AWS using DevOps practices.

Participates in on-call rotation for nights, weekends and holiday coverage.

Implements Security and patch management for platforms and technologies.

Works with architects, developers, and product teams to create stable new architectures and solutions to meet evolving business goals.

Developed and maintain comprehensive documentation for multiple application environments.

Provides solutions to identified systems issues.

Extensive hands-on experience in the design, development, and implementation in AWS cloud environment (VPC, IAM, AMI, S3, EC2, ELB, RDS, SQS, SNS, Route53 etc.) using emerging cloud technologies.

Well versed in infrastructure, network, security, and firewalls.

Knowledge experience with monitoring tools such as CloudWatch, Dynatrace, DevOps tools and continuous pipeline.

Comfortable working with Route 53 (DNS), Cognito Authentication, Amplify console, API Gateway, Microservices, Dynamo DB Experience architecting, deploying, and managing RDS, EC2, Lambda, S3, RedShift instances.

Strong understanding of TCP/IP networking as well as Cloud Load Balancers, AWS Auto Scaling, Security Groups, VPC’s, VPN Gateways, Elastic IP’s, Subnets, Route Tables, and NAT configuration.

Experience with Migration, Backup & Disaster recovery. Experience deploying dedicated infrastructure vs shared as well as identifying best instance type based on project requirements. Experience in Cloud Formation stacks

Hands-on experience designing and implementing container solutions on AWS ECS.

Postgre SQL

Installed PostgreSQL version 10,11,12 on Linux such as Fedora and CentoS.

Created PostgreSQL database, created user, granted roles and privileges.

Continuously carried out Maintenance on a daily basis which include activities like reclaiming space management via standard / auto vacuuming, updating planner statistics, Possible reindexing, log file management, taking backups and testing backups.

Backups are done via export dumps, file system image copy or continuous archiving of WAL logs.

Familiar using the following tools to manage and monitor PostgreSQL activities:

pgAdmin for database monitoring.

Barman for backups and recovery

pgBackrest for backup and recovery.

EDB Bart for backup and restore

Repmgr for replication.

Pg Bouncer for connection pooling.

Pacemaker to monitor the system for failover.

PgBench to monitor activities and perform bench marks

Psql for accessing the database.

Oracle Core DBA

15+ yrs. of Oracle Core DBA implementation on various O/S platforms, Oracle RAC and Streams.

Installation and maintenance of Oracle RAC on Linux and Sun Solaris

Have sound knowledge in Both Physical and logical Database Design for Data warehouse OLTP and OLAP applications. Extensive Knowledge on Oracle DBA.

Installation of Oracle and configuration of Oracle RDBMS Server on Windows Server, Sun Solaris,

Experienced and skilled DBA in areas of performance Tuning using Oracle Tools like ADDM, AWR SQL Trace, Explain plan, DBMS_STATS, UTL_STAT, and Oracle Grid Control and management.

Supported Development / Test / Production Databases and Red Hat Linux and Linux Enterprise Server and RDBMS server upgrades, Data warehousing data loads using SQL*Loader and Data Pump, performance tuning in a Data warehousing database

Oracle Applications DBA

Oracle 8i, 9i,10g 11g with over 15 years in the IT industry experience as Oracle Database Administrator and Oracle Applications DBA.

15+ yrs. of Oracle Applications (ERP) DBA Implementations with Oracle Financials, Manufacturing, and Siebel.

Oracle Database Development

Skilled Oracle Programmer using PL\SQL, SQL, SQL*PLUS and a Developer Using Oracle DEVELOPER\2000 and its tools (Forms 4.5, Reports 2.5, and Graphs 2.5).

Versatile in Unix Shell scripting to handle database backups using RMAN, RDBMS installations in SILENT modes, etc.

Extensive experience in system analysis, programming, development, Database maintenance, Database tuning, Sql & Pl/Sql tuning, data warehousing, business solutions and user training.

Has been responsible for round-the-clock of Very-Large-Database (VLDB) in production environment.

Proven ability to plan, prioritize and complete multiple tasks within strict time, and flexible and adept anticipating and managing shifting priorities and being able to follow all applicable project standards and methodologies.

Operating systems: UNIX (Sun Solaris), Linux & HP, Veritas NetBackup Manager, Windows NT.

Languages: SQL, PL/SQL, Sql and Performance Tuning, Korn shell, c shell, Unix Shell Scripting

GUI Tools & Utilities: DBCA, DBUA, Data PUMP. Oracle Utilities, Erwin, Webdb, OEM Grid Control

WORK EXPERIENCE

SBC TELECOMMINICATION - ROCKVILLE MD July 2015 to Feb 2021

As a member of the team, helps support core production and development services in a mission critical environment in AWS (Amazon Web Services). Communicates and works in a team oriented, collaborative environment.

As a member of the Oracle database administration team supporting worldwide managed database hosting services SBC Telecom.

Implemented within IT department Oracle database centered application (SLC) rollouts, maintenance, performance tuning and decommissions. I Implemented database disaster recovery plan using RMAN, standby databases, data guard.

The management of Oracle databases 9i, 10g and 11g on Linux Red Hat 4.5 production and development environments.

Installation and configuration of Oracle 10g and 11g databases on both the development, Testing and production environments.

Participates in on-call rotation for nights, weekends and holiday coverage support both AWS RDS and on-premise oracle databases.

Repaired and recovered AWS hardware and software failures with AWS support and coordinates and communicates with related organizations or parties.

Comfortable working with Route 53 (DNS), Cognito Authentication, Amplify console, API Gateway, Micro services, Dynamo DB Experience architecting, deploying, and managing RDS, EC2, Lambda, S3, RedShift instances

Strong understanding of TCP/IP networking as well as Cloud Load Balancers, AWS Auto Scaling, Security Groups, VPC’s, VPN Gateways, Elastic IP’s, Subnets, Route Tables, and NAT configuration

Experience with Migration, Backup & Disaster recovery. Experience deploying dedicated infrastructure vs shared as well as identifying best instance type based on project requirements. Experience in Cloud Formation stacks

As a member of the Oracle database administration team supporting worldwide managed database hosting services SBC Telecom.

Implemented within IT department Oracle database centered application (SLC) rollouts, maintenance, performance tuning and decommissions. I Implemented database disaster recovery plan using RMAN, standby databases, data guard.

The management of Oracle databases 9i, 10g and 11g on Linux Red Hat 4.5 production and development environments.

Installation and configuration of Oracle 10g and 11g databases on both the development, Testing and production environments.

Install Oracle Security Suite to monitor ERP Applications and Database Auditing tools, Enterprise Application firewall for Oracle E-Business Suites for security Assessment and Compliance.

Worked on Oracle Advance Security to attain maximum security for critical data infrastructure- in Prevention, Detection and Administrative efforts

Utilize Transparent Data Encryption features to protect sensitive data at rest and data masking.

Utilize the ERD (Entity Relationship Diagram) to design, create and describe relationship of Entities and Attributes of data relationships

Using the Oracle Erwin tool to design and create logical entities relationship between tables structures and indexes

The monitoring of the overall performance of the databases by identifying and optimizing poorly written SQL queries clogging memory and I/O, resolving deadlocks and resource contention problems, and reconfiguring the database file structures to improve performance utilizing OEM.

Completion of database integration issues including migration/conversion of Oracle v. 9.2.0.4 to 10g,10.2.04 to 11gR2 database.

The maintenance of database backup and recovery infrastructure and the performance of backup tasks utilizing RMAN and Veritas Backup.

Administration of database security and database software in cooperation with IS0 standards.

Spearheaded special projects instructed management with information on space projections for budget purposes, database concepts, and functions affecting applications during database tuning, table re-orgs, index rebuilds, and report analysis.

Identification and the generation of performance statistics to resolve potential bottlenecks utilizing Oracle STATSPACK and ADDM.

Creation of logical and physical database structures that integrated with existing or proposed database structures.

Completion of Data Uploads utilizing Exports/Imports, Data Pump and SQL Loader Utilities.

Two years’ experience managing large data warehouse, designing star schema, loading fact tables, creating, and managing materialized views.

Configuration of Oracle RAC environment for development and testing and production environment.

Testing and application of Oracle Patches to development, testing and Production databases for software fixes and upgrades.

Setup and configured Oracle Standby database (Data Guard configuration) for production databases.

Supported developers in a project integration Oracle database, Siebel, PeopleSoft, High Jump, Web Methods and Advance billing The management of Oracle databases 9i, 10g and 11g on Linux Red Hat 4.5 production and development environments.

Installation and configuration of Oracle 10g and 11g databases on both the development, Testing and production environments.

Install Oracle Security Suite to monitor ERP Applications and Database Auditing tools, Enterprise Application firewall for Oracle E-Business Suites for security Assessment and Compliance.

Worked on Oracle Advance Security to attain maximum security for critical data infrastructure- in Prevention, Detection and Administrative efforts

Utilize Transparent Data Encryption features to protect sensitive data at rest and data masking.

Utilize the ERD (Entity Relationship Diagram) to design, create and describe relationship of Entities and Attributes of data relationships

Using the Oracle Erwin tool to design and create logical entities relationship between tables structures and indexes

engine.

• Installing, configuring and managed WebLogic, Apache, tomcat, and Web methods middle ware.

Deploying certificates on WebLogic and configures secure transactions.

Deploying code on WebLogic, Apache, and tomcat.

CITIBANK – OneMain Financial – May 2012 to June 2014

The maintenance of database backup and recovery infrastructure and the performance of backup tasks utilizing RMAN and Veritas Backup.

- Conducted extensive performance tuning on the system using various tools such as :

Identification and the generation of performance statistics to resolve potential bottlenecks utilizing Oracle ADDM, AWR, STATSPACK, EXPLAIN PLAN, SQLTRACE AND DBMS_GATHER_STATS UTILITIES

Testing and application of Oracle Patches to development, testing and Production databases for software fixes and upgrades.

The maintenance of database backup and recovery infrastructure and the performance of backup tasks utilizing RMAN and Veritas Backup.

Spearheaded special projects instructed management with information on space projections for budget purposes, database concepts, and functions affecting applications during database tuning, table re-orgs, index rebuilds, and report analysis.

Provided feedback in the database change board meetings for database development, design, implementation, and maintenance.

• Supported multiple platform systems in the development environment including physical and logical database tuning, review of indexing and stored procedures for improved performance and Y2K modifications on existing customer care software.

• Involved throughout the SDLC of Data System Management (DSM) project using Java, IBM QSeries, Orbix web3.2, Java webserver2.0, database triggers for referential integrity and logging, and database indexes, table partition, tablespace segmentation for efficient data access.

Ported embedded SQL programs, Unix shell scripts from NCR servers to SUN Solaris servers.

I successfully migrated Oracle 9i to Oracle 10g Development and Test databases.

• Installed, configured and Maintained Oracle 9i Real Application Cluster (RAC) 2 nodes Development architecture for the multi-terabyte database repository.

Federal Trade Commission Mar 2006 – March 2012 (Contract)

Senior Oracle DBA Consultant

Responsibilities:

Served as Technical Lead Oracle DBA.

As a Technical Lead, I manage and provide Database Management Solutions and the design, development, deployment, operations, and maintenance of the FTC Oracle Databases (9i, 10g and 11gR2) Oracle Application Servers and Applications being hosted by Oracle Database which include Documentum, Business Objects, OID, FTC Custom Forms Application, FTC e-PreMerger custom Applications and a host of others on Unix Sun Solaris Platform, mentoring 2 other Senior DBAs

Served as the technical lead in planning, installation and implementation of Oracle RAC 11gR2 on two Sun Solaris nodes using NETAPPS storage as shared storage.

Served as the technical lead in planning, installation and implementation Oracle DR using Oracle Data Guard to replicate to a DR site.

Project and Support the Oracle 9i and 10g Databases on Sun Solaris ver. 8 and 10, and VERITAS Clusters.

Implemented data masking to meet with Bureau security standard.

Lead 3 Oracle DBAs for the migration of all Oracle Databases from Solaris 8 to Solaris 10.

Re-Architect of the Oracle Applications (Forms and Reports) server 10.1.3.

Led the design, document and the Installation, support, and Maintenance of Web Logic Server 9.2.

Documented the cloning procedures and mentored other DBA on best practices for 10gAS support.

Leads the support of different databases infrastructures/architect/design as required for different internal projects.

Lead efforts in database tuning to maximize performance in data warehousing databases.

Led effort in the design of data warehouse database instances for optimal performance, creating STAR schemas, using Oracle Warehouse Builder (OWB) and change Data Capture (CDC) system. Also, the management of Oracle Data Integrator (ODI) agent and Oracle ODI with Middleware Application server built on Oracle Fusion 11g running Oracle Web Logic for the FTC MCDW data warehousing project.

Lead efforts in Performance monitoring, tuning and system configuration recommendations and database security implementation.

Oracle Application Server 10gR3 (10.1.3) installation, deployment, cloning and tuning for FTC web reports.

Backup scripting and support using RMAN and NetBackup integrated with NETAPPS storage system servers.

Re-deployment of the Oracle Application Servers – oracle Internet Directory (OID) with Oracle Application server Infrastructure database. Also Support Documentum 6.5 databases and application servers.

Quarterly Database Patches (CPU and PSU) and database upgrades from 9i to 10gR2.

Maricom Inc. (CMS, Baltimore, MD) at Oct 2004 – Dec 2006 (Contract)

Senior Oracle DBA Consultant and Oracle Systems Center Medicaid Services (CMS)

Responsibilities:

Support the Oracle 8i, 9i and 10g Database on Sun Solaris ver. 9 and 10, and VERITAS Clusters.

Installed Oracle Data Guard for high availability

Subject Matter Expert for database system design and architect for various CSC supported projects.

Configured Oracle RMAN database backups.

Support Project development efforts implemented changes using UNIX shell scripts to move system changes between environments and through production and also support different databases infrastructures as required for different internal projects.

Supported efforts in database tuning to maximize performance for the CMS Development, databases.

Performance monitoring, tuning and system configuration recommendations.

Performed data and system architect for implementation of Oracle Data warehouse on a 2 RAC-Node.

OEM Grid Control installation and administration of oracle RDBMS server databases and environments.

Support databases, DB and Apps performance tuning.

Help developers edit PL/SQL Triggers and Stored Procedures to help manage data in production.

Oracle Application Server 10gR3 (10.1.3) installation, deployment, cloning and tuning for CMS project. Backup scripting and support using RMAN and NetBackup.

Provided lead role on system and data architect effort, in streams implementation for replication and reporting.

Database Patches (CPU and PSU) and database upgrades from 8i, 9i to 10gR2.

Software: RMAN, RDBMS: Oracle 9i, 10g (RMAN, and Data Guard)

EDUCATION

Bachelor of Science, Computer Information Systems, < University of Buea, Cameroon>

References: Available upon Request



Contact this candidate