VDOT SQL Server/Azure Database Administrator.
On-site interview required. Must be able to work on site 3 days a week initially.
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 HasExpertise 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 WillMonitor 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.
QualificationsAt 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 TechnologiesSQL Server 2016-2022 Required/Desired Skills Skill Required /Desired Amount Years of Experience SQLServer Database Management Required 5 SQL Server Tuning Required 2 Experience working with SSIS, SSRS & SSAS Required 2 Coding & debugging Transact SQL Nice to have 2 Expertise in installing, upgrading, patching and migrating SQLServer databases Required 3 DB Administration on Azure Cloud Required 2 Questions No. Question Answer Question1 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? Question2 Please list candidate's email address. Question3 Does your candidate agree to complete the entire engagement? Question4 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?