Database Administrator - #1592

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