Need PostgreSQL Database Admin at Chicago, Illinois, USA |
Email: [email protected] |
From: ayush, Scalable Systems [email protected] Reply to: [email protected] PostgreSQL Database Migration Specialist Location: Chicago, IL About Us: Briefly describe your company and its mission (1-2 sentences). Highlight what makes your company an attractive place to work (culture, benefits, etc.) (1-2 sentences). The Role: We are seeking a highly skilled PostgreSQL Database Migration Specialist to join our team and play a key role in migrating our data from Oracle to PostgreSQL. This role requires a strong understanding of both Oracle and PostgreSQL databases, along with expertise in data migration, query performance tuning, and database administration. The ideal candidate will be a passionate problem-solver with a proven track record of successfully migrating large and complex databases. Responsibilities: Lead and execute the migration of schema and data from Oracle to PostgreSQL. (Highlighted Skill: Oracle to PostgreSQL Migration) Design and implement efficient data migration strategies. (Highlighted Skills: Data Migration, PostgreSQL) Develop and optimize PostgreSQL queries to ensure optimal performance. (Highlighted Skills: PostgreSQL Query Optimization, Query Performance Tuning) Troubleshoot and resolve performance issues within the PostgreSQL database. (Highlighted Skill: PostgreSQL Query Optimization) Perform ongoing database administration tasks, including backups, restores, and monitoring. (Highlighted Skill: PostgreSQL) Collaborate with development and operations teams to ensure a smooth and successful migration. Stay up-to-date on the latest trends and technologies in PostgreSQL. (Highlighted Skill: Eager to learn new concepts) Independently identify and resolve database-related issues. (Highlighted Skill: Able to resolved issue independently) Qualifications: Minimum 5+ years of experience working with relational databases, with a strong focus on PostgreSQL. (Important Skill) Proven experience in migrating large and complex databases from Oracle to PostgreSQL. (Important Skill) Expert knowledge of PostgreSQL database architecture, schema design, and query optimization. (Important Skill) Strong understanding of Oracle PL/SQL, including tables, views, procedures, functions, packages, indexes, triggers, and materialized views. (Important Skill) Experience with performance tuning techniques, including constraint creation, index creation and analysis, VACUUM/AUTOVACUUM parameter setup, explain plan analysis, server-side parameter tuning, and SQL query rewriting. (Important Skill) Basic understanding of Google Cloud Platform (GCP) and Cloud SQL is a plus. (Preferred Skill) A passion for learning new technologies and a strong desire to continuously improve. (Important Skill) Excellent problem-solving and analytical skills. (Important Skill) Strong communication and collaboration skills. (Important Skill) Keywords: procedural language Illinois Need PostgreSQL Database Admin [email protected] |
[email protected] View all |
Fri Jul 19 03:30:00 UTC 2024 |