Information Technology Associate
CurrentSuccessfully migrated a large Oracle database to Aurora PostgresqlUsed AWS Schema conversion tool (SCT) and DMS for migration processTested the code thoroughly to ensure the code was working properly on postgresql without performance issuesMade any necessary changes to the postgresql database to ensure compatibility Expertise in migrating Oracle tables,Views, Materialized Views,Indexes, Partitions, Triggers, Procedures, Functions,Arrays,Types,DBlinks,Pragma autonomous, Global variable, External tables,Utl file packages,Bulk collect, Merge , Hierarical and Window functions into Postgresql native functionsCreated separate process to audit loggings, handle temporary tables, automatic range partitions (daily, monthly,Yearly) and also created separate process for ddl's to avoid database locking and ensure better performancesStrong knowledge in performance tuning and optimizationSupported application team in fixing the bugs till endHaving good knowledge in S3,Lambda, Cloudwatch and Event bridge services