Database Administrator

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

• Medical Insurance
• Paid Time Off
• Paid Holidays
• Remote Work