Assistant Lead Engineer - Database Developer (Software Development)

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

Job summary

Jobline Resources Pte Ltd is seeking an experienced Database Migration Engineer to lead migrations from MSSQL/Oracle to PostgreSQL in cloud environments. You will design, optimize, and secure database code while coordinating with product teams to minimize downtime.

The role requires deep expertise in SQL programming, performance tuning, and cross‑platform database design, with hands‑on experience in cloud services like AWS and Azure.

Qualifications

• Bachelor's degree in computer science or a related field with 8–10 years of experience in database development and migration.
• Hands‑on experience as a database developer with strong 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.
• Familiarity with MSSQL, Oracle, and PostgreSQL across cloud environments.
• Certifications in MSSQL, Oracle and PostgreSQL database development.

Responsibilities

• Lead migration and conversion of on-premises/cloud databases (MSSQL, Oracle) to PostgreSQL on cloud services.
• Design and optimize SQL queries, stored procedures, triggers, and functions in MSSQL/Oracle/PostgreSQL.
• Collaborate with application teams to ensure data integrity and minimal downtime during migrations.
• Ensure database code meets performance, security and coding standards.
• Diagnose and resolve performance bottlenecks (queries, indexing, I/O, memory).
• Implement indexing, partitioning, and query optimization on cloud platforms.
• Monitor post-migration performance using native cloud tools.

Skills

SQL programming

MSSQL

Oracle

PostgreSQL

Data migration

Performance tuning

Cloud databases

DB design principles

Scripting (PowerShell)

Education

Bachelor's degree in computer science or related field

Tools

AWS DMS

Azure Database for PostgreSQL

AWS RDS/Aurora

Backup utilities

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