· 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.