Database Administrator

Ascentis Sdn Bhd; Petaling Jaya; On-site; MYR 90,000 - 150,000; Full time

Benefits offered by this job

Dental

Education support

Medical

Parking

Vision card service

Smart phone

Courses

Travel benefit

Sports

Job summary

Ascentis Sdn Bhd is seeking a Database Administrator to manage and optimize databases across SQL Server, PostgreSQL, and MySQL, primarily on AWS. You will ensure high availability, security, and performance while collaborating with Application Development, Infrastructure, Security, and Support teams.

You will handle backups, migrations, tuning, and monitoring, with on-call support for critical incidents and maintenance activities.

Qualifications

• Minimum 2 years of hands-on experience in Database Administration (production or business-critical environments).
• Strong hands-on experience with Microsoft SQL Server.
• Hands-on experience with PostgreSQL and/or MySQL administration.
• Experience with database monitoring and performance troubleshooting.
• Understand SQL tuning, execution plans, indexing, statistics, locking, and resource utilization.
• Experience with backup, restore, recovery, migration, and replication.
• Experience administering databases on AWS, including Amazon RDS and EC2.
• Knowledge of High Availability, Disaster Recovery, and replication concepts.
• Familiarity with Windows Server and Linux administration.

Responsibilities

• Manage and maintain production and non-production Microsoft SQL Server, PostgreSQL, and MySQL environments.
• Provision, configure, maintain, patch, and upgrade databases on AWS (RDS/EC2).
• Perform daily database health checks and monitor availability, backups, replication, and performance.
• Tune SQL queries and monitor CPU, memory, disk utilization, IOPS, connections, and wait statistics.
• Collaborate with Development, Infrastructure, Security, and Support teams to resolve database issues.
• Plan and execute database migrations and AWS database migrations (DMS).
• Maintain database security, accounts, roles, permissions, authentication, encryption, auditing, and least-privilege access.
• Provide on-call support during critical incidents and planned maintenance.

Skills

Database administration

Analytical thinking

Troubleshooting

Communication skills

On-call readiness

Education

Bachelor's degree in Information Technology, Computer Science, Computing

Tools

SQL Server

PostgreSQL

MySQL

AWS (RDS, EC2)

AWS DMS

PowerShell

Bash

Python

Job description

Ascentis is looking for a Database Administrator primarily responsible for managing, maintaining, securing, and optimizing the organization's database environments, with additional responsibilities in supporting IT infrastructure and cloud operations.

The role will work closely with Application Development, Infrastructure, Security, and Support teams to ensure databases and supporting infrastructure are highly available, secure, reliable, and performing optimally.

The position covers Microsoft SQL Server, PostgreSQL, and MySQL environments running primarily on Amazon Web Services (AWS).

Responsibilities

Manage and maintain production and non-production Microsoft SQL Server, PostgreSQL, and MySQL database environments.

Provision, configure, maintain, patch, and upgrade databases on Amazon RDS and Amazon EC2.

Perform proactive daily database health checks, including:

Database availability and connectivity

Backup status

Replication status

Failed jobs and scheduled tasks

Database and transaction log growth

Database connections

Locking and blocking

Database errors and alerts

Overall database performance

Monitor and optimize database performance, including CPU, memory, disk utilization, IOPS, connections, wait statistics, and database resource utilization.

Perform SQL query performance tuning, including analysis of execution plans, indexes, statistics, locking/blocking, long-running queries, and other database performance bottlenecks.

Work closely with Application Development teams to identify and resolve database-related application performance issues.

Perform and maintain database backup, restore, recovery, retention, housekeeping, and maintenance activities.

Regularly validate database backup and recovery procedures.

Monitor database growth and perform capacity planning for storage, compute, memory, and other database resources.

Configure, maintain, and troubleshoot database High Availability (HA), Disaster Recovery (DR), replication, and synchronization solutions.

Plan and execute database migrations, including database server migrations, version upgrades, platform migrations, and AWS database migrations.

Support database migration and replication using AWS Database Migration Service (DMS) or other appropriate technologies.

Manage database security, including database accounts, roles, permissions, authentication, encryption, auditing, and least-privilege access.

