Responsibilities:
- 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.
- Manage virtualization technologies (VMware, Hyper-V, Nutanix, etc.)
- 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.
