Application Developer Consultant — Inline SQL Remediation (Senior) - Remote Contract Opportunity [ FastWater Staffing ]

📍 Location: Fully Remote (Maryland, U.S.)
📄 Employment Type: Contract
🚀 Start Date: Immediate
💲 Compensation: TBD — based on skills and experience

Important Screening Requirements

• Due to client and clearance requirements, candidates must be U.S. Citizens or U.S. Permanent Residents (Green Card holders) and able to work in the United States without current or future visa sponsorship.

• Undergo fingerprinting as part of the onboarding process.
• Successfully complete a government background investigation (CJIS-type clearance).

About the Role

We are seeking a Senior Application Developer Consultant specializing in Inline SQL Remediation to support a large-scale database migration initiative. This role serves as the critical bridge between the application modernization and database migration workstreams, ensuring that embedded SQL within .NET applications is successfully converted and optimized for Aurora PostgreSQL.

The consultant will work closely with both the .NET modernization team and the database migration team to ensure alignment across application code, database schemas, connection management, and query behavior.

Key Responsibilities

• 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

Note: TypeScript (.ts) inline SQL remediation is explicitly out of scope for this role.

Required Qualifications

Core Experience

• 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

Data Access & PostgreSQL Migration

• Hands-on experience migrating from:
  • ADO.NET
  • System.Data.SqlClient

To:

• Npgsql (PostgreSQL .NET Provider)
• Deep understanding of:
  • Connection management
  • Command execution
  • Parameter handling
  • Provider-specific behaviors

Entity Framework & ORM Experience

• Experience migrating:
  • Entity Framework 6 (EF6)
  • SQL Server Providers

To:

• Entity Framework Core
• Npgsql.EntityFrameworkCore.PostgreSQL
• Experience utilizing:
  • Dapper
  • Raw SQL execution patterns
  • ORM modernization approaches

SQL Remediation & Database Compatibility

• Proven experience refactoring embedded T-SQL within application code
• Strong understanding of SQL Server and PostgreSQL dialect differences, including:
  • Functions and expressions
  • Stored procedure interactions
  • Data type mappings
  • Query syntax adjustments
  • Transaction behaviors

Application & Database Integration

• Experience updating:
  • Connection strings
  • Credential management approaches
  • Database access configurations
• Ability to coordinate closely with database migration teams to ensure consistency between application and database changes

Additional Desired Experience

• Familiarity with .NET Core/.NET 8 modernization initiatives
• Understanding of application modernization activities occurring alongside database migrations
• Experience testing functionality across application and database layers
• Knowledge of transaction-handling differences between SQL Server and PostgreSQL
• Awareness of distributed transaction modernization and DTC-related considerations

Preferred Qualifications

• Prior experience supporting large-scale database migration remediation efforts
• Experience migrating applications from SQL Server to PostgreSQL
• Familiarity with AWS database services, particularly Aurora PostgreSQL
• Experience working within cloud modernization or application modernization programs
• AWS certifications or AWS platform experience are a plus

Ideal Candidate

The ideal candidate is a senior .NET developer with deep data-access expertise who understands both application architecture and database migration challenges. They can effectively bridge the gap between development and database teams, ensuring that application-layer SQL, database schemas, and modernization efforts remain aligned throughout the migration lifecycle.