Senior Database Analyst / Database Systems Programmer (zDb2)
- Hapeville, GA
- Contract
- Full-time
- 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.
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
- 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.
- Relevant certifications in DB2 or related database technologies are a plus.
- Manage and maintain IBM DB2 databases on the 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.
- 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.
- 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.
- Oversee external DBA teams and systems programmers during the 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.
- Keep management informed of risks and develop mitigation strategies to reduce potential risks.
- Participate in audit reviews, including completing quarterly SOX audits and ensuring compliance with regulations.
- Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.
- Stay up-to-date on advancements in database technologies and lifecycle management, particularly focusing on deprecated features and mitigation planning.
- 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.