Senior Manager, Artificial Intelligence Office

National University Polyclinics; Singapore; On-site; SGD 180,000 - 240,000; Full time

Job summary

National University Health System is seeking a Senior Manager for the Artificial Intelligence Office to lead robust database systems across Development, UAT, Staging, DR, and Production environments. This role administers SQL Server and PostgreSQL, handles upgrades and migrations, and ensures high availability.

You will design database architectures, manage production changes with strict change control, and build ETL/ELT pipelines with SQL/SSIS/Python, plus backups, DR, security, and performance

Qualifications

• Experience managing SQL Server and PostgreSQL across Development, UAT, Staging, DR and Production environments.
• Proficient in upgrades, migrations, DR planning, and high availability.
• Experience with CI/CD for database deployments and ETL pipelines.
• Strong security practices, RBAC and compliance awareness.

Responsibilities

• Administer and support SQL Server and PostgreSQL across dev, UAT, staging, DR, and prod.
• Design, build, and maintain ETL/ELT pipelines using SQL, SSIS, Python.
• Plan production deployments with change management to minimize downtime.
• Configure and manage HA/DR via FCI, RDS, and replication.

Skills

SQL Server Administration

PostgreSQL

Azure DevOps

ETL/ELT pipelines

RBAC security

Education

Bachelor’s degree in Computer Science / Information Technology / related field

Tools

AWS cloud architecture

Kubernetes

SQL Server

SSIS

Azure DevOps

Amazon RDS

Job description

Select how often (in days) to receive an alert: Create Alert

Senior Manager, Artificial Intelligence Office

Job ID: 10338

Job Function: Administration

Institution: National University Health System

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.

Requirements

• Degree in Computer Science, Computer Engineering, Information Technology, Information Systems or a related discipline.
• 8–12+ years of IT experience, including 3–5+ years in a leadership or management role.
• Strong stakeholder management, communication, decision-making, analytical and problem-solving skills.
• Certifications in AWS/cloud architecture, Kubernetes or ITIL/service management are preferred.

Technical Skills

• Microsoft SQL Server Administration
• Amazon RDS for PostgreSQL
• SQL Server Transactional Replication
• High Availability & Disaster Recovery (HA/DR)
• Backup & Recovery
• Performance Tuning & Query Optimization
• Index Optimization & Execution Plan Analysis
• T-SQL Development (Stored Procedures, Functions, Triggers, Views)
• SQL Server Integration Services (SSIS)
• ETL/ELT Development
• Python
• Shell Scripting
• SQL Server Agent
• Windows Task Scheduler
• Database Security & User Access Management (UAM)