Data Architect

Key Responsibilities: 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.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).Migration Waves: Plan and run migration waves end-to-end: assessment, cutover, data validation and post-migration performance tuning. Target-State Data Architecture: Produce target-state data models, migration runbooks, architecture decision records (ADRs) and guidance for application teams. Security & Compliance: Ensure migrated databases meet security and compliance requirements, applying least-privilege IAM and AWS KMS encryption at rest and in transit. Automation: Use Python and Terraform to automate data processing, migration tasks and database infrastructure provisioning. Agile Delivery: Manage your own user stories in Jira within the sprint and collaborate closely with application, infrastructure and cloud engineering teams.

Required Qualifications: 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.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.Core AWS Data Stores: Hands-on experience (Level 300) with Amazon RDS, Aurora PostgreSQL, S3, IAM and KMS.Documentation: Ability to write clear target-state data models, migration runbooks and ADRs for technical and risk audiences. AWS Certification: Active AWS Certified Solutions Architect – Associate(required); Professional preferred.

Preferred Qualifications: Python: Python for data processing and migration automation. PL/SQL Conversion at Scale: Large-scale Oracle to PostgreSQL code conversion and heterogeneous migration experience. Oracle Database@AWS: Familiarity with ODB@AWS.Financial Services: Delivering financial services or other regulated enterprises, with awareness of PCI-DSS and SOC 2.Infrastructure as Code: Terraform(AWS CDK is not required).Agile / Jira: Comfortable managing your own user stories within a sprint (Level 200).Agentic AI Accelerators: Using Amazon Bedrock or agentic AI for data accelerators such as code analysis and conversion or data-domain tagging. This is a differentiator, not a requirement. DataLake & Lakehouse: Exposure to AWS Glue, Lake Formation, Athena and Amazon Redshift. Legacy Sources: Familiarity with Exadata, Sybase, DB2 or mainframe data sources. GenAI Developer Tools: Use of AI coding assistants such as Amazon Q Developer or Kiro. Consulting: Prior experience with AWS ProServe or in a consulting delivery role.