Overview
On Site
Full Time
Skills
Data Manipulation
Backup
Performance Monitoring
Optimization
Performance Metrics
Database Performance Tuning
Statistics
Query Optimization
Effective Communication
Roadmaps
Problem Management
High Availability
ROOT
Risk Management
Sarbanes-Oxley
Auditing
Business Continuity Planning
Testing
IT Strategy
Lifecycle Management
IBM InfoSphere
Replication
API
Database Administration
z/OS
SQL
Performance Tuning
Mainframe
Operating Systems
JCL
Data Security
Regulatory Compliance
Backup Administration
Recovery
Disaster Recovery
IBM IMS
ADABAS
Service Level Management
Change Management
Computer Science
Information Technology
IBM DB2
Management
Collaboration
Database
Law
Recruiting
ACL
Job Details
Job Summary:
We are seeking an experienced Database Analyst or Database Systems Programmer with a minimum of 8 years of experience working with zDb2. The ideal candidate will have strong expertise in mainframe database technologies, including z/Db2, IMS DB/DC, 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.
Key Responsibilities:
Database Administration & Maintenance:
o Manage and maintain IBM DB2 databases on the z/OS mainframe platform.
o Create and manage database objects, such as tables, indexes, and table spaces.
o Perform data manipulation operations like loading, unloading, and reorganizing data using DB2 utilities.
o Implement database backup and recovery strategies to ensure data availability and disaster recovery.
Performance Monitoring & Optimization:
o Monitor database performance metrics to identify and resolve bottlenecks.
o Perform database tuning to enhance query performance and maintain optimal system functioning.
o Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization.
Collaboration & Consultation:
o Develop and maintain effective communication with application teams regarding infrastructure technology projects and roadmaps.
o Serve as a consultant to application teams and business users on new technologies and system enhancements.
o Collaborate with application developers to design and implement database schema changes.
Software & System Management:
o Oversee external DBA teams and systems programmers during the installation and support of mainframe database software.
o Facilitate service level management, including change management, incident, and problem management.
o Stay current with software upgrades, ensuring timely implementation of new features that enhance Delta applications.
o Work with external vendor teams to ensure smooth conversions during software updates and releases.
o Proactively monitor database platforms for high availability, identifying root causes and correcting issues.
Risk Management & Compliance:
o Keep management informed of risks and develop mitigation strategies to reduce potential risks.
o Participate in audit reviews, including completing quarterly SOX audits and ensuring compliance with regulations.
Disaster Recovery & Business Continuity:
o Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.
Technology Strategy & Lifecycle Management:
o Stay up-to-date on advancements in database technologies and lifecycle management, particularly focusing on deprecated features and mitigation planning.
Quals--
Required Skills & Knowledge:
Minimum of 8 years of experience with zDb2, IMS DB/DC, 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 z/OS 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.
Preferred Qualifications:
Knowledge of IBM DB2, IMS DB/DC, and ADABAS database products.
Familiarity with service level management, change management, and incident resolution.
Experience working with external vendors and managing software upgrades.
Education & Certification Requirements:
Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
Relevant certifications in DB2 or related database technologies are a plus.
Work Environment:
Full-time, with on-call support and responsibilities for managing database platforms and applications.
Collaboration with various internal and external teams to ensure high performance and availability of database systems.
ACL Digital is proud to be an Equal Employment Opportunity Employer. We are committed to diversity and inclusion regardless of age, race, color, ancestry, religion or creed, sex, national origin, sexual orientation, citizenship, marital status, disability, gender identity, veteran status or any other characteristic protected by law.
To ensure a fair and transparent hiring process, we encourage you to review the following resources:
Know Your Rights
Pay Transparency Act
IER Right to Work Document
If you are an individual with a disability and need a reasonable accommodation to assist with your job search or employment application, please contact us by completing our Accommodations for Applicants form. For any other queries, send an email to or call the ACL Digital HR Help/Accommodation at .
We are seeking an experienced Database Analyst or Database Systems Programmer with a minimum of 8 years of experience working with zDb2. The ideal candidate will have strong expertise in mainframe database technologies, including z/Db2, IMS DB/DC, 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.
Key Responsibilities:
Database Administration & Maintenance:
o Manage and maintain IBM DB2 databases on the z/OS mainframe platform.
o Create and manage database objects, such as tables, indexes, and table spaces.
o Perform data manipulation operations like loading, unloading, and reorganizing data using DB2 utilities.
o Implement database backup and recovery strategies to ensure data availability and disaster recovery.
Performance Monitoring & Optimization:
o Monitor database performance metrics to identify and resolve bottlenecks.
o Perform database tuning to enhance query performance and maintain optimal system functioning.
o Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization.
Collaboration & Consultation:
o Develop and maintain effective communication with application teams regarding infrastructure technology projects and roadmaps.
o Serve as a consultant to application teams and business users on new technologies and system enhancements.
o Collaborate with application developers to design and implement database schema changes.
Software & System Management:
o Oversee external DBA teams and systems programmers during the installation and support of mainframe database software.
o Facilitate service level management, including change management, incident, and problem management.
o Stay current with software upgrades, ensuring timely implementation of new features that enhance Delta applications.
o Work with external vendor teams to ensure smooth conversions during software updates and releases.
o Proactively monitor database platforms for high availability, identifying root causes and correcting issues.
Risk Management & Compliance:
o Keep management informed of risks and develop mitigation strategies to reduce potential risks.
o Participate in audit reviews, including completing quarterly SOX audits and ensuring compliance with regulations.
Disaster Recovery & Business Continuity:
o Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.
Technology Strategy & Lifecycle Management:
o Stay up-to-date on advancements in database technologies and lifecycle management, particularly focusing on deprecated features and mitigation planning.
Quals--
Required Skills & Knowledge:
Minimum of 8 years of experience with zDb2, IMS DB/DC, 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 z/OS 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.
Preferred Qualifications:
Knowledge of IBM DB2, IMS DB/DC, and ADABAS database products.
Familiarity with service level management, change management, and incident resolution.
Experience working with external vendors and managing software upgrades.
Education & Certification Requirements:
Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
Relevant certifications in DB2 or related database technologies are a plus.
Work Environment:
Full-time, with on-call support and responsibilities for managing database platforms and applications.
Collaboration with various internal and external teams to ensure high performance and availability of database systems.
ACL Digital is proud to be an Equal Employment Opportunity Employer. We are committed to diversity and inclusion regardless of age, race, color, ancestry, religion or creed, sex, national origin, sexual orientation, citizenship, marital status, disability, gender identity, veteran status or any other characteristic protected by law.
To ensure a fair and transparent hiring process, we encourage you to review the following resources:
Know Your Rights
Pay Transparency Act
IER Right to Work Document
If you are an individual with a disability and need a reasonable accommodation to assist with your job search or employment application, please contact us by completing our Accommodations for Applicants form. For any other queries, send an email to or call the ACL Digital HR Help/Accommodation at .
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.