Sr Database Administrator

Algoleap Technologies; Hyderabad; On-site; INR 1,500,000 - 1,900,000; Full time

Job summary

Algoleap Technologies Pvt Ltd is seeking a highly skilled L3 Database Administrator to manage and optimize critical SQL Server and PostgreSQL databases. The role includes advanced troubleshooting, performance tuning, cloud database management, and ensuring high availability and disaster recovery for production environments.

Responsibilities include administration, tuning, backup/restore, DR planning, monitoring, and automation using scripting.

Qualifications

• Proficient with SQL Server and PostgreSQL management and tuning.
• Experience with cloud-based database services (Azure).
• Strong skills in backups, DR, and high availability strategies.

Responsibilities

• Administer and maintain SQL Server and PostgreSQL databases.
• Analyze slow queries and optimize execution plans.
• Design and implement backup, restore, and DR strategies.

Skills

SQL Server

PostgreSQL

Performance tuning

Cloud databases

Backup & DR

Automation scripting

Tools

Azure SQL Managed Instance

Azure Monitor

Grafana

PowerShell / Bash / Python

Job description

Algoleap Technologies Pvt Ltd | Full time

We are seeking a highly skilled L3 Database Administrator with strong expertise in SQL Server and PostgreSQL to manage, support, and optimize critical database systems. The role involves advanced troubleshooting, performance tuning, cloud database management, and ensuring high availability and disaster recovery for production environments.

Key Responsibilities

Database Management

• Administer and maintain SQL Server (IaaS SQL Instance, Azure SQL Managed Instance, Azure SQL DB) and PostgreSQL databases
• Perform installations, upgrades, patching, and migrations
• Manage database provisioning and environment setup

Performance Tuning & Optimization

• Analyze and optimize slow queries and execution plans
• Design and maintain indexing strategies
• Troubleshoot blocking, deadlocks, and performance bottlenecks

Backup, Restore & Disaster Recovery

• Design and manage backup strategies (Full, Differential, Log)
• Perform database restores and point-in-time recovery
• Implement and validate DR strategies

High Availability

• Configure and manage SQL Server Always On Availability Groups
• Failover clustering
• PostgreSQL replication (streaming/logical)

Monitoring & Automation

• Implement monitoring and alerting solutions
• Automate routine DBA tasks using scripting (PowerShell, Bash, Python)
• Work with monitoring tools (Azure Monitor, Grafana, etc.)

Security & Compliance

• Manage database security (logins, roles, permissions)
• Implement encryption and auditing policies
• Ensure compliance with organizational standards