Job Details

Title: Database Administrator - Project Lead
Location: Columbia SC
On-site/Remote/Hybrid: Hybrid 3 days onsite/2 days remote.
Duration: 12 Months
Interview Process: 1-Round Video
Interview will be by skype and will be conducted by a team of 3 - 5 developers and/or Project Managers.

NOTE: Candidate location: Candidate must be a CURRENT SC resident

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)
ssist (at a senior-level) with the support, maintenance, security, and
vailability of our SQL environment.

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.

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

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

bout Us:
InterSources Inc , is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.