Curriculum Vitae – Sujeewa Dias Page * of *

Sujeewa Chathurani Dias

+1-702-***-**** 5027, W Eldorado Lane, Las Vegas, NV 89139 - USA ad4o4f@r.postjobfree.com

www.linkedin.com/in/sujeewa-chathurani-dias-25742b36 Oracle Database Administrator/Senior DBA

Profile

• Highly experienced engineer in the field of Oracle Database administration.

• Comprehensive practical knowledge in Maximum Availability Architecture/ Maximum Security Architecture/Database Management Systems Architecture and Database Implementation.

• Experienced Engineer in implementation of Oracle Enterprise Manager Cloud Control 13c with comprehensive monitoring and management capabilities.

• Experienced Solution Architect in Oracle Engineered Systems and Database Technologies fluent in solution designing, customer presentations, demonstrations, technical POCs and technical consulting.

• Solid understanding and Implementation expertise in High Availability Solutions such as Real Application Clusters and Database management in Oracle Engineered Systems/Exadata.

• Real-life experience on managing and tuning large high volume transactional systems which operates on real time.

• Efficient in Database performance monitoring, Diagnostic and Tuning, Backup and Recovery.

• Expert in Support, problem analysis and resolving complex problems, DB Maintenance, database migrations, database upgrades and enhancements.

• Working with different customers and different platforms.

• Enthusiastic on exploring new technology domains. Product Portfolio

• Oracle 19c/18c/12c/11g/10g/9i Database Management Systems with Partitioning, Advanced Compression, Indexing, RMAN and Data Guard

• Oracle Exadata

• Oracle Enterprise Manager Cloud Control 13c

• Oracle Cloud Infrastructure

• Oracle GoldenGate

• DB Visit Standby/Replicate

• Oracle Weblogic Server 14c/12c

Curriculum Vitae – Sujeewa Dias Page 2 of 6

• RedHat Enterprise Linux, Oracle Enterprise Linux, Windows Server, Sun Solaris, HP-UX, IBM AIX

• PL/SQL, SQL, Toad, SQL Navigater, SQL Developer, Bash

• Oracle MySQL DBMS

Professional Experience

Oracle Corporation - Sri Lanka (JAPAC Region)

Period : September 2021 – Nov 2023

Designations : Oracle Pre Sales Engineer for Engineered Systems/ Oracle DBA Key Project Involvements:

o Peoples Bank Exadata upgrade from X6-2 to X9M-2 project

Support on solution designing and sizing the new environment.

Maintaining the customer alive throughout the lifecycle by providing solutions to their existing environment issues.

Conducting a comprehensive DB on Exadata/EM 13c knowledge sharing workshops across 16 demo/presentation sessions.

DB and System level health checks of the existing environment. o Sri Lanka Army ODA X9 project

DB and System level health checks of the existing environment.

Conducting comprehensive workshops on Database technologies on ODA/EM 13c throughout 4 months.

o Bank of Ceylon Exadata X9M-2 Project

Conducted the post sales technology knowledge transfer workshops.

Database/Systems health checks on new environment once implemented. o Sri Lanka telecom Enterprise Manager 13.5 Implementation and HCC implementation on Exadata.

o Amana Takaful – Maldives Oracle Enterprise Manager 13.5 Implementation and customer training workshops.

o Database Performance Tuning workshops at Central Finance. o Oracle Weblogic server administration workshops / EM 13c trainings at Hatton National Bank.

Curriculum Vitae – Sujeewa Dias Page 3 of 6

Millennium IT ESP Former member of the London Stock Exchange Group Period : October 2010 – August 2021

Designations : Consultant – Enterprise Data and Middleware Senior Systems Engineer – Information Management

Technical Analyst - Oracle Database Systems

Associate Technical Analyst - Oracle Database Systems Key Project Involvements:

o Oracle RAC 12c Upgrade Project at Nairobi Stock Exchange – Kenya.

Solution design for the Upgrade Project.

Database upgrades from Oracle 11.2.0.4.0 to 12.1.0.2.0 in Production Oracle RAC/DR/UAT environments.

Completed UAT and client handover process.

o Oracle 19C RAC Upgrade Project at RDB Bank

Implementation and set up Oracle 19c Real Application Cluster of 2 Nodes at Regional Development Bank on Linux X86_64 bit platform.

Database migration to Oracle 12.2.0.1 under the 19c Grid Infrastructure.

Monitoring and troubleshooting post implementation issues. o Oracle Enterprise Manager Cloud Control 13C Release 4 implementation at HNB bank

Implementation of Oracle Enterprise Manager Cloud Control 13.4 on Linux platform.

Adding the targets such as Oracle Exadata Primary and DR systems, other host targets, databases and Middleware targets.

o Oracle Enterprise Manager Cloud Control 13C Release 4 implementation at Mobitel (Pvt) Ltd.

