IT & Web & SQA
VDOT Database Administrator
VDOT Database Administrator VDOT Oracle/SQLServer Database Administrator 5 VENDO
Position: Database Administrator
Salary: $73.05 per hour
Type: Full Time
VDOT Oracle/SQLServer Database Administrator 5
VENDOR MAXIMUM SUBMITTAL RATE $ 73.05/hr.
*candidates local to the Richmond, VA area strongly preferred
*Manager MAY choose to conduct initial phone interviews for some out-of-state candidates (it is up to agency discretion)
but a second onsite interview is required, NO Skype, NO exceptions.
The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) is seeking a senior SQL Server
database administrator to join the Oracle/SQLServer Database Administration Team in the Enterprise Data Management
section. The selected candidate will administrator & support Oracle databases throughout the agency.
The selected candidate have:
Expertise working as an Oracle & SQLServer DBA
Expertise working with SQL clustering, mirroring and high availability
Experience working with large Oracle and/or SQL databases
Expertise in writting PL/SQL and Transact SQL
Experience working with advanced PL/SQL collections (bulk,collections,arrays,cursors)
Experience tuning Oracle and/or SQLServer databases
Expertise in installing, upgrading, patching and migrating Oracle & SQLServer databases
Experience working on Windows & Linux environments
Experience working with SSIS & SSRS
Monitor databases to maintain/ensure database uptime and availability.
Troubleshoot application/database issues related to connectivity, access, security and etc...
Tune long running SQL using AWR/ASH/ADDM/Profiler and etc...
Review & refine existing database tasks and processes to better align with agency/group priorities.
Leverage & utilize cron and O/S scripting in support of database maintenance/diagnosis/support
Review the existing database implementation and propose, execute, and/or direct necessary changes.
Perform SQLServer installations (2012,2014 w/ failover clustering)
Support SQLServer 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& SQLServer DBAs.
Communicate clearly and effectively, both speaking and in writing.
At least 3 years of experience of mixed Oracle/SQLServer database 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:
Oracle 11g-12c, SQLServer 2008-2012
SkillRequired /DesiredAmountof Experience
Oracle Database Administrator or Developer Required 1 Years
SQLServer Database Administrator or Developer Required 1 Years
Expertise working with Oracle/SQLServer in windows or Linux environment Required 2 Years
Installation, patching, upgrading, migrating databases Desired 2 Years
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 that will be used when submitting E-RTR.
Question3 In what city/state does candidate reside?
Question4 Does your candidate’s experience match or exceed the skills listed above and the number of years of
experience with each sklll?
Question5 Is candidate willing and able to travel to Richmond, VA for a personal interview? Manager may choose to
conduct initial phone interviews for some out-of-state candidates (it is up to agency discretion) but a second onsite
interview is required, NO Skype, NO exceptions.
Question6 Does your candidate agree to complete the entire engagement?
Question7 How soon after an offer can your candidate start?
Question8 Has your candidate been submitted to CAI in the past? If so, for which agency and when?