Role Overview

The Database Consultant is responsible for the full lifecycle management of enterprise database systems, ensuring optimal performance, security, availability and reliability across on-premises and cloud environments. The role supports data-driven initiatives, secure data access, data integrity, cloud migration and data governance activities.

Key Responsibilities

· Install, configure, upgrade, patch and maintain database servers and instances.

· Monitor database performance and ensure high availability, reliability and operational excellence.

· Diagnose and resolve database incidents, errors, performance issues and service disruptions.

· Manage database access controls, user privileges, standards and data integrity.

· Design database architecture, develop SQL scripts, conduct performance tuning and optimise workloads.

· Perform database backup, restoration, recovery, disaster recovery and business continuity activities.

· Handle service requests covering data queries, database cloning, deployments, configuration extraction and data scrambling.

· Administer and support data scrambling and masking solutions for non-production environments.

· Support database migration and modernisation initiatives from on-premises environments to AWS and Azure Singapore Government Commercial Cloud (GCC).

· Manage and support cloud database services such as AWS RDS, AWS Redshift, Azure SQL Database, Azure SQL Managed Instance and other relevant services.

· Ensure seamless integration and connectivity between databases, applications and enterprise platforms.

· Implement database security controls, encryption, auditing, vulnerability remediation and security best practices.

· Support compliance with organisational, regulatory, audit and security governance requirements.

· Develop and maintain database operational procedures, standards, runbooks and technical documentation.

· Provide technical consultancy to stakeholders on database technologies, cloud adoption, data security and data management.

· Stay current with emerging database technologies, cloud services, security practices and industry standards.

Minimum Requirements

· Degree in Computer Science, Information Technology, Computer Engineering or a related discipline.

· Minimum 4 years of hands-on experience managing enterprise relational database management systems in production environments, including Microsoft SQL Server and Oracle.

· At least 6 months of hands-on experience supporting databases hosted in AWS and Azure Singapore Government Commercial Cloud (GCC) environments.

· At least 6 months of hands-on experience in data masking or data scrambling or an equivalent data obfuscation solution.

· Hands-on execution of at least 10 database refresh/cloning activities and 3 migration activities within the last 2 years.

· Hands-on implementation or administration of at least 3 of the following controls: Database auditing, TDE or equivalent encryption, Privileged access controls, Vulnerability assessment remediation, Security hardening.

· Developed and maintained at least 3 automation scripts/tools for database administration, monitoring, restoration, deployment or housekeeping activities.

· Supported at least 3 Priority 1 / Severity 1 production incidents and produced RCA reports with corrective actions.

· Produced at least 2 operational documents (SOP, DR, Architecture, Runbook, Technical Design) and conducted stakeholder presentations or technical briefings.

· Minimum 6 months hands-on experience or supporting a Database Activity Monitoring (DAM) solution, such as Imperva.

· Participated in at least one cloud migration project involving AWS, Azure, Singapore Government Commercial Cloud (GCC), RDS, Azure SQL or hybrid database architecture.

· Good written and verbal communication skills.

Core Competencies

· Database administration and performance optimisation

· Cloud database operations in AWS and Azure Singapore Government Commercial Cloud (GCC)

· Data security, masking and scrambling

· Technical documentation and stakeholder engagement