Senior Data Architect

Job Title: Data Architect – PostgreSQL / AWS Migration
Location: Irving, TX (Hybrid)
Duration: Long-Term Contract

Job Description:

We are seeking an experienced Data Architect with strong expertise in PostgreSQL, database architecture, data modeling, and AWS cloud migration. The ideal candidate will have hands-on experience migrating on-premise databases to AWS, optimizing database performance, and managing database sizing and capacity planning.

Key Responsibilities:

• Design conceptual, logical, and physical data models and database schemas.
• Lead/support PostgreSQL database migration from on-premise to AWS.
• Work with AWS DMS, SCT, RDS, and Aurora PostgreSQL.
• Perform data mapping, validation, reconciliation, and migration testing.
• Optimize SQL queries, indexing, partitioning, and database performance.
• Handle database sizing, capacity planning, scaling, and cloud optimization.
• Define migration strategies, cutover, rollback, RPO/RTO, HA, and DR requirements.
• Collaborate with application, infrastructure, and engineering teams.

Required Skills:

• Strong PostgreSQL, SQL, database architecture, and data modeling experience.
• Hands-on database migration and AWS cloud migration experience.
• Knowledge of AWS DMS, SCT, RDS, and Aurora PostgreSQL.
• Expertise in performance tuning, query optimization, and database sizing.
• Experience with data mapping, validation, reconciliation, and capacity planning.
• Understanding of high availability, disaster recovery, RPO, and RTO.

Preferred: Energy/Utilities industry experience, large enterprise databases, AWS S3, Glue, Redshift, Athena, Lambda, and data modeling tools such as ERwin or ER/Studio.

Pay: $70.00 - $95.00 per hour

Expected hours: 40.0 per week

Work Location: In person