Job Summary:
The SQL DBA will be responsible for the implementation configuration maintenance and performance of critical SQL Server systems. The ideal candidate will have a deep understanding of SQL Server architecture a passion for performance tuning and a proactive approach to database management. This position also involves collaborating with development teams to ensure database integrity and security.
Key Responsibilities:
- Install configure and upgrade SQL Server databases and related applications.
- Monitor database performance implement changes and apply new patches and versions when required.
- Perform database tuning and optimization including index management query optimization and database profiling.
- Plan and implement backup and recovery strategies including regular testing of backup procedures.
- Manage database storage monitor space usage and plan for capacity growth.
- Ensure high availability and disaster recovery of SQL databases through the use of clustering mirroring replication and Always On Availability Groups.
- Develop implement and maintain database security policies and procedures including user management and role assignments.
- Troubleshoot and resolve database issues including performance bottlenecks deadlocks and connectivity problems.
- Collaborate with development teams to design and review database schemas queries and stored procedures.
- Document database architectures configurations processes and procedures.
- Provide oncall support as part of a rotation for critical database issues.
- Stay updated on SQL Server technology advancements best practices and industry trends.
Qualifications:
- Bachelors degree in Computer Science Information Technology or a related field.
- 5 years of experience as a SQL Database Administrator.
- Extensive experience with Microsoft SQL Server 2012/2016/2019.
- Strong knowledge of SQL Server architecture backup and recovery strategies and performance tuning.
- Experience with SQL Server high availability and disaster recovery technologies (Always On Availability Groups Clustering or Mirroring).
- Proficient in TSQL with strong query optimization and performance tuning skills.
- Experience with SQL Server Integration Services (SSIS) Reporting Services (SSRS) and Analysis Services (SSAS) is a plus.
- Familiarity with Windows Server operating systems and PowerShell scripting.
- Strong analytical and problemsolving skills.
- Excellent communication skills with the ability to work effectively with both technical and nontechnical teams.
- SQL Server certifications (MCSA MCSE) are a plus.
Remote Work :
No