Summary
Overview
Work History
Education
Skills
Certification
Quote
Work Availability
Work Preference
Timeline
Generic

USEN USEN

Duluth,Georgia

Summary

High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Oracle Database Administrator

AT&T
01.2020 - Current
  • Provided 24x7 production support for critical systems, UAT, standby environments, and Oracle GoldenGate replication processes, ensuring high availability and rapid issue resolution.
  • Executed installations, creations, and upgrades for Oracle databases (12C, 19C, 21C), and implemented Oracle GoldenGate for real-time data integration and replication.
  • Managed database structures and implemented GoldenGate for data distribution, leveraging OEM and command-line interfaces for optimal organization and space utilization.
  • Monitored and optimized database and GoldenGate performance, focusing on space, wait events, locks, and replication lag, significantly reducing operation times and improving efficiency.
  • Conducted disaster recovery operations, including DR rebuilds, periodic RMAN backups, and GoldenGate recovery checkpoints, ensuring data integrity and consistent protection.
  • Orchestrated robust backup strategies and managed GoldenGate configurations for archiving and data transfers, aligning with retention policies and achieving storage cost savings.
  • Configured RAC and GoldenGate for system scalability, reliability, and real-time data synchronization across multiple sites, enhancing network configurations.
  • Enhanced data security through advanced obfuscation techniques, and implemented GoldenGate security features for secure data replication and system integration.
  • Managed Data Guard setups and GoldenGate replication, optimizing queries and indexes, and ensuring efficient, accurate data migration and performance tuning.
  • Maintained high-availability systems with Oracle GoldenGate, managing parameters for conflict detection and resolution to achieve near-perfect uptime and consistent data synchronization.
  • Applied OS patches, tuned Oracle Exadata systems, and integrated Oracle Cloud Infrastructure for improved query performance, leveraging GoldenGate for cloud-to-cloud and on-premises-to-cloud migrations.
  • Led disaster recovery drills and GoldenGate failover exercises, ensuring business continuity and minimal operational impact during emergencies.
  • Authored comprehensive documentation for database and GoldenGate designs, intentions, and operational procedures, maintaining clarity and accuracy in system operations.
  • Developed proactive monitoring strategies using GoldenGate Director and Oracle Enterprise Manager to oversee replication health and minimize downtime.
  • Fostered effective communication across IT teams, ensuring cohesive approach to database and GoldenGate management.
  • Provided expert technical support for Oracle database and GoldenGate issues, offering guidance and best practices to end-users and cross-functional teams.
  • Reviewed and enhanced database and GoldenGate designs, implementing security and monitoring enhancements to streamline administrative efficiency.
  • Automated routine tasks, data management, and optimized backup processes with custom scripts and PL/SQL procedures, including GoldenGate parameter automation.
  • Managed user account permissions within Oracle Database and GoldenGate environments, enforcing security protocols and ensuring compliance with data protection standards.
  • Conducted performance audits and capacity planning for both Oracle databases and GoldenGate replication paths, ensuring optimal resource allocation and database health.
  • Liaised with system administrators for comprehensive incident management, providing root cause analyses and resolution for both database and GoldenGate-related incidents.
  • Guided seamless database migrations and GoldenGate upgrades to newer versions or alternate platforms with minimal business disruption.
  • Maintained meticulous records of database and GoldenGate system configurations, processes, and historical changes through detailed documentation.
  • Established collaborative relationships across departments to understand evolving IT requirements and integrate GoldenGate solutions that support organizational goals.
  • Demonstrated leadership in managing complex database projects and GoldenGate implementations from concept to successful execution.
  • Adapted to dynamic requirements of database and replication environments by working flexible hours across various shifts.
  • Utilized strong analytical skills to develop effective solutions for challenging database and GoldenGate scenarios.
  • Managed multiple concurrent projects with excellent organizational skills, ensuring timely completion and quality outcomes.
  • Built and maintained positive team dynamics through effective communication and interpersonal skills, facilitating collaboration in database and GoldenGate initiatives.

Senior Database Engineer

