Postgresql Developer

Exp- 5-10 years. (SSE/MLSE/LSE)

Job Description: We are looking for GCP AlloyDB Engineer or 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

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