Sql Database Administrator

Ensar Solutions; Hyderabad; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Ensar Solutions is seeking a SQL Database Administrator with 5-9 years of experience to manage, maintain, and optimize SQL Server environments. You will work across Production, UAT, and Development with a focus on performance, security, backups, and automation.

The role requires hands-on SQL skills, experience in tuning, and capability to automate tasks using T-SQL and PowerShell. Collaboration with cross-functional teams is essential to ensure reliability and continuity.

Qualifications

• 5-9 years of SQL Server experience in a DBA role.
• Hands-on in query writing, maintenance, and optimization.
• Experience with production, UAT, and development DB environments.

Responsibilities

• Provide day-to-day DBA support for prod, UAT, and development environments.
• Install, configure, upgrade, and maintain SQL Server systems.
• Monitor performance and tune queries, indexes, and server configurations.
• Manage backups and recoveries to ensure data integrity and availability.
• Implement security with proper user access management and RBAC.

Skills

SQL Server

Database Administration

Performance Tuning

Backup & Recovery

Security Management

Automation & Scripting

T-SQL

Capacity Planning

Troubleshooting

Team Collaboration

Job description

JOB DESCRIPTION:

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

Key responsibilities:

1. Database Administration & Environment 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

• Automate routine DBA tasks using T-SQL and PowerShell scripting.
• Develop scripts for monitoring, maintenance, and administrative tasks.

7. Capacity Planning & Monitoring

• Perform capacity planning and monitor resource utilization.
• Continuously assess database growth and performance trends.

8. Troubleshooting & Incident Management

• Strong troubleshooting and problem-solving skills to resolve complex database issues.
• Handle production incidents with focus on root cause analysis and long-term fixes.

9. Best Practices & Continuous Improvement

• Stay updated with evolving database technologies and infrastructure changes.
• Ensure adherence to best practices in database design, maintenance, and performance management.

10. Soft Skills

• Strong communication skills with ability to work independently and in a team.
• Ability to collaborate effectively with development, infrastructure, and support teams.