| Technical PostgresSQL SME at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1575709&uid= From: lavanya, KK associates [email protected] Reply to: [email protected] We are hiring hashtag#Technical_PostgresSQL_SME Client interesting candidates please send resumes to [email protected] or 614-379-0184 Visa status: Only H1B/GC/USC / Position:- Technical PostgresSQL SME Location: - Chicago(Downtown), IL onsite hashtag#Cloud_Migration, hashtag#PostgreSQL_Query_Optimization, hashtag#data_migration Competencies: PostgreSQL, PL/SQL, Data Migration, Oracle Database 12C Administration Experience (Years): 6-8 Essential Skills: Postgres developer Query hashtag#Performance_Tuning Managed 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 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 Keywords: information technology green card procedural language Illinois Technical PostgresSQL SME [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1575709&uid= |
| [email protected] View All |
| 09:30 PM 18-Jul-24 |