Sr. Data Engineer (Alloydb, CloudSQL, GCP)
Sr. Data Engineer (Alloydb, CloudSQL, GCP)
Austin, TX
Long Term Contract
Job Description:
We are looking for GCP Data Engineer and PostgreSQL Programmer with good working experience on primarily PostgreSQL & some experience on PL/SQL programming and following technical skills.
• PostgreSQL & PL/SQL programming – Ability to write complex SQL Queries, Stored Procedures.
• Migration – Working experience in migrating Database structure and data from Oracle to Postgres SQL preferably on GCP Alloy DB or Cloud SQL.
• Working experience on Cloud SQL/Alloy DB.
• Working experience to tune autovacuum in postgresql.
• Working experience on tuning Alloy DB / PostgreSQL for better performance.
• Working experience on Big Query, Fire Store, Memory Store, Spanner and bare metal setup for PostgreSQL
• Ability to tune the Alloy DB / Cloud SQL database for better performance.
• Experience on GCP Data migration service.
• Working experience on MongoDB.
• Working experience on Cloud Dataflow.
• Working experience on Database Disaster Recovery.
• Working experience on Database Job scheduling.
• Working experience on Database logging techniques.
• Knowledge of OLTP And OLAP.
• Desirable: GCP Database Engineer Certification.
Roles & Responsibilities:
• Develop, construct, test, and maintain data architectures.
• Migrate Enterprise Oracle database from On Prem to GCP cloud autovacuum in postgresql.
• Ability to tune autovacuum in postgresql.
• Working on tuning Alloy DB / PostgreSQL for better performance.
• Performance Tuning of PostgreSQL stored procedure code and queries.
• Converting Oracle stored procedure & queries to PostgreSQL stored procedures & Queries.
• Creating Hybrid data store with Datawarehouse and No SQL GCP solutions along with PostgreSQL.
• Migrate Oracle Table data from Oracle to Alloy DB.
• Leading the database team.
