Data Architect contractor - Upwork
Chicago, IL
About the Job
Upwork has partnered with an Enterprise client that specializes in helping businesses across all industries modernize through cloud adoption to achieve data-driven transformation. Their team of experts leverages the latest Google Cloud technologies and best practices to create customized solutions for each client.
They are currently looking to partner with a Data Architect contractor for a 2.5-month remote assignment with the potential to extend.
Interested candidates should have the following required skills and the ability to work independently as well as within a team environment.
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
- Heterogenous 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 relative Google Cloud components
● Engage with customer teams as a Google Cloud expert to provide:
- Education Workshops
- Architectural Recommendations
- Technology reviews and recommendations
- 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