Inyang Inyang Akpan
McKinney,TX
Summary
Oracle Database Administrator with hands-on support for Oracle 11g/12c and 12c environments across development and production. Strong background in installation, tuning, backup and recovery, RMAN, and zero-downtime operations, with automation and performance work that saved 20 hours each week.
Overview
1
1
Certification
8
8
years of professional experience
Work History
Oracle Database Administrator
Pishontech Inc
Atlanta, Georgia
07.2018 - 02.2022
- Designed an OFA – Compliant distributed database comprising three database environments for development, test and production on an Oracle Enterprise Linux 5 platform
- Administered daily backup and archiving of data on tape, and created user accounts and database objects while managing user privileges.
- Managed various database structures: Tablespaces, data files, control files, redo log files and Parameter file using OEM, GUI Tools and Command-Line
- Performed scheduled and intermittent cloning/refreshing of production database using RMAN and Data Pump
- Performed several test recovery procedures to ensure the validity of backups and workability of the recovery system
- Scheduled and managed jobs using crontab and Oracle Scheduler
- Designed and implemented UNIX shell script/SQL Loader for loading flat files to Oracle Database daily from the FTP Server
- Worked with Developers and QA Testers to debug PL/SQL programs and carried out production installation of programs after User Acceptance Test approval.
Oracle Database Administrator
Dhihie Pharmacy Limited
Uyo, Akwa Ibom State
02.2022 - 08.2026
- Performed daily database administration tasks on 10+ Oracle 12c databases, contributing to a consistent performance across the company's IT infrastructure.
- Automated routine database maintenance tasks using Oracle Enterprise Manager, saving an estimated 20 hours per week in manual effort.
- Monitored and tuned database performance during testing and production operations; coordinated database sizing/resizing, restructuring, and index rebuilds; assisted with capacity planning for future growth; documented benchmarks and procedures to optimize performance, ensuring adherence to performance guidelines.
- Integrated artificial intelligence into oracle cloud infrastructure to enhance effective database delivery
- Enmeshed large language, machine learning models into routine database operations and increase company productivity by 23%
- Instituted a multi-functional team that established a company-wide backup and disaster recovery plan, reducing potential data loss risk by 90%.
- Planned and implemented strategies and procedures for physical disaster/recovery and contingency planning. Established mechanisms for replicating production databases in development environments which accelerated workflow to 75%.
- Created backup plan design and implementation using cold/hot backups and RMAN backup technology.
- Assisted in developing a centralized database management system, enhancing data accessibility for 50+ users.
- Trained 10 junior DBAs, improving company productivity through effective knowledge transfer.
- Provided problem resolution support, specific to database issues; identified and resolved database problems, coordinated with application users to determine root cause and ensure accurate resolution in 100% of reports received.
- Assisted in development, improvement and maintenance of database administration-related plans, processes, procedures, standards and priorities resulting 90% increase in work output.
Education
Bachelor - Pharmacy
University of Uyo
Akwa IbomSkills
- Provided 24x7 production support for Oracle 11g/12g databases on Windows / UNIX platforms
- Proficient in all DBA responsibilities such as installation, Configuration, Upgrades, Patches, Performance Tuning, Backup, Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting, Scripting in RMAN and Documentation
- TOOLS : SQL
- Plus, Enterprise Manager (OEM), Grid Control, Data Pump, SQL Loader, Oracle Recovery Manager (RMAN), DBCA, NETMGR, NETCA, Recovery Catalog, Automated Workload Repository (AWR), ADRCI, ASMCA, Oracle Scheduler, Data Pump, Real Application Clusters (RAC), Standby Database (Physical, Snapshot), Unix Shell Scripting, Automatic Storage Management (ASM), TOAD, MobaxTerm, SecureCRT, Enterprise Reporting using Microsoft Office (Word, Excel, PowerPoint, Outlook and Project)
- Excellent leadership qualities and team management skills
- Outstanding communication in English (verbal and written) and interpersonal skills
Certification
Oracle Cloud Infrastructure 2023 Foundations Associate, Oracle Cloud Data Management 2023 Foundations Associate, Oracle Cloud Infrastructure 2025 AI Foundation Associate
Timeline
Oracle Database Administrator
Dhihie Pharmacy Limited
02.2022 - 08.2026
Oracle Database Administrator
Pishontech Inc
07.2018 - 02.2022
Bachelor - Pharmacy
University of Uyo