Job Description

Location: Bangalore

Experience: 4 to 7yrs

Key skills : DBA

Notice Period: Immediate Joiners

Responsibilities:

Assess the existing Oracle databases and gauge the complexity and estimate the efforts required for a migration
Determine the best migration target based on the nature of the application and the type of data and the business logic in the database, and if PostgreSQL or MySQL or any other Open source database suits better as a target database technology for migration

Prepare data migration strategies and designs for each project, including plans to avoid downtime when required
Lead migration projects and work closely with the database migration teams , so that the project is aligned with the standards
Train internal teams on the PostgreSQL development skill set and be a single point of contact for our Global Services teams on PostgreSQL development and migration related assistance

Perform migration of PL/SQL code that includes Packages, Procedures and Functions from Oracle to PostgreSQL
Your Experience
At least 5 years of experience in performing Oracle to PostgreSQL migrations and in helping clients port applications from Oracle to PostgreSQL with alternate approaches that are open source

At least 5 years of experience in writing PLpgSQL and migrating Packages and Procedures from Oracle to PostgreSQL.
At least 1 year of experience in writing Oracle PL/SQL code
At least 1 year of experience coding in Python or Golang or Java expertise in bash scripting is a must

Job Type: Full-time

Pay: ?90,000.00 - ?100,000.00 per month

Schedule:

• Day shift

Experience:

• total work: 5 years (Preferred)

Work Location: In person