Database Administrator

RECRUIT EXPRESS PTE LTD

Singapore

On-site

SGD 90,000 - 180,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

RECRUIT EXPRESS PTE LTD is seeking an experienced Database Administrator to manage SQL Server and PostgreSQL across development to production environments. The role involves designing scalable database architectures, implementing CI/CD pipelines with Azure DevOps, and ensuring high availability and disaster recovery readiness.

You will lead upgrades, optimize performance, and collaborate with DevOps, security, and application teams to deliver reliable data services in a fast-moving environment.

Qualifications

Extensive experience administering SQL Server and PostgreSQL across multiple environments.
Strong knowledge of change management processes and release activities.
Proficient in performance tuning, query optimization, and index maintenance.
Experience mentoring junior DBAs and developers on best practices.
Solid security, audit, and RBAC governance skills.

Responsibilities

Administered, configured, and supported SQL Server and PostgreSQL databases across Development, UAT, Staging, Disaster Recovery, and Production environments.
Designed, built, and maintained Azure DevOps CI/CD pipelines for end-to-end database deployments, including schema changes, stored procedures, functions, triggers, views, indexes, constraints, and rollback strategies.
Planned, coordinated, and executed production database deployments while adhering to change management processes and minimizing downtime.
Configured and administered Amazon RDS for PostgreSQL, including parameter groups, security configuration, monitoring, backups, maintenance, and performance optimization.
Led SQL Server version upgrades (Standard Edition to Enterprise Edition), including planning, testing, migration, rollback planning, and production cutover.
Performed database performance tuning, query optimization, execution plan analysis, index optimization, statistics management, blocking analysis, deadlock troubleshooting, and capacity planning.

Skills

Database administration

Change management

Performance tuning

Mentoring

Problem solving

Tools

Microsoft SQL Server

PostgreSQL

Amazon RDS for PostgreSQL

Azure DevOps CI/CD

SSIS

SQL Server Agent

Windows Task Scheduler

Job description

Key Responsibilities

Administered, configured, and supported Microsoft SQL Server and PostgreSQL databases across Development, UAT, Staging, Disaster Recovery, and Production environments.
Installed, configured, upgraded, migrated, and maintained SQL Server and PostgreSQL database environments.
Designed, built, and maintained Azure DevOps CI/CD pipelines for end-to-end database deployments, including schema changes, stored procedures, functions, triggers, views, indexes, constraints, and rollback strategies.
Planned, coordinated, and executed production database deployments while adhering to change management processes and minimizing downtime.
Designed and maintained database architecture, schemas, tables, constraints, indexes, stored procedures, functions, triggers, views, and other database objects.
Led SQL Server version upgrades (Standard Edition to Enterprise Edition), including planning, testing, migration, rollback planning, and production cutover.
Configured and administered Amazon RDS for PostgreSQL, including parameter groups, security configuration, monitoring, backups, maintenance, and performance optimization.
Configured and supported SQL Server Transactional Replication for near real-time data synchronization.
Administered SQL Server Failover Cluster Instances (FCI), including shared storage management, cluster drive configuration, failover testing, cluster monitoring, and high availability support.
Planned, implemented, and tested backup, recovery, disaster recovery (DR), and business continuity strategies.
Created and maintained SQL Server Maintenance Plans, including automated backups, DBCC integrity checks, index maintenance, statistics updates, cleanup jobs, and scheduled maintenance.
Performed database performance tuning, query optimization, execution plan analysis, index optimization, statistics management, blocking analysis, deadlock troubleshooting, and capacity planning.
Monitored database health, storage utilization, replication, server performance, and proactively resolved production issues.
Designed, developed, and supported end-to-end ETL/ELT data pipelines for batch processing using SQL, SSIS, Python, Shell scripting, SQL Server Agent, and Windows Task Scheduler.
Planned and executed database migration projects, including schema migration, historical data migration, and large-volume data loading.
Performed SQL Server patching, cumulative updates (CU), security updates, and planned maintenance activities across Development, UAT, Staging, and Production environments.
Provided staging, production, and weekend production support for mission-critical enterprise applications, ensuring high availability and business continuity.
Collaborated with Microsoft Level 4 Support Engineers to troubleshoot complex production issues, perform root cause analysis (RCA), and implement permanent solutions.
Managed database user accounts, logins, service accounts, roles, permissions, and Role-Based Access Control (RBAC), ensuring compliance with security, audit, and User Access Management (UAM) policies.
Conducted database risk assessments, audit compliance activities, security reviews, SSL certificate implementation, database hardening, and vulnerability remediation.
Reviewed, validated, and approved database deployment scripts submitted by application teams, ensuring compliance with security, performance, coding standards, and database best practices.
Performed deployment impact analysis, release readiness assessments, rollback planning, and production implementation approvals.
Prepared and maintained database architecture documents, technical specifications, deployment guides, operational runbooks, disaster recovery documentation, standard operating procedures (SOPs), and support documentation.
Collaborated closely with application development teams, infrastructure teams, DevOps engineers, cloud engineers, and vendors to deliver secure, scalable, and highly available database solutions.
Worked with application teams to troubleshoot database-related issues, optimize SQL queries, and support application releases.
Coordinated with infrastructure teams for server provisioning, storage allocation, operating system maintenance, SQL Server clustering, networking, SSL certificate implementation, patching, and infrastructure upgrades.
Participated in production change management, release management, incident management, problem management, and post-implementation reviews.
Mentored junior DBAs and developers on SQL Server administration, database design, performance tuning, deployment standards, and operational best practices.