SQL Database Admin

This is a fully remote position, open to applicants in India.

📋 Description

• Design, configure, maintain, and troubleshoot SQL Server Always On Availability Groups in mission-critical environments.

• Manage Failover Clustering (WSFC), quorum setups, and multi-subnet deployments.

• Monitor and enhance replication lag, failover readiness, and the health states of Availability Groups.

• Develop, maintain, and test disaster recovery strategies, including geo-replication and failover runbooks.

• Implement backup and restore strategies utilizing Full, Differential, Log backups, copy-only backups, and automated validation.

• Develop and optimize T-SQL code, stored procedures, functions, views, triggers, and scripts.

• Review SQL code for performance, security, and adherence to standards.

• Tune workloads through execution plan analysis, indexing strategies, statistics maintenance, and parameter sniffing mitigation.

• Collaborate with development teams to create efficient schema, indexing, and query strategies.

• Design and implement database archiving frameworks for large and legacy datasets.

• Build automated archiving and purge jobs while ensuring referential integrity and application continuity.

• Define data retention policies in line with compliance and business requirements.

• Migrate historical data to secondary storage systems.

• Implement and manage table partitioning for large-scale transactional data.

• Create and maintain partition functions, schemes, sliding windows, and strategies for partition switching.

• Optimize data loading processes, maintenance jobs (index rebuilds, compression), and storage utilization.

• Monitor and troubleshoot CPU, memory, I/O, tempdb, locking/blocking, and wait statistics.

• Optimize high-volume transaction environments and address performance bottlenecks.

• Configure and maintain SQL Server monitoring solutions (DMVs, Extended Events, PerfMon, and third-party tools).

• Perform routine maintenance activities—indexing, statistics updates, integrity checks, growth management, and filegroup management.

• Administer SQL Server instances across DEV, QA, UAT, and PROD environments.

• Ensure best practices for security—roles, permissions, encryption, auditing, and compliance.

• Support release deployments and schema changes utilizing version control pipelines.

⛳️ Requirements

• Over 5 years of practical SQL Server DBA experience (2016 / 2019 / 2022).

• Expert-level understanding of Always On Availability Groups and Windows Server Failover Clustering (WSFC).

• Strong skills in T-SQL development and query optimization.

• Proven experience in designing and managing table partitioning for high-volume data.

• Hands-on knowledge of database archiving, purge strategies, and data retention frameworks.

• Proficient in backup/recovery planning, disaster recovery testing, and point-in-time restore procedures.

• Experience with SQL Server security measures—TDE, RBAC, row-level security, and auditing.

• Familiarity with CI/CD pipelines for schema migrations (Flyway, Liquibase, SSDT).

• Comfortable with Windows Server and SQL Server operating system-level configurations.

• A Bachelor’s degree in Computer Science, Computer Engineering, or a related field, or equivalent work experience is required.

• Preferred: Microsoft Certified: Azure Database Administrator Associate.

• Experience with Azure SQL Managed Instance or Amazon RDS for SQL Server.

• Familiarity with monitoring tools such as SolarWinds DPA, Datadog, or SentryOne.

• PowerShell scripting experience for DBA automation and scheduled tasks.

• Exposure to data warehouse environments (SSAS, SSRS, SSIS).

🏝️ Benefits

• Health insurance

• Professional development opportunities