SQL Server Database Administrator

DSA Inc.; United States; Remote; USD 70,000 - 110,000; Full time

Job summary

An innovative firm is seeking a talented SQL Database Administrator to join their dedicated team in a fully remote capacity. This role involves deploying, maintaining, and troubleshooting SQL Server instances for a complex Air Force enterprise application. The ideal candidate will have significant experience in SQL Server management, performance tuning, and a strong understanding of security protocols. You will be part of a collaborative environment where your problem-solving skills and technical expertise will directly contribute to the success of critical projects. If you are passionate about database administration and thrive in a dynamic setting, this opportunity is perfect for you.

Qualifications

• 3-5 years of experience as a SQL Server DBA, including installation and configuration.
• Experience with backups, restores, and recovery models.

Responsibilities

• Install and configure Microsoft SQL database servers to meet software needs.
• Monitor system health and performance for high availability.

Skills

SQL Server DBA

Performance Tuning and Optimization

Windows Server Management

Active Directory Management

Problem-Solving Skills

Education

Active Security+ Certification

Microsoft DP-300 Certification

Tools

SQL Profiler

Gitlab

SQL Server Reporting Services (SSRS)

Job description

Description

Data Systems Analysts, Inc. has an opening for a Structured Query Language (SQL) Database Administrator. This is a full-time remote position that requires a candidate-supplied internet connection. The SQL Database Administrator (DBA) will work as part of a dedicated team supporting a complex Air Force enterprise application. This role will be responsible for deploying, maintaining, and troubleshooting SQL Server instances.

Required Qualifications

• 3 to 5 years of experience as a SQL Server DBA (installing/configuring SQL Server 2016-2022)
• 3 to 5 years of experience with backups, restores, and recovery models
• 2 years of experience with Performance Tuning and Optimization (PTO)
• Experience with SQL Profiler to generate traces, view execution plans, identify deadlocks/contention, and resolve them
• Demonstrated experience with Windows Server and Active Directory account management
• Critical thinker with problem-solving and time-management skills
• Works effectively with other IT professionals and stakeholders
• Demonstrated experience using a modern ticket management system
• Active Security+ Certification

Desired Qualifications

• Knowledge of Air Force Network environments
• Experience with Security Technical Implementation Guides (STIGs) on SQL Server
• Supporting distributed SQL Server instances and/or SQL Server Replication
• Installing/configuring SQL Server Reporting Services (SSRS) on SQL 2016-2022
• Disaster Recovery (DR) options for SQL Server
• Using Gitlab or similar repository tools
• Experience working in a Microsoft Azure environment
• Microsoft DP-300 certification

Key Responsibilities

Acts as one of the primary database administration resources for the system, including:

• Install and configure Microsoft SQL database servers to meet software needs
• Monitor system health and performance
• Ensure high levels of performance, availability, and security
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Perform scheduled maintenance and support release deployment activities after hours
• Work well with a team and be detail-oriented

#DSA209

#LI-AH1