Principal Engineer, IT & Systems

ST ENGINEERING URBAN SOLUTIONS LTD.; Singapore; On-site; SGD 70,000 - 120,000; Full time

Job summary

ST ENGINEERING URBAN SOLUTIONS LTD. in Singapore is seeking a seasoned Database Administrator to install, optimize, and secure our database ecosystem. You will ensure high availability and enforce database standards across engines like MS SQL, MySQL, and PostgreSQL.

Responsibilities include performance tuning, access management, automation of recurring tasks, and creation of reports and dashboards. You will troubleshoot issues and provide on-call support in collaboration with IT teams.

Qualifications

• Strong command of SQL and SQL server tools.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
• Understanding of relational and dimensional data modeling.
• PowerShell and Unix shell scripting skills.
• Familiarity with SSAS, SSIS, SSRS.
• Strong mathematical and statistical knowledge.
• Excellent written and verbal communication skills.
• Impeccable attention to detail.

Responsibilities

• Install and maintain the performance of database servers.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Be available for on-call support as needed.

Skills

SQL

Database security

Backup & recovery

Performance monitoring

Relational data modeling

Dimensional data modeling

PowerShell scripting

Unix shell scripting

Communication

Attention to detail

Education

MCSE/MCSA certifications preferred

Tools

SSAS

SSIS

SSRS

MySQL

MS SQL

PostgreSQL

Oracle

MongoDB

Job description

Job Responsibilities:

• Install and maintain the performance of database servers.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Be available for on-call support as needed.

Skills and Qualifications:

• Strong command of SQL and SQL server tools
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Understanding of relational and dimensional data modeling
• PowerShell and Unix shell scripting skills
• Familiarity with SSAS, SSIS, SSRS
• Strong mathematical and statistical knowledge
• Excellent written and verbal communication skills
• Impeccable attention to detail

Requirements:

• Experiences in database administration, information technology, database architecture, or a related field
• MCSE/MCSA certifications preferred
• Experience with Linux and Windows Server environments
• Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
• Experience with cloud services (AWS, Microsoft Azure) a plus