System Engineer
ST ENGINEERING URBAN SOLUTIONS LTD. · Singapore ·
- Category
- Software engineering
Designs, optimizes, and secures SQL databases for a climate-tech company, ensuring reliability and performance while collaborating with dev and ops teams.
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).