Felix ARHIN
Accra
Summary
Highly creative and hardworking individual committed to achieving excellence. Demonstrates exceptional effectiveness in collaborating with diverse groups of people and possesses the ability to work independently. Seasoned database professional with extensive experience in database management and optimization. Proven track record of enhancing system performance and ensuring data security. Recognized for strong collaborative skills and adaptability to evolving project needs, leveraging deep knowledge of SQL, database tuning, and data backup processes.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Database Administrator
Omnibisic Bank
08.2023 - Current
- Administers and maintains over 50 production and UAT databases (Oracle 12c, Oracle 19c, MySQL and SQL Server)
- Manage Oracle Databases in High Availability and Disaster Recovery environment (RAC, Data Guard)
- Capacity planning for efficient database growth
- Introduced Oracle RMAN backups to replace export (expdp) logical backups
- Introduced RMAN Recovery Catalog for backup and recovery of Oracle Databases
- Installation and configuration of Oracle databases on Linux servers in production and UAT environments
- Introduced RMAN incrementally updated backups to complement existing backups
- Replicated all MySQL databases to Disaster Recovery site to meet Recovery Point Objective and Recovery Time Objectives
- Setup and management of Oracle Data Guard to meet Recovery Point Objective and Recovery Time Objectives
- Setup of Microsoft SQL Server Log Shipping
- Setup up of Microsoft SQL Server Always on Availability Group and Distributed Always on Availability Group for High Availability and Disaster Recovery
- Continuous provision of support to End of Day (EOD) Team when the need arises
- Application of Oracle database patches in single instance, Data Guard and RAC environments
- Performance Tuning of Oracle databases and SQL statements
- Monthly refresh of UAT databases with export (expdp) from production
- Migration of production SQL Server databases to Always on Availability Group without downtime
- Assisting developers in application upgrades
- Developing weekly report on availability, resource utilization, growth and backups of core databases
Database and Applications Expert
Opensolutions
05.2022 - 07.2023
- Monitored and managed Registrar’s General Department (RGD) oracle databases
- Migrated Registrar’s General Department (RGD) data to the G-Cloud (Government of Ghana Cloud) with no downtime
Independent Contractor (Database Specialist) - GEGOV Project
GCNET
04.2020 - 04.2021
- Assisted with the training of Ghana Revenue Authority (GRA) and Registrar’s General Department staff (RGD) prior to project takeover
- Assisted with the management of oracle storage systems (SUN Storage 7310) and tape backup systems (StorageTek SL48)
- Assisted with documenting processes and procedures for daily operations
- Assisted Ghana Revenue Authority (GRA) and Registrar’s General Department (RGD) staff in the development of reports to meet business requirements
- Assisted Ghana Revenue Authority (GRA) and Registrar’s General Department (RGD) database staff to switchover databases to meet BCM requirements
- Assisted with the daily management of oracle RAC (Real Application Clusters) database and several single instance databases
- Installed and configured several production and test databases on UNIX/Linux servers
- Assisted with oracle data guard administration (replication between primary and standby databases)
- Assisted with performance tuning of oracle databases
Database Specialist - GEGOV Project
GCNET
01.2014 - 04.2020
- Managed oracle database of about 9 TB in size for the Ghana Revenue Authority (GRA) and the Registrar’s General Department (RGD)
- Developed oracle PL/SQL packages and procedures to perform backend routines
- Managed oracle storage systems (SUN Storage 7310) and tape backup systems (StorageTek SL48)
- Managed several single instance databases and a four node oracle RAC database
- Performed switch overs of RAC and single instance databases to meet BCM requirements
- Installed and configured several production and test databases on UNIX/Linux Servers
- Planned and implemented backup and recovery strategies
- Managed several single instance databases and a four node RAC oracle database
- Performed capacity planning for efficient database growth
- Implemented backup and recovery strategies with RMAN
- Assisted in creation of LUNS and addition to storage pool for RAC databases
- Installed and configured Oracle Cloud Control 13c to monitor and manage production databases
- Assisted developers in application upgrades
Database Administrator - GEGOV Project
GCNET
01.2010 - 12.2014
- Assisted with the setup and configuration of oracle storage systems (SUN Storage 7310) and tape backup systems (StorageTek SL48)
- Installed and configured UNIX/Linux operating systems on production and test servers
- Installed and configured oracle databases on UNIX/LINUX operating systems
- Assisted in Installing and configuring four node RAC database on UNIX (Solaris) operating systems
- Created database users and roles as requested by Team Lead
- Performed daily database monitoring in production and test databases
- Performed daily backups of production databases
- Assisted in planning and implementing disaster recovery and high availability strategies (RAC and data guard)
- Assisted reporting team in developing Jasper reports
- Assisted with application upgrades
- Installed and configured oracle enterprise manager to monitor production databases
Applications Officer
GCNET
01.2007 - 12.2010
- Installed and managed on-premise databases (Gupta SQLBase) of Shipping Lines and Freight forwarders
- Assisted with backups of on-premise databases (Gupta SQLBase) of Shipping Lines and Freight forwarders
- Provided onsite support to Shipping Lines and Freight forwarders
- Assisted with troubleshooting network and operating systems related issues
National Service Personnel
GCNET
01.2006 - 12.2007
- Worked at the call Centre to support shipping lines, agents and the general public
Education
ORACLE CERTIFIED PROFESSIONAL DATABSE ADMINISTRATION -
Oracle University
Online04.2024
UDACITY NANODEGREE PROGRAM - CLOUD DEVELOPER
Udacity
03.2022
Oracle Database 11g Performance Tuning -
Koenig Solutions
01.2019
ORACLE IN-HOUSE TRAINING - Oracle Database 11G: Data Guard Administration, Oracle Database 11G: RAC Administration, Oracle Database 11G: Administration Workshop II
Oracle University
01.2011
Sun Certified Solaris Associate (SCSAS) -
Oracle
01.2010
Oracle 10g Certified PROFESSIONAL -
Intercom Programming & Manufacturing Co. Ltd (IPMC)
01.2009
Oracle 10g Certified Associate (OCA) -
Intercom Programming & Manufacturing Co. Ltd (IPMC)
01.2008
Bachelor of Science - Computer Science
Kwame Nkrumah University of Science and Technology (KNUST)
01.2006
Senior Secondary Certificate Exams (S.S.C.E) -
Ghana Secondary Technical School (G.S.T.S)
01.1999
Skills
- Database design
- Architecture
- Solaris
- Unix
- Linux commands
- SQL
- Oracle PL/SQL programming
- Bash shell scripting
- Oracle backup and recovery procedures
- Oracle database administration
- Oracle database performance tuning
- Oracle Secure Backup (OSB)
- Veritas NetBackup
- Oracle RAC
- ASM administration
- Oracle Enterprise Manager (Cloud Control)
- Oracle Storage Systems
- SUN Storage 7310
- StorageTek SL48
- Oracle data guard administration
- Software development
- Java
- VBnet
- JavaScript
- AWS Cloud Developer
- Amazon Web Services
- Docker
- Kubernetes
- REST APIs
- Microservices Basics
- Serverless Cloud Computing
- Serverless Development
- Application Authentication
- Cloud Security
- Travis CI
- CI/CD
- JavaScript Backend
- Nodejs
- Expressjs
- MySQL
- Amazon DynamoDB
- Microsoft SQL Server
- PostgreSQL
Certification
- Oracle Certified Professional Oracle Database Administration 2019
- Oracle Certified Professional (OCP) DBA 10g
- Oracle Certified Associate (OCA) DBA 10g
- Sun Certified Solaris Associate (SCSAS)
Personal Information
Nationality: Ghanaian
Hobbies and Interests
- Loves computer programming
- Listening to music
Languages
English
Timeline
Database Administrator
Omnibisic Bank
08.2023 - Current
Database and Applications Expert
Opensolutions
05.2022 - 07.2023
Independent Contractor (Database Specialist) - GEGOV Project
GCNET
04.2020 - 04.2021
Database Specialist - GEGOV Project
GCNET
01.2014 - 04.2020
Database Administrator - GEGOV Project
GCNET
01.2010 - 12.2014
Applications Officer
GCNET
01.2007 - 12.2010
National Service Personnel
GCNET
01.2006 - 12.2007
UDACITY NANODEGREE PROGRAM - CLOUD DEVELOPER
Udacity
Oracle Database 11g Performance Tuning -
Koenig Solutions
ORACLE IN-HOUSE TRAINING - Oracle Database 11G: Data Guard Administration, Oracle Database 11G: RAC Administration, Oracle Database 11G: Administration Workshop II
Oracle University
Sun Certified Solaris Associate (SCSAS) -
Oracle
Oracle 10g Certified PROFESSIONAL -
Intercom Programming & Manufacturing Co. Ltd (IPMC)
Oracle 10g Certified Associate (OCA) -
Intercom Programming & Manufacturing Co. Ltd (IPMC)
Bachelor of Science - Computer Science
Kwame Nkrumah University of Science and Technology (KNUST)
Senior Secondary Certificate Exams (S.S.C.E) -
Ghana Secondary Technical School (G.S.T.S)
ORACLE CERTIFIED PROFESSIONAL DATABSE ADMINISTRATION -
Oracle University
Similar Profiles
Kari HybertsonKari Hybertson
Retail HUB Manager at First Interstate Bank/Great Western Bank/Home Federal BankRetail HUB Manager at First Interstate Bank/Great Western Bank/Home Federal Bank
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
MAMOUD KAMARAMAMOUD KAMARA
External Board Member, Monetary Policy Committee at Bank of Sierra Leone (Central Bank)External Board Member, Monetary Policy Committee at Bank of Sierra Leone (Central Bank)
JOSEPHINE O.D. ASARE-BEDIAKOJOSEPHINE O.D. ASARE-BEDIAKO
MONEY MARKET & ALM MANAGER at BANK OF AFRICA GHANA LIMITEDMONEY MARKET & ALM MANAGER at BANK OF AFRICA GHANA LIMITED
GLADYS OWUSUA WIAFEGLADYS OWUSUA WIAFE
Admin & Finance Officer at Epsilon Collective Ltd.Admin & Finance Officer at Epsilon Collective Ltd.