Syntricate Technologies
Position- Technical Postgres SME
Duration- Contract
Location-
Chicago, IL
JD Cloud Migration, PostgreSQL Query Optimization, data migration 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,MVs 6) It is good to have GCP basic understanding and Cloud SQL knowledge 7) Oracle to Postgres Migration experience (schema and data ) is required 8) Eager to learn new concepts, functionalities and able to resolved issue independently PostgreSQL, PL/SQL, Data Migration, Oracle Database 12C Administration 6-8 Years experience Essential Skills -
Postgres developer Query Performance TuningManaged and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuningOracle 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
Regards, Pallavi Verma Sr. Technical Recruiter | Syntricate Technologies Inc. Direct
: 781-552-4333 | Email
: pallavi@syntricatetechnologies.com | Web: www.syntricatetechnologies.com
We're hiring! connect with us on LinkedIn nd visit our Jobs Portal
Minority Business Enterprise (MBE) Certified | E-Verified Corporation | Equal Employment Opportunity (EEO) Employer
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to unsubscribe .
Chicago, IL
JD Cloud Migration, PostgreSQL Query Optimization, data migration 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,MVs 6) It is good to have GCP basic understanding and Cloud SQL knowledge 7) Oracle to Postgres Migration experience (schema and data ) is required 8) Eager to learn new concepts, functionalities and able to resolved issue independently PostgreSQL, PL/SQL, Data Migration, Oracle Database 12C Administration 6-8 Years experience Essential Skills -
Postgres developer Query Performance TuningManaged and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuningOracle 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
Regards, Pallavi Verma Sr. Technical Recruiter | Syntricate Technologies Inc. Direct
: 781-552-4333 | Email
: pallavi@syntricatetechnologies.com | Web: www.syntricatetechnologies.com
We're hiring! connect with us on LinkedIn nd visit our Jobs Portal
Minority Business Enterprise (MBE) Certified | E-Verified Corporation | Equal Employment Opportunity (EEO) Employer
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to unsubscribe .