About The Position
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.
Requirements
- 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 ADO.NET and System.Data.SqlClient to Npgsql (.NET Provider for PostgreSQL)
- Deep understanding of connection management, command execution, parameter handling, and provider-specific behaviors
- Experience migrating Entity Framework 6 (EF6) and SQL Server Providers to Entity Framework Core with Npgsql.EntityFrameworkCore.PostgreSQL
- Experience utilizing Dapper and raw SQL execution patterns
- Experience with ORM modernization approaches
- 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, and transaction behaviors
- Experience updating connection strings, credential management approaches, and database access configurations
- Ability to coordinate closely with database migration teams to ensure consistency between application and database changes
- 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.
- Must undergo fingerprinting as part of the onboarding process.
- Must successfully complete a government background investigation (CJIS-type clearance).
Nice To Haves
- 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
- 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
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
Benefits
- Compensation based on skills and experience
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
