Mainframe Senior Sys Prog​/Database Administrator – Db

Responsibilities

• Work closely with all levels of IT to deploy and support z/OS Db2 infrastructure and the associated application stack
• Provide leadership in technical aspects of assigned projects and support issues; bring new ideas to the table when appropriate
• Work with companion teams to set up and enforce database standards
• Identify opportunities to improve availability, reliability, and performance of system and application infrastructure
• Monitor system and application performance & provide performance improvement recommendations
• Upgrade, configure, and migrate new releases of Db2; regularly apply maintenance, and when necessary, apply PTFs/APRS
• Manage Db2 active and archive logs
• Modify Db2 zParms
• Recycle Db2
• Ensure recoverability of the system and applications’ database components
• Support DR activities (RTO/RPO: synchronization methods)
• Monitor instances for events and resolutions/escalations
• Ensure the proper alerting is occurring for Db2 messages
• Perform triage and troubleshooting
• Install, upgrade, configure and migrate new releases of Db2 ISV products, apply maintenance, and when necessary, apply fixes
• Support Db2 Independent Software Vendor (ISV) Products
• Develop scripting to automate Db2 systems engineering tasks

• Solid knowledge in Db2 subsystems and application tuning
• A keen eye on process improvement and automation
• Competence in Incident, Problem, and Change Management
• In-depth experience in supporting mainframe technology (i.e. z/OS ISPF, JCL, JES2, etc.) specifically SMP/E or ZOSMF
• Experience reviewing HOLDDATA
• Utilize stand-alone utilities (i.e. DSNJLOGF, DSNJU
  004, DSNJU
  003, etc.)
• Understand logical and physical database design
• Experience as a z/OS DB2 administrator, working with DDL, DML/DQL, DCL, DTL, DB2 commands, and SQL
• System and Application Performance tuning; including tuning buffer pools
• Experience in the Db2 Utilities (i.e. COPY, QUIESCE, REPAIR, REORG, LOAD, etc.)
• Understand RACF Security
• Understand Db2 managed security using RACF opposed to Db2 security
• Bachelor's Degree or equivalent experience
• 4-5 years professional experience. May include:
  • 5 years of professional IT experience
  • 5 years’ experience with at least one OS/hosting platform
  • 5 years’ experience in performance tuning of application stacks
  • 5 years’ experience with monitoring and performance management of systems
  • 3-5 years’ experience with identity platform and tools
  • 2 years’ experience with modern development and scripting languages
• Experience with CICD concepts, tools, branching strategies, and leveraging knowledge to assist in delivering an infrastructure as a product
• Excellent troubleshooting skills within area of expertise, and solid troubleshooting in adjacent domains
• Solid understanding of traditional or cloud computing technologies including Networking, Compute, Storage, Development, Data, Operations, or Security
• Experience with multiple delivery methodologies such as Agile and Waterfall

• Accountability:
  Holds self and their direct reports accountable for measurable, high-quality, timely, and cost-effective results, delivery, and execution. Determines objectives, sets priorities, delegates work to direct reports, and accepts responsibility for mistakes.
• Adaptive Communication:
  Formulates strategies to be used to convey complex information about services, products, systems, or processes to targeted audiences; communicates and liaises between technical and non-technical audiences.
• Analytical Thinking:
  Organizes and compares various aspects of a situation to comprehend and identify key or underlying complex issues through the use of quantitative data and analysis; leverages strong business acumen, problem solving, and interpersonal skills to think critically about situations from multiple perspectives and consistently seeks ways to improve processes.
• Cross Functional Partnering & Planning:
  Facilitates collaboration, communication, coordination, and planning with individuals and teams from different functions within the organization, and who have different areas of expertise, to achieve common goals.
• Infrastructure Development:
  Applies the knowledge of endpoint management and infrastructure platforms…