Diverse Lynx
PostgreSQL Consultant
Diverse Lynx, Chicago, Illinois, United States, 60290
Job Title: PostgreSQL ConsultantLocation: Chicago IL(Day-1 Onsite)Duration: 12+ MonthInterview: Video
Job Description•Postgres developer Query Performance Tuning•Work with development teams to troubleshoot and fix performance related issues•Migration experience to move databases from Oracle to Cloudsql for PostgreSQL•Perform data copy from ON prem to GCP CloudSQL•CDC configuration of Primary schemas as applicable.•Strong troubleshooting skills
Skills:•Postgres developer Query Performance Tuning•Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning.•Oracle PL/SQL databases like TABLES,VIEWS,PROCEDURES,FUNCTIONS,PACKAGES,INDEXES,TRIGGERS,MVs* Have done data migration activities from Oracle On-prem to PostgreSQL onprem/cloud
Experience (Years):
6-8
Keywords:
Cloud Migration, PostgreSQL Query Optimization, data migration
Desirable Skills:
Good to have experience on GCP cloud unix / linux troubleshooting
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.
Job Description•Postgres developer Query Performance Tuning•Work with development teams to troubleshoot and fix performance related issues•Migration experience to move databases from Oracle to Cloudsql for PostgreSQL•Perform data copy from ON prem to GCP CloudSQL•CDC configuration of Primary schemas as applicable.•Strong troubleshooting skills
Skills:•Postgres developer Query Performance Tuning•Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning.•Oracle PL/SQL databases like TABLES,VIEWS,PROCEDURES,FUNCTIONS,PACKAGES,INDEXES,TRIGGERS,MVs* Have done data migration activities from Oracle On-prem to PostgreSQL onprem/cloud
Experience (Years):
6-8
Keywords:
Cloud Migration, PostgreSQL Query Optimization, data migration
Desirable Skills:
Good to have experience on GCP cloud unix / linux troubleshooting
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.