> Markdown version of [/jobs/ext/4671931-data-architect](https://www.wearedevelopers.com/jobs/ext/4671931-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Architect

- **Company:** Streetid Technologies, Inc.
- **Location:** United, WV, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, Amazon S3, JIRA, Cloud Engineering, Databases, Data Architecture, Data Validation, Relational Databases, Identity and Access Management, Python (Programming Language), Key Management, PostgreSQL, Microsoft SQL Server, Operational Databases, Oracle Databases, Oracle (Applications), Performance Tuning, Standard Sql, PL-SQL, Data Processing, Sql Optimization, Database Migration, Amazon Relational Database Service, AWS Data Analytics, Terraform, Code Restructuring
- **Published:** November 11, 2026
- **Apply:** https://www.thejobnetwork.com/job/070c1115-c387-48ec-9b90-20afd8b56bbc/data-architect

## About the Role

We are seeking a Senior Data Architect to join our AWS practice and work embedded with AWS Professional Services (ProServe) teams, modernizing a large, legacy relational database estate on AWS for a major financial services institution. You will lead the migration and modernization of complex Oracle, SQL Server and PostgreSQL workloads to AWS, primarily to Amazon Aurora PostgreSQL and, where applicable, Oracle Database@AWS (ODB@AWS), covering schema and PL/SQL conversion, migration waves, cutover and validation. The ideal candidateis a hands-on database expert with deep relational and SQL skills, a proven record of production database migrations to AWS, and the ability to guide application teams through target-state design., * Relational Databases: Expert-level (Level 400), hands-on experience with at least two of Oracle,SQL Server and PostgreSQL, with advanced SQL and PL/SQL.
\n

 * Database Migration to AWS: Proven delivery (Level 300-400) migrating production databases to Aurora PostgreSQL and/or Amazon RDS using AWS DMS and AWS SCT.
\n

 * Core AWS Data Stores: Hands-on experience (Level 300) with Amazon RDS, Aurora PostgreSQL, S3, IAM and KMS.
\n

 * Documentation: Ability to write clear target-state data models, migration runbooks and ADRs for technical and risk audiences.
\n

 * AWS Certification: Active AWS Certified Solutions Architect - Associate(required); Professional preferred.
\n, * Consulting: Prior experience with AWS ProServe or in a consulting delivery role.

## Description

n
\n

 * Database Migration Design & Execution: Design and execute migrations of relational databases (Oracle, SQL Server, PostgreSQL) to AWS, including Aurora PostgreSQL, Amazon RDS and Oracle Database@AWS.
\n

 * Schema & Code Conversion: Perform schema and PL/SQL conversion and refactoring, including heterogeneous Oracle to PostgreSQL migrations, using AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).
\n

 * Migration Waves: Plan and run migration waves end-to-end: assessment, cutover, data validation and post-migration performance tuning.
\n

 * Target-State Data Architecture: Produce target-state data models, migration runbooks, architecture decision records (ADRs) and guidance for application teams.
\n

 * Security & Compliance: Ensure migrated databases meet security and compliance requirements, applying least-privilege IAM and AWS KMS encryption at rest and in transit.
\n

 * Automation: Use Python and Terraform to automate data processing, migration tasks and database infrastructure provisioning.
\n

 * Agile Delivery: Manage your own user stories in Jira within the sprint and collaborate closely with application, infrastructure and cloud engineering teams.
\n