Install, configure, and upgrade database servers and related tools (SQL Server, PostgreSQL, or cloud-native DBs).
Perform regular database backups, restorations, and disaster recovery planning.
Implement and maintain database replication, clustering, and high-availability solutions.
Optimize SQL queries, stored procedures, and indexing strategies.
Monitor database performance and proactively identify bottlenecks or issues.
Monitor capacity and plan for growth, ensuring scalability of database systems.
Apply patches, service packs, and version upgrades while minimizing downtime.
Support developers with database design, query optimization, and troubleshooting.
Maintain documentation for database configurations, processes, and policies.
Ensure compliance with data governance, security, and privacy regulations
Provide 24x7 on-call support for critical production systems (if required).
Requirements
Diploma or Bachelor degree in Information Technology or related studies in Singapore.
2 to 4 years of hands-on experience in MS SQL Server and PostgreSQL administration.
Hands-on experience in SQL Server, PostgreSQL Administration such as DB server installation, migration, virtualisation, apply patches, service packs, version upgrades, DB backup, DR planning and etc.
Hands-on experience in developing new & optimizing SQL queries, stored procedures, and indexing strategies.
Deal with software developers on the aspect of database design, query optimization, and troubleshooting.
Knowledgeable in database capacity planning, scalability of database systems.
As required (if activated), to be on 24x7 on-call support for critical production systems issue.
Additional Preferred Skills (Nice-to-Have)
Domain experience in Banking and Financial Services Industry (BFSI) is advantageous.
Implement automation for provisioning, monitoring, and maintenance tasks.
Knowledge of data warehousing and ETL (SSIS) - Design, implement, and maintain data warehouses, SSIS packages, and ETL processes.
Cloud & RDS Management: Administer databases in hybrid cloud (AWS/Azure) and RDS environments. Support cloud infrastructure (AWS) including compute, networking, and storage.
Familiarity with Redgate tools, SQL Compare, and BI tools like Tableau and Jasper report.
Troubleshoot and resolve infrastructure issues on Windows and Linux platform (O.S Level) that interconnected to Database server.
Experience in cloud-based database migration and DevOps practices.
Collaborate with security teams to apply security hardening, vulnerability remediation, and compliance controls.
