Database Administrator -

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