Mainframe DB2 System Programmer – SME

• Install and maintain IBM DB2 z/OS software and related third-party products using SMP/E
• Work with IBM and other vendors to address product defects, issues, and usage questions
• Configure DB2 groups and subsystems in SYSPLEX data-sharing environments
• Support mainframe DB2 applications
• Perform problem analysis and resolution for mainframe DB2 system issues
• Tune system parameters and resources for performance and capacity
• Manage DB2 subsystem availability, backup and recovery strategies and procedures
• Conduct disaster recovery tests
• Maintain the DB2 Catalog, Directory, and other DB2 system objects
• Document policies and procedures
• Provide secondary support to DBA staff on DB2 subsystem issues
• Provide security services related to DB2 systems support

• 7+ years IBM System Z experience and concepts
• Knowledge of software installation via SMP/E
• Database management and performance optimization using IBM, BMC, and Broadcom toolsets
• Experience with DDF and DRDA remote client/application connectivity
• Experience with RACF, ACF2, or TopSecret access control
• Knowledge of FLASH copy, DASD replication, DB2 forward recovery, z/OS storage management, Coupling Facility, TCP/IP, SNA, WLM, and USS
• 5+ years IBM DB2 experience
• Advanced knowledge of buffer pools, page and tablespace layouts, and DB2 internal components including EDM pool and RIDs
• Data sharing sysplex management and ZPARMS configuration
• Backup, recovery, and logging strategies
• Lock/latch contention management, IFCID tracing, and performance monitoring
• Experience in problem determination and analysis
• Bachelor’s degree in computer science or related field (preferred)
• Experience with BMC MainView for DB2 and IBM Omegamon for DB2 (preferred)
• Experience with IBM Query Monitor for DB2 (preferred)
• Knowledge of Java, web services, and SOA concepts (preferred)
• REXX programming (preferred)

• Flexible, supportive environment
• Well Be programs supporting financial, mental, physical, and social health
• Personalized development goals and continuous feedback
• Certifications with Microsoft, Google, and Amazon
• Coaching and hands-on learning experiences
• Career development and advancement opportunities
• Hybrid-friendly culture
• Employee referral program