| Onsite Postgres SME at Remote, Remote, USA |
| Email: [email protected] |
| From: Shubham Choudhary, Quantum World Technologies [email protected] Reply to: [email protected] Job Title : Postgres SME Location : Onsite (Chicago, IL) Interview : Phone/Video Job 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 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 resolved issue independently 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 PostgresSQL onprem/cloud Desirable Skills : GCP basic understanding and Cloud SQL knowledge Eager to learn new concepts, functionalities and Able to resolved issue independently Unfeigned Regards, Shubham Chaudhary Technical Recruiter [email protected] Quantum World Technologies Inc. 4281 Katella Ave, Suite #102 Los Alamitos CA 90720 USA Keywords: information technology procedural language California Illinois Onsite Postgres SME [email protected] |
| [email protected] View all |
| Fri Jul 19 03:38:00 UTC 2024 |