Qualification

Job Description: We are looking for GCP Data Engineer and SQL Programmer with good working experience on PostgreSQL, & PL/SQL programming experience and following technical skills

• PL/SQL and PostgreSQL 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
  
  

Other Skills:-

• Out of the Box Thinking
• Problem Solving Skills
• Ability to make tech choices (build v/s buy)
• Performance management (profiling, benchmarking, testing, fixing)
• Enterprise Architecture
• Project management/Delivery Capabilty/ Quality Mindset
• Scope management
• Plan (phasing, critical path, risk identification)
• Schedule management / Estimations
• Leadership skills
• Other Soft Skills
• Learning ability
• Innovative / Initiative
  
  

Role

• 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
  
  

Experience

7 to 10 years

Job Reference Number

12779