Database Administrator

Home

People

ID : 1019

Education level : Bachelor's degree

Work experience level : Experienced- (4-7 year experience)

Work experience in total : Years

Job type : Online

Job time : Maandelijks

Last date of registration :

2022-11-23

Database administrator with 4+ years of experience in administering, supporting, and troubleshooting in the field of Oracle, MySql, AWS including High Availability and Disaster Recovery Solutions. Comprehensive practical knowledge in
Database Management Systems Architecture and performance monitoring, diagnostic, Backup and Recovery database.

Database Administrator - V S Information Systems (Pvt) Ltd - (Jul 2021 - Present)

Responsible for managing Mission-critical, highly transactional RAC cluster farms Banks, Financial institutes, and Telcos.
Engage in Database Patching, troubleshooting, performance tuning, and migration activities (Oracle and MySQL different versions).
Managing database running on Oracle 12c/18c/19c comprising staging, preproduction, production & disaster recovery.
Configured MySQL InnoDB and Group Replication on AWS & On-Prem Datacenters.
Implement Backup and Recovery strategies on Oracle environments.
Engage in monthly deployments releases and work closely with development teams, focusing also on security compliance & availability.
Perform daily health check reports & proactive diagnosis monitoring and housekeeping tasks.
Configured and managed backups using the Commvault backup tool for SriLankan Airlines.
Database fine-tuning using Explain Plan and analysis tools, monitor performance, and identify bottlenecks.
Monitoring indexes and analyzing their status for performance tuning and query optimization.

Database Administrator - Pearson Lanka (Pvt) Limited - (Oct 2018 - Jul 2021)

Responsible for managing Mission-critical, highly transactional RAC cluster farms having up to 6 nodes hosted in the USA data centers.
Engage in Database Patching, troubleshooting, performance tuning, and migration activities (Oracle and MySQL different versions)
Managing over 200 database single instances running on Oracle 10g/11g/12c/18c/19c and MySQL 5.x/8 comprising staging, pre-production, production & disaster recovery.
Administration & Migration of On-Prem DB’s to AWS RDS, EC2 Instances.
Administration of MySQL InnoDB/NDB clusters in AWS & On-Prem Datacenters.
Implement Backup and Recovery strategies on Oracle/MySQL environments
Engage in monthly deployments releases and work closely with development teams, focusing also on security compliance & availability.
Perform daily health check reports & proactive diagnosis monitoring and housekeeping tasks while adhering to ITIL practices.

Database Administrator Intern - Pearson Lanka (Pvt) Limited - (Feb 2018 - Sept 2018)

Software Engineering Intern - Orange IT Solutions - (Mar 2016 - Oct 2016)

Oracle Real Application Cluster
RMAN / EXP /EXPDP
AWS RDS / EC2
Oracle Data Guard
MySql - Inno/NDB Cluster
MSSQL / NoSQL

Oracle Database 12c AdministratorCertified Associate (2019)
Oracle Database SQL Certified Associate(2019)
Microsoft Certified Azure Fundamentals(2020)
Oracle Cloud Infrastructure 2021Certified Architect Associate
Oracle Cloud Infrastructure 2021Certified Architect Professional
AWS Certified Solutions Architect -Associate (2021)

Administering, supporting, and troubleshooting Database Patching, troubleshooting, performance tuning, and migration activities, Implement Backup and Recovery strategies, skills: Oracle Real Application Cluster, RMAN / EXP /EXPDP, AWS RDS / EC2, Oracle Data Guard, MySql - Inno/NDB Cluster, MSSQL / NoSQL