Job Description :
Oracle Database Administrator 5 for VDOT(515010)/F2F Required
9 Months
Richmond, VA
F2F

Short Description:
VDOT Database Administrator 5

Complete Description:
*local Richmond, VA candidates strongly preferred
Manager may elect to conduct an initial phone interview for out-of-state candidates. However, ALL candidates chosen for an interview will have to attend a personal interview, NO Skype, NO exceptions
*please do not submit candidates who were submitted to the previous VDOT DBA reqs51, 495244. We need NEW candidates ONLY

The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) is seeking a senior oracle 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 will:

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.
Perform installations of database related software. (including database upgrades and patching)
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.
Perform database migrations between multiple release of Oracle 10g/11g/12c using data pump export/import, RMAN database duplication procedures
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.

The successful candidate will be capable of performing an analysis of the effectiveness of the existing system and clearly communicate reasoned justification for continuance and update, or alternative approaches.

Qualifications:
Over 5 years of experience in maintaining/supporting Oracle databases.
Bachelor’s Degree in Computer Science, Information Systems with strong technical experience 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
Advanced oracle features (RAC, Data Guard)
Oracle Tools/Functions (RMAN, Data Pump, AWR, ASH, ADDM, Profiler)

Preferred Experience:
Familiarity with Linear referencing systems and how data is maintained
Advanced database/SQL tuning concepts

Special Instructions to Applicants:
This position requires a fingerprint-based background check.
The successful contractor will be required to continue education at own expense to stay current with VDOT technologies.

Skill
Required / Desired
Amount
of Experience
Oracle Database Administration (Linux Servers) - versions 10g/11g/12c
Required
5
Years
Oracle Database Setup/Installation/Patching/Upgrade
Required
5
Years
Oracle Database backup/restore/duplication
Required
5
Years
Oracle Cloud Control Support & Administration
Required
2
Years
Oracle Database Performance & Tuning
Required
5
Years
Oracle Database Administration (Window Servers) - versions 10g/11g/12c
Desired
3
Years
Oracle Administration - Advanced Features (Data Guard)
Desired
3
Years
Oracle Administration - Advanced Features (Partitioning)
Desired
1
Years
Oracle Administration - Advanced Features (12c MultiTenant)
Desired
1
Years
Oracle Administration - Advanced Features (RAC)
Required
2
Years

Global Candidate Requirements
Skill
Required / Desired
Amount
of Experience


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 that will be used when submitting E-RTR.
Question 3
Is candidate available for a personal interview? If outside of Richmond, is candidate willing and able to travel to Richmond, VA for a personal interview?
Question 4
Does your candidate''s experience match or exceed the skills listed above and the number of years of experience with each skill?
Question 5
Has your candidate been submitted to any of the previous VDOT DBA reqs51, 495244> We need NEW candidates ONLY
Question 6
Does your candidate agree to complete the entire engagement?
Question 7
How soon after an offer can your candidate start?
Question 8
Has your candidate been submitted to CAI in the past? If so, for which state agency and when?