Senior Database Administrator

Weekday AI (YC W21); Bengaluru; On-site; INR 1,000,000 - 2,000,000; Full time

Job summary

Weekday AI (YC W21) in Bengaluru is seeking an experienced Senior Database Administrator to manage production and non-production environments. The role focuses on Microsoft SQL Server and PostgreSQL with emphasis on availability, security, backup/recovery, and disaster recovery.

The ideal candidate will have 6+ years of hands-on production database administration, strong T-SQL skills, and experience with Always On, replication, and performance tuning.

Qualifications

• The candidate should have hands-on production DB administration experience.
• Expertise in Microsoft SQL Server and PostgreSQL is mandatory.
• Strong skills in backup, recovery, security, and HA/DR operations.

Responsibilities

• Administer and maintain SQL Server and PostgreSQL databases across environments.
• Monitor health, performance, availability, and capacity; optimize queries.
• Manage backups, restores, and point-in-time recovery with high availability features.
• Troubleshoot complex database issues and support production incidents.
• Automate repetitive tasks using PowerShell and dbatools; document procedures.

Skills

Database administration

SQL Server

PostgreSQL

T-SQL

Query tuning

HA/DR

PowerShell

Incident management

Tools

Azure SQL Managed Instance

AWS RDS

MySQL

CI/CD

dbatools

Job description

Job Description:

This role is for one of the Weekdays clients.

Rs 1000000 - Rs 2000000 (ie INR 10-20 LPA)

Experience: 6+ yrs

Location: Bengaluru

Job Type: Full-time

We are looking for an experienced and hands-onSenior Database Administratorto manage, maintain, and support business-critical database environments across production and non-production systems. The role requires strong expertise inMicrosoft SQL Server and PostgreSQL, with a focus on database availability, performance, security, backup and recovery, and high-availability and disaster-recovery operations.

The ideal candidate will be capable of independently troubleshooting complex database issues, supporting critical production environments, and working closely with application, infrastructure, and engineering teams to ensure reliable database operations.

Key Responsibilities

• Administer and maintainMicrosoft SQL Server and PostgreSQLdatabases across production and non-production environments.
• Perform SQL Server installation, configuration, patching, upgrades, and ongoing maintenance.
• Monitor database health, performance, availability, resource utilisation, and capacity.
• Diagnose and resolve complex database issues involvingslow queries, blocking, deadlocks, replication, connectivity, and database failures.
• Perform database performance tuning and query optimization using execution plans, DMVs, Query Store, wait statistics, and other diagnostic tools.
• Develop and maintainT-SQL scriptsand database administration utilities.
• Manage database backup, recovery, restore, and point-in-time recovery processes.
• Regularly validate backup integrity and restore readiness to support business continuity.
• SupportAlways On Availability Groups, high availability, disaster recovery, replication, and failoverenvironments.
• Participate in planned failover activities and disaster-recovery exercises.
• Implement and maintain database monitoring, alerting, and capacity-management processes.
• Participate in production incidents and provide timely technical updates to stakeholders.
• Conduct root-cause analysis and prepare detailedRCA reports and technical documentation.
• Work closely with application, infrastructure, DevOps, and engineering teams to troubleshoot and resolve database-related issues.
• Follow database security, access-control, change-management, and operational best practices.
• Identify opportunities to automate repetitive database administration activities usingPowerShell, dbatools, or similar tools.
• Support database upgrades, migrations, configuration changes, and operational improvement initiatives.
• Maintain accurate database documentation, operational procedures, and recovery processes.

What Makes You a Great Fit

• 6+ years of hands-on experiencein production database administration.
• Mandatory expertise inMicrosoft SQL Server and PostgreSQL.
• Strong experience with SQL Server installation, configuration, patching, upgrades, and maintenance.
• Strong knowledge ofdatabase performance tuning and query optimization.
• Hands-on experience with execution plans, DMVs,Query Store, wait statistics, blocking, and deadlock analysis.
• Strong understanding ofbackup, recovery, restore, and point-in-time recovery.
• Experience withAlways On Availability Groups, HA/DR, replication, and failover.
• Strong proficiency inT-SQL and database scripting.
• Experience with database monitoring, alerting, capacity planning, and availability management.
• Practical experience troubleshooting critical production database issues.
• Familiarity withPowerShell and dbatoolsis an advantage.
• Exposure toAzure SQL Managed Instance, AWS RDS, MySQL, Database DevOps, CI/CD, or regulated environmentsis an added advantage.
• Strong understanding of database security, access controls, change management, and operational governance.
• Excellent verbal and written communication skills.
• Strong analytical and problem-solving abilities with a structured approach to incident resolution.
• Ability to work independently, manage production priorities, and collaborate effectively with cross-functional technical teams.

Requirements: