Prabash Dassanayaka
Auckland,New Zealand
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior Database Administrator
GTN Technologies (GTN Tech)
01.2023 - 07.2024
- Troubleshooting database issues, attending to faults, carrying out detail analysis of issues, applying corrective action/workarounds, Automating day-to-day operational activities (reduced weekly alerts by 80%).
- Coordinated with application developers to optimize query performance, ensuring seamless integration between databases and applications used throughout the company (AWS cost saving 50% per database server).
- Implemented robust backup strategies to safeguard essential data against potential loss or corruption incidents.
- Provided expert advice on database design, leading to improved efficiency and scalability in new projects.
- Implemented BI solution framework for business intelligence projects.
- Implemented security measures to protect vital business data.
- Ensured high availability of critical databases by implementing proactive monitoring and disaster recovery strategies.
- Developed comprehensive documentation of database systems, facilitating knowledge sharing among team members and improving training initiatives.
- Optimized database performance by conducting regular maintenance and implementing best practices.
- Facilitated strong communication between IT departments and business stakeholders through clear reporting on key metrics related to database health and performance indicators.
Database Administrator
Dialog Axiata PLC
11.2012 - 12.2022
- Perform regular Health Checks on all critical databases.
- Focused on uptime, stability & performance.
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
- Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Implemented BI solution framework for business intelligence projects.
- Reduced operational costs by identifying and decommissioning underutilized database resources.
- Contributed to successful audits, ensuring full compliance with data governance and regulatory requirements.
Instructor
Department of Computer Engineering, Faculty of Engineering, University of Peradeniya
09.2011 - 10.2012
- Conducting lab classes and tutorials and marking assignments in courses offered to undergraduate students who follow the BSc Engineering degree programme in Computer Engineering.
Education
Bachelor of Science - Computer Engineering
Faculty of Engineering,
University Of Peradeniya. 2011
Master of Business Administration -
University of Colombo
2021
Skills
- Installing, configuring and supporting EDB PostgreSQL, Oracle, MSSQL, MySQL databases
- Perform Oracle to EDB PostgreSQL database migration
- Configure and manage high availability of EDB PostgreSQL database using EFM, Oracle RAC & replication
- Database upgrade, patching and performance tuning
- Configuring ETL tools Taland Open Studio, AWS Glue
- Database backup and recovery (Oracle RMAN, EDB BARMAN, native methods)
- Troubleshoot and provide 24 x 7 support for business-critical databases
- Data migration between different platforms and Oracle versions (oracle 10g/11g/12c/19c)
- Data migration between different platforms and PostgreSQL versions (v12/v13/v14/v15/ v16)
- Writing PL/SQL and shell scripting (bash)
Extracurricular Activities
Captain table tennis team, Dialog Axiata PLC - 2015-2016 Junior treasurer of the Sports Council, UOP - 2010/2011 Captain of the table tennis team, UOP - 2010/2011 Committee member of Association of Computer Engineering Students (ACES 2010)
Availability
Immediate
References
References will be furnished upon request.
Certification
- Microsoft Certified: Azure Fundamentals (AZ-900), 08/2024, 1100049567
- AWS Certified Solution Architecture Associate, 12/2019, AWS01871971
- Oracle Certified Associate 11g (OCA), 2014
- Cisco Certified Associate (CCNA), 2012
Training
- PostgreSQL Essentials v16, 07/2024
- EDB Postgres Advanced Server Database Administration Essentials and Advanced Custom, 10/2018
- Oracle 11g training, 06/2016
- WebLogic Administration, 05/2016
- Exadata Database Machine 12c Administration Workshop Ed 2, 12/2016
- Certified Lead Implementer Professional for ISO22301 Business Continuity Management System, 2015
Timeline
Senior Database Administrator
GTN Technologies (GTN Tech)
01.2023 - 07.2024
Database Administrator
Dialog Axiata PLC
11.2012 - 12.2022
Instructor
Department of Computer Engineering, Faculty of Engineering, University of Peradeniya
09.2011 - 10.2012
Bachelor of Science - Computer Engineering
Faculty of Engineering,
Master of Business Administration -
University of Colombo
Similar Profiles
YEHAN FERNANDOYEHAN FERNANDO
Assistant Manager - Group Risk and Compliance at GTN TechnologiesAssistant Manager - Group Risk and Compliance at GTN Technologies
DHANUSH VARSHINI. MDHANUSH VARSHINI. M
Project Officer & Business Development at GTN ENGINEERING (INDIA) LIMITEDProject Officer & Business Development at GTN ENGINEERING (INDIA) LIMITED
TYLER CAMPBELLTYLER CAMPBELL
Project Lead, RunOps at HCL – GTN Site on assignment at MetaProject Lead, RunOps at HCL – GTN Site on assignment at Meta