| Postgres SME at Chicago, Illinois, USA |
| Email: [email protected] |
| From: Pradeep, Scalable Systems [email protected] Reply to: [email protected] Hi, Greetings of the day! I have an urgent requirement below, please go through JD and let me know if you are comfortable or have any profile. Kindly revert me back with your updated resume as well. Job Title: Postgres SME Location: Chicago, IL (Work from Office) Duration: Long Term Contract Key Responsibilities: 1) Postgres SME who has worked in Database migration from Oracle to PostgreSQL. Should have a thorough understanding of schema and data migration of large database to PostgreSQL 2) 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 5) 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 Thanks & Regards, Pradeep Sharma Email: [email protected] Keywords: information technology golang procedural language Illinois Postgres SME [email protected] |
| [email protected] View all |
| Fri Jul 05 15:39:00 UTC 2024 |