Database Developer

Company:  Diverse Lynx
Location: Chicago
Closing Date: 18/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / 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 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

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Apply Now
Share this job
  • Similar Jobs

  • Database Developer

    Chicago
    View Job
  • Database DBA

    Chicago
    View Job
  • Senior Database Administrator

    Chicago
    View Job
  • Sample Database Programmer

    Chicago
    View Job
  • Oracle Database Administrator

    Chicago
    View Job
An error has occurred. This application may no longer respond until reloaded. Reload 🗙