Accenture's
10.2016 - 12.2019
  • Resolved Severity 1 issues in RAC and standalone databases, ensuring high reliability and performance.
  • Supported over 20 Oracle instances across diverse database environments, demonstrating adaptability and expertise.
  • Provided 24x7 support in critical production environments for continuous system availability and rapid issue resolution.
  • Led new server setups, including Oracle software installation and database creation, enhancing system capacity.
  • Maintained comprehensive documentation and mentored new team members, improving team knowledge and efficiency by 40%.
  • Collaborated with application development teams for SQL tuning, resulting in a 30% improvement in database performance.
  • Administered databases across multiple environments (production, staging, development, test), ensuring seamless operation.
  • Refreshed test/development databases using RMAN/hot backup and data pump, optimizing processes.
  • Created and maintained database schemas and objects, ensuring efficient organization and accessibility.
  • Spearheaded Oracle instance upgrades and migrations, improving versatility and performance.
  • Assisted in query optimization using Explain Plan, TkProf, and SQL Trace, improving performance by up to 25%.
  • Conducted performance tuning, leading to 20% improvement in response times.
  • Ensured reliable database backups, achieving 99.9% success rate in data recovery scenarios.
  • Demonstrated expertise in troubleshooting in RAC, ASM, and Oracle Failsafe environments.
  • Monitored and managed databases through script automation for improved health and performance.
  • Maintained standby and DR databases, enhancing disaster recovery preparedness.
  • Configured Flashback and Block Change Tracking, streamlining data recovery and historical data analysis.
  • Played key role in database upgrades and high availability solutions, utilizing Oracle Active Data Guard, Materialized Views, and Golden Gate.
  • Utilized OEM for performance tuning, scheduling, and troubleshooting, reducing performance-related incidents by 20%.
  • Delivered high-quality work through adherence to industry standards such as normalization rules and naming conventions in database design.
  • Facilitated smooth communication between IT teams by acting as a liaison between software developers, system administrators, and end-users regarding database-related concerns.
  • Managed multiple simultaneous projects under tight deadlines without compromising quality or functionality of deliverables.
  • Established clear documentation of all databases, facilitating knowledge transfer among team members and across departments.
  • Performed comprehensive database health checks, identifying areas of improvement for optimal performance.
  • Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
  • Ensured database security by establishing access controls, backup procedures, and auditing protocols.
  • Documented and communicated database schemas using accepted notations.
  • Troubleshot and resolved critical database issues, minimizing downtime and maintaining business continuity.
  • Optimized ETL processes to improve data processing speeds and overall efficiency.

Database Administrator

Lowe's
08.2014 - 09.2016
  • Managed and optimized complex database applications, improving performance by 20% and processing speed by 25%.
  • Installed and configured MongoDB for enhanced security and redundancy; upgraded Oracle databases to 12c and 19c RAC environments.
  • Conducted source system data analysis for accurate data mapping and supported multiple SQL & NoSQL technologies including Oracle, MongoDB, and PostgreSQL.
  • Configured Oracle network components like TNSNAMES and Listener; performed SQL statement and database tuning, enhancing query performance by 30%.
  • Contributed to database design and supported data warehousing, ETL processing, and SSIS package development.
  • Managed Oracle migrations, OEM Grid Control, and Cloud Control, maintaining 99.9% uptime and high levels of performance, availability, and security.
  • Implemented disaster recovery using physical standby databases and collaborated with AWS platform service teams for project consulting.
  • Migrated databases to Exadata and Oracle Hyperion, optimized Oracle Essbase applications, and managed NoSQL storage solutions.
  • Executed performance tuning and cloning databases using RMAN, achieving robust backup and recovery processes with 99.9% data integrity
  • Led projects for installing and configuring Oracle Hyperion EPM Suite and Oracle Management Cloud; upgraded Oracle server software and related products.
  • Utilized DRM APIs, integrated data between various Oracle systems, and implemented high availability/clustering concepts.
  • Conducted Disaster Recovery Drills, used MarkLogic for analytics, and maintained system consistency and integration.
  • Enhanced performance and functionality through continuous improvement efforts, testing operations, correcting errors, and making modifications
  • Coded database logic, oversaw database use and protections, and controlled access by establishing user levels for each database segment.
  • Optimized database performance by monitoring health and implementing tuning recommendations.
  • Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
  • Evaluated emerging technologies to identify opportunities for improving database operations and reducing costs.
  • Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
  • Built databases and table structures for web applications.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
  • Developed scripts and processes for data integration and maintenance.
  • Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
  • Tested programs and databases to identify issues and make necessary modifications.

