Senior Application Developer Consultant — Inline SQL Remediation

HIKINEXDatabase Migration

Fully Remote (Maryland, U.S.)ContractSenior

Salary not disclosed

Apply NowOpens the employer's application page

Job Details

5+ years of full-stack .NET development experience with strong emphasis on data-access development
Extensive experience working with SQL Server-backed enterprise applications
Strong understanding of database migration impacts on application code
Hands-on experience migrating from ADO.NET and System.Data.SqlClient to Npgsql
Deep understanding of connection management, command execution, and parameter handling in .NET providers
Experience migrating Entity Framework 6 to Entity Framework Core
Experience utilizing Dapper and raw SQL execution patterns
Proven experience refactoring embedded T-SQL within application code
Strong understanding of SQL Server and PostgreSQL dialect differences
Experience updating connection strings, credential management, and database access configurations

Analyze and modify embedded/inline SQL across multiple .NET applications to ensure compatibility with Aurora PostgreSQL
Refactor data-access code and update database connectivity components to support PostgreSQL
Convert SQL Server-specific queries and logic to PostgreSQL-compatible syntax and functionality
Coordinate closely with both application modernization and database migration teams to ensure consistent implementation
Update connection handling, credential management, and database access configurations
Validate application functionality against migrated database environments
Troubleshoot query performance, compatibility issues, and data-access concerns throughout the migration process
Ensure application-layer SQL changes remain aligned with ongoing schema conversion efforts
Participate in testing activities across application and database boundaries
Document remediation decisions, conversion approaches, and technical findings

View Full Description & ApplyYou'll be redirected to the employer's site