Senior Technical Lead

• Oct 2021 - Present

ProjectsOct 2021 - To date Trintech - ADRA - Financial closure Application suite DBA Consultancy for SASOPS team on critical operational issue. Re engineering the existing app lication DB’s (Azure SQL) while adhering to best practicestandards. Provide the consultancy for developers on DB related enhancements. DB Optimization on Azure SQL Server Instances Introduce SQL server partitioning and archiving techniques to reduce the operational data load. PII data masking script preparation.

Lead Database Consultant

• Sep 2012 - Oct 2021

ProjectsJun 2020 - Oct 2021 - British Telecom - Tech Lead ORACLE DB (RAC instances) maintenance , performance tuning including On Call support CR/SR support while adhering to BT P roces s and S ecu rity S ta nda rds. DB migra tion fr om 1 2c to 19 c / planning and provide consultancy for dev / ASG TeamsMar 2020 - Jun 2021 - M &T Bank - Senior DBA 3 rd line DB Incident support for 88 application with 80 + SQL Server DB’s AlwaysONclustering / Log shipping / Transactional Replication ) & 30+ Oracle DB’s( RAC / DG / ASM B ackup & restoration issue / Scheduled Job issues / Node failures / Perf ormance issues etc. SSIS ETL development, Deployment, troubleshooting and administration . SSRS Design, Deployment & administration. Consultancy for the development teams  DB design activities / capacity Estimation / migration planning / Change Implementation.May 2017 – Mar 2020 - Gowireless Inc. - DBA/ DB Architect. Administrating the 3 SQL server 2016 production instances hosted in AWS and Azure. Transactional Replication / SSRS administration. SSRS report creation / SSIS package creation. Estimation and solution design for new projects.  SQL server managed services (PaaS) migration.Jul 2016 – Dec 2018 - CSG International - DBA /Tech Lead Oracle RAC and DB maintenance and Support for 6 Telco clients.  RMAN backup scheduling and maintenance.  Troubleshoot the performance issues in Oracle DB.  Provide guidance, Training for support team on DB issues for over 50 Telco clients.  Support for IIS serves and SQL server DB’s.  Attended to project transition in Switzerland.Sep 2012 – Jul 2016 - British Telecom - DBA/ Tech Lead ORACLE DB maintenance, Support and performance tuning including on-call support on highly critical production DB’s. Database migration - 9i to 11g / 10g to 11g. Worked in India for 1 and half months during the project transition.

Database Administrator

• Mar 2012 - Oct 2012

 Administration, Support, troubleshooting, Performance tuning on ORACLE/MySQL DB’s. Backup / Recovery work on ORACLE and MySQL DB’s. Query SQL Tune-up and DB / Query support for the Developers. Legacy system data migration. Worked in Cloud environment (AWS).  Administration, Support, troubleshooting, Performance tuning on ORACLE/MySQL DB’s. Backup / Recovery work on ORACLE and MySQL DB’s. Query SQL Tune-up and DB / Query support for the Developers. Legacy system data migration. Worked in Cloud environment (AWS).

Database Administrator

• Mar 2010 - Mar 2012

Technical Support Engineer

• Mar 2007 - Dec 2009

 Worked on an Oracle Database/E-biz DBA team, Providing support & consultancy for multiple customers such as Sri Lanka Ports Authority, Sri Lanka Army, Sri Lankan Air Lines in multiple domains.- This includes, Installing, configuring, performance tuning, Oracle Database/Applications/Tools for optimal performance & implementing solid DR/ Backup methods and 24*7 support. Controlling, risk mitigating, executing & managing projects in migration of Oracle E-biz & Databases. Implemented first ever Oracle Virtualization project in Sri Lanka for Sri Lankan Air lines.