Haystack
← Back to Jobs
Remote
Technology

Database Administrator (W2)

AdientOne LLCUnited States🇺🇸United StatesPosted 17 Jul 2026

Quick Overview

Work Type
Remote
Level
Mid Senior

Job Description

DUTIES AND RESPONSIBILITES:
• Responsible for elicitation, analysis, and documentation of business requirements.
• Research and exploration of user requirements, costs, and benefits in support of documentation required for the demand management process.
• Responsible for analyzing the business needs to identify new processes and process improvements that will meet those needs.
• Documents current business processes and models to define requirements and/or gaps.
• Analyze detailed system factors including input/output requirements, information and paper flow, hardware, and software needs.
• Analyze “soft" system factors including roles, responsibilities, policy, culture, etc.
• Evaluate the impact of potential software and process changes on the organization.
• Develop and facilitate groups as necessary in pursuit of eliciting and defining requirements.
• Assist in the creation of the business case documentation.
• Understanding of architectural consistency and usability standards.
• Defines and develops user test cases and validates test results during testing.
• Executes unit and functional test cases.
• May conduct system demonstrations and training sessions, as well as participate in design/review of training content.
• Plays a third level support role by helping to troubleshoot and resolve issues with production systems.
• Participates in associate meetings and communicates any concerns to management.


QUALIFICATIONS AND REQUIREMENTS:
• Bachelor’s degree in computer science, Information Systems, Business, or another related field or equivalent work experience.
• Proven experience leading data migration requirements from legacy systems into a new ERP (Sage X3) environment
• Strong hands-on expertise in requirements elicitation, documentation, and management, with emphasis on data mapping, transformation rules, and validation
• Deep understanding of data structures, data quality, and migration best practices, with the ability to identify gaps and risks early
• Self-driven and accountable professional with strong stakeholder management and communication skills, able to drive outcomes with minimal oversight
• Working knowledge of Confluence and JIRA.
• Experience in any of the following business areas is desired: Sales operations, order entry, accounting, finance, procurement, warehouse operations, order management, and order fulfillment.
• Minimum of 3-5 years’ business analysis or systems analysis experience is preferred.
• Bonus: Sage X3 experience (ERP).


Associate is expected to operate at a proficient level across the following areas of technical knowledge and skill:
• Ability to organize and prioritize work.
• Detail oriented, proactive, creative, and efficient
• Intermediate level abilities in Excel, Outlook, PowerPoint, Visio, and Word
• Familiarity with application integration methods to include understanding of data mapping process.
• Ability to effectively work both independently and collaboratively in a team environment
• Ability to work on simultaneous and complex projects, with domain expertise in at least one business area.
• Expertise in ERP solution selection and implementation is a plus
• Ability to communicate effectively to both technical and non-technical audiences in written and non-written format
• Ability to work with all levels of associates
• Ability to work with minimal supervision in a very dynamic environment
• Ability to learn new systems and tools
• Knowledge of software development life cycle methodologies, processes, and procedures.
• Active listener
• Effective in a variety of formal/informal presentation settings: one-on-one, small, and large groups.

Job Title: Database Administrator

Location: REMOTE

Duration: 12 Months

W2 Only

 

Daily duties / responsibilities:

The IDMS DBA is responsible for working closely with application development teams, Client z/OS system support staff and the Client Database Administrators to provide IDMS DBA support for application and infrastructure databases.

 

Duties include:

  • Hands-on IDMS monitoring and application support in ways that are consistent with IDMS best practices.
  • Collaboration with Client’s database administration team to maintain test, staging, production databases and the development of operations procedures for database management.
  • Enable and tune IDMS features to optimize the performance of databases in the context of the mainframe environment.  Generate and analyze performance data, recommend courses of action and implement best solutions to achieve optimum performance.
  • Coordinating with outside entities, including vendors for other systems/services, providers, professional associations, and other State agencies.
  • Advising development and product teams on best approaches for required data model extensions and/or changes.
  • Participate in a 24x7 on-call support rotation.
  • Other duties as assigned.

 

Client is seeking an IDMS professional with the knowledge and experience along with comparable communication and interpersonal skills to enable success on this high-visibility project.

 

Environment and Tools:

VB.Net, C#.Net, Java, Javascript, CSS, HTML, JQuery, Cobol, CICS, SQL, TSO, JCL, ADSO, Assembler, RPG

 

Required skills (rank in order of importance):

  • The IDMS DBA role has four major attributes: Database deployment and administration leadership, project management skills, people skills, and domain knowledge in enterprise class application development projects. Candidates must display excellence in all areas.
  • 15+ years of experience with IDMS deployment and operations in a z/OS environment on a z-series IBM mainframe computer.
  • 10+ years of experience with IDMS SQL option.  Be able to create and support IDMS databases that are deployed using the relational model with SQL syntax.  Understand the implementation of SQL access to native IDMS databases.
  • 15+ years of experience with deployment of IDMS security, including security of ADS/O application structures, IDD and relational database objects.
  • 15+ years of experience with application programming for the IDMS database, both native and SQL, using the COBOL and ADS/O programming languages.
  • 12+ years of experience with IBM High Level Assembler on the z/OS operating system.
  • 10+ years of experience with IDMS Perfmon online monitoring and report generation.

 

Preferred skills (rank in order of importance):

  • RACF security knowledge.
  • Knowledge of application change management.
  • Healthcare industry experience and/or experience managing PHI/PII data
  • Medicaid Management Information System (MMIS) experience
  • Medicaid operations experience.
  • Public sector experience is a plus.

 

Additional Skills:

  • Understanding of IT development and implementation projects.
  • Project planning experience, including effort estimation on technical tasks and resource allocation.
  • Strong written and oral communications skills, including the ability to give presentations to project management.
  • Impeccable integrity. This project will have very high visibility and will impact significant expenditures of public funds. Candidates must be confident with their abilities to make correct decisions and the courage to speak out when necessary.
  • Willingness and ability to effectively engage with people and organizations on a continuous basis.

 

Required education:

Bachelor’s degree in a technical, business, or related field or equivalent work experience. Masters degree is desirable.

Skills

SQL
C#
COBOL
CSS
Confluence
HTML
Java
JavaScript
Jira
Stakeholder Management
jQuery

Similar jobs