Assist in database security reviews, patching, vulnerability remediation, and implementation of database security best practices.

Troubleshoot database-related production issues, including performance degradation, connectivity issues, high resource utilization, slow-running queries, locking/blocking, replication failures, availability issues, and backup/recovery failures.

Assist with ad-hoc database queries, data requests, troubleshooting, and database-related technical requirements from internal teams or clients.

Develop and maintain scripts and automation for database administration, monitoring, health checks, maintenance, and operational activities.

Maintain database documentation, including configurations, architecture, maintenance procedures, backup/recovery procedures, and troubleshooting guides.

Provide on-call support for critical production database incidents when required.

Requirements

Preferably a Bachelor's degree in Information Technology, Computer Science, Computing, or a related discipline. Equivalent relevant hands‑on experience will also be considered.

Minimum 2 years of hands‑on experience in Database Administration, preferably supporting production or business‑critical database environments.

Strong hands‑on experience administering Microsoft SQL Server.

Hands‑on experience with PostgreSQL and/or MySQL database administration.

Experience with database monitoring and performance troubleshooting.

Good understanding of SQL query tuning, execution plans, indexing, statistics, locking/blocking, connection management, and database resource utilization.

Experience with database backup, restore, recovery, maintenance, replication, and migration.

Hands‑on experience administering databases on AWS, particularly Amazon RDS and databases hosted on EC2.

Familiarity with database High Availability, Disaster Recovery, and replication concepts and technologies.

Good understanding of database security, including authentication, authorization, encryption, auditing, and least-privilege access.

Working knowledge of Windows Server and Linux administration.

Good understanding of infrastructure fundamentals, including TCP/IP, DNS, firewall/security groups, networking, storage, CPU, memory, and operating systems.

Basic scripting or automation skills using PowerShell, Bash, Python, SQL, or similar technologies.

Strong analytical and troubleshooting skills with the ability to identify, investigate, and resolve database and infrastructure issues.

Ability to work independently as well as collaboratively with cross‑functional technical teams.

Good communication skills and ability to work effectively with Development, Infrastructure, Security, and Support teams.

Willingness to participate in on‑call support and planned maintenance activities when required.

Added Advantages

Experience or knowledge in the following areas will be an added advantage:

Terraform or other Infrastructure as Code (IaC) technologies.

AWS Database Migration Service (DMS).

SQL Server Always On Availability Groups, Log Shipping, Replication, Change Data Capture (CDC), and Change Tracking.

PostgreSQL streaming replication, logical replication, and High Availability solutions.

MySQL replication, read replicas, High Availability, and performance tuning.

AWS managed database technologies, including Amazon RDS for SQL Server, PostgreSQL, MySQL, and Amazon Aurora.

AWS infrastructure and operational services such as CloudWatch, CloudTrail, Systems Manager, AWS Backup, IAM, KMS, GuardDuty, and Inspector.

Database and infrastructure monitoring or observability tools.

Infrastructure automation and configuration management.

Database and infrastructure security best practices.

Experience supporting 24×7 business‑critical production environments.

What we offer

At Ascentis Sdn Bhd, we provide a collaborative environment where everyone can work on real business problems and build solutions used by leading brands in the region. We offer competitive salary, health benefits, career development opportunities, and a flexible work culture.

About us

Ascentis is the leader in powering CRM and Loyalty programs for leading brands in Singapore and the region. Our solutions cover CRM, Omni-channel Loyalty, eCommerce, Business Intelligence, Mobile Engagement, and Digital Marketing Services.

We are a young spirited company with a culture of innovation. Our teams are agile, passionate, and driven by experience. We believe in our people, and our clients believe in us.

If you are a Database Administrator looking to broaden your experience, develop your skills, and take on new challenges, we encourage you to apply and join our growing team at Ascentis Sdn Bhd.

Perks and benefits Dental Education support Miscellaneous allowance Medical Parking Vision card service, smart phone, courses, travel benefit Sports (e.g. Gym)

To help fast track investigation, please include here any other relevant details that prompted you to report this job ad as fraudulent / misleading / discriminatory / salary below minimum wage.

What can I earn as a Database Administrator