Database Administrator - Project LeadLocation: Columbia SCOn-site/Remote/Hybrid: Hybrid 3 days onsite/2 days remote.Duration: 12 MonthsInterview Process: 1-Round Video Interview will be by skype and will be conducted by a team of 3 – 5 developers and/or Project Managers.Candidate must be a CURRENT SC residentScope Of The ProjectThis 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.Daily Duties / ResponsibilitiesPrimarily, 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, andfunctions that accommodate changing business priorities and technologicalchanges 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 minimumdowntime; configures alerts and telemetry for proactive detection.Interacts with project management and Agile development teams to developa strong understanding of project and database development objectives.Participates in troubleshooting and triaging of issues with differentteam 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-endsupport for build, deployment, and operational activities.Exercises considerable latitude, discretion, and independent judgment indetermining 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 SkillsDatabase 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 YearsAbout Us: InterSources IncInterSources 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.