Support Engineer

Abu Dhabi Health Services; Dubai; On-site; AED 120,000 - 200,000; Full time

Job summary

A healthcare provider in Dubai is seeking a skilled IT Specialist to handle incident responses and database troubleshooting. The candidate should have 3-4 years of experience with MS SQL and Node.js. The role involves optimizing performance and managing backend fixes effectively using Azure tools. Immediate joiners in Visit Visa preferred. A competitive salary range of 10,000 to 12,000 AED is offered, along with opportunities to work with modern tech stacks.

Qualifications

• 3-4 years of experience with MS SQL including strong T-SQL and query tuning.
• 3-4 years of experience with Node.js, particularly with Express/Fastify APIs.
• Basic working knowledge of Azure services like App Insights and Azure Functions.

Responsibilities

• Own and resolve L2/L3 incidents within SLAs.
• Troubleshoot databases, optimize queries, and enhance performance.
• Manage backend fixes in Node.js with minimal downtime.

Skills

MS SQL

Node.js

Azure

Git

Postman/cURL

Tools

Azure Portal

SQL Server Management Studio (SSMS)

VS Code

Job description

Key Responsibilities

• Incident response & triage: Own L2/L3 tickets, perform root-cause analysis, and drive issues to closure within SLAs.
• Database troubleshooting (MS SQL): Diagnose User Issues, slow queries, deadlocks, blocking; create/modify indexes; analyze execution plans; write safe roll-forward/rollback scripts.
• Backend fixes (Node.js): Reproduce bugs, patch services, add tests, and ship hotfixes via CI/CD with minimal downtime.
• Observability: Build actionable dashboards/alerts (App Insights, Azure Monitor, Log Analytics), define SLOs and error budgets.
• Performance & reliability: Capacity checks, connection-pool tuning, caching strategies, and memory/CPU profiling for Node.js services.
• Release support: Participate in canary/blue-green rollouts, config toggles/feature flags, and post-deployment validation.
• Runbooks & documentation: Create step-by-step playbooks for recurring incidents; improve on-call readiness.
• Security & compliance: Apply least-privilege DB roles, rotate secrets/keys, and follow change-management procedures.
• Stakeholder communication: Provide clear updates during incidents; write postmortems with corrective actions.

Required Skills & Experience

• MS SQL (3–4 yrs):
  • Strong T-SQL (CTEs, window functions), query tuning with actual/estimated plans
  • Indexing strategies (clustered/non-clustered, filtered, covering), stats maintenance
  • Troubleshooting deadlocks, blocking chains, tempdb contention; SQL Agent jobs & backups
• Node.js (3–4 yrs):
  • Express/Fastify APIs, async patterns, Promises, error handling
  • ORM/Query builders (TypeORM/Knex/Sequelize) and direct T-SQL when needed
  • Debugging (Chrome DevTools/VS Code), memory leak detection, log correlation
  • Unit/integration tests (Jest/Vitest), env/config management
• Azure (basic, working knowledge):
  • App Service / Azure Functions basics, APIM, Azure Storage (Blob), App Insights & Log Analytics
  • CI/CD pipelines (Azure DevOps/GitHub Actions) and basic networking concepts
• General: Git, Postman/cURL, reading/writing OpenAPI specs, REST fundamentals, JSON/NDJSON logs.
• Immediate Joiners in Visit Visa preferred

Nice-to-Have

• KQL for App Insights/Log Analytics; Kusto queries for incident investigations
• Azure Service Bus, Event Grid basics; Redis caching; message-driven troubleshooting
• Containers & AKS basics; Nginx/Ingress understanding

Tools You’ll Use

Azure Portal, App Insights, Log Analytics (KQL), Azure DevOps, Git, Postman, SQL Server Management Studio (SSMS), VS Code, Grafana/Power BI (nice)

Salary offered: 10,00 AED to 12,000 AED