DOT-FAA Operational Business Intelligence Wide Accounting Network Project (OBIWAN) 3rd party subcontracting with prime. This was mainly a system integration project, integrating data from 2 seperate FAA projects i.e. PRISM & DELPHI for the purpose of facilitating Business Reporting. Production Support for Financial Reporting RAC & RAC Node 1 Databases within FAA. Data Replication using Oracle Goldengate from PRISM COTS systems to OBIWAN Backend Support of Data Integration from source Delphi to OBIWAN using ODI Backend Support of OBIEE & OAS to facilitate financial reporting Upgrade of Exadata Compute Nodes, DOM-Us, DOM-0s, storage servers, IB and Ethernet switches from 18.1.21.0.0 to 21.2.9.0.0 Upgrade of Exadata RAC databases from 12c to 19c. Configuration & Installation of Oracle Exadata X9-M2 Use of Oracle Exadata Deployment Assistance tool for Exadata GI & RDBMS Configuration ASR maintenance for Oracle Service Request Auto Creation. Migration of DW databases from X6-2 X9-M2 GI & Database PSU patching in RAC cluster and non-RAC standalone databases. Installation & Configuration of 19c GI & RDBMS software. Supporting Oracle Engineers for hardware replacement. Application of Rolling BUG fix patches for GIS and RAC database software. User access management for database users for Tableau and OBIEE/ODI. TDE/Tablespace encryption and wallet maintenance. Rebuild lower env databases using RMAN duplicate.
Subcontracting Project with prime vendor via Sun Technologies- Supporting various backend database activities Production Support for 800+ Oracle 11g & 12C OLTP & DSS databases on Oracle Linux and Solaris. Installation & Configuration of 12CR1 and 12CR1 RAC 3-8 node cluster configuration on Oracle Linux 6.5 Working with Advanced Distribution Management Systems (ADMS) Working with Service-Now for prod & non prod change management and incidents. Creation of Oracle RAC & Non-RAC databases. PSU patching with opatch and datapatch in RAC environment. GI & Database patching in RAC cluster and Non-RAC standalone databases. TDE/Tablespace encryption and wallet creation. Working with rman backups/ddboost and restore, troubleshooting. Upgraded RAC database from 11.2.0.4 12.1.0.2 Working with Database hung issues related to archiving. Proactive and reactive monitoring thru OEM 13C. Working on performance issues and working with Oracle support as needed. Working with sql baseline for resolving performance issues. Working with ADDM and AWR reports for resolving performance issues. Proactive and reactive database monitoring & troubleshooting performance. Working with application teams to promote their releases and fixes. Working with Oracle Internet Directory for TNS lookups for databases. Working with Oracle Support on performance issues and bug fixes. Supporting large DSS databases up to size 600TB.
Ekka IT Solutions Inc.