| PostgreSQL Database Migration Specialist :: Onsite Role :: at Chicago, Illinois, USA |
| Email: [email protected] |
| From: Sridar, ITechUS [email protected] Reply to: [email protected] Hi, Title:: PostgreSQL Database Migration Specialist Location:: Chicago, IL :: Onsite Role :: Duration:: Contract Role Responsibilities- 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 Very strong expertise in PostgreSQL database 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. 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 Should have good understanding of Oracle PL/SQL databases like TABLES,VIEWS,PROCEDURES,FUNCTIONS,PACKAGES,INDEXES,TRIGGERS,MVs It is good to have GCP basic understanding and Cloud SQL knowledge Oracle to Postgres Migration experience (schema and data ) is required Eager to learn new concepts, functionalities and able to resolve issue independently Essential Skills: Database migration from Oracle to PostgreSQL strong expertise in PostgreSQL databasedata migration of large database to PostgreSQL Address PostgreSQL query / Stored procedures performance issuesOracle to Postgres Migration experience (schema and data ) is required Thanks, Sridar Guvvala 802-231-2644 iTech US, Inc. Keywords: information technology procedural language Illinois PostgreSQL Database Migration Specialist :: Onsite Role :: [email protected] |
| [email protected] View all |
| Wed Jul 03 19:47:00 UTC 2024 |