IBM Z Mainframe Engineer(US)-Int

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