Required Skills

Postgres DBA

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 16th Jul 2024

JOB DETAIL

who has worked in Database migration from Oracle to PostgreSQL. 
Should have a thorough understanding of schema and data migration of large database to PostgreSQL2) Very strong expertise in PostgreSQL database
3) Very strong expertise and hands-on experience in understanding and rewriting SQL queries, migrating packages, migrating stored procedures and optimizing the same. 
Should be able to identify and recommend solution on PostgreSQL query / Stored procedures performance issues. 
4) Strong hands-on experience in performance tuning - Constraints creations, Indexes creation & analysis, VACUUM,AUTOVCUUM parameter setup & enabling, explain plan analysis, Server side parameter setup, SQL query re-writing, bloating monitoring 6) Should have good understanding of Oracle PL/SQL databases like TABLES,VIEWS,PROCEDURES,FUNCTIONS,PACKAGES,INDEXES,TRIGGERS,MVs
6) It is good to have GCP basic understanding and Cloud SQL knowledge
7) Oracle to Posgres Migration experience (schema and data ) is required
8) Eager to learn new concepts, functionalities and able to resolved issue independently
 

Company Information