Consultation for implementation, target addition and notification rules setup for the Cloud Control 13.4.

Conduct user awareness session.

o Core Banking System migration to 19c RAC and 12.2 Oracle Database project at HNB Bank.

Implementation of Oracle 19c RAC One Node Grid Infrastructure on Solaris Platform with 2 nodes.

Core DB migration to Oracle 12.2.0.1.0 of Production RAC/UAT RAC environments.

Dataguard DR setup with Snapshot standby features. o Working as the Oracle DBA in Ooredoo Telecom, Maldives. (Feb/2016 to Feb/2017)

Administering the Oracle 11g R2 databases with Grid Infrastructure.

Troubleshooting SQL performance issues.

Data Warehouse migration. (Informatica warehouse DB) Curriculum Vitae – Sujeewa Dias Page 4 of 6

o AIX HA Cluster Oracle DB implementation and Configuration at Arpico Sri Lanka

Implementation and set up of IBM AIX Power Systems High Availability 2 node cluster at Arpico, Sri Lanka.

Set up and configure Oracle 11.2.0.2 Enterprise Edition database in a way to support for service failovers.

o Oracle Database installation and Dataguard set up project at Abans

Implementation and set up Oracle 11.2.0.3 database and Dataguard environments for more than 7 standalone databases.

ASM storage set up as a standalone DB storage mechanism.

Implement RMAN, Exp dump scripts to automate daily backup procedures.

Implement Dataguard monitoring mechanisms using scripts.

Project documentation with a complete user manual. o Daily Start of the Day monitoring and Troubleshooting at Colombo Stock Exchange (CSE) RAC environment including Dataguard environment. (Assisted in Borsa Italiana monitoring as well).

Checking DB level, ASM level, Cluster level alert logs for errors and report if any error found.

Checking the Dataguard replication and troubleshooting the replication related issues.

Act upon DB related and RAC related issues.

o Oracle RAC 10g to 11g upgrade at Airtel Sri Lanka

Migrated the Oracle Cluster and database which was in 10.2.0.4 earlier to 11.2.0.3 up on the customer requirement.

o Oracle ASM storage migration at Airtel Sri Lanka

Oracle 11.2.0.3 RAC database's storage was migrated to a new SAN storage. OCR, Voting disks, Data and FRA ASM diskgroups were included in the migration.

o Oracle Real Application Cluster (11.2.0.3) Implementation at PABC Bank

Implemented Oracle 11g R2 Real Application Cluster with 2 nodes. o Oracle 12c and 13c Cloud Control implementation and configuration at Hatton National Bank in Colombo.

Implemented Cloud Control 12c with adding different targets of different OS platforms and HA clusters.

Curriculum Vitae – Sujeewa Dias Page 5 of 6

o Working as a DBA in Oracle Exadata implementation project (FEBA project) at Hatton National Bank in Colombo.

Installation of databases in Exadata platform.

Administering databases on Exadata machine.

Oracle dataguard setup in Exadata environment.

Roomsnet International (Private) Limited

Period : March 2006 – October 2010

Designation : Software Engineer - Oracle Database

Key Project Involvements:

o Worked as a DB administrator and a SQL developer in a hotel reservation project which was the main project at Roomsnet International. Certifications/ Qualifications

Professional

Certifications:

• Oracle Database 11g Administrator Certified Master - OCM

• Oracle Exadata Database Machine X9M Certified Implementation Specialist

• Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator

• Oracle Autonomous Database Cloud 2023 Certified Professional

• Oracle Autonomous Database Cloud 2019 Specialist

• Oracle Enterprise Manager 12c Certified Implementation Specialist

• Oracle Database SQL Certified Expert

• Oracle Database 12c Administrator Certified Professional

• Oracle Database 11g Administrator Certified Professional

• Oracle Database 10g Administrator Certified Professional

• Oracle Database 10g Administrator Certified Associate

• MySQL 5.6 Database Administrator

• Redhat Certified Engineer

• Redhat Certified Administrator

• Australian Computer Society Examination – 2004 July Professional

Trainings:

• Oracle Database 12c: Clusterware Administration Ed 1.1- On Demand Training

• Oracle Database 12c: SQL Tuning for Developers Ed 1- On Demand Training

• Oracle Weblogic Server 12c – Administration I (LVC)

• Oracle Real Application Clusters 11g– Oracle University Malaysia

• IBM DB2 Boot Camp - Sri Lanka

Curriculum Vitae – Sujeewa Dias Page 6 of 6

• MySQL 5.6 Database Administration - Malaysia

Academic

Qualifications:

• Masters of Information Technology at University of Colombo School of Computing – 1st January 2012

• Bachelor of Information Technology at University of Colombo School of Computing – 1st January 2007

Contact this candidate