SQL DBA Admin - Onsite

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