Job Description:
Installation & Configuration
- Install and configure SQL Server instances across environments (development, test, production).
- Set up clustering, replication, and Always On availability groups for high availability.
Database Maintenance- Perform routine health checks, index maintenance, and statistics updates.
- Monitor database growth and manage storage effectively.
Performance Tuning- Analyze query execution plans and optimize SQL queries.
- Configure server settings and indexes to improve performance.
Security & Compliance- Manage user accounts, roles, and permissions.
- Implement encryption, auditing, and compliance policies (GDPR, HIPAA, etc.).
Backup & Recovery- Design and implement backup strategies (full, differential, transaction log).
- Perform disaster recovery drills and ensure recovery time objectives (RTO) are met.
Troubleshooting- Diagnose and resolve blocking, deadlocks, and failed jobs.
- Work with developers to debug stored procedures and optimize schema design.
Upgrades & Migrations- Plan and execute upgrades to newer SQL Server versions.
- Migrate databases between servers or cloud platforms (Azure SQL, AWS RDS).
SSRS & SSIS- Strong knowledge of T-SQL, SSIS, SSRS, SSAS.
- Problem-solving and analytical thinking.
Risks & Challenges- Communication and collaboration with cross-functional teams.
- Ability to work under pressure during outages or performance issues.
Skills Required:
- MS SQL Database Administration
- Installation & Configuration
- Backup & Recovery
- Upgrades & Migrations
- SSRS & SSIS
Educational Qualification:
BTech/BE/BCA/BSc (CS , IT )/MSc or Equivalent Bachelor Degree in IT.
Project Management:
