Senior Data Architect

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., * 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.

• 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.