| PostgreSQL Developer at Remote, Remote, USA |
| Email: [email protected] |
| PostgreSQL Developer Chicago, IL (Initial Remote) Contract Job description PostgreSQL performance tuning expert. 1) 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 procedure's 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,MV's 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 be resolved issue independently -- Keywords: information technology procedural language Illinois PostgreSQL Developer [email protected] |
| [email protected] View all |
| Mon Jul 08 23:53:00 UTC 2024 |