Microsoft .NET / SQL Server Developer

Our government client is looking for experienced Microsoft .NET / SQL Server Developer on an onsite 12 months renewable contract opportunity in Columbia, SC.

Role: Microsoft .NET / SQL Server Developer

Scope Of The Project

The agency is seeking a highly skilled Application Developer to support the transformation of its legacy Case Management System (CMS), currently built on CA Plex, into a modern, scalable, and maintainable .NET (C#) architecture. This role will support the progressive migration of business logic, data access layers, and system interfaces from a model-driven 4GL environment into standards-based, service-oriented architecture including the development of RESTful APIs to support internal and external integrations (e.g., SLED, DMV, eCitation, Public Index, and partner agencies).

The ideal candidate combines deep legacy system understanding, modern software engineering expertise, and enterprise integration experience within a high-availability, data-sensitive environment.

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 languag

Responsibilities 2. Application Modernization (Core Responsibility) 3. API Development & Integration 4. Data Layer Transformation 5. Azure DevOps & Development Standards 6. Incremental Migration Strategy 7. Stakeholder Collaboration Required Skills and/or Education: Preferred Education and/or Certifications:

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

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

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
• 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
• 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)
• Support a phased modernization approach, including:
• Strangler Fig pattern (wrapping legacy functionality with APIs)
• Parallel run strategies
• Risk mitigation for court operations
• Collaborate with stakeholders to prioritize modules (e.g., case initiation, dispositions, warrants)
• Work closely with:
• Judges, clerks, and court administration
• IT leadership and development teams
• External vendors and partner agencies
• Translate business needs into technical solutions
• 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
• 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)
  

About Vector

Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY

www.vectorconsulting.com

“Celebrating 30 years of service.”