Apelon Terminology Server Administrator

The Apelon Terminology Server Administrator works closely with a team supporting the Indian Health Service, Health Information Technology Systems and Support (HITSS) project. The Apelon Terminology Server Administrator works in the development and augmentation of current Apelon-based mechanisms to enable the routine import of medium to large scale edits to Apelon content for any designated terminology using and enhancing, as needed, Terminology Query Language (TQL) based scripts, for example, consistent with the Apelon DB (future state operating procedure). The work requires skills associated with understanding Apelon software and Apelon DB. Also, the Terminology Server Administrator will ensure the correct transfer of database content from the current locally developed database to the Apelon DB and back (current standard operating procedure). The Terminology Server Administrator will be able to understand the local software DB to the extent needed. The "data" being integrated is clinical terminology knowledgebase content, i.e. collections of clinical concepts and concept mappings. It is not patient data. The ideal candidate is familiar with healthcare terminology standards and has worked in healthcare-based environments supporting interoperability and the large-scale use of healthcare terminologies in national or large regional electronic healthcare records. The ideal candidate works very closely with the System Engineer and the Clinical Terminologist as part of a quality driven team in support of content integral to the delivery of patient care in the Indian Health Service. The ideal candidate works closely with the team for guidance in understanding system/clinical/customer needs and the translation of such to work requirements. The ideal candidate seeks input and accept feedback from all team members to enhance understanding of candidate's work impact and meet IHS needs. An understanding of required input, error impact and standardization of processes, as well as the impact of such on the delivery of high-quality work is essential. The ideal candidate is very comfortable deeply applying analytical skills, is creative and typically proactively problem solves. This position desires deep technical understanding and familiarity with healthcare data flow. The team engages with other stakeholders, particularly with the Distributed Terminology System federal lead, other HIT teams, and at times vendor experts. Effective communication is required. The ideal candidate demonstrates the ability to collaborate in, what is at times, a high-pressure environment, exhibiting grace under pressure with internal and external stakeholders including teammates and customers. The ideal candidate will join a team of experienced professionals providing valuable expertise and technical support to meaningful work. Chickasaw Nation Industries, Inc. serves as a holding company with multiple subsidiaries engaged in several lines of business (Technology, Infrastructure & Engineering, Health, Manufacturing, Public Safety, Consulting, and Transportation) for the federal government and commercial enterprises. A portion of our profits is used to support Chickasaw citizens. We are proud to support the economic development and long-term viability of the Chickasaw Nation and its people. CNI offers premium benefits eligible on the first day of hire to full time employees; (Medical - Dental – Vision), Company Life Insurance, Short-Term and Long-Term Disability Insurance, 401(K) Immediate Vesting, Professional Development Assistance, Legal Aid Assistance Program, Family Planning / Fertility Assistance, Personal Time Off, and Observance of Federal Holidays. As a federal contractor, CNI is a drug-free workplace and adheres to the Federal Controlled Substance Act. ESSENTIAL REQUIREMENTS Must be able to obtain Public Trust Level 5 background clearance. System integration certification – desired certification from nationally recognized accrediting body. Experienced with terminology servers, system integration, database and application support and maintenance. Possesses knowledge to support current health information technology, recommend improvements and assists in upgrade/enhancements of current systems as needed. Expertise in system integration in which data pipeline traceability is essential. Strong Java programming is required; Experience with Git source code repository strongly preferred. Experience with a Java/Excel API is a plus. Expertise with terminology servers is desired, especially Apelon DTS. Experience with SQL databases, especially SQL Server, at both application- and DBA-levels. Expertise with application support, development and maintenance. Experience with end-to-end implementation and support. Possesses DB experience sufficiently enough to develop the required understanding of the relationship between the Apelon environment and the DB the current local software (ATOM) sits on. Experienced in information Modeling at both conceptual (e.g. UML Object modeling with class diagrams) and logical (entity-relationship, 3NF modeling) levels. Experienced in interaction modeling (e.g. using UML sequence diagrams); Understanding and deep experience with infrastructure such as Windows Authentication. Engineering mindset – to organize complexity and keep it under control. Strong experience with at least one standard clinical terminology is desired (SNOMED CT, ICD-10-CM, RxNorm, LOINC, etc.). Possesses excellent time management and organizational skills and has demonstrated ability to multi-task manage multiple projects and priorities and to meet specified deadlines. Excellent customer service and relationship-building skills. Excellent computer skills with proficiency using Microsoft Office, and very strong in MS Excel. Excellent verbal and written communications skills with ability to compose meaningful reports and to present information with clarity. Strong analytical, problem-solving, teamwork and communication skills. Ability to employ a collaborative, customer service approach and to work effectively with others in diverse and multi-functional roles. Understands need for and has the ability to maintain confidentiality of sensitive information. Ability to raise appropriately issues and concerns for resolution. Ability to work effectively, both independently and in a team environment for the successful achievement of goals. ESSENTIAL DUTIES AND RESPONSIBILITIES Essential duties and responsibilities include the following, other duties may be assigned. Maintains server security and integrity. Contributes the requisite technical expertise in the implementation of security standards and guidelines. Integrates Apelon DTS content into IHS test and production environments. Maintains traceability of work and issues. Manages system performance. Reports on infrastructure capabilities to team as needed. Assesses System integration – current and future. Supervises all alerts related to application and system procedures and provide services proactively. Installs and prepares tools required for proper functioning of application, including Apelon DTS, on regular basis, documenting and communicating as needed. Application administration, support and maintenance. Lead the installation, upgrade, and maintenance of Apelon DTS and other enterprise applications and servers as needed. This includes installing new software releases and system upgrades, evaluating, and installing patches, and conducting application migrations, refreshes, and restores. Develops expertise in Apelon software and Apelon DB. Develops and augments current Apelon-based mechanisms to enable the import of medium to large scale edits to Apelon content for any designated terminology, utilizing an effective combination of Apelon Terminology Query Language (TQL) and other Apelon plug-ins preserving the integrity of the Apelon DB (future state operating procedure). Bidirectionally Integrates Apelon DTS with locally developed Java terminology application (ATOM) (current standard operating procedure), maintaining traceability of requests through delivered results, with MS Excel reporting at various points for pipeline transparency Implement and maintain these integrations using a combination of: their native import/export/query tools and Java/JDBC. Document how and when these capabilities are used in the context of regular content update cycles. Routinely advise on feasibility of integration improvements and provide corresponding work estimates. Designs and implements tools to measure effectiveness of current and of new systems/processes or improvements to existing systems/processes. Organizes and implements projects and provide assistance to all processes under guidance of the System Engineer, the Clinical Terminologist and the Project Manager. Assess existing infrastructure and system to identify opportunities for upgrade and consolidation of subsystems integration into cohesive entities, based on work/team-driven requirements, to better meet organizational goals, increase quality and efficiency. Solicit feedback from team then proceed with plan, with subsequent evaluation for desired/untoward impacts. Provides data-driven recommendations regarding new health IT systems/processes and improvements to existing systems/processes, working closely with DTS team and in collaboration with other IHS based health information technology experts. As part of routine workflow, creates, implements test plans and results, soliciting and incorporating team feedback at each step. Designs and maintains content pipelines across application processes and systems. Administer and resolve applications issues, provide updates and perform root cause analysis. Provide production support in a 24 x 7 environment, maintain SLA, system availability, capacity management, and performance KPI. Performs root cause assessment and debug all issues on server domain, and availability of applications. Provides support and identify all issues and prepare appropriate documentation all issues and solutions. Identifies and provide resolutions ranging in complexity from medium to high. Maintains SQL Server including some Administrator duties. Maintains General Server admin (mostly Windows patching, backups). Works closely with team and vendor(s) to identify optimal system use. Gathers and analyzes HIT data to help federal customers with decisions of enterprise-wide impact. Understands and communicates regulatory and IT requirements affecting health business processes. Gathers and documents requirements for existing and new projects using agile tools and/or standard requirements documentation. Prepares analysis and findings using Microsoft products, such as PowerPoint, Visio, Excel and Word. Assists the project manager with the development and maintenance of backlog items used in agile development. Reviews and contributes to documentation, reports, and other documents for new and existing systems. Contributes to the development/modification of policies and procedures supporting new and existing systems. Contributes to the development and implementation of system training program and materials. Analyze problems for various projects to identify significant factors, gather pertinent data and recognize solutions. Understand and responds to a rapidly changing business environment and works closely with the project manager and project team on customized solutions. Performs miscellaneous administrative duties related to accomplishing tasks and any duties assigned by the project manager. Maintains good professional relationships with internal and external team. Supports internal CMMI-related commitments to support cyclical audits and maintains quality assurance standards for existing documentation through peer reviews, audits, and checklists. Demonstrates flexibility to support emerging program needs and priorities. EDUCATION/EXPERIENCE REQUIRED Bachelor of Science degree in Computer Science, Software Engineering, Information Science, Health Information Technology or other IT related field of study. Five (5) years of experience working in system integration and database design. PHYSICAL DEMANDS Work is primarily performed in an office environment. Regularly required to sit. Regularly required use hands to finger, handle, or feel, reach with hands and arms to handle objects and operate tools, computer, and/or controls. Required to speak and hear. Occasionally required to stand, walk and stoop, kneel, crouch, or crawl. Must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and ability to adjust focus. Exposed to general office noise with computers printers and light traffic. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job. EOE including Disability/Vet The estimated pay range for this role is $100K to $120K, with the final offer contingent on location, skillset, and experience. CNI offers a comprehensive benefits package that includes: Medical Dental Vision 401(k) Family Planning/Fertility Assistance STD/LTD/Basic Life/AD&D Legal-Aid Program Employee Assistance Program (EAP) Paid Time Off (PTO) – (11) Federal Holidays Training and Development Opportunities Your application submission will be considered for all potential employment opportunities with Chickasaw Nation Industries (CNI). #INDREMOTE Chickasaw Nation Industries, Inc. (CNI) is a federally chartered corporation wholly owned by the Chickasaw Nation. Headquartered in Norman, Oklahoma, CNI serves as a holding company with multiple subsidiaries that operate as Limited Liability Companies (LLCs) engaged in several lines of business including Civilian, Defense, Filtration, Network Services, and Research, Development, Test and Evaluation. CNI supports a diverse culture that offers innovative approaches and customer-centered services. When you do business with us, you gain efficient and cost-effective solutions that help safeguard the environment, protect and secure key assets, and connect resources to needs. We are proud to support the economic development of the Chickasaw Nation and to contribute to the tribal mission of enhancing the overall quality of life of the Chickasaw people. A portion of our profits is used to support Chickasaw citizens through a multitude of programs and services such as education, health care, nutrition services, housing programs, legal services, elder and child care and community support programs. Successful economic development is an integral part of the Chickasaw Nation's operations.