Senior Oracle Database Consultant | Cloud & Engineered Systems Specialist | Exadata DMA
Chanaka Yapa is a highly accomplished Senior Database Consultant with over 14 years of hands-on experience in Oracle database technologies. His expertise spans the full lifecycle of database management, including analysis, implementation, monitoring, optimization, and troubleshooting of complex Oracle environments. Chanaka has a deep command of Oracle RAC, Data Guard, ASM, RMAN, Oracle Enterprise Manager (OEM), and Oracle Advanced Security technologies, with a strong focus on performance, high availability, and business continuity.
Chanaka has previously held a leadership role as the second-in-command for Oracle database technologies at the London Stock Exchange Group (LSEG), BSL (Sri Lanka), where he also extended support to LCH (London Clearing House). He has also contributed to global consulting initiatives during his tenure at Virtusa, a prominent US-based IT services and consulting firm, delivering critical solutions to clients across North America, Europe, Asia, and Australia.
Core Competencies & Technical Expertise
Exadata DMA: Deep expertise in full-stack patching for Oracle Exadata, including infrastructure, grid, and database components, across on-premises and Cloud@Customer (C@C) deployments.
Oracle Database Technologies: RAC, Data Guard, ASM (10g – 19c), GoldenGate, RMAN.
Cloud Platforms: Oracle Cloud Infrastructure (OCI), Microsoft Azure, Amazon Web Services (AWS).
Virtualization & OS: Oracle Linux Virtualization Manager (OLVM), VMware vSphere ESXi; Linux, AIX, Solaris, Windows.
Middleware: Installation and configuration of Oracle WebLogic and Fusion Middleware.
Key Projects & Achievements
Exadata & ODA Maintenance: Led full-stack patching and lifecycle management for multiple Exadata and Oracle Database Appliance (ODA) environments, ensuring stability and compliance for critical infrastructure.
Cloud Migrations:
Successfully migrated large-scale production and non-production workloads to Exadata Cloud@Customer for a major financial institution.
Delivered seamless database migrations from on-premises environments to Oracle Cloud Infrastructure (OCI), ensuring minimal downtime and zero data loss.
Database Upgrades: Spearheaded upgrades from Oracle 11g and 12c to 19c and 23ai, aligning systems with the latest security and performance features.
Performance Optimization:
Tuned EOD batch jobs and OLTP environments to deliver sub-second response times.
Enhanced performance and reduced operational risk for high-volume financial systems.
High Availability Solutions:
Engineered zero-downtime node migrations and clustering configurations for mission-critical Oracle instances.
Enterprise-Scale Production Support:
Delivered database administration and support for over 4,000 servers and 100+ applications in live production environments, meeting stringent SLAs and compliance requirements.