Cloudera & Database Administrator (Oracle / SQL Server / Big Data)

Note: 1-year Contract (Renewable)
Workplace: Roving

About the Role

You will manage, monitor, and optimize enterprise databases and Cloudera Big Data platforms on Windows and Linux. This role ensures high availability, security, and performance for critical business applications, working closely with application teams, infrastructure engineers, and security specialists.

Key Responsibilities

Database Administration:

• Install, configure, upgrade, and maintain Oracle (12c/19c/21c) and SQL Server (2016/2019/2022) databases.

• Manage users, roles, storage, access privileges, and database patching.

• Implement backup and recovery strategies using RMAN (Oracle) and SQL Server tools.

• Monitor and tune database performance troubleshoot slow queries using AWR, ADDM, Query Store, and Extended Events.

Big Data & Cloudera Administration:

• Deploy and maintain Cloudera Data Platform (CDP) on private/public cloud environments.

• Administer Hadoop ecosystem components: HDFS, YARN, Hive, Impala, HBase, Spark, Kafka, NiFi.

• Manage cluster resources, capacity, and workload distribution.

• Configure Cloudera Manager, Hive metastore, partitioning, and query optimization.

• Implement ETL workflows and data ingestion pipelines manage HDFS quotas, replication, and lifecycle policies.

• Administer Apache Ranger for security, access control, and data masking.

High Availability & Replication:

• Configure and maintain Oracle Data Guard, Oracle GoldenGate, SQL Server AlwaysOn Availability Groups, and Failover Cluster Instances.

• Implement HDFS HA and HBase replication for distributed workloads.

Performance & Optimization:

• Analyze and tune SQL, Hive, Impala, and Spark queries.

• Optimize YARN resources, container sizing, and job scheduling.

• Conduct cluster performance assessments and implement optimization recommendations.

Security & Compliance:

• Enforce database security policies, encryption, and audit mechanisms.

• Ensure compliance with MAS TRM, ISO 27001, and other governance standards.

• Implement RBAC, LDAP/AD integration, data encryption (at rest/in transit), data lineage, and audit logging.

Monitoring & Automation:

• Set up proactive monitoring with Oracle Enterprise Manager, SSMS, Cloudera Manager, and third-party tools.

• Automate maintenance, monitoring, reporting, and cluster provisioning using Shell, PowerShell, Python, Ansible, or Chef.

• Develop dashboards for cluster health, resource utilization, and SLAs.

Disaster Recovery & Documentation:

• Conduct DR drills, validate failover/failback, and maintain HDFS backup strategies.

• Document database and cluster architecture, configurations, and operational runbooks.

• Participate in 24x7 on-call rotation and incident response.

Required Skills & Qualifications

• Degree/Diploma in Computer Science, IT, Electrical Engineering, or equivalent.

• At least 1 year of hands-on experience in database administration, big data platforms, or database monitoring tools.

• Strong experience with Oracle Data Guard, GoldenGate, SQL Server AlwaysOn, and FCI.

• Hands-on administration of both Windows and Linux environments (Red Hat, Oracle Linux).

• Proficiency with Oracle (RAC, ASM, RMAN, OEM), SQL Server (SSMS, SSIS, SSRS), and Cloudera/Hadoop ecosystem.

• Scripting experience in Shell, PowerShell, or Python.

• Familiarity with backup tools (NetBackup, CommVault, or equivalent) and networking/storage fundamentals.

Preferred Skills & Certifications

• Oracle or SQL Server certifications

• Windows or Linux certifications

• ITIL Foundation

Soft Skills

• Strong analytical and troubleshooting skills

• Excellent communication and documentation

• Team-oriented and able to work in multi-vendor, cross-platform environments

• Ability to prioritize multiple tasks under pressure