Database Administrator (DBA)
Job Summary
Summary of the role
The SQL Server DBA is responsible for the overall health performance and security of all Microsoft SQL Server database environments. The core focus is on maintaining high availability (HA) implementing robust disaster recovery (DR) plans and ensuring optimal database performance to support critical business applications.
Responsibilities of the role:
- Design implement and manage High Availability/Disaster Recovery (HA/DR) solutions primarily utilizing Always On Availability Groups (AGs) Failover Cluster Instances (FCIs) and Log Shipping.
- Manage comprehensive backup and recovery operations including periodic validation through DR drills.
- Install configure and patch SQL Server instances across multiple versions (e.g.).
- Proactively monitor analyze and tune SQL Server performance using DMVs and built-in tools.
- Expertly analyze and optimize complex T-SQL queries stored procedures and database objects (indexes statistics).
- Maintain strict security models managing logins users roles and permissions according to the principle of least privilege.
- Schedule and execute essential maintenance tasks (e.g. DBCC index rebuilds) using SQL Server Agent.
- Develop and manage SQL Server Integration Services (SSIS) packages for ETL processes.
- Collaborate with development teams on schema changes data modeling and code deployment.
Qualifications :
Qualifications and Skills:
- Experience: 3-6 years of hands-on experience as a SQL Server DBA in a production environment.
- Core Skills: Deep proficiency in T-SQL HA/DR setup (Always On AGs) performance tuning and database security.
- Tools: Expert use of SSMS and related SQL Server tools.
- Education/Certifications: Bachelors degree in a relevant field. Relevant Microsoft certifications (MCSA or Azure Database Administrator Associate) are highly preferred.
Additional Information :
We offer:
A fun working environment in a fast-growing company
A supportive and collegial team
Unique insights into the coffee world
Potential for growth in a diverse and fascinating sector
A competitive remuneration
Free coffee around the clock
Remote Work :
No
Employment Type :
Full-time
About Company
Jobs for Humanity paves the way to a fairer future for all by connecting historically underrepresented talent to welcoming employers. Through the combination of cutting-edge recruiting technology and expert D&I consultation, Jobs for Humanity makes inclusive hiring seamless, scalable, ... View more