Joseph Yufenyuy Jr

Upper Marlboro, MD *****

301-***-**** - adjel8@r.postjobfree.com

Professional Summary

Talented Database Administrator with 8+ years of diverse experience in database administration and design, data modeling, data warehousing, Enterprise Systems Architecture and Business Intelligence (BI). Extensive technical skills and advanced understanding of Oracle, SQL Server, MongoDB and Azure administration. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.

Skills

Expert in Oracle Golden Gate configuration and maintenance for unidirectional, bidirectional and peer to peer configurations on heterogenous platforms.

Expert in performance tuning at the database level, OS level, network, application and instance with help of tools like OEM, TOAD, TKPFROF, STATSPACK, TRACE, AWR, ADDM etc.

Expert in Migrating single instance databases to multimode and RAC environments and vice versa, using data pump, RMAN. Sql loader and transportable tablespaces.

Expert in using Flash-Back Recovery, Recovery of critical and non-critical and data files, point in time recovery.

Expert in Project support across the SDLC involving refreshes, code debugging and code deployments

.

Great at Data guard configuration, planning and implementation of off-site Disaster Recovery

Expert in configuring and maintaining Oracle RAC and ASM.

Proficient in the use of various Operating systems; Linux, Solaris, HPUX, AIX 5

Proficient in Data Security, TDE implementation.

Great at capacity planning

Expert in UNIX Shell Scripting for database monitoring and backup configuration.

Database Upgrades and Patches.

Needs Assessment

Proficient in Database Design,

Proficient in Trapeze software

Proficient at debugging and writing PL SQL.

Proficiency in database Design

Work History

09/2018 to Current

Oracle Database Administrator

MSRB

Work in an environment comprising about 160 databases and five applications.

Agile environment involving a lot of development and testing.

Provide expert Support across the SDLC through constant refreshes of the lower environments, code deployments and code debugging.

On call once week, every month for production and devOPs support after hours.

Apply PSU patches quarterly.

Support Linux patching quarterly.

Configure golden gate on newly created environments and perform maintenance on others.

Re-baseline golden gate on already existing golden gate environments after refreshes.

SQL tuning with developers to ensure queries are not resource intensive.

Performance tuning at the level of the application, network, OS, and database.

Running of capacity planning reports monthly given limited resources but need for optimal performance.

Adding ASM disks to ASM disk groups as necessary and data files to tablespaces as need be.

Troubleshooting golden gate and CRS errors.

Fix various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM), Active Session History (ASH), explain plan, STATSPACK, SQL TRACE, and TKPROF utilities.

Adding subscribers to our databases and granting them the necessary privileges.

Migrated databases from on premises servers to AWS cloud servers

Work as Cloud Administrator on Microsoft Azure. Configured virtual machines, storage accounts, resource groups etc.

troubleshoot, monitor and deploy applications on Azure.

Use Azure Site recovery for backup, VM Migration and Disaster recovery on Azure Cloud.

Migrated multiple applications from on premise to cloud using AWS services like SMS, DBMS, CloudFormation, S3, Route53, Glacier, EC2, RDS, SQS, SNS, Lambda, Kinesis and VPC.

Built AWS and Azure infrastructure using automation tools like Terraform.

Designed and built Azure network topology for extending on-premises network connectivity and isolating workloads using VPN Gateways, VNet peering’s, user defined routes via Route Tables, and Azure Firewall.

01/2016 to 08/2018

Oracle Database Administrator

Verisk – NJ

•Worked in an environment comprising 250 databases with the largest databases each of size 100 TB.

•Installed, configured, and maintained Oracle 12c on Linux and also Upgraded from Oracle 11g to 12c multitenant architecture.

•Configured Golden Gate for High Availability using Oracle DBFS and Active Data Guard.

•Table refreshes and schema refreshes using Data pump, expdp and impdp.

•Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

•Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.

•Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.

•Also set matrices for db monitoring.

•Rebuilt a 2-node RAC databases due to a SAN crash and recovered the 4-node production database after the SAN recovered with latest RMAN backups.

•Applied critical patches to Oracle databases and application servers.

•Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

•Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.

•Assisted in the administration of Oracle database applications on Exadata platforms.

•Participated in analyzing and designing of Oracle Exadata Server for infrastructure and related projects.

•Conducted analysis and feasibility studies for development of Oracle Exadata solutions

•Patched and upgraded database Exadata

•Created database Objects, Tablespaces, Schemas as needed.

•Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.

05/2012 to 12/2015

Oracle Database Administrator

Pragmatics, Inc – McLean, VA

Worked in an environment comprising 200 databases with the largest databases each of size 50 TB.

Implemented Disaster Recovery (DR) Plan using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.

Implemented 11g Database compression feature for Development and test Instances to reduce the size of databases which help the client to save huge disk space.

Performed DR switchover and failover operations.

Syncing of DR databases with the Primary Database for any archival gaps.

Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM), Active Session History (ASH), explain plan, STATSPACK, SQL TRACE, and TKPROF utilities.

Configured and maintained a peer to peer Golden Gate architecture for high availability purposes.

Responsible for network configuration and involved in a Client -Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc.

Assisted MTA client with TRAPEZE software development, automation and implementation

Configured listener for external procedure calls.

Enforced corporate business rules through adequate user/resource/object management.

Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.

Education

Master’s degree: Data Analytics

University of Maryland – Global campus, MD

Bachelor's degree: Financial Economics & Information systems

University of Maryland - Baltimore, MD.

Oracle Certified Associate (OCA)

AWS Certified Solutions Architect - Professional

Contact this candidate