Responsibilities

• Design, implement, and maintain scalable and efficient databases to support application requirements.
• Optimize SQL queries and database performance by analyzing execution plans and indexing strategies, conduct tuning of database as needed.
• Plan, configure and test regular database backup, recovery processes, and disaster recovery.
• Monitor database health and performance, proactively identifying and resolving bottlenecks and issues.
• Troubleshoot complex SQL queries and provide solutions to improve execution speed and resource usage.
• Collaborate with development and operations teams to ensure database reliability and availability.
• Maintain documentation for database architectures, backup procedures, and maintenance schedules.
• Hardening and provide rectification of Vulnerability Assessment and Penetration Test
• Support other systems, especially interfaces that use data storage.
• Stay updated with the latest trends and best practices in database technologies and performance tuning.
• Ensure security best practices in database management and access control.

Requirement/Skills

• Proven experience as a Systems Engineer or Database Engineer with a focus on SQL databases
• Strong expertise in database design, normalization, and optimization techniques.
• In-depth knowledge of SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficient in reading and interpreting SQL query execution plans to optimize query performance.
• Experience with backup, recovery, and maintenance of large-scale databases.
• Strong communication skills to work effectively with cross-functional teams.
• If you possess any of the following, it will be considered a bonus:

o Experience with database monitoring tools and performance tuning utilities.

o Knowledge of cloud-based database services (e.g., AWS RDS, Azure SQL Database).

o Familiarity with NoSQL databases is a plus.

o Certification in database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate).

Useful Q&A information below:

• What types of the project will be handling: Government Security projects.
• Security clearances are required? yes, local born Singaporeans for ease of clearance.