Pradeep De Silva

Experience Team Leader, Database Engineer with 13+ years of experience with administrating of Databases, Assign jobs for collogues and adopting their skill for career development of institution. Database Oracle, MySQL, MSSQL Server on Linux, Unix, windows platforms and handling of oracle engineered systems(Oracle Database Appliance) without any downtime and zero data loss objectives. Professional who is being specially applied his expertise in Banking, Finance sector environments. Overall experience is 23+ years of System Administration, Software development and Database Administration on his owned carrier path. Key Areas Currently Covering - - Oracle, MySQL, MSSQL Database Administration. - Oracle Database Appliance (X6-2HA). - Oracle Real Application Cluster.(RAC). - Oracle Golden Gate Replication tool. - Oracle Enterprise Manager 13c Cloud Control. - Oracle Active Data Guard.(ADG) - Oracle Automatic Storage Management.(ASM) - Data Backup and Recovery Software - Commvault - Data Backup and Recovery Software - HP Data Protector. - Oracle MYSQL Monitoring tool. - Oracle PL/SQL Developer. - Oracle SQl Developer. - Use of Oracle Linux, Redhat Linux, Windows o/s. - Linux Shell Scripting. - Data Warehouse Administration. Roles and Responsibilities - - Creating, Configuring and maintaining all databases required for live deployments, and testing. (Oracle10g, 11g, 19c, Mysql 5.6,5.7, MSSQL 2000-2005, 2014-2018) - Install new versions, patches and upgrades of the Oracle, Mysql and MySQL RDBMS. - Performance Tuning of all Oracle, Mysql and MSSQL Databases. - Plan and implement backup and recovery of the Oracle, Mysql and MSSQL databases. - Implement and enforce security for all of the Oracle, MYSQL and MSSQL Databases. - Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. - Maintain High Availability, clustering of databases. - Assists with impact analysis of any changes made to the database objects. - Install and maintain Database Client Software as required. - Maintain change management procedures. - Monitor capacity requirements regularly. - Monitoring Data Replication, Maintaining of RPO/RTO for all DB’s. - Carry out planned Disaster Recovery Drills. - Troubleshooting and resolving day-to-day problems related to databases. - Implement PCI-DSS, ISO20001 audit requirements for all Databases. Data Extraction, Transformation and Loading. - Train and share the knowledge with the secondary person as a fail over plan contributes to team effort by accomplishing related results as needed.