Support Engineer

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.

Tools You ll Use

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