Database Administrator

Wells Fargo
02.2012 - 07.2014
  • Created low-level design documents, coding standards, and naming conventions to enhance code quality and consistency in development projects.
  • Designed modules and database objects like packages and procedures, contributing to efficient schema creation and system deployment
  • Worked on database design, including ERD creation, for clear and effective data structuring
  • Participated in unit and integration testing, ensuring robust and reliable software solutions
  • Extracted and delivered year-end customer data to ATM switches, enhancing customer service efficiency.
  • Validated balance and customer data, deploying solutions with accuracy and reliability.
  • Implemented Zero Data Loss strategy, enhancing data protection and system resilience.
  • Monitored and optimized database performance, applying patches and upgrades as needed for optimal functionality.
  • Managed databases across various environments, providing metrics and recommendations for optimization.
  • Developed and maintained backup and recovery procedures, ensuring data integrity and recoverability.
  • Provided scripting support for database content and reporting, and administered database and application security.
  • Installed and configured servers, hardware, and software, aligning with standards and project requirements.
  • Supported data migration across platforms like Oracle, SQL Server, and PostgreSQL, ensuring data integrity.
  • Configured Real Application Clusters (RAC) on Oracle 11g/12c, enhancing scalability and availability.
  • Conducted tests to ensure data backup, security, privacy, and integrity, maintaining high data governance standards.
  • Collaborated with teams for successful project delivery and performed remote troubleshooting to minimize downtime.
  • Identified and implemented improvements for continuous process optimization.
  • Protected data against loss through security measures and addressed performance issues through continuous monitoring.
  • Adhered to set schedules to test databases for flaws and reduce downtime.
  • Assisted with day-to-day operations, working efficiently and productively with all team members.
  • Demonstrated creativity and resourcefulness through development of innovative solutions.
  • Skilled at working independently and collaboratively in team environment.
  • Coordinated with project management on database development timelines.

Education

Master of Science - Information Security And Assurance

Kennesaw State University
Kennesaw, GA
06.2022

Master of Science - Healthcare Management And Informatics

Kennesaw State University
Kennesaw, GA
06.2022

Bachelor of Science - Biochemistry

Lagos State University
Lagos, Nigeria
05.2007

Skills

  • Operating System: Unix/Linux, Windows, AIX
  • Databases: Oracle, SQL Server, MongoDB, PostgreSQL, MySQL
  • Tools: TOAD, SQL Developer
  • Oracle Database Administration: Installation and Configuration
  • Cluster Management and Patch Upgrades/Management
  • Performance Tuning
  • Disaster Recovery
  • Database Troubleshooting
  • Oracle RAC Configuration
  • Implementing security measures
  • Incident Management
  • Continuous Process Improvement
  • GoldenGate Implementation
  • High Availability Solutions
  • Real Application Testing
  • Oracle Enterprise Manager
  • Oracle Cloud Services
  • ITIL Processes
  • Information Protection
  • Database Development
  • Oracle Exadata Management
  • Database Administration
  • Disaster Recovery Planning
  • Data Guard Implementation
  • Database Security Management
  • Relational Database Management
  • Capacity Planning
  • Database Cloning
  • Data Governance
  • Oracle ASM Management

Certification

  • OCI AI Foundations Associate (2023)
  • Oracle Cloud Database Migration and Integration Professional (2023)
  • Oracle Database 19c Admin Professional
  • OCI GoldenGate Workshop Training - 2023

Quote

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader."
John Quincy Adams

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full Time

Work Location

RemoteHybrid

Timeline

Senior Oracle Database Administrator

AT&T
01.2020 - Current

Senior Database Engineer

Accenture's
10.2016 - 12.2019

Database Administrator

Lowe's
08.2014 - 09.2016

Database Administrator

Wells Fargo
02.2012 - 07.2014

Master of Science - Information Security And Assurance

Kennesaw State University

Master of Science - Healthcare Management And Informatics

Kennesaw State University

Bachelor of Science - Biochemistry

Lagos State University
USEN USEN