Senior SQL Developer with CA Plex

Responsibilities:

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

Feature Enhancements & Business Logic Updates

• Design, develop, and implement enhancements within the CA Plex model
• Modify existing:
  • Business rules
  • Screens and workflows
  • Batch processes and reports
• Ensure all changes align with judicial policies and statutory requirements

CA Plex Model Development

• Work directly within the CA Plex development environment to:
  • Update objects, functions, and relationships
  • Regenerate and deploy application components
• Maintain integrity of the model-driven architecture as the system evolves

Database & Data Integrity Management

• Write and optimize SQL Server (T-SQL) queries, stored procedures, and data fixes
• Support:
  • Data corrections (e.g., invalid dates, missing relationships)
  • Performance tuning for large datasets (millions of records)
• Ensure data accuracy across integrated systems

System Integration Support

• Maintain and support integrations with:
  • Law enforcement (e.g., SLED)
  • DMV eDisposition
  • eCitation systems
  • Public Index and eFiling platforms
• Assist in adapting legacy I/O processes as APIs are introduced

Reporting & Data Support

• Support reporting needs by:
  • Developing queries and extracts
  • Assisting with data feeds into the Data Warehouse
• Collaborate with analytics teams to ensure data consistency

Collaboration & Stakeholder Support

• Work closely with:
  • Court Administration
  • IT leadership and development teams
• Translate business requirements into technical updates within the CMS

Documentation & Knowledge Transfer

• Document:
  • System changes
  • Business rules
  • Technical processes
• Assist in knowledge transfer to internal staff and modernization teams

Preferred/Nice to Have Skills:

• Experience in judicial, government, or public sector environments
• Experience with:
  • Data warehouse architecture (star/snowflake schema)
  • Power BI backend optimization
  • .NET application data access patterns
  • Always On Availability Groups
  • Azure DevOps
• Familiarity with Imperva or similar security appliances
• Experience cleaning legacy data structures across multiple counties or jurisdictions

Required Education and/or Certifications:

• Bachelor s degree in computer science, Information Systems, or related field (or equivalent experience)
• 10+ years of experience with application development
• 7+ years of experience CA Plex or similar 4GL/model-driven environments
• 7+ years of experience SQL Server / T-SQL
• 7+ years of experience maintaining legacy or enterprise systems
• 10+ years of experience debugging and problem-solving skills