Skill diminta
CommunicationSQLSQL ServerTroubleshooting
Gaji pasar untuk posisi ini
Median Rp2,8 jt/bulan · rentang umum Rp2,0 jt – Rp3,4 jt
Berdasarkan 2.419 lowongan F&B Service se-Indonesia (semua level).
Lihat data gaji selengkapnya →Deskripsi
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.
- 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).