SQL Database Administrator

Location
Industry FMCG
Job reference 18116
Job type Permanent
Consultant email nhu.dinh@manpower.com.vn
Date posted Apr 14, 2025

Job Description

In a nutshell

As a Database Administrator, you will be responsible for designing, installing, configuring, upgrading, and maintaining databases to ensure their smooth operation.

Your role

  • Your role will involve optimizing database performance, managing security, performing regular backups, and implementing high availability solutions.
  • You will oversee SQL Server databases across multiple environments, ensuring scalability, reliability, and efficiency.
  • Managing database replication, clustering, Always On availability groups, and other HA/DR strategies will be a crucial part of your responsibilities.
  • Your expertise will be essential in administering SQL Server instances hosted on Azure, optimizing cloud database performance, and ensuring seamless migrations from on-premises environments.
  • You will be responsible for developing and optimizing complex T-SQL queries, troubleshooting performance issues, and designing efficient database schemas.
  • Automation is a key aspect of this role, requiring you to implement scripts and processes to streamline database maintenance, backups, and health checks using PowerShell and SQL Server Agent Jobs.
  • You will also be responsible for implementing Change Data Capture (CDC), job monitoring, and alerts to ensure database health.
  • Your role will involve configuring SSL/TLS encryption for SQL Server instances and continuously improving performance through indexing and execution plan analysis.
  • Collaboration with development teams and stakeholders will be essential to align database architecture with business goals.
  • Additionally, you will provide on-call support for production issues and contribute to documentation and process improvement initiatives.

 

Qualifications

Are you our kind of extraordinary?

  • To be successful in this role, you should have at least three to four years of experience as a SQL Database Administrator, with at least one to two years working in Azure Cloud environments.
  • A deep understanding of SQL Server architecture, high availability, and disaster recovery solutions is essential.
  • You should have strong experience in T-SQL development, including writing complex queries, stored procedures, and functions, as well as troubleshooting and performance optimization. Experience with PowerShell scripting to automate DBA tasks such as backups and health checks is highly valued.
  • You should be familiar with database monitoring tools such as Grafana, SolarWinds, and Azure Monitor, and have experience setting up Change Data Capture (CDC) for tracking changes. Knowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) is beneficial.
  • Strong problem-solving skills, the ability to work independently, and effective communication skills are required to collaborate with cross-functional teams and stakeholders.
  • Certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are a plus.