SQL Database Administrator Systems Analyst

Required

6+ years of experience as a Database Administrator

6+ years of experience with Backup/Recovery

6+ years of experience with Performance Tuning

Preferred Cloud Platform experience (SQL Database)

PowerShell Scripting and Automation

Database planning, scaling, and capacity planning

DAILY DUTIES / RESPONSIBILITIES: 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, while prioritizing Teamcommitments. • 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. 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 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

Job Type: Full-time

Pay: $70.00 - $80.00 per hour

Expected hours: 40 per week

Benefits:

• 401(k)
• Dental insurance
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

Work Location: Hybrid remote in West Columbia, SC 29169