Database Administrator

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.

• Documents, tracks and escalates issues as appropriate.

• Participates in Scrum teams in support of Agile projects; end-to-end

support for build, deployment, and operational activities.

• Exercises considerable latitude, discretion, and independent judgment in

determining technical objectives of assignments.

• Performs routine operations and maintenance including installations,

upgrades, patching, monitoring, auditing, and issue resolution.

• Manages and prioritizes multiple, diverse tasks simultaneously.

• Must be flexible, independent and self-motivated.

• Work collaboratively to meet team goals/mission.

• Provides after-hours or weekend maintenance as needed.

• Perform other duties as assigned

Database Administration Expert 10 Years

Backup/Recovery Expert 10 Years

Performance Tuning Expert 10 Years

RDBMS Expert 6 Years

SQL Server Expert 10 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

ETL Advanced 2-4 Years

SSAS Advanced 2-4 Years

Verbal Communication Intermediate 2-4 Years

Written Communication Intermediate 2-4 Years

PowerShell Intermediate 1-2 Years

RedGate Toolset Intermediate 1-2 Years

SDLC Intermediate 1-2 Years

REQUIRED EDUCATION: Bachelor's Degree