Data Engineer

Company Overview

TroyTech International Consulting Pte Ltd is a Singapore-based consulting firm specializing in SOA, EAI, JEE technical support, web and mobile solutions, and business integration with IBM and open source software. It serves Financial, Transportation, and Government sectors across APAC.

Job Summary

You will design, implement, administer, and monitor databases to ensure efficient and secure operations. You will manage incidents and requests within SLAs, collaborate with development teams, and work with vendors to resolve database issues proactively.

Responsibilities

• Design, implement, document, administer, and monitor databases to ensure efficient and secure database operations
• Own, track, and resolve database-related incidents and requests within Service Level Agreements (SLAs)
• Review daily service-related reports such as database backups, maintenance, and monitoring to ensure system health
• Respond promptly to database alerts and collaborate with vendors and stakeholders to resolve issues
• Manage and resolve database issues in alignment with SLAs, escalating unresolved problems proactively
• Maintain clear communication with development teams to update on request statuses and changes
• Initiate and perform changes on Non-Production systems to support development and testing activities
• Implement operational automation using scripts and shell scripting to improve database management efficiency
• Write and implement Stored Procedures, PL/SQL, and SQL to support database functionality and performance

Required competencies and certifications

• Minimum 5 years of experience in Database Administration
• Experience administering DB2 (version 10 onwards), Oracle Server (version 11 onwards), and PostgreSQL (version 14 onwards) databases
• Experience troubleshooting and resolving database problems to maintain system stability
• Experience in Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools, including index management and statistics
• Experience with backups, restores, and recovery models to ensure data integrity and availability
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for DB2, Oracle Server, and PostgreSQL
• Experience working with Windows, AIX, Linux, and Solaris server environments

Preferred competencies and qualifications

• Bachelor’s degree in a technical field such as engineering, data communications, or computer science
• Knowledge or experience with SQL Database servers and MySQL
• Experience in data modeling, including performing, managing, and validating Data Model creation using ERWIN or equivalent tools
• Experience with cloud database computing environments

Other Information

• Responsibilities include occasional work during evenings and weekends