Job Summary
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 PowerExchange & IDMC
- Java, web services, SOA concepts
- Application DBA Responsibilities
- DB2-AI and Cloud Modernization Technology
