Thilina Rathnasiri
Mirihana,Nugegoda
Summary
19+ years of experience in Database Administration, ERP Applications, and Enterprise Automation. Expert in managing mission-critical Oracle and SQL Server platforms, driving security governance, and pioneering AI-driven orchestration systems. Passionate about researching and applying emerging technologies such as agentic AI, automation platforms, and intelligent workflow orchestration to transform IT and business operations.
Overview
24
24
years of professional experience
1
1
Certification
Work History
AVP – Database Administration & ERP Applications
Softlogic Life Insurance PLC
01.2019 - Current
- Directed SQL optimization projects, cutting execution times of core systems and boosting scalability.
- Designed and implemented Always On Availability Groups and Oracle RAC/Data Guard, ensuring maximum uptime.
- Enforced data encryption, auditing, and compliance frameworks to safeguard sensitive data (insurance, financial).
- Migrated SQL Server environments from 2008 Enterprise to 2022, improving performance and security posture.
- Championed the integration of open-source IT Asset Management systems for better visibility and control.
- Collaborated with vendors and internal audit teams to align IT infrastructure with risk, compliance, and governance standards.
- Pioneered AI-driven automation by implementing an n8n-based agentic orchestration platform, enabling enterprise-wide workflow automation and AI-assisted decision-making for IT and business operations.
- Researched and piloted an AI-enabled DBA Assistant, integrated with monitoring systems to provide predictive insights, performance recommendations, and anomaly detection.
Senior Manager – Oracle ERP Applications & DBA
Asian Alliance Insurance PLC
01.2013 - 12.2018
- Managed Oracle E-Business Suite (EBS) R12 environments including upgrades, patching, and cloning.
- Migrated multiple EBS and non-EBS databases to Oracle Exadata X4-2 Eight Rack environment.
- Deployed and administered Oracle Audit Vault (AVDF 12.1.1) ensuring governance and audit compliance.
- Configured and maintained Oracle Enterprise Manager Cloud Control 12C and Exadata systems.
- Implemented Oracle Data Guard for EBS and 11g environments.
- Automated DBA tasks with shell scripting and job scheduling at OS/DB level.
- Performed cold/hot backups, recovery procedures, and query optimization.
- Worked with Oracle MetaLink (SRs) to troubleshoot and resolve critical incidents.
Oracle DBA / Network Engineer
Asian Alliance Insurance PLC
01.2010 - 12.2012
- Installed and maintained EBS R12 with Oracle Data Guard in production.
- Implemented RMAN backup/recovery strategies.
- Administered critical patch updates for Oracle Linux and EBS.
- Automated day-to-day DBA activities with scripting.
Network Engineer
Asian Alliance Insurance PLC
01.2006 - 12.2009
- Secured corporate network with content filtering, anti-spam, and firewall controls.
- Administered Active Directory, Exchange, and WAN environments.
- Implemented GLPI + OCS Inventory for IT asset management.
System Administrator
Siva Computers & Electronics Co. Ltd.
01.2002 - 12.2005
- Maintained Linux server security standards and handled ISO audit compliance.
- Performed penetration testing and vulnerability assessments (Nessus, Metasploit).
- Designed open-source solutions for enterprise (virtualization, CMS, monitoring, gateways).
Education
MSc - Information Systems Management
University of Colombo
01.2015
Skills
- SQL Server Always On
- Oracle RAC
- Data Guard
- Exadata
- Oracle EBS R12
- Azure SQL Database
- Oracle Cloud
- Agentic AI
- N8n Orchestration
- RAG
- AI-driven DBA Monitoring
- Low-Code Automation
- Access Control
- Database Security Strategy
- Data Encryption
- Regulatory Compliance
- Vulnerability Assessment
- Enterprise IT Roadmaps
- Team Leadership
- Workflow Optimization
- Digital Transformation Initiatives
- PL/SQL
- T-SQL
- PowerShell
- Bash
- Python
- Azure DevOps
- Git
Certification
- Microsoft Azure Fundamentals AZ-900, 2022
- Azure Data Fundamentals
- Oracle Cloud Infrastructure Certified Architect Professional, 2019
- Oracle Exadata Administrator (X3/X4), 2017
- Oracle Database OCA / OCP 12c
- Oracle E-Business Suite R12 Applications DBA
- Certified Ethical Hacker (CEH), 2010
- Cisco CCNA, 2013
- Microsoft Certified IT Professional – Enterprise Administrator
- Microsoft Certified Systems Engineer, 2003-2008
- CompTIA A+
Core Competencies
SQL Server Always On, Oracle RAC & Data Guard, Exadata, Oracle EBS R12, Azure SQL Database, Oracle Cloud, Agentic AI, n8n Orchestration, RAG, AI-driven DBA Monitoring, Low-Code Automation, Access Control, Database Security Strategy, Data Encryption, Regulatory Compliance, Vulnerability Assessment, Enterprise IT Roadmaps, Team Leadership, Workflow Optimization, Digital Transformation Initiatives, PL/SQL, T-SQL, PowerShell, Bash, Python (Automation/AI Integration), Azure DevOps, Git
Key Research And Innovation Initiatives
- Agentic AI for Enterprise Operations, Researched and prototyped the use of agentic AI systems to analyze PRs, database changes, and IT workflows—enabling automated recommendations for performance tuning, normalization, and security checks.
- AI-Assisted DBA Monitoring, Developed a framework to integrate AI into SQL Server and Oracle monitoring—capable of detecting slow queries, identifying schema bottlenecks, and suggesting optimizations in real-time.
- Workflow Orchestration with n8n, Designed research-backed agentic orchestration models using n8n, blending AI with automation to bridge IT operations and business process automation across Softlogic Life.
- RAG-based Knowledge Systems, Explored (RAG) for enterprise knowledge management, ensuring contextual decision-making for DBA and IT operations.
- Security & Compliance Automation, Researched and piloted methods to use automation for continuous compliance checks, auditing, and alerting at organizational scale.
Publication
http://it-toolkit.blogspot.com/
Timeline
AVP – Database Administration & ERP Applications
Softlogic Life Insurance PLC
01.2019 - Current
Senior Manager – Oracle ERP Applications & DBA
Asian Alliance Insurance PLC
01.2013 - 12.2018
Oracle DBA / Network Engineer
Asian Alliance Insurance PLC
01.2010 - 12.2012
Network Engineer
Asian Alliance Insurance PLC
01.2006 - 12.2009
System Administrator
Siva Computers & Electronics Co. Ltd.
01.2002 - 12.2005
MSc - Information Systems Management
University of Colombo