Motion Recruitment
Senior Database Analyst / Database Systems Programmer (zDb2)
Motion Recruitment, Atlanta, Georgia, United States, 30383
Join to apply for the
Senior Database Analyst / Database Systems Programmer (zDb2)
role at
Motion Recruitment 1 day ago Be among the first 25 applicants Join to apply for the
Senior Database Analyst / Database Systems Programmer (zDb2)
role at
Motion Recruitment Get AI-powered advice on this job and more exclusive features. Every year, nearly 200 million travelers trust our client to get them where they're going. Take your career to new heights by working for this longstanding leader in air travel that services more worldwide destinations than any other airline.
We are looking for a Senior Database Analyst / Database Systems Programmer to join our team for a long-term contract in Hapeville, GA (hybrid).
Contract Duration: 12 months
Required Skills & Experience
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).
Desired Skills & 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.
What You Will Be Doing
Database Administration & Maintenance:
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.
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 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.
Risk Management & Compliance
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.
Disaster Recovery & Business Continuity
Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.
Technology Strategy & Lifecycle Management
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.
Posted By:
VMS Sourcing Seniority level
Seniority level Mid-Senior level Employment type
Employment type Contract Job function
Job function Information Technology Industries Staffing and Recruiting Referrals increase your chances of interviewing at Motion Recruitment by 2x Get notified about new Senior Database Analyst jobs in
Atlanta, GA . Senior Database Analyst/Database Systems Programmer
Senior Cloud Operations Database Administrator (Remote - United States)
Atlanta, GA $89,301.33-$121,194.66 2 weeks ago Atlanta, GA $114,816.00-$165,845.33 2 weeks ago Atlanta, GA $78,825.00-$126,120.00 2 days ago Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Atlanta, GA $182,700.00-$263,900.00 3 weeks ago Atlanta, GA $97,000.00-$200,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Senior Database Analyst / Database Systems Programmer (zDb2)
role at
Motion Recruitment 1 day ago Be among the first 25 applicants Join to apply for the
Senior Database Analyst / Database Systems Programmer (zDb2)
role at
Motion Recruitment Get AI-powered advice on this job and more exclusive features. Every year, nearly 200 million travelers trust our client to get them where they're going. Take your career to new heights by working for this longstanding leader in air travel that services more worldwide destinations than any other airline.
We are looking for a Senior Database Analyst / Database Systems Programmer to join our team for a long-term contract in Hapeville, GA (hybrid).
Contract Duration: 12 months
Required Skills & Experience
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).
Desired Skills & 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.
What You Will Be Doing
Database Administration & Maintenance:
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.
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 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.
Risk Management & Compliance
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.
Disaster Recovery & Business Continuity
Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.
Technology Strategy & Lifecycle Management
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.
Posted By:
VMS Sourcing Seniority level
Seniority level Mid-Senior level Employment type
Employment type Contract Job function
Job function Information Technology Industries Staffing and Recruiting Referrals increase your chances of interviewing at Motion Recruitment by 2x Get notified about new Senior Database Analyst jobs in
Atlanta, GA . Senior Database Analyst/Database Systems Programmer
Senior Cloud Operations Database Administrator (Remote - United States)
Atlanta, GA $89,301.33-$121,194.66 2 weeks ago Atlanta, GA $114,816.00-$165,845.33 2 weeks ago Atlanta, GA $78,825.00-$126,120.00 2 days ago Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Atlanta, GA $182,700.00-$263,900.00 3 weeks ago Atlanta, GA $97,000.00-$200,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr