Nikita Gaganov

8+ years’ experience of supporting mission-critical databases with 24/7 high workload, focused on constantly improving performance and availability. Looking for a position in an international company.

Supported 100+ Oracle databases, up to 1.5PB in size. Managed RAC 12c, 18c, 19c with high workload, up to 1000 active sessions. Supported 15+ Exadata racks.

Upgrades

• Upgraded Oracle databases: 12c->18c, 18c->19c, 19c->21c, using DBUA, AutoUpgrade, command-line tools
• Upgraded RAC and Grid Infrastructure 12c->18c, 18c ->19c
• Upgraded Oracle SAP databases, including GI for SAP
• Migrated non-CDBs to PDBs

Backups

• Devised and implemented backup strategies, including tape backups, delayed standby, incremental backups
• Configured database backup via enterprise-wide storage management applications: Tivoli, StoreOnce, CommVault Simpana

Working with Oracle Support

• Found solutions in knowledge base
• Created and followed up Service Requests
• Resolved patch conflicts
• Localized bugs in Oracle Optimizer, InMemory and HCC, created test cases for Oracle Support

Maintenance

• Installed patches using opatch, opatchauto
• Implemented table partitioning using dbms_redefinition
• Tuned SQL request performance using baselines and profiles
• Traced long-running sessions using SQL Trace and TKPROF
• Analyzed AWR and ASH reports, fine-tuned database parameters for best performance
• Requested changes from the developers and gave hardware recommendations
• Configured Resource Manager to prioritize critical workload
• Implemented ILM to optimize database size
• Set up and maintained OEM 13.x monitoring of database, OS, and hardware

Oracle DBA OCP 11g, Oracle DBA OCP 12c