Senior Application Developer Consultant – Inline SQL Remediation

Responsibilities

• Develop and maintain enterprise applications using C# and .NET technologies.
• Refactor embedded and inline SQL within application code to support PostgreSQL compatibility.
• Modernize data access layers using ADO.NET, Entity Framework, and Dapper.
• Migrate SQL Server-based applications and database integrations to PostgreSQL.
• Convert T-SQL queries and database logic to PostgreSQL-compatible syntax.
• Update connection strings, credentials, and database access configurations.
• Perform application testing, debugging, and performance optimization throughout migration efforts.
• Collaborate with cross-functional teams to deliver scalable, secure, and high-quality application modernization solutions.

Requirements

• 5+ years of full-stack .NET development experience.
• Strong hands-on experience with:
• C# and .NET application development
• ADO.NET / System.Data.SqlClient and Npgsql
• Entity Framework (EF6 and EF Core)
• Dapper and data access layer development
• SQL Server and PostgreSQL database integration
• Refactoring embedded and inline SQL within application code
• Experience migrating or converting:
• SQL Server-based applications to PostgreSQL
• Connection strings, credentials, and database access layers
• T-SQL queries to PostgreSQL-compatible syntax
• Strong understanding of application-to-database interactions, testing, troubleshooting, and performance optimization.

Core Competencies

Demonstrates extensive experience in full-stack .NET development, particularly with C# and .NET technologies, while effectively modernizing data access layers and migrating SQL Server applications to PostgreSQL. Proficient in application testing, debugging, and performance optimization to ensure high-quality software delivery.