|
Technical Audit Of The Existing Oracle Environment, Preparation Of Database, Schema And Object Inventory, Dependency Mapping, Compliance Assessment And Detailed Migration Plan Preparation, Developing The Postgresql Target Architecture, Designing Production, Test/Uat And Backup Environments, Calculating Resource Capacity And Preparing Basic System Parameters, Migration Of Oracle Schema And Database Objects To Postgresql, Including Conversion Of Table, Index, Constraint, Sequence, Partition, View, Materialized View, Function, Procedure, Package, Trigger, Synonym, Database Link And Scheduler Jobs, Complete Analysis Of Aqtis Software Source Code, Detection Of Oracle Dependencies And Elimination Of Those Dependencies, Modification Of Sql Queries, Data Access Layer, Orm, Connection, Transaction, Locking, Reporting And Integration Mechanisms In The Source Code Of Aqtis Software According To Postgresql, Developing And Conducting Module, Integration, Functional, Regression And Performance Tests Of Modified Aqtis Software, Migration Of Production And Archive Databases To Postgresql Using Full Load, Incremental Load And Delta Synchronization Methods, Including Migration Of Lob/Blob/Clob Data, Development Of Data Verification And Reconciliation Mechanisms, Verification Of Record Counts, Checksum/Hash, Pk/Fk, Relational Integrity, Data Formats And Business Rules, Performing Postgresql Performance Tuning, Sql And Index Optimization, Security Hardening, Rbac, Auditing, Monitoring, Logging And Alerting Mechanisms, Building A Postgresql High-Availability And Disaster Recovery Environment: Master-Backup Replication, Automatic Failover And Switchover, Wal Archiving, Pitr, Automated Recovery From Backup, Dr Switchover, Rpo/Rto Scenarios And Development Of Automatic Service Recovery Mechanisms
|
