Senior Manager, Artificial Intelligence Office

NUHS Singapore

Fresher

Singapore

Posted 3 hours ago
Be among the first 10 applicants

Job Description

Senior Database Administrator / Senior Database Engineer

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