Oracle Database Migration Engineer
New York City, NY - USA
Job Summary
PROJECT NAME: The Data Center Colocation and Migration
Scope of Project:
Project Overview:
NYC DSS is undertaking a large-scale Data Center Co-location and Migration Project to modernize its IT infrastructure.
Approximately 90% of current data center infrastructure is reaching End-of-Life (EOL) / End-of-Support (EOS)
Migration from 15 MetroTech Center to 11 MetroTech (Brooklyn NY)
Consolidation of multiple data centers into a single co-location facility
Focus on:
Infrastructure modernization
Risk mitigation
Improved system reliability and performance
This project is critical to DSS operations supporting applications used for:
Public assistance
Housing and shelter services
Benefits distribution systems
Risk mitigation
Improved system reliability and performance
This project is critical to DSS operations supporting applications used for:
Public assistance
Housing and shelter services
Benefits distribution systems
Responsibilities:
Architect and execute Oracle micro-segmentation to deliver a zero-trust database security posture in a highly complex Oracle RAC environment.
Deep analysis of blocking sessions and strict validation of source and destination IP mappings to ensure no cross-segment access and complete isolation preserving zero trust throughout the migration.
Design and enforce access policies identity and access management (IAM) and group policies to ensure that no unauthorized users can log in and that only approved service and privileged accounts have access while implementing granular east-west segmentation and strict workload isolation.
Implement policy-driven micro-segmentation to control traffic between workloads inter-node communication and continuously observe performance metrics and replication health.
Configure granular access controls between workloads apps and environments (dev/test/prod) with security lists flow logs and firewall policies; deploy zero-trust network models
Develop automation for repeatable deployments ensuring scalable consistent policies across all environments.
Implement and oversee data replication from primary to standby ensuring zero data loss minimized replication lag and high availability.
Ensure compliance reduce attack surfaces and deliver a secure resilient and high-performance colocation deployment
Deep analysis of blocking sessions and strict validation of source and destination IP mappings to ensure no cross-segment access and complete isolation preserving zero trust throughout the migration.
Design and enforce access policies identity and access management (IAM) and group policies to ensure that no unauthorized users can log in and that only approved service and privileged accounts have access while implementing granular east-west segmentation and strict workload isolation.
Implement policy-driven micro-segmentation to control traffic between workloads inter-node communication and continuously observe performance metrics and replication health.
Configure granular access controls between workloads apps and environments (dev/test/prod) with security lists flow logs and firewall policies; deploy zero-trust network models
Develop automation for repeatable deployments ensuring scalable consistent policies across all environments.
Implement and oversee data replication from primary to standby ensuring zero data loss minimized replication lag and high availability.
Ensure compliance reduce attack surfaces and deliver a secure resilient and high-performance colocation deployment
Required/Preferred Skills:
4 years experience in migrating large complex databases and applications along with associated schemas users/roles privileges jobs (DBMSSCHEDULER) GoldenGate replications and linked configurations to Oracle AI Database 26ai (built on 23ai).
4 years 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.
4 years experience regarding project status stakeholder meetings reporting requirements scope changes and migration planning/execution for Oracle database upgrades/migrations.
4 years 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.
4 years 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.
4 years experience regarding project status stakeholder meetings reporting requirements scope changes and migration planning/execution for Oracle database upgrades/migrations.
4 years 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.
V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector Enterprise Solutions Professional Services Ecommerce Projects and Products. Within Public Sector business unit we cater IT Professional Services to Federal State and Local. We have multiple awards/ contracts with 30 states including but not limited to NY CA FL GA MD MI NC OH OR CO CT TN PA TX VA NM VT and WA.
If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.