.Net Programmer - Advanced -Exp in SQL Server / T-SQL-legacy or enterprise systems

1. 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

2. 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

3. 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

4. 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

5. 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)

6. Incremental Migration Strategy

• 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)

7. 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

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)