Sr Subject Matter Expert (Support&Ops)
Singapore
Job Description
Sr Subject Matter Expert (Support&Ops)
Singapore, Singapore

Job Summary

We are seeking an experienced and highly motivated Senior Database Administrator (DBA) with strong expertise in Oracle, Microsoft SQL Server, PostgreSQL, and Database Automation. The ideal candidate will be responsible for the administration, performance optimization, security, high availability, disaster recovery, and automation of enterprise database environments across on-premises and cloud platforms.

The candidate should possess hands-on experience in designing and implementing automation solutions using tools such as Ansible, PowerShell, Python, Shell Scripting, and DevOps pipelines to streamline database operations, improve service reliability, and reduce operational effort.

This role requires collaboration with application teams, cloud teams, infrastructure teams, cybersecurity teams, and business stakeholders to deliver highly available, secure, and scalable database services.

Key Responsibilities

Oracle Database Administration

 

Install, configure, patch, upgrade, and maintain Oracle databases.

Manage Oracle RAC, ASM, Data Guard, GoldenGate, and Oracle Enterprise Manager.

Perform backup and recovery using RMAN.

Conduct database cloning, refreshes, and migrations.

Monitor and optimize Oracle database performance.

Support Oracle version upgrades and migration projects.

Implement security controls, auditing, and compliance requirements.

 

 

Microsoft SQL Server Administration

 

Administer SQL Server 2016/2019/2022 environments.

Manage AlwaysOn Availability Groups, Clustering, Replication, and Log Shipping.

Perform database backup, restore, refresh, and migration activities.

Monitor database performance and troubleshoot production incidents.

Implement indexing strategies and query optimization.

Manage SQL Server security, encryption, and compliance controls.

 

 

PostgreSQL Database Administration

 

Install, configure, and administer PostgreSQL databases.

Manage PostgreSQL replication, failover, and high availability solutions.

Perform performance tuning and query optimization.

Conduct PostgreSQL upgrades and migrations.

Implement backup and recovery strategies.

Manage schemas, extensions, roles, and security configurations.

 

 

Database Automation & Platform Engineering

 

Design and implement automation for routine DBA operations.

Develop automated workflows for:

Database provisioning

User management

Database refreshes

Backup validation

Health checks

Monitoring and alert remediation

Patching and upgrades

Capacity management

Skill Requirements

 

Ansible

PowerShell

Shell Scripting

Python

Git

CI/CD Pipelines

 

 

Develop self-healing mechanisms for recurring database issues.

Drive Infrastructure as Code (IaC) and DevOps initiatives within database platforms.

 

 

 

Cloud Database Administration

 

Support cloud database platforms including:

 

AWS RDS Oracle

AWS RDS PostgreSQL

Azure SQL Managed Instance

Azure Database for PostgreSQL

 

Support cloud migrations and modernization programs.

Optimize cloud database performance and costs.

 

 

Production Support

 

Provide L3/L4 support for mission-critical production systems.

Participate in 24x7 on-call support rotation.

Lead troubleshooting during critical incidents and outages.

Perform Root Cause Analysis (RCA) and corrective actions.

Support Change, Incident, Problem, and Release Management processes.

 

 

Documentation & Knowledge Management

 

Create and maintain:

 

SOPs

Runbooks

Architecture Documents

Automation Workflows

Knowledge Base Articles

 

 

Conduct knowledge transfer sessions and mentor junior DBAs.

Prepare operational and management reports.

 

 

Mandatory Technical Skills

Oracle

 

Oracle RAC

ASM

Data Guard

RMAN

OEM

SQL Server

SQL Server 2019/2022

AlwaysOn Availability Groups

Replication

Clustering

Backup & Recovery

Performance Tuning

 

PostgreSQL

PostgreSQL 12/13/14/15/16

Replication

High Availability

Backup & Recovery

Performance Tuning

Query Optimization

 

Automation

 

Ansible

Python

PowerShell

Shell Scripting

Git

Jenkins

CI/CD Pipelines

Infrastructure as Code (IaC)

 

Operating Systems

Linux (RHEL, CentOS, Ubuntu)

Windows Server

 

Preferred Skills

AWS Database Services

Azure Database Services

Kubernetes & Containers

Database Migration & Modernization

AI/ML-driven Infrastructure Automation

ITIL Service Management Framework

 

 

Soft Skills

 

Excellent communication and stakeholder management skills.

Strong analytical and problem-solving abilities.

Experience working in global delivery environments.

Ability to lead technical initiatives and mentor team members.

Strong customer focus and service-oriented mindset.

Other Requirements

null
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.