What are the responsibilities and job description for the Web Server & Application Migration Consultant position at Synapse Business Systems?
Experience in migrating large complex databases and applications along with associated schemas,
users/roles, privileges, jobs (DBMS_SCHEDULER), GoldenGate replications, and linked configurations to
Oracle AI Database 26ai (built on 23ai),
• Experience with designing and implementing high availability solutions, including Oracle RAC, Data
Guard, Active Data Guard, and Always-On-like configurations with multitenant PDB failover, plus migration to
cloud platforms like Oracle Exadata or Autonomous Database.
• Experience regarding project status, stakeholder meetings, reporting requirements, scope changes, and
migration planning/execution for Oracle database upgrades/migrations.
• Experience with providing Hyper Care support post migration of databases and applications, including
user support, performance troubleshooting, and issue resolution during stabilization phases.
• Hands-on experience implementing microsegmentation in Oracle environments using OCI Network Security
Groups (NSGs) for fine-grained network isolation between application tiers (e.g., web, app, database), enforcing
zero-trust policies, restricting east-west traffic to database ports (e.g., SQL*Net.
• Proficiency in Oracle Multitenant architecture migrations, such as non-CDB to PDB conversions, PDB
unplug/plug operations, refreshable clones for minimal-downtime upgrades, and using AutoUpgrade for
automated in-place or clone-based migrations to Oracle AI Database 26ai.