Job 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.
Working with clients to optimize database performance. This includes day-to-day administration, performance tuning, and maintenance.
Managing On-Premises SQL Servers and cloud-based Microsoft Azure SQL Services.

Role and Responsibilities

Ensure system availability and recovery
Execute performance tuning, backup, and restoration of databases
Maintain all databases including Development, QA, Training, and Production environments
Work with business users, developers, and infrastructure teams to ensure quality products
Responsible for documenting all database maintenance procedures, data standards, procedures, and definitions for the data dictionary.
Keep SQL servers up to date with necessary patches
Provide daily management of Microsoft SQL Server infrastructure and assure service availability
Other duties may be performed as the need arises.

Skillset

Solid work ethic geared towards proving high quality service to clients
People-oriented -- enjoys interacting with people and working on group projects.
Adaptable/flexible -- enjoys doing work that requires frequent shifts in direction.
Detail-oriented -- would rather focus on the details of work than the bigger picture.
Achievement-oriented -- enjoys taking on challenges, even in the face of possible failure.
Autonomous/Independent -- enjoys working with minimal direction.
Skilled at prioritizing and organizing work

Requirements

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

Benefits