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
- 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
Role:
Industry Type:
Department:
Employment Type: Full Time, Permanent
Role Category: Software Development
Education
UG: Any Graduate
PG: Any Postgraduate
Skills Required
Data Warehousing, Sql, Data Migration, Project Management, Stored Procedures, Disaster Recovery, Olap, Scheduling, Oracle, Performance Tuning