Assistant Lead Engineer - Database Developer (Software Development) at Synapxe

, , Singapore -

Full Time

Start Date

Immediate

Expiry Date

14 Sep, 26

Salary

0.0

Posted On

16 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

MSSQL, Oracle, PostgreSQL, Database Migration, SQL Programming, Performance Tuning, AWS RDS, Azure SQL Database, T-SQL, PL/SQL, Cloud Database Management, Data Integrity, CI/CD Pipelines, Database Architecture, AWS DMS, PowerShell

Industry

IT Services and IT Consulting

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

Responsibilities

Lead the migration and conversion of on-premises and cloud databases from MSSQL and Oracle to PostgreSQL. Design and optimize SQL queries and manage cloud-managed database services across AWS and Azure.