Module Lead Data Engineer/GCP Module Lead Database Engineer
Impetus Technologies- Posted 3 months ago
- Over 200 applicants have applied
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
- 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: Data Engineer
Industry Type: IT Services & Consulting
Department: Engineering - Software & QA
Employment Type: Full Time, Permanent
Role Category: Software Development
Education
UG: Any Graduate
PG: Any Postgraduate
More Info
Key Skills
About Company
Impetus designs and develops state-of-the-art products, spanning all leading-edge development platforms, for a host of fast-paced and innovative software companies. We offer product-oriented services, across the entire product development lifecycle, to our clients.
We keep very successful company-all our clients are leaders in their spaces. They range from some of the finest startups in the Silicon Valley, such as Scalix, KnowNow, Navic, Sennari, to well established players including NeuStar, 3M, LiveCapital and PeopleSoft. Leading blue-chip VCs like Sequoia, Kleiner Perkins, Redrock, and Venrock recommend us as the preferred offshore service provider for companies they are incubating.
Our sister companies, Servigistics, ClearTrail and Intellicus, and the intellectual property we create, have been phenomenally successful, setting innovative trends and establishing new markets.