SQL DBA

SQL DBALocation: Tallahassee, FL 32301Duration: 10 monthsExperience: The candidate must have skill and 15 years combined experience in database administration for the following database platforms:1. DB2 for z/OS2. SQL Server 2008R2, 20123. Oracle 10g and above4.

Experience with the FDOT integrated database infrastructure is a plus.5. Knowledge of the FDOT Financial Management applications is a plus.6. Knowledge of the FDOT integrated application environment is a plus7. Primary Job Duties/TasksThis resource will primarily be tasked with performing Database (DB2, SQL Server, Oracle, GIS) planning and operational activities including, but not limited to the following:1. Daily operational and database administration activities2. Plan, design, implement, support for database structures3. Conduct database performance monitoring and tuning4. Develop and maintain database administration procedures and documentation5. Perform SQL Code reviews6. Assist with training/mentoring other technical staff This resource may also be required to perform other database or infrastructure activities as requested8. Job Specific Knowledge, Skills, and Abilities (KSAs)The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:1. Advanced knowledge of DB2 for z/OS application integration, performance management and data base administration2. Advanced knowledge of upgrading DB2 for z/OS3. Advanced knowledge of DB2 for z/OS catalog maintenance4. Advanced knowledge of DB2 for z/OS sub-system point in time recovery5. Advanced knowledge of JCL6. In depth knowledge of the z/OS integrated platform7. In depth knowledge of CA GEN model management and application object support8. In depth knowledge of ISPF9. In depth knowledge of the ASG Scheduler10. In depth knowledge of COBOL11. In depth knowledge of the use and interpretation of DB2 for z/OS database monitoring tools12. In depth knowledge of the use and interpretation of z/OS software monitoring tools13. In depth knowledge of technical infrastructure implementation planning and coordinating14. Solid working knowledge of z/OS started task creation and management15. Solid working knowledge of IBI z/OS service support16. Solid working knowledge of AFOPER commands17. Solid working knowledge of RACF18. Solid working knowledge of CICS19. Solid working knowledge of IOF20. Solid working knowledge of the technical requirements of Disaster Recovery21. Solid working knowledge of Oracle application integration, performance management and data base administration22. Solid working knowledge of MSSQL application integration, performance management and data base administration23. Solid working knowledge of verification testing techniques for infrastructure change management24. Working knowledge of z/OS EXITs25. Working knowledge of BJS26. Working knowledge of Windows Servers27. Working knowledge of SSMS, SSRS, SSIS