Job ID: VA-609008 (97391023)
Oracle/SQL Server DBA with windows, Linux, Installation, patching, upgrading and migrating experience
Location: Richmond, VA (VDOT)
Duration: 08+ months
Interview: Both Phone and In Person
SKills :
Oracle Database Administrator or DeveloperYears
SQLServer Database Administrator or DeveloperYears
Expertise working with Oracle/SQLServer in windows or Linux environmentYears
Installation, patching, upgrading, migrating databasesYears
*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.
Qualifications:
•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