Senior Database Administrator

Writer Corporation; Mumbai; On-site; INR 2,800,000 - 5,200,000; Full time

Job summary

Writer Corporation is seeking an experienced Database Administrator to design, deploy, and optimize MS SQL Server databases across on-premise and cloud environments. You will manage HA/DR, perform advanced tuning, and implement robust backup and security measures.

The role also covers open-source DBs (MySQL, PostgreSQL, MongoDB), scripting automation, and collaboration with engineers on schema design and CI/CD pipelines. On-call rotation is required.

Qualifications

• Experience: 7+ years of dedicated Database Administration experience with at least 5 years on MS SQL Server.
• Proficiency in MS SQL Server internals, T-SQL, execution plans, Extended Events, and Query Store.
• 2+ years hands-on experience with MySQL, PostgreSQL, and MongoDB in production environments.

Responsibilities

• Design, deploy, and maintain mission-critical MS SQL Server databases in on-premise and cloud environments.
• Manage High Availability (HA) and Disaster Recovery (DR) solutions including AlwaysOn Availability Groups, Failover Clustering, Log Shipping, and Replication.
• Perform advanced query optimization, indexing, and performance tuning to resolve complex database performance issues.
• Develop and implement robust backup, restore, and data archiving strategies.
• Automate routine DBA tasks using PowerShell, T-SQL, or other scripting languages.
• Manage database security, user access, and auditing in compliance with industry standards.
• Administer, monitor, and optimize MySQL and PostgreSQL databases, including replication and maintenance.
• Deploy and maintain MongoDB clusters with proper sharding and replica set configuration.
• Lead capacity planning, collaborate on schema design, and enforce CI/CD for databases.
• Mentor junior DBAs and engineers; participate in 24/7 on-call rotation.

Skills

MS SQL Server

PowerShell

Python

Bash

Windows Server

Linux

Query Store

AlwaysOn

Failover Clustering

Log Shipping

Replication

Scripting & Automation

Tools

SolarWinds

Redgate

Datadog

Percona Monitoring and Management

Terraform

Ansible

Job description

Key Responsibilities

Primary: MS SQL Server Administration

• Design, deploy, and maintain mission-critical MS SQL Server databases in on-premise and cloud environments.
• Manage High Availability (HA) and Disaster Recovery (DR) solutions, including AlwaysOn Availability Groups, Failover Clustering, Log Shipping, and Replication.
• Perform advanced query optimization, indexing, and performance tuning to resolve complex database performance issues.
• Develop and implement robust backup, restore, and data archiving strategies.
• Automate routine DBA tasks using PowerShell, T-SQL, or other scripting languages.
• Manage database security, user access, and auditing in compliance with industry standards.

Secondary: Open-Source & NoSQL Database Management

• Administer, monitor, and optimize MySQL and PostgreSQL databases, including managing replication and routine maintenance (e.g., PostgreSQL vacuuming).
• Deploy and maintain MongoDB clusters, ensuring proper sharding, replica set configuration, and document modeling optimization.
• Troubleshoot performance bottlenecks and implement scaling strategies across open-source platforms.
• Assist in migrating data between different database engines where architecturally appropriate.

General Engineering & Leadership

• Lead database capacity planning and infrastructure scaling initiatives.
• Collaborate with software engineers to review schema designs and optimize database interactions within applications.
• Establish and enforce database development standards, best practices, and CI/CD pipelines for database deployments.
• Mentor junior database administrators and engineers.
• Participate in a 24/7 on-call rotation to resolve critical database incidents.

Required Qualifications

• Experience: 7+ years of dedicated Database Administration experience, with at least 5 years focused heavily on MS SQL Server.
• Expertise in MS SQL: Deep, hands-on knowledge of MS SQL Server internals, T‑SQL, execution plan analysis, Extended Events, and Query Store.
• Open-Source Proficiency: 2+ years of hands‑on experience managing and troubleshooting MySQL, PostgreSQL, and MongoDB in a production environment.
• Scripting & Automation: Strong proficiency in scripting languages such as PowerShell, Python, or Bash.
• OS Knowledge: Solid understanding of both Windows Server and Linux operating systems as they relate to database performance.
• Problem‑Solving: Exceptional analytical skills with a proven track record of resolving complex database outages and performance degradation under pressure.

Preferred Qualifications

• Experience with Cloud Database PaaS/IaaS offerings (Azure SQL, AWS RDS).
• Familiarity with Infrastructure as Code (IaC) tools like Terraform or Ansible.
• Experience implementing database monitoring tools (e.g., SolarWinds, Redgate, Datadog, or Percona Monitoring and Management).
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, DBA certification).