| Technical Postgres SME - Chicago, IL (Onsite) Only CST or EST - Contract at Chicago, Illinois, USA |
| Email: [email protected] |
| From: Divya Sai, iTech US Inc [email protected] Reply to: [email protected] Hello This is Divya Sai from iTech US, we have an urgent Job opening from one our client, please go through below JD if you are interested, please share me your updated resume. Role: Technical Postgres SME Location: Chicago, IL (Onsite) Only CST or EST Type : Contract Description: Technical 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,MVs6) It is good to have GCP basic understanding and Cloud SQL knowledge 7) Oracle to Postgres Migration experience (schema and data ) is required8) Eager to learn new concepts, functionalities and able to be resolved issue independently Competencies: PostgreSQL, PL/SQL, Data Migration, Oracle Database 12C Administration Experience (Years): 6-8 Essential Skills: Postgres developer Query Performance Tuning Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning Oracle PL/SQL databases like TABLES,VIEWS,PROCEDURES,FUNCTIONS,PACKAGES,INDEXES,TRIGGERS,MVs* Have done data migration activities from Oracle On-prem to Postgres SQL onprem/cloud Desirable Skills: GCP basic understanding and Cloud SQL knowledge Eager to learn new concepts, functionalities and Able to resolved issue independently Keywords: Cloud Migration, PostgreSQL Query Optimization, data migration Thanks & Regards Divya Sai Chandu iTech US Inc, Email:[email protected] Ph:18028510921 Ext:308 Keywords: information technology golang procedural language Illinois Technical Postgres SME - Chicago, IL (Onsite) Only CST or EST - Contract [email protected] |
| [email protected] View all |
| Thu Jul 18 19:23:00 UTC 2024 |