Job Details

Work Location: Role is 100% remote.

Candidate location: No SC residency required. Candidate must reside in lower 48 states (Continental US) and comfortable working EST time zone hours.

Responsibilities:

1. Application Maintenance & Support

• Maintain and support the CA Plex-based CMS across multiple environments
• Troubleshoot and resolve production issues, defects, and data anomalies
• Perform root cause analysis and implement sustainable fixes
• Provide on-call or escalation support for critical system issues

• Design, develop, and implement enhancements within the CA Plex model
• Modify existing:
  • Business rules
  • Screens and workflows
  • Batch processes and reports
• Ensure all changes align with judicial policies and statutory requirements

• Work directly within the CA Plex development environment to:
  • Update objects, functions, and relationships
  • Regenerate and deploy application components
• Maintain integrity of the model-driven architecture as the system evolves

• Write and optimize SQL Server (T-SQL) queries, stored procedures, and data fixes
• Support:
  • Data corrections (e.g., invalid dates, missing relationships)
  • Performance tuning for large datasets (millions of records)
• Ensure data accuracy across integrated systems

• Maintain and support integrations with:
  • Law enforcement (e.g., SLED)
  • DMV eDisposition
  • eCitation systems
  • Public Index and eFiling platforms
• Assist in adapting legacy I/O processes as APIs are introduced

• Support reporting needs by:
  • Developing queries and extracts
  • Assisting with data feeds into the Data Warehouse
• Collaborate with analytics teams to ensure data consistency

• Work closely with:
  • Court Administration
  • IT leadership and development teams
• Translate business requirements into technical updates within the CMS

• Document:
  • System changes
  • Business rules
  • Technical processes
• Assist in knowledge transfer to internal staff and modernization teams

• Experience in judicial, government, or public sector environments
• Experience with:
  • Data warehouse architecture (star/snowflake schema)
  • Power BI backend optimization
  • .NET application data access patterns
  • Always On Availability Groups
  • Azure DevOps
• Familiarity with Imperva or similar security appliances
• Experience cleaning legacy data structures across multiple counties or jurisdictions

• Bachelor's degree in computer science, Information Systems, or related field (or equivalent experience)
• 10+ years of experience with application development
• 7+ years of experience CA Plex or similar 4GL/model-driven environments
• 7+ years of experience SQL Server / T-SQL
• 7+ years of experience maintaining legacy or enterprise systems
• 10+ years of experience debugging and problem-solving skills

• Experience in South Carolina court/judicial systems or other government environments
• Generated languages (C++, Java, or .NET from Plex)
• Batch processing and transactional systems
• API integrations
• Data warehousing environments
• Case lifecycle (filed → pending → disposed)
• Court performance metrics (backlog, clearance rates)