Overview
On Site
BASED ON EXPERIENCE
Full Time
Contract - W2
Contract - Independent
Skills
SQL
Mentorship
Scalability
Migration
Storage
Replication
Statistics
Optimization
Project Management
ROOT
Scrum
Agile
Auditing
Issue Resolution
Database Administration
Backup
Recovery
Performance Tuning
RDBMS
Transact-SQL
Failover
High Availability
Microsoft SSIS
Microsoft SSRS
SQL Tuning
Database
Capacity Management
Microsoft SQL Server
Extract
Transform
Load
Microsoft SSAS
Communication
Windows PowerShell
Red Gate
Software Development Methodology
SANS
IT Consulting
Staff Augmentation
Information Technology
Insurance
Life Insurance
Job Details
Database Administrator - Project Lead
Hybrid: Columbia, SC
About the Job
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.
Responsibilities:
Qualification:
Bachelor's Degree
Hybrid: Columbia, SC
About the Job
- Duration: Long term Contract Position
- Location: Hybrid: Columbia, SC
- Pay rate: Hourly
- Job ID: 8660.
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.
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, SARG ability 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.
Qualification:
- 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
Bachelor's Degree
About our Company
DataSoft Technologies is a highly recognized provider of professional IT Consulting services in the US. Founded in 1994, DataSoft Technologies, Inc. provides staff augmentation services for Information Technology and Automotive Services. Our team member benefits include:
- Paid Holidays/Paid Time Off (PTO)
- Medical/Dental Insurance Group
- Accident/Critical Illness Insurance
- Life Insurance
- 401 (K)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.