Sr. Operation Management Specialist/SQL Database admin

ITCAN Pte Ltd

Singapore

Sur place

SGD 120 000 - 180 000

Plein temps

Il y a 5 jours
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

ITCAN PTE. LIMITED in Singapore seeks an experienced SQL Server Database Engineer to design and deploy Microsoft SQL Server solutions across Azure, AWS, and on-premises environments. You will drive database administration, backups, and protection of data.

The role emphasizes DR testing, retention policies (LTR/PITR/YTR), TDE and CMK governance, and automation using T-SQL and PowerShell. You will collaborate with project teams, support on-call incident response, and contribute to documentation

Qualifications

  • Experience in designing and deploying Microsoft SQL Server solutions on Azure, AWS, and on-premises.
  • Hands-on DB administration across monitoring, patching, upgrades, and configuration management.
  • Experience with backups, DR tests, and retention policies (LTR/PITR/YTR).
  • Strong security controls including TDE, CMK, and auditing.
  • Proficient in automation using T-SQL and PowerShell; familiar with Python/Terraform.

Responsabilités

  • Design and deploy SQL Server solutions on cloud and on-premises.
  • Manage backups and restore tests; DR readiness.
  • Configure retention policies and TDE lifecycle.
  • Audit and secure databases with CMK and Key Vault.
  • Performance tuning using Query Store and Extended Events.
  • Automate routine tasks with T-SQL and PowerShell.
  • Collaborate with application teams; participate in on-call rotation.
  • Create runbooks and SOP documents.

Connaissances

Database administration
Cloud SQL Server
Automation scripting
Performance tuning
Security & compliance
Disaster recovery planning
Terraform / ARM / Bicep
PowerShell
T-SQL
Python

Outils

Azure SQL on VM/MI/DB
Azure Monitor
Azure Defender for SQL
AWS RDS/EC2 SQL Server
Veeam/Commvault
Azure Backup
Key Vault CMK
Terraform
ARM/Bicep
Git
SQL Server Agent

Description du poste

Key Responsibilities
  • Experience in Design and deploy Microsoft SQL Server solutions on Azure (Azure VM, SQL MI, Azure SQL Database), AWS (EC2, RDS) and on-premises Microsoft SQL Server environments
  • Hands on with Database Administration tasks monitoring, patching, upgrades, and configuration management across all platforms
  • Manage native Microsoft SQL Server backups (full, differential, transaction log) and cloud-native backup solutions including Azure Backup for Microsoft SQL VMs and Azure SQL MI
  • Configure and maintain LTR (Long-Term Retention), PITR (Point-in-Time Restore), and YTR (Yearly Retention) policies aligned to data retention and compliance requirements
  • Manage TDE (Transparent Data Encryption) certificate lifecycle - creation, backup, rotation, and secure escrow - across on-premises, EC2/Azure VM, and managed cloud database services
  • Conduct regular restore tests and DR drills, maintaining documented RTO/RPO targets
  • Manage database security including logins, RBAC, auditing, Azure Key Vault integration for customer-managed keys (CMK), and SQL Server Audit configuration
  • Perform query tuning, index management, and performance analysis using Query Store, Extended Events, AWS Performance Insights, and Azure SQL Intelligent Insights
  • Automate routine DBA tasks using T-SQL and PowerShell, support database deployments
  • Meet Security Compliance with Hardening Baselines, Auditor-General's Office (AGO), IM8 (Instruction Manual 8) and Vulnerability Management
  • Provision and manage cloud database infrastructure using Terraform, ARM templates, or Bicep
  • Create and maintain technical documentation including architecture design, runbooks, and SOP documents
  • Thrives in a fast-paced, rapidly evolving cloud environment, adapting quickly to shifting priorities, new technologies, and changing business requirements
  • Effectively manages multiple concurrent workloads balancing implementation projects, BAU operations, and incident response with the ability to context-switch seamlessly across teams and platforms
  • Collaborate with various Application Project Managers, development teams, participate in on-call rotation for critical Database incident response, and deliver root cause analysis
  • Possesses strong verbal and written communication skills, with the ability to convey complex technical concepts clearly to both technical peers and non-technical stakeholders
  • Demonstrates strong self-organisation and the ability to independently plan, prioritise, and execute database engineering tasks with minimal supervision
Technical Skills Required
  • Azure: SQL Server on Azure VM, Azure SQL MI, Azure SQL Database, Elastic Pools, Failover Groups, Geo-Replication, Azure Monitor, Azure Defender for SQL
  • AWS: SQL Server on EC2, RDS for SQL Server, Multi-AZ, EBS storage, CloudWatch, IAM, Secrets Manager
  • On-Premises: SQL Server 2016-2022, Always On AG, FCI, Log Shipping, SQL Server Agent
  • Backup Recovery: Native SQL backup, Azure Backup, LTR/PITR/YTR, Veeam/Commvault (advantageous)
  • Security: TDE certificate management, Azure Key Vault (CMK), Dynamic Data Masking, Always Encrypted, Row-Level Security
  • Scripting Automation: T-SQL, PowerShell (essential); Python, Terraform, ARM/Bicep, Git (advantageous)
Technical Certifications
  • Required (1 of the 2): DP-300 (Administering Relational Databases on Microsoft Azure), DBS-C01 (AWS Certified Database Specialty)
  • Advantageous: AZ-104 (Microsoft Azure Administrator), AWS SAA-C03 (AWS Certified Solutions Architect - Associate)
Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Database Administrator-SQL Server and Azure SQL
Database Administrator-SQL Server and Azure SQL

SAGL CONSULTING PTE. LTD. • Singapore

Sur place
SGD 90 000 - 140 000
Database Administrator-SQL Server and Azure SQL
Database Administrator-SQL Server and Azure SQL

SAGL Consulting • Singapore

Sur place
SGD 90 000 - 130 000
Database Administrator
Database Administrator

RAPSYS TECHNOLOGIES PTE. LTD. • Singapore

Sur place
SGD 120 000 - 180 000
Azure Platform Devops Engineer
Azure Platform Devops Engineer

SOFTENGER (SINGAPORE) PTE. LTD. • Singapore

Sur place
SGD 180 000 - 240 000
SQL Server Security & Vulnerability Management
SQL Server Security & Vulnerability Management

HCL Technologies Limited • Singapore

Sur place
SGD 120 000 - 180 000
Application Systems Analyst (.NET / Azure / SQL)
Application Systems Analyst (.NET / Azure / SQL)

PHAIDON INTERNATIONAL (SINGAPORE) PTE. LTD. • Singapore

Sur place
SGD 110 000 - 150 000
Database Administrator (Support Data Platform Services operations)
Database Administrator (Support Data Platform Services operations)

TEAMLEASE DIGITAL SOLUTIONS PTE. LTD. • Singapore

Sur place
SGD 180 000 - 260 000
Data Architect
Data Architect

INNOVATIQ TECHNOLOGIES PTE. LTD. • Singapore

Sur place
SGD 120 000 - 180 000
Principal Engineer, IT & Systems
Principal Engineer, IT & Systems

ST ENGINEERING URBAN SOLUTIONS LTD. • Singapore

Sur place
SGD 70 000 - 120 000
Data Architect – Lead
Data Architect – Lead

INNOVATIQ SOLUTIONS PTE. LTD. • Singapore

Sur place
SGD 120 000 - 190 000