Job Tasks and Activities :
- 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
Required Experience :
The candidate must have skill and 15 years combined experience in database administration for the following database platforms :
DB2 for z / OSSQL Server 2008R2, 2012Oracle 10g and abovePreferred Experience :
Advanced knowledge of DB2 for z / OS application integration, performance management and data base administrationAdvanced knowledge of upgrading DB2 for z / OSAdvanced knowledge of DB2 for z / OS catalog maintenanceAdvanced knowledge of DB2 for z / OS sub-system point in time recoveryAdvanced knowledge of JCLIn depth knowledge of the z / OS integrated platformIn depth knowledge of CA GEN model management and application object supportIn depth knowledge of ISPFIn depth knowledge of the ASG SchedulerIn depth knowledge of COBOLIn depth knowledge of the use and interpretation of DB2 for z / OS database monitoring toolsIn depth knowledge of the use and interpretation of z / OS software monitoring toolsIn depth knowledge of technical infrastructure implementation planning and coordinatingSolid working knowledge of z / OS started task creation and managementSolid working knowledge of IBI z / OS service supportSolid working knowledge of AFOPER commandsSolid working knowledge of RACFSolid working knowledge of CICSSolid working knowledge of IOFSolid working knowledge of the technical requirements of Disaster RecoverySolid working knowledge of Oracle application integration, performance management and database administrationSolid working knowledge of MSSQL application integration, performance management and database administrationSolid working knowledge of verification testing techniques for infrastructure change managementWorking knowledge of z / OS EXITsWorking knowledge of BJSWorking knowledge of Windows ServersWorking knowledge of SSMS, SSRS, SSISWorking knowledge of Azure