Database Administrator

SCOPE OF THE PROJECT:

This request is for a senior-level database administrator to 1) Provide senior-level support and guidance to our Child Care team for several initiatives; 2) Assist (at a senior-level) with the support, maintenance, security, and availability of our SQL environment.

PRE-EMPLOYMENT CHECKS (drug, credit, criminal, motor vehicle)?

After Selected:

• South Carolina SLED Check via website
• Central Registry Check (Internal to SCDSS)
• Will need Full Name (with Maiden name if applicable), Address, Prior Address, SSN, DOB, Place of Birth

DAILY DUTIES / RESPONSIBILITIES:

Primarily, this position will provide senior-level support and guidance to our Child Care team, including mentoring Child Care 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 Child Care commitments.

• 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- 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

Benefits at IntelliBee

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.