Programmer Consultant

Columbia, IN - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

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

2. Feature Enhancements & Business Logic Updates

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

3. CA Plex Model Development

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

4. Database & Data Integrity Management

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

5. System Integration Support

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

6. Reporting & Data Support

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

7. Collaboration & Stakeholder Support

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

8. Documentation & Knowledge Transfer

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

Preferred/Nice to Have Skills:

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

Required Education and/or Certifications:

Bachelors 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

Preferred Education and/or Certifications:

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

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 ...