Role Overview
The Database Consultant is responsible for end-to-end lifecycle management of enterprise database platforms across on-premises and cloud environments. The role supports multiple client projects and stakeholders, ensuring database performance, availability, security, and operational excellence. You will handle BAU operations, service requests, incident management, and project delivery (e.g., refresh, migration, modernization), while producing clear technical documentation and briefings.
Key Responsibilities
- Database Platform Operations
- Install, configure, upgrade, patch, and maintain database servers/instances.
- Monitor health and performance; perform tuning and workload optimisation.
- Ensure high availability, reliability, and operational stability.
- Incident & Problem Management
- Diagnose and resolve database incidents, errors, performance degradation, and service disruptions.
- Support high-severity production incidents and produce RCA reports with corrective actions.
- Backup, Recovery & Continuity
- Execute backup, restoration, recovery, and disaster recovery activities.
- Support business continuity planning and operational readiness.
- Service Requests & Non-Production Support
- Handle service requests including data queries, cloning/refresh, deployments, configuration extraction, and data scrambling.
- Administer and support data masking/scrambling solutions for non-production environments.
- Security & Compliance
- Manage database access controls, user privileges, and security standards.
- Implement database security controls such as encryption (e.g., TDE or equivalent), auditing, privileged access controls, vulnerability remediation, and security hardening.
- Support compliance with organisational audit and security governance requirements.
- Cloud Database Operations & Migration
- Support cloud database services (e.g., managed relational database services and data warehouse services).
- Participate in cloud migration/modernisation projects (on-prem to cloud and/or hybrid architectures).
- Ensure integration/connectivity between databases, applications, and enterprise platforms.
- Automation & Tooling
- Develop and maintain automation scripts/tools for administration, monitoring, restoration, deployment, and housekeeping to improve reliability and efficiency.
- Documentation & Stakeholder Engagement
- Produce operational documents (e.g., SOPs, runbooks, DR, architecture, technical design).
- Conduct stakeholder presentations/technical briefings and provide consultancy across client teams.
Minimum Requirements (Mandatory)
- Degree in Computer Science, Information Technology, Computer Engineering, or related discipline.
- 4+ years hands-on experience managing enterprise RDBMS in production, including Microsoft SQL Server and Oracle.
- 6+ months hands-on experience supporting databases hosted in both AWS and Azure cloud environments.
- 6+ months hands-on experience in data masking/scrambling (or equivalent obfuscation solution).
- Executed at least 10 database refresh/cloning activities and at least 3 database migration activities within the last 2 years.
- Implemented/administered at least 3 of the following:
- Database auditing
- Encryption (e.g., TDE or equivalent)
- Privileged access controls
- Vulnerability assessment remediation
- Security hardening
- Developed and maintained at least 3 automation scripts/tools for DBA operations (monitoring/restoration/deployment/housekeeping).
- Supported at least 3 high-severity production incidents and produced RCA reports with corrective actions.
- Produced at least 2 operational documents (SOP/DR/Architecture/Runbook/Technical Design) and delivered stakeholder briefings/presentations.
- 1 year of hands-on experience supporting a Database Activity Monitoring (DAM) solution (e.g., Imperva or equivalent).
- Participated in at least one cloud migration project involving AWS/Azure services and/or hybrid database architecture.
Core Competencies
- Database administration and performance optimisation (SQL Server, Oracle)
- Cloud database operations (AWS and Azure)
- Data security, encryption, auditing, and masking/scrambling
- Automation/scripting for DBA operations
- Strong documentation, communication, and stakeholder management across multiple client projects