Information Technology_USA – USA_Database Administrator

Overview

Job Title:

Senior Database Analyst / Database Systems Programmer (zDb2)

We are seeking an experienced Database Analyst or Database Systems Programmer with a minimum of 8 years of experience working with zDb
2. The ideal candidate will have strong expertise in mainframe database technologies, including zDb2, IMS DBDC, and/or ADABAS. This role involves overseeing database systems, optimizing performance, managing upgrades, and supporting application teams to implement new technologies that align with business goals.

• Database Administration & Maintenance:
  Manage and maintain IBM DB2 databases on z/OS mainframe platform. Create and manage database objects, such as tables, indexes, and table spaces. Perform data manipulation operations like loading, unloading, and reorganizing data using DB2 utilities. Implement database backup and recovery strategies to ensure data availability and disaster recovery.
• Performance Monitoring & Optimization:
  Monitor database performance metrics to identify and resolve bottlenecks. Perform database tuning to enhance query performance and maintain optimal system functioning. Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization.
• Collaboration & Consultation:
  Develop and maintain effective communication with application teams regarding infrastructure technology projects and roadmaps. Serve as a consultant to application teams and business users on new technologies and system enhancements. Collaborate with application developers to design and implement database schema changes.
• Software & System Management:
  Oversee external DBA teams and systems programmers during installation and support of mainframe database software. Facilitate service level management, including change management, incident, and problem management. Stay current with software upgrades, ensuring timely implementation of new features that enhance Delta applications. Work with external vendor teams to ensure smooth conversions during software updates and releases. Proactively monitor database platforms for high availability, identifying root causes and correcting issues.
• Risk Management & Compliance
• Disaster Recovery & Business Continuity
• Technology Strategy & Lifecycle Management

• Minimum of 8 years of experience with zDb2, IMS DBDC, and/or ADABAS.
• Proficiency with replication software such as IIDR IBM Infosphere Data Replication Suite.
• Strong understanding of zConnect Enterprise Edition (zCEE) API framework.
• Expertise in IBM DB2 database administration on zOS mainframe platforms.
• In-depth knowledge of SQL, DB2 partitioning, indexing, data sharing, and performance tuning techniques.
• Experience with mainframe operating system concepts and Job Control Language (JCL).
• Familiarity with data security best practices and compliance regulations.
• Ability to troubleshoot and resolve complex database-related issues.
• Strong experience in managing database backups, recovery procedures, and disaster recovery planning.

• Knowledge of IBM DB2, IMS DBDC, and ADABAS database products.
• Familiarity with service level management, change management, and incident resolution.
• Experience working with external vendors and managing software upgrades.

Sys Mind