Jobs via Dice ยท 3 hours ago
Sr Google Cloud Platform Cloud database Migration Engineer ( Oracle to PostGreSQL )
Jacksonville, FL
Contract
Hybrid
Senior Level, Lead/Staff
$80/hr - $90/hr
8+ years expDice is the leading career destination for tech experts at every stage of their careers, and they are seeking a Cloud Database Migration Engineer for a contract position. The role involves planning, executing, and validating large-scale database migrations from Oracle to PostgreSQL, focusing on cloud implementations on Google Cloud Platform.
Computer Software
Responsibilities
Lead end-to-end database migration initiatives from Oracle to PostgreSQL, including assessment, design, execution, validation, and post-migration optimization
Design and implement PostgreSQL architectures on Google Cloud Platform, leveraging services such as Cloud SQL for PostgreSQL and related Google Cloud Platform-native tooling
Analyze existing Oracle schemas, PL/SQL, stored procedures, triggers, and packages; refactor or re-engineer database logic to be compatible with PostgreSQL
Develop and execute migration strategies, including schema conversion, data transformation, and cutover planning, while minimizing downtime and risk
Utilize and, where appropriate, customize migration tools and frameworks (e.g., ora2pg, DMS-style tooling, custom scripts)
Collaborate with application development teams to remediate SQL and application-level dependencies impacted by the migration
Optimize PostgreSQL performance, indexing strategies, query execution plans, and connection management in a cloud environment
Implement security best practices, including encryption, access controls, auditing, and compliance alignment within Google Cloud Platform
Establish backup, recovery, high availability, and disaster recovery strategies for PostgreSQL workloads
Produce clear, maintainable technical documentation covering architecture, migration steps, and operational procedures
Provide post-migration support and knowledge transfer to operations and support teams
Qualification
Required
Bachelor s degree in Computer Science, Engineering, or a related technical discipline, or equivalent professional experience
8+ years of experience working with enterprise relational databases, including significant hands-on experience with Oracle
Proven experience migrating Oracle databases to PostgreSQL in production environments
Strong knowledge of PostgreSQL internals, including query optimization, indexing, vacuuming, and replication
Experience deploying and managing PostgreSQL in Google Cloud Platform environments
Deep understanding of SQL dialect differences and migration challenges between Oracle and PostgreSQL
Experience refactoring PL/SQL to PostgreSQL-compatible procedural languages (e.g., PL/pgSQL)
Familiarity with CI/CD pipelines and Infrastructure-as-Code concepts as they relate to database deployments
Strong troubleshooting, analytical, and problem-solving skills
Excellent written and verbal communication skills, with the ability to work effectively across technical teams
Preferred
Hands-on experience with Google Cloud Platform services such as Cloud SQL, Compute Engine, Cloud Storage, VPC, IAM, and monitoring/logging tools
Experience with high-availability PostgreSQL architectures and read-replica strategies
Knowledge of containerized or Kubernetes-based PostgreSQL deployments
Experience in regulated or compliance-driven environments
Relevant cloud or database certifications (e.g., Google Cloud Professional, PostgreSQL, Oracle)
Experience with open-source monitoring tools such as Prometheus & Grafana
Benefits
Medical
Dental
Retirement
Other benefits
Company
Jobs via Dice
Welcome to Jobs via Dice, the go-to destination for discovering the tech jobs you want.
0-1 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase