Senior CA Plex Application Developer (SQL Server / T-SQL) - REMOTE - W2 Only
Posted Today by Chandra Technologies, Inc.
Negotiable
Undetermined
Remote
Remote
Summary: The South Carolina Judicial Branch is seeking a Senior Application Developer with extensive experience in CA Plex and SQL Server to maintain and enhance its Case Management System and Juror Management System. This fully remote role requires the candidate to ensure operational stability and support integrations while working towards modernization efforts. The position demands a strong background in application development, troubleshooting, and data integrity management. The ideal candidate will collaborate with various stakeholders to translate business requirements into technical solutions.
Key Responsibilities:
- 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, workflows, batch processes, and reports
- Ensure all changes align with judicial policies and statutory requirements
- Update objects, functions, and relationships within the CA Plex development environment
- Regenerate and deploy application components
- Write and optimize SQL Server (T-SQL) queries, stored procedures, and data fixes
- Support data corrections and performance tuning for large datasets
- Maintain and support integrations with law enforcement and other systems
- Assist in adapting legacy I/O processes as APIs are introduced
- Support reporting needs by developing queries and extracts
- Collaborate with analytics teams to ensure data consistency
- Work closely with Court Administration and IT leadership
- Document system changes, business rules, and technical processes
- Assist in knowledge transfer to internal staff and modernization teams
Key Skills:
- Bachelor's degree in computer science, Information Systems, or related field (or equivalent experience)
- 15+ years of experience with application development
- 15+ years of experience in CA Plex or similar 4GL/model-driven environments
- 15+ years of experience with SQL Server / T-SQL
- 15+ years of experience debugging and problem-solving skills
- 15+ years of experience with API integrations (Rest, Windows Services, MicroServices, XML, Soap)
- 10+ years of experience maintaining legacy or enterprise systems
- 5+ years of experience in State court case management and jury management systems
- Experience in judicial, government, or public sector environments (preferred)
- Experience with data warehouse architecture, Power BI, and Azure DevOps (preferred)
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Job Description:
***Only W2 resumes are accepted
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.
The South Carolina Judicial Branch (SCJB) is seeking an experienced Senior Application Developer to support the ongoing maintenance, enhancement, and operational stability of its current Case Management System (CMS) and the Juror Management System (JMS) built on CA Plex.
This role is responsible for ensuring the continuity of mission-critical court operations by maintaining and extending existing functionality, supporting integrations with internal and external systems, and assisting with data quality and performance improvements.
The selected candidate will work in parallel with modernization efforts, ensuring the current platform remains secure, reliable, and responsive to evolving business needs until full transition to modern architecture is achieved.
Responsibilities:
- 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
- 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
- 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
- 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
- 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
- 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
- Collaboration & Stakeholder Support
- Work closely with:
- Court Administration
- IT leadership and development teams
- Translate business requirements into technical updates within the CMS
- 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:
- Bachelor s degree in computer science, Information Systems, or related field (or equivalent experience)
- 15+ years of experience with application development
- 15+ years of experience CA Plex or similar 4GL/model-driven environments
- 15+ years of experience SQL Server / T-SQL
- 15+ years of experience debugging and problem-solving skills
- 15+ years of experience with API integrations (Rest, Windows Services, MicroServices, XML, Soap)
- 10+ years of experience maintaining legacy or enterprise systems
- 5+ years of experience in State court case management and jury management systems
Preferred Education and/or Certifications:
- Generated languages (C++, Java, or .NET from Plex)
- Batch processing and transactional systems
- Data warehousing environments
- Case lifecycle (filed pending disposed)
- Court performance metrics (backlog, clearance rates)