Description

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.

Responsibilities

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

Qualifications

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 setting 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

📌 DATABASES-Engineering-MySQL (Hyderabad)
🏢 Zensar Technologies
📍 Hyderabad