PostgreSQL databasedata migration - ONSITE at Remote, Remote, USA |
Email: [email protected] |
From: Devakar Balachandran, KK Software Associates [email protected] Reply to: [email protected] Note: Please don't share OPT, CPT, H4EAD, TN, L2, J2 and E3 Client: TCS Location: Chicago(Downtown), IL / ONSITE JD: Role name: Developer Role Description: echnical 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 6) 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 Posgres Migration experience (schema and data ) is required8) Eager to learn new concepts, functionalities and able to resolved issue independently Competencies: PostgreSQL, Data Migration, Oracle 10g Database performance tuning Experience (Years): 6-8 Essential Skills: Database migration from Oracle to PostgreSQLstrong expertise in PostgreSQL databasedata migration of large database to PostgreSQLAddress PostgreSQL query / Stored procedures performance issuesOracle to Postgres Migration experience (schema and data ) is required Desirable Skills: GCP basic understanding and Cloud SQL knowledgeEager to learn new concepts, functionalities and able to resolved issue independently Country: United States Keywords: information technology trade national procedural language Illinois Tennessee PostgreSQL databasedata migration - ONSITE [email protected] |
[email protected] View all |
Wed Jul 03 20:38:00 UTC 2024 |