Amadu Koroma
Database Administrator @First Citizens Bank
Signup · Get unlimited contacts
WORK HISTORY
Database Administrator @First Citizens Bank
Phoenix, AZ, US
Monitored and administered numerous databases in UNIX/Linux environments using OEM 13.4Successfully performed Out-of-Place manual upgrade of Oracle Database version 11.2.0.1.0 to 11.2.0.4.0 and from 11.2.0.4.0 to 12.2.0.1Created CDB/PDB’s based on client\'s needs.Performed cloning of PDB from a remote source databaseSuccessfully plugged in PDB’s to a CDB on the same server and across servers. Restored a PDB to an auxiliary container database instance.Created restore point for PDB’s and Flash a PDB to a restore point (point in time recovery)Implement proactive database monitoring using OEM/13.4. Monitor key performance indicators such as CPU usage, memory utilization, I/O latency, and database wait events.Identify and optimize poorly performing SQL statements using tools like Oracle SQL Tuning Advisor and SQLTXPLAIN to analyze and tune SQL queries. Consider using hints, indexes, and materialized views to improve query performance.Adjust memory allocation parameters such as SGA and PGA to optimize performance.Collaborate with development teams to design and implement efficient database schemas and optimize SQL queries.Export/import a specific schema or a set of schemas and tables using EXPDP/IMPDP command. DEV, UAT and PROD Environment.Manage, administer and maintain multiple Oracle 19c and 12c databases ensuring high availability and optimal performance.Plan and execute routine database backups using RMAN, minimizing data loss risks and ensuring data integrity.Perform regular database backups and recovery procedures, minimizing downtime and data loss risks.Develop RMAN shell scripts to automate routine backup and recovery tasks.Design and implement appropriate backup strategies based on business requirements, RTO, and RPO.Monitored various database activities such as backup, error logs, space, object, performance, user, and session monitoring to ensure proper capacity and availability. Implement TDE to encrypt sensitive data at rest.
EDUCATION
Oracle University
Certificate
George Mason University
Bachelor of Science - BS
Northern Virginia Community College
Associate of Science - AS
ABOUT AMADU KOROMA
A dedicated Oracle Database Administrator with over 6 years experience in designing, installing, managing, and maintaining DEV/SIT/UAT/PROD Database versions (19c, 12c, 11g, 9i). Over the years as an Oracle Database Administrator, I have engaged in a wide range of activities on Oracle RDBMS databases from versions 11g/12c to 19c. These activities encompass application installation and configuration, disaster recovery strategies, data replication, ensuring database high availability, performance tuning, query optimization, backup and recovery, database migration and integration, upgrades and patching, database security, and monitoring and troubleshooting database performance. In collaboration with interdepartmental teams, I support various applications, manage incidents, problems, and changes, and implement advanced security and auditing features. I utilize tools such as GoldenGate, Data Guard, RAC, OEM13c, and Exadata, as well as RMAN, to provide backup and recovery solutions, use OEM for monitoring and tuning, and implement data replication solutions. My passion for being a DBA stems from my ability and perseverance in troubleshooting and finding solutions. I am inspired by solving problems and am eager to learn from my challenges. My educational background and work experience have endowed me with a strong problem-solving drive. As an enthusiastic and proactive team player, I am always keen to learn new technologies. My attention to detail, strong organizational skills, and effective verbal and written communication are among my key strengths. Throughout my career, I have adeptly handled multiple responsibilities in a dynamic and fast-paced work environment. Technical Skills: Oracle database versions 19c/12c/11g/9i Database security (auditing/TDE) Exadata X6-2, X7-2 AIX/HP-UX/Solaris/Linux/Windows OEM/Grid Control (13c/12c/) CDB’s PDB’s OPatch Data Guard(19c/12c/11gR2/10gR2) RAC (19c/12c11gR2/11gR1/) Oracle Streams RMAN backup/Recovery Data Pump (expdp/impdp) Sql*Loader ASM Oracle GoldenGate (19c/12c/11g) Commvault MV Replication TOAD Change Management IT Controls Oracle Diagnostics(RDA 4/OS Watcher) SOX Compliance ODBC/ODAC Oracle Tuning (ASH/ADDM/AWR/TKPROF) TKPROF CVS Unix Shell (ksh, bash), awk, Perl.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.