Design And Development Consultant (Jobs in Columbia, SC)   Requirement id 158406 Job title Consultant Job location in Columbia, SC Skills required CA PLEX, Case Management, MS SQL Database, Design And Development Open Date 08-Jun-2026 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Consultant: CA PLEX, Case Management, MS SQL Database, Design And Development Start date :7/3/2026 End Date :12 Months from projected start date Submission deadline : 6/15 at 5:00 PM EST. Client Info : SC COURTS Note: * Interview Process: 1 round, virtual * Possibility for Extension: Yes * Work Location: Role is 100% remote Description: We are 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. Job Duties: 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: o Business rules o Screens and workflows o 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: o Update objects, functions, and relationships o 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: o Data corrections (e.g., invalid dates, missing relationships) o Performance tuning for large datasets (millions of records) • Ensure data accuracy across integrated systems 5. System Integration Support • Maintain and support integrations with: o Law enforcement (e.g., SLED) o DMV eDisposition o eCitation systems o Public Index and eFiling platforms • Assist in adapting legacy I/O processes as APIs are introduced 6. Reporting & Data Support • Support reporting needs by: o Developing queries and extracts o Assisting with data feeds into the Data Warehouse • Collaborate with analytics teams to ensure data consistency 7. Collaboration & Stakeholder Support • Work closely with: o Court Administration o IT leadership and development teams • Translate business requirements into technical updates within the CMS 8. Documentation & Knowledge Transfer • Document: o System changes o Business rules o Technical processes • Assist in knowledge transfer to internal staff and modernization teams Required Skills, Education and/or Certifications: • Bachelors degree in computer science, Information Systems, or related field (or equivalent experience) • 15+ years of CA Plex development experience • 15+ years of experience working with Judicial Case Management Systems • 15+ years working with MS SQL Database • 10+ years developing Data Interfaces exchanging court data with outside agencies • 10+ years of experience deploying and installing applications in   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 158406 while calling.   Other jobs in SC: Beaufort (1), Blythewod (2), Blythewood (3), Charleston (17), Columbia (37), Greenville (4), Hartsville (2), North Charleston (2), Overland Park (1), San Francisco (1), SENECA (4), South Carolina (1), Spartanburg (3), Unknown (2), CA PLEX job openings in Columbia, SC Jobs List SOFTWARE ARCHITECT- CONSULTANT - 10856-1 Create date: 07-Jun-2023 start date :7/1/2023 End date :1+ YEARS submission deadline : 6/14/2023 client info : Judicial Department Note: * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? * Phone interview or teams * SCHEDULE INTERVIEW: How soon can you schedule.... (This job is for - SQL Server 2005 Jobs in SC COLUMBIA Architect - (in Columbia, SC)) SOFTWARE ARCHITECT- CONSULTANT - 10389-1 Create date: 25-May-2022 start date:6/6/2022 submission deadline:5/31/2022 client info : Judicial Department Note: * Q INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? * A Phone interview Description: • UNDER LIM.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) DATA/INFORMATION ARCHITECT - 9395-1 Create date: 12-Jun-2020 Start Date :06/29/2020 Submission Deadline :06/19/2020 Client Info : Judicial Department Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? Phone interview * SCHEDULE INTERVIEW: How soon can you schedule an interview (date / tim.... (This job is for - job Jobs in SC COLUMBIA Architect - (in Columbia, SC)) DATA/INFORMATION ARCHITECT - 9338-1 Create date: 27-May-2020 Start Date :06/15/2020 Submission Deadline :06/03/2020 Client Info : Judicial Department Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? Phone interview * SCHEDULE INTERVIEW: How soon can you schedule an interview (date / times)? <.... (This job is for - job Jobs in SC COLUMBIA Architect - (in Columbia, SC))         (Consultant: CA PLEX, Case Management, MS SQL Database, Design And Development in Columbia, SC)

Featured Jobs Design Consultant (Jobs in Columbia, South Carolina) Aura JAVA Analyst (Jobs in Lansing, Michigan) ASP.Net Visual Developer (Jobs in Madison, Wisconsin) Java/J2EE SQL Developer (Jobs in Madison, Wisconsin) CICD Consultant (Jobs in Jackson, Mississippi) VPN Consultant (Jobs in Jackson, Mississippi) Agile Troubleshooting System Analyst (Jobs in Madison, Wisconsin) Documentation Architect (Jobs in Madison, Wisconsin) Python BASH Architect (Jobs in Columbia, South Carolina) - Consultant (Jobs in Columbia, South Carolina)