Senior DB2 Mainframe Database Administrator - Onsite in Tallahassee, FL
Job Description
Required Qualifications
\n
The candidate must have a minimum of 15 years of combined database administration experience across the following database platforms:
\n
- \n
- DB2 for z/OS
- Microsoft SQL Server 2008 R2 and 2012
- Oracle 10g or higher
\n
\n
\n
\n
\n
Primary Responsibilities
\n
The selected resource will be responsible for database planning, administration, and operational support across DB2, SQL Server, Oracle, and GIS environments. Responsibilities include, but are not limited to:
\n
- \n
- Perform daily database administration and operational activities
- Plan, design, implement, and support database structures
- Monitor and tune database performance
- Develop and maintain database administration procedures and technical documentation
- Conduct SQL code reviews
- Provide training, guidance, and mentoring to other technical staff
- Perform additional database and infrastructure-related activities as needed
\n
\n
\n
\n
\n
\n
\n
\n
\n
Required Knowledge, Skills & Abilities
\n
The successful candidate should have demonstrated expertise in the following areas:
\n
DB2 for z/OS & Mainframe
\n
- \n
- Advanced knowledge of DB2 for z/OS application integration, performance management, and database administration
- Advanced experience upgrading DB2 for z/OS
- Advanced knowledge of DB2 for z/OS catalog maintenance
- Advanced knowledge of DB2 for z/OS subsystem point-in-time recovery
- Advanced knowledge of JCL
- In-depth knowledge of the z/OS integrated platform
- In-depth knowledge of ISPF
- In-depth knowledge of ASG Scheduler
- In-depth knowledge of COBOL
- In-depth experience using and interpreting DB2 for z/OS database monitoring tools
- In-depth experience using and interpreting z/OS software monitoring tools
- Solid experience with z/OS started task creation and management
- Solid knowledge of IBI z/OS service support
- Solid knowledge of AFOPER commands
- Solid knowledge of RACF
- Solid knowledge of CICS
- Solid knowledge of IOF
- Working knowledge of z/OS exits
- Working knowledge of BJS
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Database & Application Technologies
\n
- \n
- In-depth knowledge of CA Gen model management and application object support
- Solid knowledge of Oracle application integration, performance management, and database administration
- Solid knowledge of Microsoft SQL Server application integration, performance management, and database administration
- Working knowledge of Windows Server environments
- Working knowledge of SSMS, SSRS, and SSIS
- Working knowledge of Azure
\n
\n
\n
\n
\n
\n
\n
Infrastructure, Testing & Disaster Recovery
\n
- \n
- In-depth knowledge of technical infrastructure implementation planning and coordination
- Solid knowledge of Disaster Recovery technical requirements
- Solid knowledge of verification and testing techniques for infrastructure change management
\n
\n
\n
\n
\n
Consulting Solutions and its family of companies is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at: requests@consultingsolutions.com