Systems Engineer - Database Specialist - #1101682

• 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.

• 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.