IBM Z Mainframe Engineer; US-Ext

DB2 Systems Administrator Team Lead

Company provides comprehensive hosted services for retail brokerage customers' end-to-end business operations. The core of these services runs on multiple IBM Parallel Sysplex environments utilizing IBM's DB2 z/OS in a high-performance, highly-available data-sharing configuration. This DB2 Systems Administrator Team Lead role is responsible for the installation, maintenance, and administration of the DB2 z/OS subsystem and associated support products to support the demands of the fast-paced, time-critical financial trading industry.

Essential Responsibilities

• Installation/maintenance of IBM DB2 z/OS software and related 3rd-party products utilizing SMP/E. This includes working with IBM and other vendors to address product defects, issues, and usage questions.
• Configuration of DB2 groups and subsystems in SYSPLEX data-sharing environment, supporting IBM CICS, batch COBOL, and distributed access applications.
• Perform problem analysis and resolution, both technical and application related
• Performance and capacity tuning of system parameters and resources, utilizing various monitoring and reporting tools.
• Responsible for DB2 availability and recovery strategies and procedures.
• Documentation of policies and procedures in compliance with ISO 27002 standards.
• Provide mentoring and cross-functional collaboration with business units.
• Provide secondary and level 2 support for the DBA staff on system issues, application performance and overall DB2 issues, including being comfortable with high-pressure, time-sensitive environments.

Qualifications

• 12+ years IBM System Z experience and concepts, with considerable knowledge in the following:
• SMP/E
• IBM DB2 utilities, BMC Mainview for DB2 and BMC Tool Suite for DB2, particularly Detector, Subsystem analyzer, Apptune, AMI Reorg and AMI Unload/Load
• Experience with DB2 z/OS as a distributed server
• FLASH technology, DASD replication techniques
• z/OS Storage management
• RACF security management w/DB2 z/OS
• Coupling Facility
• Networking concepts (IP, SNA)
• WLM concepts
• USS - z/OS UNIX System Services
• 'For-Bit' Data structures
• REXX application programming
• 7+ years IBM DB2 experience, with advanced knowledge in the following:
• Bufferpool/memory management
• DB2 internal structures (RID, EDM, BPs, etc.)
• Tablespace/Page structures / UTS
• Backup/recovery/logging facilities and strategies
• DB2 locking
• ZPARMS
• DB2 tracing/IFCIDs
• Experience in problem determination and analysis
• Analytical / critical / "outside-the-box" thinking in problem solving, especially in possible critical, high-pressure situations.

Additional Skills A Plus

• Informatica Power Exchange & IDMC
• Java, web services, SOA concepts
• Application DBA Responsibilities
• DB2-AI and Cloud Modernization Technology