Senior Microsoft SQL Server Database Support

  • Pengembangan & Administrasi Database
  • Pekanbaru Riau
  • 07-Aug-2024
  • Full time

Requirement:

  • Minimum Bachelor Degree
  • Minimum has seven years of working experience in a related field
  • Having MCSA Certification Server 2016 DB Administration (ex.: MCSA: SQL 2012-2014 & 2016 / MCSA: SQL 2012-2014).
  • 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.