Assistant Lead Engineer Database Developer (software Development)

Singapore, Singapore

Job Description

Position Overview
This role focuses on MSSQL, Oracle, and PostgreSQL database programming. The engineer will work closely with Senior Application DBAs and application teams to manage and implement database deliverables, ensuring high-quality migration and development in cloud-managed environments.
Role & Responsibilities

  • Database Development & Migration
  • 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
  • Performance Tuning & Optimization
  • 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
  • Cloud Database Management
  • 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
  • Documentation & Reporting
  • 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
  • Security & Compliance
  • Implement database security policies and access controls
  • Stay current with security threats and apply patches/updates as needed
Requirements
  • 8-10 years of experience in database development and migration for MSSQL, Oracle, and PostgreSQL
  • 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
Qualifications:
  • Bachelor's degree in computer science or a related field
  • 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
Preferred Qualifications:
  • 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
Apply Now
#LI-SYNX32

Skills Required

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD1735046
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Singapore, Singapore
  • Education
    Not mentioned