Description:

The DBA serves an important role at Datex, including supporting and assisting in the implementation of new and existing SQL systems, data conversions and migrations, stored procedure review, deployment, and monitoring of the system. This includes maintaining legacy system databases and assisting in the migration to new systems.
The role involves working with clients to optimize database performance, which includes day-to-day administration, performance tuning, and maintenance.
The DBA will manage On-Premises SQL Servers and cloud-based Microsoft Azure SQL Services.
Responsibilities include ensuring system availability and recovery, executing performance tuning, backup, and restoration of databases, and maintaining all databases including Development, QA, Training, and Production environments.
The DBA will work with business users, developers, and infrastructure teams to ensure quality products and is responsible for documenting all database maintenance procedures, data standards, procedures, and definitions for the data dictionary.
Keeping SQL servers up to date with necessary patches and providing daily management of Microsoft SQL Server infrastructure to assure service availability are also key duties.
Other duties may be performed as the need arises.

Requirements:

A Bachelor’s Degree in computer science or equivalent education, training, and work-related experience is required.
The candidate must have 4+ years of experience in database administration of SQL Server database environments.
Knowledge of Microsoft SQL Server 2016/2019/2022 is essential.
The candidate should have knowledge of On-Premises and cloud databases built with SQL Server and Azure SQL Services.
Experience with SSRS, SSIS, or SSAS is required.
A thorough understanding of Relational Databases, T-SQL Scripting, Database Normalization best practices, database technologies, and concepts is necessary.
Experience with Performance Tuning, Index Analysis, and Query Optimization is expected.
Proficiency in SQL Development, including the ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints) is required.
The candidate should have experience troubleshooting and resolving database integrity and performance issues.
Experience in Database Design in a Software Development Environment as a contributor is necessary.
Experience with troubleshooting SQL Server Transactional Replication is also required.