jobs in RECRUIT EXPRESS PTE LTD

Kerja Sepenuh Masa Database Administrator, Gaji tinggi SGD 10,000 di RECRUIT EXPRESS PTE LTD West Region (Singapore) - Maukerja

Database Administrator

RECRUIT EXPRESS PTE LTD

SGD10,000 - SGD10,000 Sebulan

West Region (Singapore)

Kongsi
Simpan

Lokasi Kerja

  • 100 NORTH BUONA VISTA ROAD West Region (Singapore) Singapore

Penerangan Kerja

Tanggungjawab

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.

Technical Skills

  • Microsoft SQL Server Administration
  • PostgreSQL Administration
  • Amazon RDS for PostgreSQL
  • Azure DevOps CI/CD Pipelines
  • SQL Server Failover Clustering (FCI)
  • 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)
  • Role-Based Access Control (RBAC)
  • SSL Certificate Management
  • Risk Assessment & Audit Compliance
  • Release & Change Management
  • Database Migration
  • Technical Documentation
  • Root Cause Analysis (RCA)
  • Database Monitoring & Capacity Planning
  • DevOps Collaboration
  • Infrastructure & Application Support

Interested applicants please send your resume to *************

Venessa Goh Wee Ni

R24124686

Recruit Express Pte Ltd

EA License No: 99C4599

We regret that only shortlisted candidates will be contacted.

Peringatan Penting

Jangan pernah kongsikan maklumat bank atau kad kredit anda semasa memohon pekerjaan. Elakkan membuat sebarang pembayaran atau mengisi survey yang tidak berkaitan. Jika ada yang mencurigakan, sila laporkan iklan pekerjaan ini segera.

Lebih Lanjut