- Location
- Singapore
- Type
- Full-time
- Department
- IT
- Experience
- 4+ years
- Closing date
- Today
- Source
- CareersPage
Description
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 optimize 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 modernization initiatives from on-premises environments to AWS and Azure cloud environments.
- 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 organizational, 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.
- Hands-on experience supporting databases hosted in AWS and Azure cloud environments.
- Hands-on experience with data masking, data scrambling, or equivalent data obfuscation solutions.
- Practical experience performing database refresh, cloning, and migration activities.
- Hands-on experience implementing or administering database security controls, such as database auditing, encryption, privileged access controls, vulnerability remediation, and security hardening.
- Experience developing and maintaining automation scripts or tools for database administration, monitoring, restoration, deployment, or housekeeping activities.
- Experience supporting high-priority production incidents and preparing root cause analysis (RCA) reports with corrective actions.
- Experience producing operational and technical documentation, such as SOPs, DR plans, architecture documents, runbooks, or technical designs, and conducting stakeholder presentations or technical briefings.
- Hands-on experience supporting or administering a Database Activity Monitoring (DAM) solution.
- Experience participating in cloud migration projects involving AWS, Azure, or hybrid database architectures.
- Good written and verbal communication skills.
Core Competencies
- Database administration and performance optimization
- Cloud database operations across AWS and Azure
- Data security, masking, and scrambling
- Database migration and modernization
- Technical documentation and stakeholder engagement
- Database monitoring, automation, and operational support