Module Lead Data Engineer/gcp Module Lead Database Engineer @ Impetus Technologies

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:-

1. Out of the Box Thinking


2. Problem Solving Skills


3. Ability to make tech choices (build v/s buy)


4. Performance management (profiling, benchmarking, testing, fixing)


5. Enterprise Architecture


6. Project management/Delivery Capabilty/ Quality Mindset


7. Scope management


8. Plan (phasing, critical path, risk identification)


9. Schedule management / Estimations


10. Leadership skills


11. Other Soft Skills


12. Learning ability


13. Innovative / Initiative

• 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