SQL Server Specialist

Job Code: DI/Tech/2023/286

Position: SQL Server Specialist

Location: Bangkok/Chon Buri

Experience: 5 Years. (Other experiences also apply)

Data & AI (SQL Server Infrastructure / SQL optimization / High Availability) - JOB DESCRIPTION

Technical Expertise Required

SQL Server & Data

The role requires depth knowledge in a number of the following technology areas:

Mandatory

·Data modelling and database design.

·Indexing strategy

·Performance Optimization and Tuning Capabilities

·Partitioning data implementations

·Metadata management and repository usage.

·Database schema creation and management.

·Backup and recovery.

·Ensuring data integrity.

·Ensuring High availability and Disaster recovery.

·SQL code reviews with ability to dissect query plan, T-SQL code

·Sargability of statements

·Procedural skills.

·Data security.

·Data Encryption

·Auditing

·Replication of data

·SQL Edition and version differences with discontinued and deprecated features

·Upgrade process

·Storage management techniques.

·Data Engine Capacity planning.

·General database management, Policy based management

·Extended events and Traces

·Basic Licensing and support scenarios

Nice to have

·Windows Failover Clustering

·SQL Server Reporting service

·SQL server Integration Service

·SQL Server Analysis Service

·Powershell