REMOTE - ADABAS Database Specialist/DB2

Zachary Piper Solutions is seeking an ADABAS/DB2 Database Specialist to join a Federal Program working on a Remote Schedule. The ADABAS/DB2 Database Specialist will provide expert-level technical support in planning, configuring, implementing, and maintaining Software AG’s (SAG) suite of ADABAS products in an enterprise z/OS mainframe environment.

Responsibilities of the ADABAS/DB2 Database Specialist:

• Plan, install, configure, customize, and implement SAG ADABAS software products, including Cluster Services, Online Services (AOS), SAF security, and associated tools.
• Plan, configure, and implement ADABAS support for structured/unstructured data, SQL, Natural, and security features.
• Plan and execute disaster recovery strategies for ADABAS and related products, including offsite restoration.
• Manage and create table spaces, assist DBAs with parameter settings, and optimize database structures for efficiency.
• Configure and optimize ADABAS Cluster Services, add-on tools, and Nucleus 64-bit processing support.
• Implement buffering strategies for data and indexes in main memory to reduce CPU consumption and improve performance.
• Monitor, analyze, and tune ADABAS database performance, including reporting resource consumption through SMF.
• Support compliance with audits, regulatory requirements, and OPM change control processes.
• Provide technical assistance to PMO DBMS programming and systems design staff.
• Troubleshoot and perform dump analysis of Natural programs and resolve database performance issues.
• Plan and perform migrations or conversions of the SAG software suite to other platforms such as DB2 or Oracle.
• Support z/OS operating system parameters and IBM CICS Transaction Server tuning for optimal ADABAS and Natural performance in CICSPlex environments.
• Automate ADABAS startup/shutdown using Tivoli System Automation for z/OS or compatible tools.
• Apply SAG software fixes and updates, ensuring operational continuity.

Qualifications of the ADABAS/DB2 Database Specialist:

• Recent hands-on experience with ADABAS Cluster Services in IBM z/OS Parallel Sysplex environments.
• Experience with ADABAS Suspend/Resume in support of Point-in-Time copy.
• Proficiency with SAG products such as PREDICT, REVIEW DB, REVIEW Natural Monitor, Natural Security, Natural Optimizer Compiler, Natural Construct, ADABAS Native SQL, and AOS.
• Experience developing and implementing disaster recovery procedures for ADABAS environments.
• Demonstrated ability to monitor and tune ADABAS databases, optimize CPU utilization, and maintain high availability.
• Experience supporting CICS Natural applications in CICSPlex configurations.
• Strong background in maintaining z/OS operating systems and IBM CICS parameters for optimal ADABAS performance.
• Hands-on experience with SAG software migrations and applying released fixes.
• Excellent communication and problem-solving skills, with the ability to provide technical consultation and training.
• Must be able to obtain a Public Trust Clearance.

Compensation for the ADABAS/DB2 Database Specialist:

• Salary Range: $100,000 - $110,000 *flexible based on experience*
• Comprehensive Benefits: Medical, Dental, Vision, PTO, and Sick Leave as required by law
• Flexible working schedule
• Unlimited opportunities for growth

#LI-CJ2

#LI-REMOTE

Key Words: ADABAS, Database, db2, federal, specialist, IT, government, cleared, IBM, zos, upgrades, installation, configure, configuration, troubleshooting, information technology