2 CL - Database Administrator - Consultant Jobs in Columbia, SC
SORT BY
R
E
CL - Database Administrator - Consultant
$89k-113k (estimate)
Full Time
6 Days Ago
Ricefw Technologies is Hiring a CL - Database Administrator - Consultant Near Columbia, SC
Job Description: BillNA
Scope Of The ProjectThe Department of Social Services has a large Relational Database Management Systems (RDBMS) environment consisting of approximately NA8 databases (1NA production) across 46 instances (25 production). This request is for a consultant-level database administrator position to lead the security, availability, maintenance, and support of this environment.
Daily Duties / ResponsibilitiesThis position will lead the security, availability, maintenance, and support of our SQL environment.
Monitors our SQL environment to ensure secure services with minimum downtime.
Work collaboratively to meet team goals/mission.
Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while providing availability, scalability, performance, recoverability, reliability, and security.
Acts as liaison for SQL Server DB security, performance, integration, migration, upgrade, storage, support, and replication strategies.
Interacts with project management and Agile development teams to develop a strong understanding of the project and database development objectives.
Documents, tracks, and escalates issues as appropriate.
Routine operation maintenance including installations, upgrades, patching, monitoring, and auditing.
Ensures standards are met and procedures are followed.
Manage and prioritize multiple, diverse tasks simultaneously.
Must be flexible, independent, and self-motivated.
Provide 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 4-6 Years
High-Availability Expert 4-6 Years
DMVs Expert 4-6 Years
SSIS Services Expert 2-4 Years
SSRS Expert 2-4 Years
Profiler Expert 4-6 Years
SQL Tuning Expert 2-4 Years
Database planning, scaling, and capacity planning Expert 2-4 Years
SQL Server 2019 Expert 3 Years
SQL Server 2022 Expert 1 Years
ETL Advanced 2-4 Years
SSAS Advanced 2-4 Years
Verbal Communication Advanced 4-6 Years
Written Communication Intermediate 2-4 Years
PowerShell Intermediate 1-2 Years
RedGate Toolset Intermediate 2-4 Years
SDLC Advanced 2-4 Years
Required EducationBachelor's Degree
Remote 50% is typically 2-3 days in office 2-3 days out of office. This will be determined by the supervisor and discussed during the interview. HOWEVER initially the contract is required to be in office 5 days a week for training and until training is completed. ADDITIONALLY, because we are a state agency the telework policy can change at any time as deemed by the Governor of South Carolina with no notice.
Additional Sills: Database Administration Expert 6 YearsBackup/Recovery Expert 6 YearsPerformance Tuning Expert 6 YearsRDBMS Expert 6 YearsSQL Server Expert 6 YearsT-SQL Expert 6 YearsFailover Clusters Expert 4-6 YearsHigh-Availability Expert 4-6 YearsDMVs Expert 4-6 YearsSSIS Services Expert 2-4 YearsSSRS Expert 2-4 YearsProfiler Expert 4-6 YearsSQL Tuning Expert 2-4 YearsDatabase planning, scaling, and capacity planning Expert 2-4 YearsSQL Server 2019 Expert 3 YearsSQL Server 2022 Expert 1 YearsETL Advanced 2-4 YearsSSAS Advanced 2-4 YearsVerbal Communication Advanced 4-6 YearsWritten Communication Intermediate 2-4 YearsPowerShell Intermediate 1-2 YearsRedGate Toolset Intermediate 2-4 YearsSDLC Advanced 2-4 Years Skills: Category Name Required Importance Level Last Used Experience Database Platforms backup/recovery Yes 1 Expert Currently Using 6 Years Database Platforms Performance Tuning Yes 1 Expert Currently Using 6 Years Miscellaneous Database Administration Yes 1 Expert Currently Using 6 Years
Scope Of The ProjectThe Department of Social Services has a large Relational Database Management Systems (RDBMS) environment consisting of approximately NA8 databases (1NA production) across 46 instances (25 production). This request is for a consultant-level database administrator position to lead the security, availability, maintenance, and support of this environment.
Daily Duties / ResponsibilitiesThis position will lead the security, availability, maintenance, and support of our SQL environment.
Monitors our SQL environment to ensure secure services with minimum downtime.
Work collaboratively to meet team goals/mission.
Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while providing availability, scalability, performance, recoverability, reliability, and security.
Acts as liaison for SQL Server DB security, performance, integration, migration, upgrade, storage, support, and replication strategies.
Interacts with project management and Agile development teams to develop a strong understanding of the project and database development objectives.
Documents, tracks, and escalates issues as appropriate.
Routine operation maintenance including installations, upgrades, patching, monitoring, and auditing.
Ensures standards are met and procedures are followed.
Manage and prioritize multiple, diverse tasks simultaneously.
Must be flexible, independent, and self-motivated.
Provide 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 4-6 Years
High-Availability Expert 4-6 Years
DMVs Expert 4-6 Years
SSIS Services Expert 2-4 Years
SSRS Expert 2-4 Years
Profiler Expert 4-6 Years
SQL Tuning Expert 2-4 Years
Database planning, scaling, and capacity planning Expert 2-4 Years
SQL Server 2019 Expert 3 Years
SQL Server 2022 Expert 1 Years
ETL Advanced 2-4 Years
SSAS Advanced 2-4 Years
Verbal Communication Advanced 4-6 Years
Written Communication Intermediate 2-4 Years
PowerShell Intermediate 1-2 Years
RedGate Toolset Intermediate 2-4 Years
SDLC Advanced 2-4 Years
Required EducationBachelor's Degree
Remote 50% is typically 2-3 days in office 2-3 days out of office. This will be determined by the supervisor and discussed during the interview. HOWEVER initially the contract is required to be in office 5 days a week for training and until training is completed. ADDITIONALLY, because we are a state agency the telework policy can change at any time as deemed by the Governor of South Carolina with no notice.
Additional Sills: Database Administration Expert 6 YearsBackup/Recovery Expert 6 YearsPerformance Tuning Expert 6 YearsRDBMS Expert 6 YearsSQL Server Expert 6 YearsT-SQL Expert 6 YearsFailover Clusters Expert 4-6 YearsHigh-Availability Expert 4-6 YearsDMVs Expert 4-6 YearsSSIS Services Expert 2-4 YearsSSRS Expert 2-4 YearsProfiler Expert 4-6 YearsSQL Tuning Expert 2-4 YearsDatabase planning, scaling, and capacity planning Expert 2-4 YearsSQL Server 2019 Expert 3 YearsSQL Server 2022 Expert 1 YearsETL Advanced 2-4 YearsSSAS Advanced 2-4 YearsVerbal Communication Advanced 4-6 YearsWritten Communication Intermediate 2-4 YearsPowerShell Intermediate 1-2 YearsRedGate Toolset Intermediate 2-4 YearsSDLC Advanced 2-4 Years Skills: Category Name Required Importance Level Last Used Experience Database Platforms backup/recovery Yes 1 Expert Currently Using 6 Years Database Platforms Performance Tuning Yes 1 Expert Currently Using 6 Years Miscellaneous Database Administration Yes 1 Expert Currently Using 6 Years
Job Summary
JOB TYPE
Full Time
SALARY
$89k-113k (estimate)
POST DATE
07/06/2024
EXPIRATION DATE
08/03/2024
WEBSITE
ricefwtech.com
HEADQUARTERS
Okemos, MI
SIZE
25 - 50
Related Companies
Show more
Similar Jobs
Popular Articles
Top 10 Things to Avoid Putting on a Job Application
Read Article
How to Describe Your Education in a Resume
Read Article
How to Write a Memorable Cover Letter in 5 Ways
Read Article
4 Personal Finance Tips to Make During Job Transition
Read Article
4 Best Camera Setups for Interview
Read Article
Keeping a Job Search Journal: 9 Types of Journaling You Can Do
Read Article
