Nous Infosystems - Database Administrator

Description :

- Position : Database Administrator

- Exp : 6-10 Years

- Location : Hyderabad [Madhapur]

- Work mode : 3 Days WFO

Mandatory Skills :

- Sql, Azure SQL Managed Instance, Azure SQL DB and PostgreSQL databases Perform installations

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.

Role :

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 :

1. SQL Server Always On Availability Groups

2. Failover clustering

3. 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