Scope of Services
Education
Experience
Primary Job Duties/ Tasks
Job Specific Knowledge, Skills, and Abilities (KSAs)
- The DBA team is responsible for ensuring the application and processing architectures, data dictionaries, and database schemas meet the department standards for data requirements.
- The candidate in this position will be responsible for assisting in the design, development, amendments and optimization of the schema to meet system(s) requirements.
- The candidate must be able to understand and demonstrate the ability to develop database and warehousing design across multiple platforms and computing environments.
- The candidate must be able to work as part of a team to assist in developing an overall data architecture that supports the Department's needs and meets Department and Agency for State Technology (AST) security standards.
Education
- Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Experience
- DB2 for z/OS
- SQL Server 2008R2, 2012
- Oracle 10g and above
- Experience with the FDOT integrated database infrastructure is a plus.
- Knowledge of the FDOT Financial Management applications is a plus.
- Knowledge of the FDOT integrated application environment is a plus
Primary Job Duties/ Tasks
- Daily operational and database administration activities
- Plan, design, implement, support for database structures
- Conduct database performance monitoring and tuning
- Develop and maintain database administration procedures and documentation
- Perform SQL Code reviews
- Assist with training/mentoring other technical staff This resource may also be required to perform other database or infrastructure activities as requested
Job Specific Knowledge, Skills, and Abilities (KSAs)
- Advanced knowledge of DB2 for z/OS application integration, performance management and data base administration
- Advanced knowledge of upgrading DB2 for z/OS
- Advanced knowledge of DB2 for z/OS catalog maintenance
- Advanced knowledge of DB2 for z/OS sub-system point in time recovery
- Advanced knowledge of JCL
- In depth knowledge of the z/OS integrated platform
- In depth knowledge of CA GEN model management and application object support
- In depth knowledge of ISPF
- In depth knowledge of the ASG Scheduler
- In depth knowledge of COBOL
- In depth knowledge of the use and interpretation of DB2 for z/OS database monitoring tools
- In depth knowledge of the use and interpretation of z/OS software monitoring tools
- In depth knowledge of technical infrastructure implementation planning and coordinating
- Solid working knowledge of z/OS started task creation and management
- Solid working knowledge of IBI z/OS service support
- Solid working knowledge of AFOPER commands
- Solid working knowledge of RACF
- Solid working knowledge of CICS
- Solid working knowledge of IOF
- Solid working knowledge of the technical requirements of Disaster Recovery
- Solid working knowledge of Oracle application integration, performance management and data base administration
- Solid working knowledge of MSSQL application integration, performance management and data base administration
- Solid working knowledge of verification testing techniques for infrastructure change management
- Working knowledge of z/OS EXITs
- Working knowledge of BJS
- Working knowledge of Windows Servers
- Working knowledge of SSMS, SSRS, SSIS
- Working knowledge of Azure