Key Responsibilities

- Develop and implement database backup and recovery procedures to ensure data integrity

- Monitor database performance and optimize queries, indexes, and database structures

- Implement high availability solutions using technologies such as Always On Availability Groups, clustering, and replication

- Manage database security, including user access, roles, and permissions

- Participate in capacity planning and work with infrastructure teams to scale database resources

- Troubleshoot and resolve complex database issues with minimal downtime

- Perform database migrations and upgrades with minimal business impact

- Automate routine database maintenance tasks using scripts and tools

- Collaborate with development teams to optimize database designs and SQL code

- Stay current with SQL Server updates, patches, and emerging database technologies

- Document database designs, configurations, and maintenance procedures

Qualifications

- 5+ years of hands-on experience as a SQL Server DBA

- Deep knowledge of SQL Server architecture, internals, and query optimization

- Experience with performance tuning, capacity planning, and database security

- Proficiency in T-SQL scripting and PowerShell automation

- Experience with high availability solutions (Always On Availability Groups, clustering)

- Familiarity with monitoring tools such as SQL Server Profiler, Extended Events, and Performance Monitor

- Knowledge of backup and recovery strategies, including point-in-time recovery

- Experience with disaster recovery planning and implementation

- Strong problem-solving skills and attention to detail

- Excellent communication skills and ability to work in a team environment

Preferred Skills

- Microsoft certifications (MCSA, MCSE, or newer SQL Server certifications)

- Experience with cloud platforms (Azure SQL, AWS RDS)

- Experience with database virtualization and containerization

- Experience with data warehousing and business intelligence solutions