About the Role
Primarily, this position will provide senior-level support and guidance to our
team, including mentoring developers on schema and query
design, execution-plan review/tuning, and security best practices.
In addition to this, this position will assist (at a senior-level) with the
support, maintenance, security, and availability of the agency’s SQL Server
environment for other application teams
Description
Designs, develops, implements, and maintains database, procedures, and
functions that accommodate changing business priorities and technological
changes while ensuring availability, scalability, performance,
recoverability, reliability, and security.
• Acts as liaison for SQL Server database performance, integration,
migration, upgrade, storage, and replication strategies.
• Performs SQL Server performance tuning: waits/Query Store analysis, index
& stats optimization, SARGability fixes, and parallelism tuning.
• Monitors the database systems to ensure secure services with minimum
downtime; configures alerts and telemetry for proactive detection.
• Interacts with project management and Agile development teams to develop
a strong understanding of project and database development objectives.
• Participates in troubleshooting and triaging of issues with different
team members to drive towards root cause identification and resolution.
Requirements
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 2-4 Years
High-Availability Expert 2-4 Years
DMVs Expert 2-4 Years
SSIS Services Expert 2-4 Years
SSRS Expert 2-4 Years
Profiler Expert 2-4 Years
SQL Tuning Expert 2-4 Years
Database planning, scaling,
and capacity planning Expert 2-4 Years
SQL Server 2008R2 Expert 1-2 Years
SQL Server 2012 Expert 1-2 Years
SQL Server 2014 Expert 1-2 Years
SQL Server 2016 Expert 1-2 Years