IT Associates ยท 1 day ago
Sr GCP Cloud Database Migration Engineer - Oracle to PostGreSQL
United States
Contract
Remote
Senior Level, Lead/Staff
$80/hr - $90/hr
8+ years expIT Associates is seeking a Cloud Database Migration Engineer responsible for planning, executing, and validating database migrations from Oracle to PostgreSQL on Google Cloud Platform. The role requires collaboration with various teams to ensure successful migration outcomes while focusing on performance, security, and operational excellence.
Communications InfrastructureConsultingInformation Technology
Hiring Manager
Meena Aftab
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 GCP-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 GCP
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 GCP 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)
Company
IT Associates
IT Associates provides businesses and organizations with IT, data, consulting, and communications services and equipment.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Kevin Quinn
Sr. Client Partner
Company data provided by crunchbase