Senior Associate
CurrentAnalysed the existed Oracle database Structure and review the oracle database schema, tables, views, indexes, constraints functions and other objects.Assess the complexity of the existing database and identified areas like data formatted data types, view dependencies that may require special attention during themigration.Completed Ora2pg setup and configurations setting as per the project requirements,Used Ora2pg converted Oracle schemas to PostgreSQL, verified the scripts and did the changes according to the Postgres standard.Translate and adapt Oracle SQL scripts (PL/SQL) to PostgreSQL(PL/pgsql) and rewrite and replace complex Oracle -specific constructs with equivalent PostgreSQL functionalityCreated FARM Postgres database manually and execute the converted scripts in Postgres DB using pgadmin4 .Executed all the objects scripts which are converted from oracleto Postgres and Validated.Completed the unit testing after post-migration like compared the existed objects count and data validation using data dictionary in source& target manually (Oracle to Postgres).Prepared Unit testing documentation along with screen shot and validation scripts from oracle to Postgres for FARM VM.
