Middle SQL Engineer
5 days ago
Pekanbaru, Riau, Indonesia
PT Sisindokom Lintasbuana
Full time
120,000 - 180,000 per year
Requirement:
- Minimum Bachelor Degree
- Minimum has 4 years of working experience in a related field.
- Having MCSA Certification Server 2016 DB Administration (ex.: MCSA: SQL & 2016 / MCSA: SQL
- Knowledge in MS SQL Server 2016 Always On Technology.
- Have experience in Microsoft Active Directory, Microsoft Exchange, Microsoft WSUS, Microsoft SCCM, dan Microsoft Azure , atau 365 (Microsoft Certified: Azure Database Administrator Associate / MCSA: SQL 2016 & Microsoft Certified: Azure Database Administrator Associate which is still valid during the Services are provided).
- Mastering Windows Server Failover Cluster, replication and Always On.
- Mastering performance tuning.
- Mastering database security features (audit trail, database firewall, encryption, data masking).
- Familiar with SQL Server Analysis Service, SQL Server Integration Services, SQL Server Reporting Services.
- Mastering basic DBA activities (installation, patch updates, migration, backup restore, DML, DDL, and others).
Job Description:
- Installation and Configuration Database SQL Server (Including Upgrade and Patching)
- Create, Manage Database Files & Structure Storage
- Ensure security configuration of objects such as user, schema, concurrency data, and consistency
- Daily Maintenance & Preventive,
- Monitoring, Tuning Performance, and Backup & Recovery Database
- Identify Issues and Risks, and minimize the impact.