Asanka Prasad

Experience

• 

  Ceylinco Insurance Plc

  Nov 2004 - Mar 2009

  Executive Database Administration

  I was responsible for maintaining twenty three Oracle Databases island wide for the Insurance System of Ceylinco Insurance Company, and also I was responsible for, - Operating System installation for databases (Windows / Linux) - Install, Configure and upgrade oracle database related products - Database monitoring and performance tuning - Backup maintenance (RMAN) - Recover databases (Block corruption / table space corruptions etc...) - Working with Developers and Network Administrators to ensure high and overall database performance Show less

• 

  HNB Assurance PLC

  Apr 2009 - Feb 2012

  Database Administrator

  Team Leader of the Database UnitI am responsible for all the database related functions for smooth continuation of the business process. And also responsible for the protection of the invaluable data in the company, their availability and the system performance when we retrieve them. And I had to plan for the business continuity when a in a disaster. Data security also has to be verified. And also to present those data to the management in an understandable and stylish manner for their decision making (Business Intelligence). Meanwhile, always have to research and plan for implementing new database related technologies.Regular Works,- OS installation, optimization for databases- Database installations, configuration upgrade- Monitoring backups (RMAN) and restoring in a remote location- Performance tuning.Projects Handled- Upgraded production oracle database from 9i to 10g.- Migrated databases Operating Systems from Windows 2000 to RHEL 5- Upgraded database from 10g to 11g- Oracle Real Application Cluster- Oracle Data Guard- Implemented a disaster recovery solution for the company- Application cluster for WebLogic Application server with Red Hat Cluster suit. Show less

• 

  Millennium IT

  Feb 2012 - May 2015

  Technical Analyst

  Manage Oracle database administration assignments for diverse industry clients such as banking, insurance , finance ,telecommunication etc. Enhance database performance, implement recovery procedures and conduct regular system backups to ensure database high availability and trusted protection on their critical data. Ensure technical and functional designs meet their business requirements.

• 

  V S Information Systems (Pvt) Ltd

  Jun 2015 - now

  Managing and providing solutions relate with Oracle database administrations for various industries.

  • Manager - Enterprise Data Management

    Apr 2018 - now

  • Assistant Manager - Technical Services

    Jun 2015 - Mar 2018