Amazon Web Services (AWS), Background Investigation, Consulting, Data Migration, Data Quality, Database Extract Transform and Load (ETL), Database Triggers, Functional Testing, Government, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Performance Testing, PostgreSQL, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Stored Procedures, United States Citizen, Validation Testing
Must-Have Screening Requirements:
- U.S. Citizen or Green Card (Permanent Resident) holder ONLY.
- No visa holders or temporary-status individuals.
- Must be willing to undergo fingerprinting and a government background check (CJIS-type).
- LinkedIn profile required; all resumes will be verified against LinkedIn.
Requirements:
- 3+ years of SQL development experience.
- Strong hands-on experience with:
- Microsoft SQL Server and T-SQL
- Stored Procedures, Functions, Triggers, and Views
- PostgreSQL and PL/pgSQL
- SQL Server to PostgreSQL code conversion and remediation
- Functional and performance testing of database objects
- Familiarity with:
- T-SQL to PostgreSQL dialect conversion (TOP/LIMIT, ISNULL/COALESCE, GETDATE()/NOW(), temp tables, identity vs. sequences)
- AWS Schema Conversion Tool (SCT) assessment reports and remediation
- Data validation and migration testing
- Experience supporting database modernization or migration projects.
Preferred:
- AWS DMS experience.
- SSIS/SSRS remediation or migration experience.
- AWS exposure and SQL Server to PostgreSQL migration experience.
- Familiarity with AWS Glue and ETL modernization concepts.