Urgent Need | Database Developer | Chicago, IL (Hybrid) at Chicago, Illinois, USA |
Email: [email protected] |
Hi, Hope you are doing great! Please find the requirement below, If you find yourself comfortable with the requirement. Role- Database Developer Location- Chicago, IL (Hybrid) Duration- Long term contract Job 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. 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 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 required Eager to learn new concepts, functionalities and able to resolved issue independently PostgreSQL, Data Migration, Oracle 10g Database performance tuning www.envisiontechsol.com 10130 Mallard Creek Rd, Charlotte NC, 28262 Name Satya Prakash Designation Technical Recruiter Envision Technology Solutions E: Email [email protected] Office: number 315-275-5700 LinkedIn : linkedin.com/in/satya-prakash-205335238/ -- Keywords: information technology procedural language Illinois North Carolina Urgent Need | Database Developer | Chicago, IL (Hybrid) [email protected] |
[email protected] View all |
Fri Jul 12 22:40:00 UTC 2024 |