Adabas Linux Database Administrator (DBA)

Candidate must be able to provide proof of residency within New England states: MASS, RI, CT, NH, VT, PARTS OF MAINE AND NY

EOHHS (EHS) is developing a strategic plan to streamline and combine its current eligibility and enrollment processes through the One Health initiative. Eligibility and enrollment processes for MAGI members, currently serviced through the Health Insurance Exchange (HIX), and non-MAGI members, currently serviced through the legacy MA21 mainframe system. The system will be modernized on a modular basis to provide a single point of access for individuals and/or families applying for public health insurance benefits. The modernization will provide common data storage and eligibility determination processes and rules for all Medicaid programs. To develop a plan for implementing a single point of access for benefits, EOHHS is undertaking an intensive effort to map the current state of Medicaid and MA21 operations and the systems that support those operations, then will port those operations and systems to a new infrastructure. The MA21 system is the MassHealth legacy, mainframe-based eligibility determination system that manages seniors and those in need of long-term care services populations. These populations are also described as non-MAGI. MA21 seeks a highly motivated Adabas Linux Database Administrator (DBA) who will support a "Lift and Shift" of the on-premises legacy mainframe application to AWS Cloud. Collaborate closely with development to be the liaison between the business community, the technical development team, and Cloud Rehosting Vendors. The DBA will play an integral role in supporting the cloud rehosting project, maintenance enhancements that may be implemented on the cloud platform, or defect fixes that need to be remediated on the cloud platform to meet the requirements of the business community. The first step in porting operations and systems to a new infrastructure will be to rehost the Natural/Adabas MA21 mainframe system in the AWS cloud. The successful candidate will support the MA21 AWS Cloud rehosting effort in support of the One Health Initiative. Coordinating these efforts of the MA21 cloud rehosting project will enable the successful migration of the MA21 legacy mainframe system as a key strategic step toward the future One Health Initiative.

DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:

Monitor and maintain the stability of Adabas/Natural applications supporting services in the Cloud-based, distributed Linus server environment

Experience supporting Linux operating systems: RedHat (preferred), SuSe, and CentOS. Understanding of Linux operating systems architecture and use of commands and utilities.

Fundamental Cloud knowledge, AWS, Azure

Responsible for supporting a broad range of Software AG (SAG) and other third-party vendor products to provide a stable technical infrastructure

Design and implement Adabas databases to ensure optimal performance and scalability

Participate with database support and provide timely resolution of database-related issues

Understanding knowledge of EntireX Communicator (RPC & ACI Protocol)

Monitor database performance using tools like Adabas Manager

Develop and implement backup and recovery procedures using Adabas Backup and Recovery Tools

Optimize database performance through query optimization, indexing, and buffer pool management

Monitor database using Adabas Performance Monitor to identify and resolve performance bottlenecks

Communicate effectively with business users and managers. Ensure project documentation, plans, and scheduling comply with agency initiatives and priorities

Administering the Natural development environment

Experience with Adabas Utilities: Use of utilities like ADAREP, ADABAS, ADASAV, ADAORD, etc. for database maintenance and reporting

Security certificate configuration with Software AG products Upgrades, Configuration, and Management Of Software AG Products on Linux, Including:Upgrades, Configuration, and Management Of Software AG Products on Linux, Including:

▪ Adabas ▪ EntireX Communicator

▪ Adabas Encryption ▪ Natural Construct

▪ ConnX ▪ Natural One

▪ Entire Net-Work

▪ Natural Security

▪ Entire Connection

▪ Predict

Linux shell scripting

Performing database startup and shutdown

Performing and restoring database backups

Performing Adabas File Reorders

Using the Software AG Update Manager to apply updates/fixes

Using administration subsystems, including cron, to schedule system tasks

Qualifications

• Strong relationship skills and ability to interact with internal and external stakeholders and management

• Demonstrated proficiency in business modeling, process modeling, and data modeling

• Knowledge of methods and techniques of computer systems analysis, design, technical terminology, codes, and standard abbreviations

• Using the available system management tools (both console and Web-based System Management)

• Knowledge of MA HIX or other State Health Exchange

• Ability to work with multiple vendors

• Strong organizational skills, problem-solving aptitude, and attention to detail

• Ability to work well with others in a fast-paced, dynamic environment

• Strong initiative, ability to manage multiple projects, and strong follow-through skills

• Deliver oral and written instructions in a precise, understandable manner

• Strong organizational skills with the ability to maintain accurate records and status reporting

• Proficiency in Microsoft 365, Excel, Word, PowerPoint, Access, and Visio

• Experience with Jira Software

• Experience with the SDLC (Software Development Life Cycle)

• EDUCATION AND CERTIFICATIONS

• Bachelor's degree in computer science, Information Systems, Business Administration, or a related field.

• Minimum of (10) years of Information Technology experience

• Minimum of (5) years of experience as an Adabas Database Administrator

• Prior Government or healthcare experience desired.