SQL Database Administrator

The Department of Social Services has a large Relational Database Management Systems’ (RDBMS) environment consisting of approximately 628 databases (192 production) across 46 instances (25 production). This request is for a consultant-level database administrator position to lead the security, availability, maintenance, and support of this environment.

DAILY DUTIES / RESPONSIBILITIES:

This position will lead the security, availability, maintenance, and support of our SQL environment.

• Monitors our SQL environment to ensure secure services with minimum downtime.
• Work collaboratively to meet team goals/mission.
• Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
• Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
• Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while providing availability, scalability, performance, recoverability, reliability, and security.
• Acts as liaison for SQL Server DB security, performance, integration, migration, upgrade, storage, support, and replication strategies.
• Interacts with project management and Agile development teams to develop a strong understanding of the project and database development objectives.
• Documents, tracks, and escalates issues as appropriate.
• Routine operation maintenance including installations, upgrades, patching, monitoring, and auditing.
• Ensures standards are met and procedures are followed.
• Manage and prioritize multiple, diverse tasks simultaneously.
• Must be flexible, independent, and self-motivated.
• Provide after-hours or weekend maintenance as needed.
• Perform other duties as assigned.
  
  

REQUIRED SKILLS:

Database Administration Expert 6+ Years

Backup/Recovery Expert 6+ Years

Performance Tuning Expert 6+ Years

RDBMS Expert 6+ Years

SQL Server Expert 6+ Years

T-SQL Expert 6+ Years

Failover Clusters Expert 4-6 Years

High-Availability Expert 4-6 Years

DMVs Expert 4-6 Years

SSIS Services Expert 2-4 Years

SSRS Expert 2-4 Years

Profiler Expert 4-6 Years

SQL Tuning Expert 2-4 Years

Database planning, scaling, and capacity planning Expert 2-4 Years

SQL Server 2019 Expert 3+ Years

SQL Server 2022 Expert 1+ Years

ETL Advanced 2-4 Years

SSAS Advanced 2-4 Years

Verbal Communication Advanced 4-6 Years

Written Communication Intermediate 2-4 Years

PowerShell Intermediate 1-2 Years

RedGate Toolset Intermediate 2-4 Years

SDLC Advanced 2-4 Years

REQUIRED EDUCATION:

Bachelor's Degree

Category

Name

Required

Importance

Level

Last Used

Experience

Database Platforms

backup/recovery

Yes

1

Expert

Currently Using

6 + Years

Database Platforms

Performance Tuning

Yes

1

Expert

Currently Using

6 + Years

Miscellaneous

Database Administration

Yes

1

Expert

Currently Using

6 + Years

Additional Skills:

Database Administration Expert 6+ Years

Backup/Recovery Expert 6+ Years

Performance Tuning Expert 6+ Years

RDBMS Expert 6+ Years

SQL Server Expert 6+ Years

T-SQL Expert 6+ Years

Failover Clusters Expert 4-6 Years

High-Availability Expert 4-6 Years

DMVs Expert 4-6 Years

SSIS Services Expert 2-4 Years

SSRS Expert 2-4 Years

Profiler Expert 4-6 Years

SQL Tuning Expert 2-4 Years

Database planning, scaling, and capacity planning Expert 2-4 Years

SQL Server 2019 Expert 3+ Years

SQL Server 2022 Expert 1+ Years

ETL Advanced 2-4 Years

SSAS Advanced 2-4 Years

Verbal Communication Advanced 4-6 Years

Written Communication Intermediate 2-4 Years

PowerShell Intermediate 1-2 Years

RedGate Toolset Intermediate 2-4 Years

SDLC Advanced 2-4 Years