Senior Application Developer (Programmer – Consultant)Location: Columbia, SC 100% Remote (Must reside in Continental US & work EST hours) Duration: 12 Months (Extension Possible) Interview: 1 Round – Virtual Work Hours: 37.5 hours/week (On-call support required)Key ResponsibilitiesApplication Maintenance & SupportMaintain and support CA Plex-based CMS across multiple environmentsTroubleshoot production issues, defects, and data anomaliesPerform root cause analysis and implement long-term fixesProvide escalation/on-call support for critical issuesEnhancements & DevelopmentDesign and implement enhancements within CA Plex modelModify business rules, workflows, screens, batch jobs, and reportsEnsure compliance with judicial policies and statutory requirementsCA Plex DevelopmentUpdate objects, functions, and relationships within CA PlexRegenerate and deploy application componentsMaintain model-driven architecture integrityDatabase & Data ManagementWrite and optimize SQL Server / T-SQL queries and stored proceduresPerform data corrections and ensure data integrityTune performance for large-scale datasets (millions of records)System IntegrationsSupport integrations with external systems such as:Law enforcement systems (e.g., SLED)DMV eDispositioneCitation systemseFiling & Public Index platformsAssist in transitioning legacy I/O processes to APIsReporting & Data SupportDevelop data extracts and reporting queriesSupport data warehouse feeds and analytics teamsEnsure data consistency across systemsCollaboration & DocumentationWork with court administration, IT teams, and stakeholdersTranslate business requirements into technical solutionsDocument system changes, processes, and business rulesSupport knowledge transfer initiativesRequired Skills & Experience10+ years of experience in Application Development7+ years of experience with SQL Server / T-SQL7+ years of experience maintaining legacy or enterprise systems10+ years of experience in debugging and problem-solving7+ years of experience with CA Plex or similar 4GL/model-driven environmentsStrong experience with production support, troubleshooting, and performance tuningPreferred SkillsExperience in government or judicial systems (especially court systems)Experience with generated languages (C++, Java, or.NET from Plex)Knowledge of batch processing and transactional systemsExperience with API integrationsExposure to data warehousing environments (star/snowflake schemas)Understanding of case lifecycle (filed ? pending ? disposed)Familiarity with court performance metrics (backlog, clearance rates)Experience with tools/technologies such as:Power BI (backend optimization)Azure DevOpsSQL Always On Availability GroupsSecurity tools like ImpervaEducationBachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience)About Us:InterSources Inc.
is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.