15 years combined experience in database administration for the following database platforms:
- DB2 for z/OS
- SQL Server 2008R2, 2012
- Oracle 10g and above
- Experience with the DOT integrated database infrastructure is a plus.
- Knowledge of the DOT Financial Management applications is a plus.
- Knowledge of the DOT integrated application environment is a plus
- Primary Job Duties/ Tasks
This resource will primarily be tasked with performing Database (DB2, SQL Server, Oracle, GIS) planning and operational activities including, but not limited to the following:
- Conduct database performance monitoring and tuning
- Develop and maintain database administration procedures and documentation
- Perform SQL Code reviews
The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:
- 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