Assistant Lead Engineer - Database Developer (Ref 26357)

JOBLINE RESOURCES PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

JOBLINE RESOURCES PTE. LTD. in Singapore seeks an experienced Database Migration Engineer to lead MSSQL/Oracle to PostgreSQL migrations on cloud-managed platforms (AWS/Azure).

You will design and optimize SQL queries and ensure data integrity while coordinating with application teams to minimize downtime. The ideal candidate has 8–10 years in database development and migration, strong SQL/T-SQL/PL-SQL skills, and hands-on experience with cloud DB services and data-movement tools.

Qualifications

• Bachelor's degree in CS or related field with 8–10 years in database development and migration (MSSQL/Oracle/PostgreSQL).
• Hands-on database developer with strong SQL programming skills.
• Proficiency in SQL, T-SQL, PL/SQL, and scripting languages.
• Experience with performance tuning, security/compliance, and cloud DB services.
• Experience with MSSQL, Oracle, or PostgreSQL on cloud platforms.

Responsibilities

• Lead migration and conversion of on-premises/cloud databases to PostgreSQL on cloud-managed services.
• Design and optimize SQL queries, stored procedures, triggers, and functions in MSSQL/Oracle/PostgreSQL.
• Collaborate with application teams to minimize downtime during migrations.
• Ensure database code meets performance, security, and coding standards.
• Configure and manage cloud-managed DB services across AWS and Azure.
• Implement backup, recovery, and disaster recovery aligned to RPO/RTO objectives.
• Design high availability and scalability patterns.
• Maintain migration runbooks, schema mappings, and conversion logic.

Skills

SQL programming

T-SQL

PL/SQL

Database design

Performance tuning

Security compliance

Cloud DB services

AWS RDS

Azure SQL

PostgreSQL

MSSQL

Oracle

Data migration

DevOps for DB

CI/CD pipelines

Documentation

Communication

Education

Bachelor's degree in computer science or related field

Tools

AWS DMS

AWS Glue

AWS Athena

Backup utilities

Data Pump

PowerShell

Git

Job description

Responsibilities

• Lead migration and conversion of on-premises / cloud databases (MSSQL, Oracle) to PostgreSQL on cloud-managed database services
• Design, develop, and optimize SQL queries, stored procedures, triggers, and functions in at least one of: MSSQL, Oracle, or PostgreSQL
• Collaborate with application teams to ensure seamless integration, data integrity, and minimal downtime during migrations
• Ensure database code meets performance, security, and coding standards
• Diagnose and resolve performance bottlenecks (query plans, indexing, I/O, memory utilization)
• Implement indexing strategies, partitioning, and query optimization techniques tailored to MSSQL, Oracle, or PostgreSQL on cloud-managed platforms
• Monitor and fine-tune performance post-migration using native cloud tools
• Configure and manage cloud-managed database services across AWS and Azure for MSSQL, Oracle, and PostgreSQL workloads
• Implement backup, recovery, and disaster recovery strategies aligned to RPO/RTO objectives
• Design and support high availability and scalability patterns
• Enforce security (encryption, IAM roles, least privilege) and governance best practices
• Maintain migration runbooks, schema mappings, and conversion logic
• Produce reports on migration progress, performance metrics, and cost optimization
• Communicate updates and risks clearly to stakeholders
• Implement database security policies and access controls
• Stay current with security threats and apply patches/updates as needed

Requirements

• Bachelor's degree in computer science or a related field with 8-10 years of experience in database development and migration for MSSQL, Oracle, and PostgreSQL
• Must have hands-on experience as a database developer with strong skills in SQL programming
• Proficiency in SQL, T-SQL, PL/SQL, and scripting languages
• Strong understanding of database design principles
• Experience with database performance tuning and optimization
• Knowledge of database security and compliance requirements
• Exposure to database administration tasks on MSSQL, Oracle, or PostgreSQL is preferable
• Excellent problem-solving and troubleshooting skills
• Ability to work independently and collaboratively in a team
• Effective communication and documentation skills
• Proven experience in database conversion from MSSQL and Oracle to PostgreSQL in cloud environments
• Strong knowledge of database architecture, design principles, and performance tuning
• Hands-on experience with cloud-managed database services (AWS RDS/Aurora, Azure SQL Database, Azure Database for PostgreSQL)
• Experience with data migration and movement tools, including on-premises database tools (e.g., Backup utilities, Data Pump) and cloud services (e.g., AWS DMS, AWS Glue, AWS Athena)
• Familiarity with DevOps tools and automation for database deployments (PowerShell, Git, CI/CD pipelines)
• Understanding of cloud infrastructure components (networking, load balancers, virtualization) and commercial cloud platforms (AWS, Azure)
• Experience supporting high-availability production systems in cloud environments is advantageous
• Software development experience in any programming language is a plus
• Strong analytical and critical thinking skills with a service excellence attitude
• Ability to work independently and collaboratively with Senior Application DBAs and application teams
• Excellent verbal and written communication skills for interaction with technical and business stakeholders
• Certifications in MSSQL, Oracle and PostgreSQL database developer
• Experience with cloud-based database services (e.g., AWS RDS, Azure Database)
• Experience on database migration and replication technologies

Licence no: 12C6060