Database Engineer

Home

People

Database Engineer

ID : 1022

Education level : Bachelor's degree

Work experience level : Expert- (more than year 7)

Work experience in total : Years

Job type : Online

Job time : Maandelijks

Last date of registration :

2022-11-23

Experienced Database Engineer with over 8 years extensive industry experience and demonstrated history of working in domains such as HRIS, Telecommunication, Hospitality, Aviation, Transportation, and banking in the software industry. Repeatedly successful in navigating complex technical environments and possess strong PL/SQL expertise in stored procedures, performance tuning and optimization. Exceed ongoing and overlapping deadlines in fast paced environments, handle multiple assignments simultaneously and coordinate deliverables with key stakeholders in cross functional groups.

Senior Database Administrator - KALERIS: Colombo, Sri Lanka - (October 2019 - Present)

Maintain reliability, stability and data integrity of the databases. Provide support in the administration, backup, integrity and security of various SQL databases. Continually assess, improve, and optimize current database environment.
AWS database migration Oracle to Postgres and post migration database tuning
Postgres and Oracle data archive scripting and configurations
Optimize database by automating vacuum and analyze jobs
Creating and managing RDS classes, storage, enabling high-availability, encryption, cross region backups
Monitor performance of database systems resources, query throughput and optimize
Optimize SQL Code by analyzing execution plan and tuning advisor, apply profiles if needed
Monitor and maintain database storage resources
Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
Oracle database Installation, Upgrades, Migrations and Configuration
Trouble shoot and resolve database connectivity issues
Follow Change Management processes to implement database configuration changes
On-call requirements to ensure 24 x 7 support of database operations

Database Engineer - Hitachi Digital Payment Solutions: Colombo, Sri Lanka - (March 2018 - October 2019)

Developing and maintaining database related tasks for electronic payment processing solutions that empower Banks & Financial Service Providers across global markets. ATM and POS systems.
Experience in working with VISA, Master Card, Union Pay, etc.
Developing packages, procedures, triggers and required queries in PLSQL, DB2, PostgreSQL and
MySQL for application.
Ensure data integrity and quality in database systems.
Proficient in database performance tuning in Oracle, DB2, PostgreSQL, MySQL.
Assist in designing and development of database systems
Expertise in Data Migrations: migration scripting, testing and performance tuning (Including Cross DB: Oracle to DB2, Oracle to PostgreSQL, MySQL)
Resolving customer and developer related issues in databases.
Highly proficient in SQL/PLSQL and business reports creation using financial data.
Proficient in working with OS like - Red Hat, CentOS, Oracle Linux, Windows.
Monitoring Oracle, Postgres & DB2 Database performance and identify SQL errors, bugs occurring from C and Java modules.
Shell/Perl basic Programming tasks.

Associate Database Administrator - John Keels IT Colombo, Sri Lanka - (November 2015 - February 2018)

Developing database functions, scripts, stored procedures and triggers to support application development.
Provide database solutions based on technical documents and business requirements.
Provide technical assistance to resolve all database issues related to performance, code issues, capacity and access.
Provide scripts for database migration and monitoring performance.
Optimize database systems for performance and reliability.
Prepare documentations regarding database design, configuration and change management tasks.

Implementation Engineer - Hsenid Business Solutions Colombo, Sri Lanka - (November 2013 - December 2015)

Implementing product at client site.
Conducting product walkthrough training
Taking ownership of database related technical issues and solving them
Working with the development group to resolve more advanced issues when necessary
Resolving escalated customer complaints without the need for team lead intervention

Expertise in: PostgreSQL, Oracle database development and database architecture
Specialties: Oracle, PostgreSQL, SQL Server, MySQL, IBM-DB2, CouchDB, MongoDB, AWS, UNIX, Linux, Python, Cassandra, RDS, EC2, S3, Power BI

Following MSc in Big Data Analytics, Skills: Expertise in- PostgreSQL, Oracle database development and database architecture | Specialties: Oracle, PostgreSQL, SQL Server, MySQL, IBM-DB2, CouchDB, MongoDB, AWS, UNIX, Linux, Python, Cassandra, RDS, EC2, S3, Power BI