DBA SQL Server

PT. Metrodata Electronics Tbk.; Jakarta Barat; On-site; IDR 180,000,000 - 340,000,000; Full time

Job summary

PT. Metrodata Electronics Tbk. is seeking an experienced SQL Server Database Administrator to manage, optimize, and support Microsoft SQL Server environments within enterprise projects in Jakarta.

The role emphasizes availability, performance tuning, and proactive maintenance. You will handle upgrades, migrations, and the implementation of HA/DR solutions such as Always On and WSFC, ensuring RPO/RTO goals are met and incidents are resolved quickly.

Qualifications

• Bachelor's degree in CS/IT/IS or related field.
• At least 3 years of SQL Server DBA experience.
• Strong hands-on MS SQL Server administration, installation, configuration and maintenance.
• Experience with SQL Server performance tuning, troubleshooting, backup and recovery.
• Hands-on experience in upgrade and migration projects (in-place and side-by-side).
• Experience implementing and managing SQL Server HA/DR solutions.
• Understanding of T-SQL, indexing, execution plans, and database optimization.
• Familiarity with Windows Server environments, clustering, and enterprise infrastructure.

Responsibilities

• Administer, monitor, and maintain SQL Server databases to ensure availability, security, and optimal performance.
• Perform preventive and corrective maintenance activities.
• Install, configure, and provision SQL Server instances and databases.
• Conduct database health checks, indexing, statistics maintenance, and capacity monitoring.
• Monitor and optimize database performance, including troubleshooting bottlenecks and incidents.
• Manage SQL Server Agent Jobs, alerts, backup, and recovery processes.
• Execute SQL Server upgrades using in-place and side-by-side migrations.
• Perform database migration assessments and implementation activities.
• Configure and maintain HA/DR solutions including Always On and WSFC; perform DR testing.
• Analyze and optimize T-SQL queries and execution plans.
• Conduct root cause analysis and preventive actions for recurring issues.
• Collaborate with infra, network, application, and vendor teams to resolve issues.

Skills

SQL Server DBA

T-SQL

Performance tuning

Backup & recovery

HA/DR

Windows Server

Migration projects

Education

Bachelor's Degree in CS / IT / IS

Tools

Always On AG

WSFC

SQL Server

Job description

Metrodata Group is seeking an experienced SQL Server Database Administrator (DBA) to manage, maintain, and optimize Microsoft SQL Server environments within enterprise projects. The role involves database administration, performance tuning, troubleshooting, system upgrades, migration activities, and implementation of High Availability (HA) and Disaster Recovery (DR) solutions.

Responsibilities

• Administer, monitor, and maintain Microsoft SQL Server databases to ensure availability, security, and optimal performance.
• Perform preventive and corrective maintenance activities.
• Install, configure, and provision SQL Server instances and databases.
• Conduct database health checks, integrity checks, indexing, statistics maintenance, and capacity monitoring.
• Monitor and optimize database performance, including troubleshooting performance bottlenecks and incidents.
• Manage SQL Server Agent Jobs, alerts, backup, and recovery processes.
• Execute SQL Server upgrades using both in-place upgrade and side-by-side migration methods.
• Perform database migration assessments, compatibility checks, and implementation activities.
• Configure and maintain High Availability (HA) and Disaster Recovery (DR) solutions, including Always On Availability Groups and Windows Server Failover Clustering (WSFC).
• Perform DR testing and recovery validation to meet RPO and RTO requirements.
• Analyze and optimize T-SQL queries, execution plans, and indexing strategies.
• Conduct Root Cause Analysis (RCA) and implement preventive actions for recurring issues.
• Collaborate with infrastructure, network, application, and vendor teams to resolve technical issues and improve database services.

Minimum Qualifications

• Bachelor's Degree in Computer Science, Information Technology, Information Systems, or related field.
• Minimum 3 years of experience as a SQL Server Database Administrator.
• Strong hands-on experience in Microsoft SQL Server administration, installation, configuration, and maintenance.
• Experience with SQL Server performance tuning, troubleshooting, backup, and recovery.
• Hands-on experience in SQL Server upgrade and migration projects (in-place upgrade and side-by-side migration).
• Experience implementing and managing SQL Server High Availability (HA) and Disaster Recovery (DR) solutions.
• Strong understanding of T-SQL, indexing, execution plans, and database optimization.
• Familiarity with Windows Server environments, clustering, and enterprise infrastructure.
• Experience supporting production environments and handling critical incidents.
• Good analytical, troubleshooting, and communication skills.