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.