Liyanage Tharindu Dhaneenja Perera (MCSE,MCA, MCITP, MCTS, OCA)

Colombo, Sri Lanka.

Email: ac8jos@r.postjobfree.com

Mobile: +94-076*-***-***

http://www.databaseusergroup.com

https://lk.linkedin.com/in/dhaneenja

A professional and versatile Database Specialist (Consultant) with extensive industry experience with database management, data processing and analysis, design, and implementation of database and BI solutions in development, test, and production environments. Offer strong diagnostic skills, Performance optimization and the ability to quickly isolate and implement remedies for system failures. Experience in database cloud service and database container system (for windows & Linux). Seeking a challenging and fast paced assignment to leverage my strengths to become a successful and valued Database Specialist in a prestigious software development company where I can apply my professional expertise and training.

Key Accomplishments

• Engineering data archive system efforts focusing on performance enhancements, effectively increasing application efficiency.

• Live data migration with minimal system downtime.

• Led and implements a company-wide effort to draft, document, and implement database coding standards, training and database security policies.

• Migrate database to cloud and container system.

• Engineering database script & versing tool to fulfil DevOps evolution of database system.

• Engineering database container system for automatic deployment and installation.

• Engineering and Design Data management tool for application automation.

• Work and supported Database Administrator/Engineer in Production database for Saudi Arabia and Dubai stock broker system.

• Engineering and implements Database replicate for Saudi Arabia stock broker system. Community Experience

• Editor/Founder – Databaseusergroup.com

• Guest Columnist - sqlservercentral.com

• Member Since 2004 SQL Server user group Sri Lanka (sponsorship by Microsoft). Work Experience

Senior Tech Lead (Database) in Cambio Healthcare Systems (2010 - Present) I am currently working a Swedish company with a large Nordic customer base experience developing large-scale mission critical Database System.

During this tenure I have worked following main projects mainly based on Health care Module.

• Design and develop SQL Server Manual Handling T-SQL Process and released plan

• Design and develop data management processes and tool Using SSIS and T-SQL scripts

• Design and developing intelligent backup and restore tool for our internal database management.

• Design and develop report and ETL tool for JIRA issue track system for Cambio internal Management Using SSIS.

• Database technical document manage for Cambio internal and external.

• Monitoring, troubleshooting and Database supports for Cambio Internal and external Database Servers.

• Develop customer data migration tools using T-SQL scripts and SSIS.(UK team and Messenger mail system)

• Setup and manage database container system (Docker for windows & Linux)

• Internal POC for AWS with SQL Server.

• Design and developing SQL Server Integration Services(SSIS) project also knows as Cosmic Intelligent(CI)

• Design and developing Oracle Database Systems Project Cosmic performance conversion and archive scripts for Denmark Team.

• Design, developing database scalability project for Cambio.

• Engineering and Design Internal Database high availability solution.

• Develop script & tools Automate Tools using C#, Python and Power-shell. (Create VM, Create Docker Image, Backup Tools, Data Processing Tools) Previous Experience

Senior /Database Administrator– Directfn known as Mubasher NTG(2008 – 2010) One of the largest ICT companies in the Middle East, specializes in providing solutions ranging from Desktop Information Workstations, Transaction Systems and Order Management Systems through to total end to end solutions.

• Engineering and Design Database replication Saudi Arabia data centres using SQL Server 2005.

• Database Engineering, Management, and Design Logical and Physical Design Application Building Performance Tuning Query Optimization SQL Server Backup and Recovery Full System Development with windows and Linux including Oracle & SQL Server database systems.

Software Engineer – Softlogic Information Systems(2006 – 2008) Leading software and hardware solutions provider in Sri Lanka.

• Maintaining and totally responsible for all SQL Server database in Softlogic group.

• I have been Redesigned all input, reports and Develop Inventory Control System, Debtors System, and Creditors System, Help desk information system, job costing and automobile system, Menu reservation and fixed asset registry system relating to the VB6, SQL Server and Cristal Report and understanding its complete scope. Software Engineer – Delvon Computers (2006)

Junior software Programmer – IDM Software (2003 – 2005) Professional Qualifications

Duration Qualification Grade Institute/Examinations Body

Jan 2016 MCSE: Data Platform SQL 2014 Pass IDM Compute Studies Nov 2011 OCP Oracle Database 11g: Administration II

(1Z0-053)

Pass IDM Compute Studies

Sep 2010 OCA Oracle Database 11g: Administration I

(1Z0-052)

Pass IDM Compute Studies

May 2010 OCA Oracle Database SQL Certified Expert

(1Z0-047)

Pass IDM Compute Studies

Dec 2009 Microsoft certified IT Professional SQL

2008(70-453)

Pass IDM Compute Studies

Dec 2009 Microsoft certified IT Professional (70-443) Pass IDM Compute Studies May 2009 Microsoft certified IT Professional (70-444) Pass IDM Compute Studies December

2006

Microsoft certified technology specialist Pass IDM Compute Studies 2003-2004 Diploma in Computers Studies Distinction IDM Compute Studies 2001-2002 Computer Hardware Engineering. Complete Raytronics Computer Systems

(Pvt) Ltd

http://raytronicscomputers.tk

Tools/Technology Expertise

Application Software Microsoft Office

SQL Developer, SQL Navigator 5.5

Docker for windows & Linux

AWS

Databases Microsoft Access 2000/2003

SQL Server

Oracle

PostgreSQL

Languages/Technologies VB Script,

Visual Basic 6.0,

VB.NET,C#,ASP.NET,

SQL (PL-SQL and T-SQL),

HTML,

Crystal Reports

Python and PowerShell

Operating Systems Microsoft DOS

Windows 2000, XP

Windows NT Workstation 4.0

Windows NT Server

Linux – Ubuntu, Red Hat Enterprise Linux, Oracle Enterprise Linux REFEREES :

Furnished upon request

Contact this candidate