Engagement Type
Contract
Short Description
VDOT SQL Server / Azure Database Administrator.
On-site interview required. Must be able to work on site 3 days a week initially.
Complete Description
The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) is seeking a senior SQL Server database / Azure database administrator to join the Oracle / SQL Server Database Administration Team in the Enterprise Data Management section.
The selected candidate will administrator and support SQL Server databases throughout the agency.
The selected candidate has :
- Expertise working as a SQL Server DBA
- Expertise working with SQL clustering, mirroring and high availability
- Experience working with large SQL databases
- Expertise in writing Transact SQL
- Experience tuning Oracle and / or SQL Server databases
- Expertise in installing, upgrading, patching and migrating SQL Server databases
- Experience working on Windows environment
- Experience working with SSIS, SSAS, & SSRS
- Experience working with Azure Cloud
The selected candidate will :
- Monitor databases to maintain / ensure database uptime and availability.
- Troubleshoot application / database issues related to connectivity, access, security and etc.
- Tune long running SQL
- Review & refine existing database tasks and processes to better align with agency / group priorities.
- Leverage & utilize O / S scripting utilities in support of database maintenance / diagnosis / support.
- Review the existing database implementation and propose, execute, and / or direct necessary changes.
- Perform SQL Server installations (2012,2014,2016 w / failover clustering).
- Support SQL Server databases (administration, support, tuning).
- Knowledgeable of data modeling principals
Be expected to...
- Rely on experience and judgment to plan and accomplish goals.
- Independently perform a variety of complicated tasks.
- Work with a team of Oracle & SQL Server DBAs.
- Communicate clearly and effectively, both speaking and in writing.
Qualifications :
- At least 5 years of experience w / SQL Server database experience
- At least 2 years of Azure experience
- Bachelor's Degree in Computer Science, Information Systems or other applicable and / or equivalent skills, knowledge and / or work history
- Demonstrated experience in communicating effectively using standard requirements and design artifacts
Desired knowledge of and experience with the following technologies :
SQL Server 2016-2022
Required / Desired Skills
Skill
Required / Desired
Amount
of Experience
SQLServer Database Management
Required
Years
SQL Server Tuning
Required
Years
Experience working with SSIS, SSRS & SSAS
Required
Years
Coding & debugging Transact SQL
Nice to have
Years
Expertise in installing, upgrading, patching and migrating SQLServer databases
Required
Years
DB Administration on Azure Cloud
Required
Years
Questions
Description
Question 1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence.
The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2
Please list candidate's email address.
Question 3
Does your candidate agree to complete the entire engagement?
Question 4
This position requires that, if selected for the role, candidate agrees to comply with ED#18, "Ensuring A Safe Work Place", and the supplemental contractor guidelines regarding COVID-19 vaccination and masking requirements.
Do you accept this requirement and affirm you will share this requirement with your candidate?