Systems Administrator, Contract Writing Systems (TS with SCI eligibility)

Trifecta; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

Trifecta is seeking a seasoned Appian/DoD systems specialist to administer and enhance Contract Writing Systems within a cloud Appian environment. You will lead release management, performance tuning, and data integration across FPDS, SAM.gov, and related systems.

The role requires a DoD contracting background, CompTIA Security+, and strong SQL/Power BI skills. Travel may be required; you’ll work with cross-functional teams to ensure FAR/DFARS compliance and secure operations.

Qualifications

• Bachelor's degree and 7–9 years of relevant experience.
• DoD contracting background, including PD2 legacy environments.
• CompTIA Security+ certification.
• Hands-on Appian administration or development with release management and GitLab.
• SQL, Oracle, PowerShell, Power BI, and VB.Net proficiency.
• Familiarity with FAR/DFARS/SOFARS compliance.
• Ability to travel as needed.

Responsibilities

• Administer and troubleshoot Contract Writing Systems (CWS), SPS/PD2, and related eBusiness platforms.
• Deploy and configure CWS packages across environments in a cloud Appian instance, including customization file imports and coordination with cloud platform administrators on release timing
• Build and modify Appian interfaces, process models, records, and expression rules to support CWS integration, following platform design standards
• Coordinate with the database administrator to keep Appian data connections and schema requirements aligned with the cloud RDS environment
• Manage version control and release packaging through GitLab, tagging and tracking Appian application versions across environments
• Support vulnerability triage and remediation tracking for Appian-related security findings
• Coordinate application-level updates alongside broader platform patches and version upgrades
• Monitor Appian performance through logs and health dashboards, tuning process execution and resolving application-level slowdowns
• Manage user accounts, system patches, and IA vulnerability remediation more broadly
• Build reports and dashboards using Cognos, SQL, and Power BI
• Support data integration with FPDS, SAM.gov, and other acquisition systems
• Ensure system changes comply with FAR/DFARS requirements
• Lead testing (UAT), documentation, and end-user training

Skills

DoD contracting background

CompTIA Security+ certification

Release management

Performance tuning

Education

Bachelor's degree

Tools

Appian

GitLab

SQL

Oracle

PowerShell

Power BI

VB.Net

Cognos

Job description

Key Responsibilities

• Administer and troubleshoot Contract Writing Systems (CWS), SPS/PD2, and related eBusiness platforms
• Deploy and configure CWS application packages across environments in a cloud-hosted Appian instance, including customization file imports and coordination with cloud platform administrators on release timing
• Build and modify Appian interfaces, process models, records, and expression rules to support CWS integration, following platform design standards
• Coordinate with the database administrator to keep Appian data connections and schema requirements aligned with the cloud RDS environment
• Manage version control and release packaging through GitLab, tagging and tracking Appian application versions across environments
• Support vulnerability triage and remediation tracking for Appian-related security findings
• Coordinate application-level updates alongside broader platform patches and version upgrades
• Monitor Appian performance through logs and health dashboards, tuning process execution and resolving application-level slowdowns
• Manage user accounts, system patches, and IA vulnerability remediation more broadly
• Build reports and dashboards using Cognos, SQL, and Power BI
• Support data integration with FPDS, SAM.gov, and other acquisition systems
• Ensure system changes comply with FAR/DFARS requirements
• Lead testing (UAT), documentation, and end-user training

Qualifications

• Bachelor's degree, 7 to 9 years of relevant experience
• CompTIA Security+ certification
• DoD contracting or acquisition systems background, including experience with legacy Standard Procurement System (PD2) environments
• Hands-on Appian administration or development experience, including release management, GitLab-based version control, and performance tuning (AoK certification a plus)
• Proficiency in SQL, Oracle, PowerShell, Power BI, and VB.Net
• Familiarity with FAR/DFARS/SOFARS compliance
• Ability to travel as needed