System Engineer

ST ENGINEERING URBAN SOLUTIONS LTD.; Singapore; Vor Ort; SGD 60.000 - 100.000; Vollzeit

Zusammenfassung

ST ENGINEERING URBAN SOLUTIONS LTD. is seeking a Database Engineer to design, implement, and tune scalable SQL databases supporting our applications. You will optimize queries, plan backups, and monitor health, collaborating with cross-functional teams to ensure reliability and security.

Prior experience with SQL Server, MySQL, PostgreSQL, and cloud DB services is valued. The role emphasizes strong database design, performance optimization, and maintenance of large-scale systems with attention

Qualifikationen

• Proven experience as a Systems Engineer or Database Engineer focusing 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.
• Experience with backup, recovery, and maintenance of large-scale databases.
• Ability to read SQL execution plans to optimize performance.
• Good communication to work with cross-functional teams.
• Bonus: cloud-based DB services, NoSQL familiarity, and Azure cert.

Aufgaben

• Design, implement, and maintain scalable databases to support applications.
• Optimize SQL queries and performance using execution plans and indexing.
• Plan and test regular backup, recovery, and disaster recovery.
• Monitor health and performance, identifying bottlenecks.
• Collaborate with development and operations teams for reliability.
• Maintain documentation of architectures, backups, and maintenance.
• Implement security best practices in access control.

Kenntnisse

Systems Engineer

Database Engineer

SQL databases

Database design

Query optimization

Backup and recovery

Large-scale databases

Cross-functional collaboration

Cloud DB services

NoSQL databases

Azure certification

Jobbeschreibung

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:
• Experience with database monitoring tools and performance tuning utilities.
• Knowledge of cloud-based database services (e.g., AWS RDS, Azure SQL Database).
• Familiarity with NoSQL databases is a plus.
• Certification in database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate).