Upwork
Data Architect contractor
Upwork, Chicago, Illinois, United States, 60290
Job Description
● Facilitate, guide, and influence the client and teams towards an effective architectural pattern and becoming an interface between business leadership, technology leadership, and the delivery teams.
● Perform Migration Assessments and Produce Migration Plans that include:
Total Cost of Ownership (TCO)
Migration Architecture
Migration Timelines
Application Waves
● Designing of solution architecture on Google Cloud to support critical workloads:
Heterogeneous Oracle Migrations to Postgres or Spanner
● Design a migration path that accounts for the conversion of:
Application Dependencies
Database objects
Data
Data Pipelines
Orchestration
Users and Security
● Oversee migration activities and provide troubleshooting support including:
Translation of DDL and DML
Executing data transfers using native Google Cloud and 3rd party tools
Setup and configuration of relevant Google Cloud components
● Engage with customer teams as a Google Cloud expert to provide:
Education Workshops
Architectural Recommendations
Technology reviews and recommendations
Qualifications:
5+ years of experience with data engineering, cloud architecture, or working with data infrastructure.
5+ years of Oracle database management and IT experience.
Experience with Oracle Database adjacent products like Golden Gate and Data Guard.
3+ years of PostgreSQL experience.
Proven experience in performing performance testing and applying remediations to address performance issues.
Experience in designing data models.
Proficiency in Python programming language and SQL.
Advanced SQL skills, including the ability to write, tune, and interpret SQL queries; tool-specific experience in the database platforms listed above is ideal.
Proven experience in migrating and/or implementing cloud databases like Cloud SQL, Spanner, and Bigtable.
Additional Information:
Duration: 10 weeks (40 hrs/wk)
Google Cloud Professional Architect and/or Data Engineer Certification is preferred.
#J-18808-Ljbffr
● Facilitate, guide, and influence the client and teams towards an effective architectural pattern and becoming an interface between business leadership, technology leadership, and the delivery teams.
● Perform Migration Assessments and Produce Migration Plans that include:
Total Cost of Ownership (TCO)
Migration Architecture
Migration Timelines
Application Waves
● Designing of solution architecture on Google Cloud to support critical workloads:
Heterogeneous Oracle Migrations to Postgres or Spanner
● Design a migration path that accounts for the conversion of:
Application Dependencies
Database objects
Data
Data Pipelines
Orchestration
Users and Security
● Oversee migration activities and provide troubleshooting support including:
Translation of DDL and DML
Executing data transfers using native Google Cloud and 3rd party tools
Setup and configuration of relevant Google Cloud components
● Engage with customer teams as a Google Cloud expert to provide:
Education Workshops
Architectural Recommendations
Technology reviews and recommendations
Qualifications:
5+ years of experience with data engineering, cloud architecture, or working with data infrastructure.
5+ years of Oracle database management and IT experience.
Experience with Oracle Database adjacent products like Golden Gate and Data Guard.
3+ years of PostgreSQL experience.
Proven experience in performing performance testing and applying remediations to address performance issues.
Experience in designing data models.
Proficiency in Python programming language and SQL.
Advanced SQL skills, including the ability to write, tune, and interpret SQL queries; tool-specific experience in the database platforms listed above is ideal.
Proven experience in migrating and/or implementing cloud databases like Cloud SQL, Spanner, and Bigtable.
Additional Information:
Duration: 10 weeks (40 hrs/wk)
Google Cloud Professional Architect and/or Data Engineer Certification is preferred.
#J-18808-Ljbffr