Assistant Lead Engineer - Database Developer (Software Development) (Ref 26357)

Jobline Resources Pte Ltd; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Jobline Resources Pte Ltd in Singapore is seeking an experienced Senior Database Migration Specialist to lead migrations from on‑premises to cloud‑managed PostgreSQL, MSSQL, and Oracle. You will design, optimize SQL code, and coordinate with application teams to minimize downtime.

Requirements include 8–10 years in database development and migration, strong SQL skills (T‑SQL/PL‑SQL), and hands‑on cloud experience (AWS/Azure).

Qualifications

• 8–10 years in database development and migration (MSSQL, Oracle, PostgreSQL).
• Strong SQL proficiency (T-SQL, PL/SQL) and scripting.
• Experience with cloud-managed DB services (AWS/Azure) and migration tools.

Responsibilities

• Lead migration/conversion from on-premises/cloud databases to PostgreSQL on cloud-managed services.
• Design and optimize SQL queries, stored procedures, triggers, functions.
• Collaborate with application teams to minimize downtime during migrations.
• Ensure database code meets performance, security, and governance standards.
• Diagnose and resolve performance bottlenecks and fine-tune deployments.
• Implement backup, recovery, and disaster recovery strategies.

Skills

SQL programming

Database migration

Cloud databases

PostgreSQL

MSSQL

Oracle

T-SQL/PL-SQL

Performance tuning

Security/compliance

DevOps tooling

Education

Bachelor’s degree in Computer Science or related field

Tools

MSSQL

Oracle

PostgreSQL

AWS DMS

Azure DB

PowerShell

Git

CI/CD

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