Data Migration Consultant

Ascii Group, LLC
Houston, TX, United States
3 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Compensation
$166,400
Working hours
Regular working hours
Job source

Tech stack

Application Programming Interfaces (APIs) Amazon Web Services Amazon S3 Databases Continuous Integration Data Architecture Data Migration Relational Databases PostgreSQL Microsoft SQL Server MySQL SQL Stored Procedures
+5 more
Indexer Transactional Database Terraform Domain Driven Design Databricks

Requirements

Looking for a principal-level ETRM Data Lead / Principal Data Migration Consultant with 10+ years of experience across SQL Server & PostgreSQL, Amazon Aurora PostgreSQL, AWS DMS & Schema Conversion (SCT), CDC Pipelines, Data Modeling, and Energy/ETRM domains for a Long-Term /opportunity (Hybrid) in Houston, TX!

*Note: Strictly W2 Candidates Only (No C2C / No Third-Party Vendors). Applicants must be legally authorized to work in the US without immigration sponsorship, now or in the future. Must be local to Houston, TX 77079 (Hybrid) and available to attend a mandatory in-person Face-to-Face interview for the final round., Core Experience: 10+ years of hands-on experience in enterprise data engineering, transactional database modernization, and complex relational data modeling. Database & AWS Migration Stack: Deep mastery of SQL Server, PostgreSQL, Amazon Aurora PostgreSQL/MySQL, AWS DMS, AWS Schema Conversion Tool (SCT), and CDC pipelines (bulk loads, LOB migrations, cutover/rollback plans). Performance & Schema Engineering: Proven track record resolving stored procedure conversions, data type incompatibilities, CDC latency, indexing, execution plans, locking, and concurrency tuning. Data Modeling & Architecture: Advanced conceptual, logical, and physical data modeling skills alongside domain-driven data architecture, data contracts, and API/event-driven downstream patterns. Domain & Preferred Stack: Experience in Energy / Oil & Gas Midstream / ETRM or financial trading environments; exposure to Databricks, Amazon S3 lakehouse patterns, Terraform, and database CI/CD is a strong plus. Logistics & Authorization: Must be authorized to work in the US on W2 without sponsorship, local to Houston, TX 77079, and able to attend an in-person Face-to-Face final interview.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…