Job Description

About the job Tech Engineer - SQL Server (Based in MY/ Thailand) Job Summary In this role, you will have the opportunity to Drive ongoing efforts to achieve a proactive approach. Deploy, upgrade, or migrate a specific Microsoft technology following proven best practices. Uncover the root cause of IT issues. Build new skills to improve IT services and support. Job Responsibilities You will be responsible for customer satisfaction, deployment, adoption, and support of MS SQL Servers initiatives. Assist customers in building, deploying, operating, and optimizing complex enterprise environments. This job has proven to be a career accelerator for hundreds of engineers over the years. You will be a trusted advisor, an SME specialist on your core technology and deemed as an expert providing your expertise on below. Analyzing the technology environment. Analyzing enterprise specifics. Analyzing and documenting requirements. Setting the collaboration framework. Creating a solution prototype. Participating in technology selection. Controlling solution development. Working with customers during their preferred downtime for critical deployment/support. Job Requirements Must-Have Skills Experience in Enterprise SQL Server 2016-2022 environments Architect and implement SQL database High Availability and Disaster Recovery strategies using AlwaysOn, replication, log shipping etc. Perform SQL Server performance analysis which includes reviewing query plans, index usage, and TSQL code reviews. Worked with developers and business analysts to create, modify, and tune database structures. Collaborated with application and infrastructure teams to identify solutions to complex problems and test/ implement new database features. Complete requests from application teams for database changes, security changes, data loads, etc. Experience in Replication failure errors and taking necessary steps. Install and support SQL Server BI components including SSIS, SSRS and SSAS Manage database backups and maintain recovery policies and procedures. Support ongoing and future database projects based on technology roadmaps. Maintain configuration information for the enterprise SQL Server environment, including details for server, storage, software versions, criticality, confidentiality, licensing, capacity, and ownership. Solving performance problems, query tuning, and optimization. SQL code reviews with the ability to dissect query plans, T-SQL code SQL Server Integration Services, Reporting Services, Analysis Services Perform SQL Server software installations, patching, and upgrades. Responsible for setup, configuration, and troubleshooting of complex Windows environments (e.g., clustering, high availability, load balancing, etc.). Experience in Storage management techniques, Data Engine Capacity planning, general database management, Policy-based management, Extended events and Traces. Exposure to Basic Licensing and support scenarios Good to Have Skills Working knowledge of DDL, DML, TSQL, stored procedures, triggers, views, constraints, cursors Experience with PowerShell, including using PowerShell to automate repeatable tasks. Use of PowerShell DSC for automating SQL Server installations and configuration Experience with Visual Studio for the creation and maintenance of SSRS reports and SSIS packages. Exposure to SQL Server Reporting service, SQL Server Integration Service, SQL Server Analysis Service Remuneration Malaysia: MYR 10,000 - MYR 11,000 Thailand: THB 75,000 - THB 120,000 Consultant In Charge Shin Yoong | [HIDDEN TEXT] | 013 - 863 5499 Victor Hew | [HIDDEN TEXT] | 016 - 229 2513 Phoebe Loke | [HIDDEN TEXT] | 016 - 211 7443

foundit