[Remote] Application Developer Consultant – Inline SQL Remediation (Senior) | Remote Contract Opportunity | Fastwater Staffing
Note: The job is a remote job and is open to candidates in USA. HIKINEX is seeking an experienced Application Developer Consultant – Inline SQL Remediation to support enterprise application modernization and database migration initiatives. The role involves refactoring embedded SQL within .NET applications and modernizing data access layers to facilitate migration from SQL Server to PostgreSQL.
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
Skills
- 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
- Experience with .NET Framework to .NET Core/.NET 8 modernization projects
- Experience with AWS services, including AWS Secrets Manager and AWS Systems Manager Parameter Store
- Experience supporting SQL Server to PostgreSQL migration initiatives
- Familiarity with transaction management and distributed system modernization
Company Overview