What are the responsibilities and job description for the Database Developer position at Diverse Lynx?
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.
