Cloudera & Database Administrator (Oracle / MS SQL), Singapore

Job Title: Cloudera & Database Administrator (Oracle / MS SQL) Location:
Singapore Contract:
12 Months
About the Role We are hiring a
Cloudera & Database Administrator (DBA)
responsible for installation, configuration, administration, monitoring, and performance tuning of
Cloudera Data Platform (CDP), Oracle, and Microsoft SQL Server
environments across Windows and Linux platforms. This role ensures high availability, security, and disaster recovery readiness of enterprise database and big data systems supporting mission-critical applications. Cloudera competency is mandatory. Key Responsibilities Database Administration Install, configure, and upgrade
Oracle 12c/19c/21c
and
SQL Server 2016/2019/2022 Manage users, roles, storage structures, and access controls Perform patching, maintenance, and performance tuning Implement backup & recovery using
RMAN
and SQL Server native tools
Big Data / Cloudera Administration Install and manage
Cloudera Data Platform (CDP)
– Private & Public Cloud Administer Hadoop ecosystem components: HDFS, YARN, Hive, Impala, HBase Spark, Kafka, NiFi Manage cluster capacity, workload distribution, and storage policies Configure and monitor via Cloudera Manager Implement ETL/data ingestion pipelines Manage HDFS quotas, replication, lifecycle policies Administer Hive Metastore and query optimization Configure Apache Ranger for RBAC and security governance
High Availability & Replication Configure and manage Oracle Data Guard (DR setup) Implement Oracle GoldenGate (real-time replication) Manage SQL Server AlwaysOn Availability Groups Support SQL Server Failover Cluster Instances (FCI) Configure HDFS HA and distributed replication strategies
Performance Optimization SQL tuning, indexing, execution plan analysis Use AWR, ADDM (Oracle), Query Store & Extended Events (MSSQL) Optimize Hive/Impala queries & Spark performance Monitor YARN resource allocation and cluster performance
Security & Compliance Implement encryption (at rest & in transit) Configure Apache Ranger policies Apply database security controls and auditing Ensure compliance with standards (e.g., MAS TRM, ISO 27001) Perform patching and vulnerability remediation
Monitoring & Automation Configure monitoring tools (OEM, SSMS, Cloudera Manager) Develop automation scripts (Shell, PowerShell, Python) Implement logging & monitoring integrations (ELK, Splunk) Automate cluster provisioning and maintenance
Disaster Recovery & Documentation Conduct DR drills and validate failover procedures Implement HDFS BDR strategies (distcp, snapshots, replication) Maintain detailed architecture and operational documentation Participate in 24x7 on-call rotation
Required Qualifications Degree/Diploma in Computer Science, IT, Engineering or equivalent Singapore Citizen (Mandatory) Minimum 1+ year experience in: Oracle / MS SQL administration Cloudera / Hadoop ecosystem Strong hands-on experience in: Oracle Data Guard & GoldenGate SQL Server AlwaysOn & FCI Windows & Linux (Red Hat / Oracle Linux)
Technical Skills Oracle 12c/19c/21c (RAC, ASM, RMAN, OEM) SQL Server 2016/2019/2022 (SSMS, SSIS, SSRS, AlwaysOn) Cloudera CDP & Hadoop ecosystem Scripting: Shell, PowerShell, Python Backup tools: NetBackup / CommVault Strong OS, networking & storage fundamentals
Preferred Certifications Oracle and/or Microsoft SQL Certification Windows/Linux Certification ITIL Foundation
Soft Skills Strong troubleshooting & analytical skills Excellent communication & documentation ability Experience in cross-platform, multi-vendor environments Ability to manage multiple priorities under pressure