Database administrator (DBA) with experience in designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL Server environments. Proficient in an assortment of technologies, including Oracle 11g and MS SQL Server, in Windows and Linux systems. DBA skills include:
Read More »
Oracle 9i/10g/11g Database Administration
Database Cloning and Instance Management
SQL Server Development and Administration
IBM DB2 Database version 9 and 10 Administration
Oracle Golden Gate 11 implementation
Totalamber (Pvt) Ltd. Technical Consultant (Dubai) 10/2013 Present
Golden Gate Replication for Seadrill (Dubai)
Have been based in Seadill Dubai on an Oracle Golden Gate implementation. Seadrill is a leading offshore deepwater drilling company, which operates a versatile fleet of 69 units that comprises drillships, jack-up rigs, semi-submersible rigs and tender rigs for operations in shallow to ultra-deep water areas in harsh and benign environments.
Currently Seadrill has more than 30 oil rigs all around the world, connected through satellite network which has IFS applications for their supply chain management system. Our task is to develop a proof of concept for a bi-directional data replication solution using Oracle Golden Gate 11 to provide real time data replication between the offshore servers and central database. We are a 3 man team working in developing this POC for Seadrill
Oracle Golden Gate
Performance Tuning Analysis for Oracle Databases in Seadrill
I am further working on performance tuning and daily monitoring on Seadrills Oracle Databases. These include,
? Instance Tuning
? Server Tuning (I/O tuning, Memory tuning etc.)
? SQL Tuning
? Daily Health Monitoring
IBM World Trade Corporation Sri Lanka. 5/2013 10/2013
Bharathi Airtel Sri Lanka
Worked as a Database Administrator for the IBM Client, Bharathi Airtel Sri Lanka and managing around 30 DB2 databases and...
Read More »
Technical Consultant - Oracle DBA
2013 - Present
Currently working onsite in Dubai for Seadrill as a technical consultant for Oracle Golden Gate Data replication solution and other database support activities.
Golden Gate Replication for...
IBM World Trade Co-opration
2013 - 2013
I was involved in providing database production support for more than 17 oracle databases and 30 IBM DB2 databases for Bharathi Airtel project. The tasks included daily database maintenance...
Associate Engineer - Specialist(DB)
2010 - 2012
Oracle E-Business Suite (12.1.3) H2R Implementation
Served as DBA for the Oracle E-Business Suite implementation of the H2R module for one year.The objective of the project was...