Gilbert Tamo-Nayang

Oracle Postgresql Database Administrator @FreightCar America, Inc.

Cherokee, AL, US

Experience with large databases (1.5 Tb) for OLTP and OLAP applications. Performed installation, configuration and maintenance of oracle 12c/19c, 12c RAC databases. Experience in configuring oracle 11g, 12c Real application cluster (RAC)(2 and 3 nodes) using cluster ware and automatic storage management(ASM). Performed migration of oracle 11g/12c non RAC single instance to RAC database instances. Experience with 12c cluster maintenance using CRSCTL command. Experience in using SRVCTL command for Oracle 12c RAC database. Implemented Disaster Recovery database 11g/12cData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode. Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab. Installed and configured Oracle 12c database on a test server using Oracle standard procedures and OFA, for performance testing and future 11g production implementation. Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity. Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption Extensively worked with ASMCMD for managing ASM environment. Used Oracle 12c/19c AWR & ADDM to monitor database activities and performance tuning. Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments. Applying upgrade patch, maintenance and interim (opatch) patches on all the databases. I