Database Administrator at Genesis10 in Plano, TX

Job description

• Genesis10 is currently seeking a Mainframe DB2 DBA - Hybrid position with a Global Financial Institution located in Charlotte, NC, Plano, TX or Jersey City, NJ. This is a 12+ month contract opportunity.
• This position requires a candidate with in-depth Mainframe DB2 DBA (DB2 on z/OS) knowledge with a focus on performance tuning. The successful candidate will be responsible for developing log scraping strategies, building monitoring dashboards, managing database security, and supporting a stable production environment within a large financial institution. This role has a hybrid schedule requirement of a minimum of 3 days per week onsite.

Responsibilities

• Develop log scraping strategies to limit CPU, memory usage, and staging space
• Build Splunk dashboards to monitor the Db2 environment
• Work with other DB2 teams in setting up log retention policies
• Translate business requirements into a physical model for implementation
• Consult with application teams on ACF2 and RACF managed database security
• Define and implement application-specific backup and recovery strategies
• Support product upgrades related to DB2 replication
• Provide performance tuning support and recommendations for database calls
• Monitor and address items on exception reports to ensure a stable production environment
• Support DBA production on-call rotation including 24x7 SEV1 test support
• Support Self Identified Audits, Control assessments, Database Audits, and SOX reviews

Requirements

• Minimum of 7-9 years of DB2 DBA experience on z/OS, preferably at a single large financial institution
• Experience with DB2 Utilities including IBM and BMC
• Working knowledge of BMC tools including Change Manager, Catalog Manager, Mainview, and SQL Performance
• Solid understanding of DB2 recovery options
• Broad understanding of ACF2 and RACF2 managed security for DB2 Access
• Working knowledge of Endevor
• Working knowledge of ITSM Processes and tools including BMC Remedy
• In-depth understanding of Db2 zOS, JCL, COBOL, and SQL
• Understanding of SMF data and reporting
• Knowledge of Splunk
• Knowledge of Python

Skills

Required

• DB2 DBA on z/OS
• DB2 Utilities (IBM and BMC)
• DB2 recovery options
• ACF2 and RACF2 managed security
• Endevor
• ITSM Processes and tools (BMC Remedy)
• Db2 zOS, JCL, COBOL, SQL
• SMF data and reporting

Preferred

• Splunk
• Python

Benefits

• For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10:
• Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
• The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
• Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
• Behavioral Health Platform
• Medical, Dental, Vision
• Health Savings Account
• Voluntary Hospital Indemnity (Critical Illness & Accident)
• Voluntary Term Life Insurance
• 401K
• Sick Pay (for applicable states/municipalities)
• Commuter Benefits (Dallas, NYC, SF, and Illinois)
• For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.
• Pay range: $58.32 - $66.32 per hour