Key Responsibilities :
- Install, Configure, and Maintain : Set up and maintain SQL Server instances (on-premises and / or cloud).
- Monitor and Optimize : Monitor database performance, implement changes, and apply patches / versions when required.
- Database Backups and Recovery : Perform database backups , restores, and recovery.
- Security Management : Manage SQL Server security (authentication, permissions, roles).
- Query and Index Optimization : Optimize SQL queries and indexes for better performance.
- Troubleshooting : Troubleshoot database-related issues, including system outages and performance bottlenecks.
- High Availability (HA) and Disaster Recovery (DR) : Implement HA and DR solutions for SQL Server.
- Task Automation : Automate repetitive DBA tasks using T-SQL , PowerShell , or other tools.
- Capacity Planning : Perform capacity planning and storage management .
- Documentation : Create and maintain technical documentation and Standard Operating Procedures (SOPs) .
- Collaboration : Work with development and support teams on database-related issues and projects.
Required Skills and Qualifications :
Proven Experience : Experience as a SQL Server DBA (SQL Server 2012 / 2016 / 2019 / 2022).T-SQL & SSMS Proficiency : Strong proficiency in T-SQL and SQL Server Management Studio (SSMS) .Backup, Restore, and Recovery : Experience with backup , restore , and recovery models .High Availability & Disaster Recovery : Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.Monitoring Tools : Experience with monitoring tools like SQL Profiler , Extended Events , and third-party solutions (e.g., SolarWinds , Redgate ).Performance Tuning & Optimization : Familiarity with performance tuning and optimization (PTO).Cloud Database Experience : Experience working with Azure SQL Database , SQL Managed Instance , or AWS RDS (preferred).Project Management Skills : Ability to handle multiple projects and priorities.Strong Communication Skills : Excellent communication and documentation skills.Preferred Qualifications :
Microsoft Certification : Azure Database Administrator Associate or similar certification.SQL Server Tools : Experience with SSIS , SSRS , and SSAS .DevOps & CI / CD : Knowledge of DevOps processes and CI / CD pipelines for database code deployment.Cloud Platforms : Exposure to cloud platforms like Azure , AWS , and GCP .Skills Required
Azure, Aws, Gcp, Ssis, Ssrs, Sql