.Net/SQL Server Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Innosoul inc, is seeking the following. Apply via Dice today!

Job ID: SC-10332

Onsite/Local .Net/SQL Server Developer with T-SQL, legacy maintenance/Modernization, CA Plex/C /Java, Batch, API, DW, Power BI/DAX, JWT/OAuth2/RBAC, Entity/Dapper, Azure DevOps, CI/CD, Git, court/judicial system experience

Location: Columbia, SC (SCCOURTS)

Duration: 12 Months

Candidate location: Candidate MUST be a SC resident. No relocation allowed.

Required Skills and/or Education:

Bachelor s degree in computer science, Information Systems, or related field (or equivalent experience)

3 years of experience with application development

3 years of experience with SQL Server / T-SQL

3 years of experience with maintaining legacy or enterprise systems

3 years of experience with debugging

Preferred Education and/or Certifications:

Experience in South Carolina court/judicial systems or other government environments

CA Plex or similar 4GL/model-driven 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)

Job Description:

Please list any additional details: Job Duties

This role will also develop, build and maintain other .NET applications built around our data warehouse for use by judges, clerks, attorneys, and other users.

Build, support and maintain Power BI reports using DAX language.

Responsibilities:

• Legacy System Analysis & Reverse Engineering
  
  

Analyze and interpret CA Plex models, generated code (C /Java/.NET), and underlying database structures

Identify and document:

• Business rules
• Data flows
• System dependencies
  
  

Translate model-driven logic into clear, maintainable .NET equivalents

• Application Modernization (Core Responsibility)
  
  

Design and develop .NET (C#) applications to replace or augment CA Plex-generated components

Refactor legacy logic into:

• Layered architecture (API, Services, Data Access)
• Domain-driven or modular design patterns
  
  

Ensure backward compatibility where required during phased migration

• API Development & Integration
  
  

Design and implement RESTful APIs to replace legacy I/O interfaces

Enable secure integrations with:

• Law enforcement systems
• State agencies (e.g., SLED, DMV)
• Public-facing systems (eFiling, Public Index)
  
  

Implement:

• Authentication/Authorization (JWT, OAuth2, RBAC)
• API versioning and governance
• Logging, monitoring, and throttling
• Data Layer Transformation
  
  

Modernize data access patterns using:

• Entity Framework / Dapper
• Stored procedures where appropriate
  
  

Support integration with:

• Existing SQL Server environments (multi-database CMS architecture)
• Data Warehouse / reporting pipelines
  
  

Ensure data integrity, auditability, and performance optimization

• Azure DevOps & Development Standards
  
  

Transition development workflows into:

• Visual Studio / Git-based source control
• CI/CD pipelines (Azure DevOps or similar)
  
  

Establish coding standards, documentation practices, and testing strategies

Support automated testing (unit, integration)

• Incremental Migration Strategy
  
  

Support a phased modernization approach, including:

• Strangler Fig pattern (wrapping legacy functionality with APIs)
• Parallel run strategies
  
  

of Risk mitigation for court operations

Collaborate with stakeholders to prioritize modules (e.g., case initiation, dispositions, warrants)

• Stakeholder Collaboration
  
  

Work closely with:

• Judges, clerks, and court administration
• IT leadership and development teams
• External vendors and partner agencies
  
  

Translate business needs into technical solutions