| Looking On-site || Technical Postgres SME || Chicago, IL (Onsite) at Chicago, Illinois, USA |
| Email: gaurav.kumar@quantumworldit.com |
|
From: Gaurav kumar, Quantum World Technologies Inc. gaurav.kumar@quantumworldit.com Reply to: gaurav.kumar@quantumworldit.com Greeting, I hope all is well with you For the following, Quantum World IT is seeking the best consultant profile. Please respond with your most recent resume if you are considering new opportunities. Looking On-site || Technical Postgres SME || Chicago, IL (Onsite) Role name: Developer Role 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 PostgreSQL2) Very strong expertise in PostgreSQL database3) 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 knowledge7) Oracle to Postgres Migration experience (schema and data ) is required8) Eager to learn new concepts, functionalities and able to resolved issue independently Competencies: PostgreSQL, PL/SQL, Data Migration, Oracle Database 12C Administration 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 Desirable Skills: GCP basic understanding and Cloud SQL knowledgeEager to learn new concepts, functionalities and Able to resolved issue independently Country: United States Please enter the following information is needed for submission and share your visa and Photo id Position Applied for Candidate Full Name [As per Passport] Contact Number Primary & Secondary Current Location Work Authorization Total years of Experience Had ever worked with TCS in Past (Required filed) Have you gotten covid Vaccination does LinkedIn ID Are you comfortable for on-site Rate Gauarv Kumar Phone: +1 805 749 5070 Email: Gaurav.kumar@quantumworldit.com Quantum World Technologies Inc. 4281 Katella Ave, Suite #102 Los Alamitos CA 90720 USA Keywords: information technology procedural language California Idaho Illinois Looking On-site || Technical Postgres SME || Chicago, IL (Onsite) gaurav.kumar@quantumworldit.com https://jobs.nvoids.com/job_details.jsp?id=1577629 |
| gaurav.kumar@quantumworldit.com View All |
| 02:46 AM 19-Jul-24 |