JOB DESCRIPTION:

We are seeking for SQL Database Administrator (DBA) with 3-5 years of experience to manage, maintain, and optimize our SQL Server database environments. The ideal candidate should have hands-on experience in database administration, performance tuning, backup and recovery, security management, automation, and troubleshooting across Production, UAT, and Development environments.

Key responsibilities:

1. Database Administration & Setting Support
- Support production, UAT, and development environments with day-to-day database administration tasks.
- Install, configure, upgrade, and maintain SQL Server database systems.
- Manage routine database operations such as monitoring, maintenance, purging, and alert handling.
- Manage and refresh DEV and QA environments to ensure consistency with production data (where applicable).

2. Performance Tuning & Optimization
- Monitor database performance and implement tuning strategies for queries, indexes, and server configurations.
- Provide expertise in database performance tuning and SQL Server performance features.




- Troubleshoot and resolve blocking, deadlocks, and other performance bottlenecks.
- Proactively monitor system behavior to predict potential performance or failure issues.
- Advise development and support teams on performance issues and recommend tuning solutions.

3. Backup & Recovery
- Manage backup and recovery processes to ensure data integrity and business continuity.
- Ensure database recoverability through proper backup strategies and validation.
- Ensure system stability and availability through proactive monitoring and issue resolution.

4. Indexing & Query Efficiency
- Proficient in creating and managing clustered and non-clustered indexes.
- Understand and manage index fragmentation and perform index maintenance activities.

5. Security & Access Management
- Ensure database security through proper user access management and role-based permissions.

6. Automation & Scripting
- Automa

📌 Database Administrator (Hyderabad)
🏢 Ensar Solutions
📍 Hyderabad