Engineer

Skill : SQL Database Administrator

Roles & Responsibilities :

• We are seeking a seasoned SQL DBA to design, build, secure, and operate Azure SQL Managed Instance (SQL MI) and Azure SQL Database (PaaS) environments.
• The role combines deep database administration expertise with modern DevOps practices CI / CD for database changes, infrastructure-as-code, automation, monitoring, and SRE style reliability, supporting mission-critical workloads at scale
• Plan, create, and administer Azure SQL Managed Instance and Azure SQL Database across Dev, Test, UAT, and Production.
• Own HA-DR : failover groups, auto failover groups, availability design, backup / restore strategy (long-term retention), and disaster recovery drills.
• Performance engineering : index and query tuning, plan analysis, statistics management, workload classification, and elastic pool rightsizing.
• Security & compliance : Azure AD authentication, AAD-only auth, role-based access, encryption (TDE, CMK), auditing, Defender for Cloud for SQL, vulnerability assessments, and data masking.
• Operate at scale : automated provisioning, configuration baselines, and policy enforcement using Terraform / Bicep / ARM and Azure DevOps pipelines.
• Implement database DevOps : source control for schema (Git), migration scripts (SQLProj / DACPAC), bluegreen / canary deployment patterns, and automated validation.
• Monitor & observability : Azure Monitor, Log Analytics, metrics / alerts, Query Store, Intelligent Insights; define SLOs / SLIs and error budgets with SRE practices.
• Cost governance : sizing, reserved capacity planning, serverless vs provisioned, elastic pools, and cost monitoring / optimization.
• Data protection & recovery : PITR, georestore, long-term backup retention (LTR), and ransomwareresilient restore procedures.
• Manage connectivity : private endpoints, VNet integration, NSGs, firewall rules, service endpoints, and connection resiliency.
• Migration : assess readiness (DMA / DTU / AMR), use DMS / Azure Migrate, nearzero downtime migration strategies, and postmigration validation.
• Operational excellence : patching cadence, change management, incident / Problem management, root cause analysis, and runbooks with automation (Azure Automation / Functions).
• Collaboration : partner with app teams, security, network, and SRE to deliver reliable, secure data platforms; provide documentation and knowledge transfer.

Salary Range - $100,000-$130,000 a year

TCS Employee Benefits Summary :