SQL Database Admin, Contract

Posted Yesterday
Be an Early Applicant
Hiring Remotely in India
Remote
Senior level
Cloud • Information Technology
The Role
Responsible for administering and optimizing SQL Server environments: design and maintain Always On Availability Groups and WSFC, implement backup/DR and archiving strategies, tune T-SQL and indexes, manage table partitioning, monitor performance, ensure security/compliance, and support schema deployments across DEV/QA/UAT/PROD.
Summary Generated by Built In

Overview of 66degrees

66degrees is an end-to-end AI transformation partner that guides enterprises from complex business challenges to clear, quantifiable outcomes. Our company is the culmination of several successful firms, each a leader in its own right in cloud, artificial intelligence, and data. This convergence of talent and expertise is how we help businesses reach their own "inflection point," where chaotic data becomes a strategic asset, complexity becomes clarity, and AI becomes an engine for growth. Our ultimate vision is to be the catalyst for a future where every business operates as an intelligent enterprise, with autonomous systems unlocking human potential.

At 66degrees, we believe in thriving through challenges and winning together. These values not only guide us in achieving our goals as a company but also for our people. We are dedicated to creating a significant impact for our employees by fostering a culture that sparks innovation and supports professional and personal growth along the way.

Overview of Role

We are seeking a highly skilled SQL Server Database Administrator (DBA) responsible for ensuring the availability, performance, security, and scalability of critical database systems. This role demands deep expertise in High Availability (HA) technologies—especially Always On Availability Groups, data archiving strategies, and table partitioning for large-scale OLTP/OLAP workloads and database development.


Availability to join: ASAP

Working shift: 1 PM IST to 10 PM IST (preferred)

Duration: Contract To Hire (6 Months), potential to convert/extend

Responsibilities
  • Design, configure, maintain, and troubleshoot SQL Server Always On Availability Groups for mission-critical environments.
  • Manage Failover Clustering (WSFC), quorum configuration, and multi-subnet deployments.
  • Monitor and optimize replication lag, failover readiness, and AG health states.
  • Develop, maintain, and test DR strategies, including geo-replication and failover runbooks.
  • Implement backup/restore strategies using 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 standards compliance.
  • Tune workloads using execution plan analysis, indexing strategies, statistics maintenance, and parameter sniffing mitigation.
  • Collaborate with development teams to design efficient schema, indexing, and query strategies.
  • Design and implement database archiving frameworks for large and older datasets.
  • Build automated archiving and purge jobs—while ensuring referential integrity and application continuity.
  • Define data retention policies aligned 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 partition switch strategies.
  • Optimize data loading, maintenance jobs (index rebuilds, compression), and storage utilization.
  • Monitor and troubleshoot CPU, memory, IO, tempdb, locking/blocking, and wait statistics.
  • Optimize high-volume transaction environments and resolve performance bottlenecks.
  • Configure and maintain SQL Server monitoring solutions (DMVs, Extended Events, PerfMon, third-party tools).
  • Perform routine maintenance—indexing, statistics updates, integrity checks, growth management, and filegroup management.
  • Administer SQL Server instances across DEV, QA, UAT, and PROD environments.
  • Ensure security best practices—roles, permissions, encryption, auditing, and compliance.
  • Support release deployments and schema changes using version control pipelines.
Qualifications
  • 5+ years of hands-on SQL Server DBA experience (2016 / 2019 / 2022).
  • Expert-level knowledge of Always On Availability Groups and Windows Server Failover Clustering (WSFC).
  • Strong T-SQL development and query tuning skills.
  • Proven experience designing and managing table partitioning for high-volume data.
  • Hands-on experience with database archiving, purge strategies, and data retention frameworks.
  • Proficient in backup/recovery planning, DR testing, and point-in-time restore procedures.
  • Experience with SQL Server security—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 OS-level configuration.
  • A Bachelor’s degree in Computer Science, Computer Engineering, or related or equivalent work experience 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 for DBA automation and scheduled tasks.
  • Exposure to data warehouse environments (SSAS, SSRS, SSIS).
  • Prior experience in a Managed Services or multi-client production environment is a plus.

66degrees is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to actual or perceived race, color, religion, sex, gender, gender identity, national origin, age, weight, height, marital status, sexual orientation, veteran status, disability status or other legally protected class.

AI Transparency & Disclosure

As an AI transformation partner, 66degrees leverages intelligent solutions to enhance our recruitment experience. We utilize AI tools—including LinkedIn Recruiter’s Hiring Assistant and interview transcription technologies—to assist with sourcing, role analysis, and capturing interview highlights.

These tools augment our process, but we "Commit to Our Craft" by ensuring all final hiring decisions are made by our human Talent Team. By applying, you acknowledge the use of these technologies to help us "Win Together" in finding the best fit for our team.

Skills Required

  • 5+ years of hands-on SQL Server DBA experience (2016/2019/2022).
  • Expert-level knowledge of Always On Availability Groups and Windows Server Failover Clustering (WSFC).
  • Strong T-SQL development and query tuning skills.
  • Proven experience designing and managing table partitioning for high-volume data.
  • Hands-on experience with database archiving, purge strategies, and data retention frameworks.
  • Proficient in backup/recovery planning, DR testing, and point-in-time restore procedures.
  • Experience with SQL Server security: 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 OS-level configuration.
  • Bachelor's degree in Computer Science, Computer Engineering, or equivalent experience.
  • 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 for DBA automation and scheduled tasks.
  • Exposure to data warehouse environments (SSAS, SSRS, SSIS).
  • Prior experience in a Managed Services or multi-client production environment.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, Illinois
564 Employees

What We Do

At 66degrees, we specialize in helping businesses across all industries modernize through cloud adoption to achieve data-driven transformation. As a pure play Google Cloud partner, our team of experts leverages the latest Google Cloud technologies and best practices to create customized solutions for each client. We offer comprehensive advisory, implementation, and managed services to support our clients throughout their cloud journey. Our commitment to excellence is reflected in our partnership with our clients. We prioritize staying up-to-date with the latest cloud technologies and trends through training and certification. By enabling businesses to harness the power of data, we help them make informed decisions, enhance customer experiences, and drive growth.

Similar Jobs

Zapier Logo Zapier

Manager/Sr. Manager, Sales Assist

Artificial Intelligence • Productivity • Software • Automation
Remote
3 Locations
800 Employees

Airwallex Logo Airwallex

Associate Account Executive

Artificial Intelligence • Fintech • Payments • Business Intelligence • Financial Services • Generative AI
In-Office or Remote
Bangalore, Bengaluru Urban, Karnataka, IND
2200 Employees

Micron Technology Logo Micron Technology

Safety Manager

Artificial Intelligence • Hardware • Information Technology • Machine Learning
Remote
Gujarat, IND
45000 Employees
5-8 Annually

CrowdStrike Logo CrowdStrike

Account Manager

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
Bangalore, Bengaluru Urban, Karnataka, IND
10000 Employees

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account