ADABAS Database Specialist/DB2

Job description

Job Title : ADABAS Database Specialist/DB2
Location: US-Remote (EST Hours)
Clearance Requirements: Successful completion of a Public Trust background investigation and/or a Public Trust clearance.


Min Citizenship Status Required: Must be a U.S. Citizen per client
Compensation: $67/HR


ALTA IT is seeking an experienced ADABAS Database Specialist to 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.

This role is critical to ensuring the reliability, security, and performance of mission-critical ADABAS Cluster Services, ensuring high availability and continuous operations.


The specialist will lead initiatives in disaster recovery, performance tuning, system optimization, and regulatory compliance, while providing technical guidance to DBAs, PMOs, and system design staff.
Key Responsibilities:
+ Plan, install, configure, customize, and implement SAG ADABAS software products, including Cluster Services, Online Services (AOS), SAF security, and associated tools.
+ 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.
+ Ensure compliance with audits, regulatory standards, and internal change control processes.
+ Provide technical assistance to programming, DBMS, and systems design teams.
+ Troubleshoot and perform dump analysis of Natural programs and resolve database performance issues.
+ Plan and execute 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 performance in CICSPlex environments.
+ Automate ADABAS startup/shutdown using Tivoli System Automation for z/OS or similar tools.
+ Apply SAG software updates and fixes to ensure operational continuity.


Qualifications:
Education & Experience:
+ Bachelor’s Degree or equivalent experience required.
+ Minimum of 12 years of experience installing, implementing, maintaining, and supporting SAG’s ADABAS database systems.
+ Minimum of 5 years of recent experience with ADABAS on z/OS.


Required & Desired Skills/Certifications:
+ Recent hands-on experience with ADABAS Cluster Services in IBM z/OS Parallel Sysplex environments.
+ Experience with ADABAS Suspend/Resume functionality for 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
+ AOS
+ Experience developing and implementing disaster recovery procedures.
+ Proven ability to monitor and tune ADABAS, optimize CPU usage, and ensure high availability.
+ Experience supporting CICS Natural applications in CICSPlex environments.
+ Strong background in maintaining z/OS operating systems and IBM CICS parameters for optimized performance.
+ Experience with SAG software migrations and applying software patches and updates.
+ Excellent communication and problem-solving skills, including the ability to provide technical consultation and training.


System One, and its subsidiaries including Joulé, ALTA IT Services, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America.

We help clients get work done more efficiently and economically, without compromising quality.

System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

#M2
#LI-AJ1
#DI-AJ1





Ref: #850-Rockville (ALTA IT)




System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America.

We help clients get work done more efficiently and economically, without compromising quality.

System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Required Skill Profession

Other General