Yasas Pathirana
Tauranga
Summary
I am a highly motivated self-starter with a true passion for Database development, Data Analysis and Data Engineering along with advanced knowledge in Database management, Data Analysis (DAX) and SQL .With successful completion of Microsoft (MCSA) and Oracle certifications , I believe my skills can contribute to a company's future goals. Which will make me a valuable asset to any organization.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Application Support Analyst (Contract)
Xplor Limited
07.2023 - 10.2024
- Using MS SQL and T-SQL to provide solutions to client’s issues
- Monitoring Kubernetes environments to check the service status
- Splunk alert monitoring and providing resolutions (with the help of development team)
- Monitoring the RabbitMQ environment to publish and transfer messages / error messages
- Collaborating with clients, stakeholders, and dev team to discuss about the requests , updates, and solutions
- Using Postman software to process refunds , merchant onboarding and various other tasks
SQL Developer (Intermediate)
Tally group
07.2022 - 04.2023
- SQL scripts development such as Procedures, functions , triggers, etc
- API Development for various Business requirements
- Assisting Software developers , QA testers queries related to business requirements and technical information (SQL related queries)
- Enhanced data retrieval processes with efficient SQL coding practices.
- Resolving tickets issues by the client in day-to-day operations
Engineer -Technology
Virtusa (PVT) LTD
01.2019 - 11.2019
- Procedure, package, function, Trigger creation using PL/SQL
- SQL query writing
- Performance tuning
- Data Migration from Oracle EBS to Fusion
- Shell scripting for database documentation
- Data Integration using Talend Software
Trainee Database Engineer
Interblocks Limited
01.2018 - 12.2018
- Oracle, DB2 database migration to production databases
- Installation, Administration, Backup, Recovery, and performance tuning of Oracle, DB2 and PostgreSQL
- Procedure, package, function, Trigger creation using Oracle DB2, PostgreSQL databases
- Oracle to DB2, PostgreSQL database migration (Conversion)
- Creation of automated DML, DDL scripts for PostgreSQL database
- Job creations for Oracle, DB2 databases to purge high growth tables
Junior Database Administrator (Intern)
John Keels Computer Services
10.2017 - 01.2019
- Oracle Database migration
- Procedure, package, function, Trigger creation using Oracle and SQL server databases
Education
New Zealand Level 7 Diploma - Technology Management
Aspire2 International
Tauranga, NZ11-2020
BSc - Information Technology
Sri Lanka Institute of Information Technology
09-2019
Skills
- Procedure
- Function
- DAX
- Triggers
- Oracle
- SQL Server
- DB2
- PostgreSQL
- MySQL
- Database designing
- Data Analysis (Power BI)
- Performance tuning
- Linux / Windows Operating System
- Azure Data Lake
- ETL pipelines
- Azure Database
- Microsoft Excel
- PIVOT tables
- Java
- Postman
- Kubernetes
- Splunk
Certification
- Microsoft PL-300 Power BI Data Analyst Associate
- Microsoft DP-900 Azure Data Fundamentals
- MCSA: SQL Server 2016 Database Development
- Microsoft 70-761: Querying Data with T-SQL
- Microsoft 70-762: Developing SQL Databases
- Oracle 11g SQL Expert (Oracle Testing ID – OC1745105)
Timeline
Application Support Analyst (Contract)
Xplor Limited
07.2023 - 10.2024
SQL Developer (Intermediate)
Tally group
07.2022 - 04.2023
Engineer -Technology
Virtusa (PVT) LTD
01.2019 - 11.2019
Trainee Database Engineer
Interblocks Limited
01.2018 - 12.2018
Junior Database Administrator (Intern)
John Keels Computer Services
10.2017 - 01.2019
New Zealand Level 7 Diploma - Technology Management
Aspire2 International
BSc - Information Technology
Sri Lanka Institute of Information Technology
Similar Profiles
Mallory SneedMallory Sneed
Daycare Assistant at Xplor EducationDaycare Assistant at Xplor Education
Mariah DaughtryMariah Daughtry
Lead Toddler Teacher at XPLOR Preschool and School Age CareLead Toddler Teacher at XPLOR Preschool and School Age Care
Dominique NarivaDominique Nariva
People Coordinator APAC at Xplor TechnologiesPeople Coordinator APAC at Xplor Technologies