Oracle Consultant

• Proof of concept with Oracle 12c, evaluation of old and new options
• Area: data warehouse (DWH), business intelligence (BI), administration
• Tools: Oracle 12c, PL/SQL, SQL, SQL*Plus
• PoC topics: table statistics (local and global), extended star schema, bitmap indexes

• Database and SQL tuning of the CRM database (20 days)
• Area: development
• Tools: Oracle 12c, AWR reports, sql_trace, tkprof, Toad, code review of PL/SQL code

• Upgraded/migrated Oracle 11g to Oracle 12c for about 200 databases
• Migrated the first 10 databases, split into subprojects, supported the Indian operations team in English
• Used container and pluggable databases, Oracle Enterprise User Security, Transparent Data Encryption, wallets, DB Vault, and realms
• Application and SQL tuning, optimized table design (a temporary table slowed statements by factor 10), Data Guard, in-memory DB
• Tools: Data Pump (expdp, impdp), SQL*Plus, Toad, SQL Developer, Oracle Cloud Control, bash, ksh

• Large-scale performance and error analysis project for 350 databases with a team of 25
• SQL tuning: debugging, sql_trace, tkprof, execution plan analysis, indexes (B*-tree, bitmap, function-based), parallelization, optimizer hints
• DBA tuning: AWR reports, cache tuning (shared pool, PGA), IO tuning, wait tuning
• Data warehouse: partitioning (interval, range, hash, list), local and global indexes, materialized views with query rewrite, GROUP BY ROLLUP/CUBE, change data capture
• Administration: installation, patches, backup & recovery, Data Guard, flashback, networking, clustering (Solaris, Red Hat, VMware), documentation
• Database administration: OS environment design, silent installation, migration, relink, init.ora/spfile, monitoring
• Backup & recovery (RMAN, LogMiner), tablespace management, user and role management, LOB management, advanced queuing, replication
• Tools: Oracle 8.1.7–12.1, RMAN, Grid/Cloud Control, Enterprise Manager, shell scripts

Highlights:

• Analyzed hardware contention waits with LOBs and resolved them with patch/event
• Reduced middleware licensing costs by migrating to Red Hat Fuse/JBoss
• Solaris to Linux migration cut hardware costs
• Restored deleted online redo logs without data loss
• Flashback improved test performance by factor 5