What are the responsibilities and job description for the Senior Oracle to Google Cloud Platform PostgreSQL Migration Specialist position at DTEL Engineering & Consultants Inc?
Job Details
Required skills:
Oracle
PostgreSQL
Google Cloud Platform or Google Cloud SQL
Job Overview:
We are looking for a highly experienced Senior Database Migration Specialist with 12 years of expertise in database administration, development, and migration from Oracle to PostgreSQL on Google Cloud Platform.
The ideal candidate will lead large-scale migration projects, provide strategic direction, and ensure seamless database transitions with minimal downtime and optimal performance.
Key Responsibilities:
- Lead end-to-end database migration projects from Oracle to PostgreSQL, ensuring best practices and minimal disruptions.
- Lead and execute large-scale Oracle to PostgreSQL migration projects on Google Cloud SQL for PostgreSQL or Cloud Spanner.
- Assess existing Oracle database architecture and design optimized schema migration strategies for PostgreSQL.
- Convert and optimize complex PL/SQL code (procedures, functions, triggers, packages) into PL/pgSQL in PostgreSQL.
- Develop and implement data migration pipelines using tools such as Google Database Migration Service (DMS), Ora2Pg, and custom ETL scripts.
- Optimize PostgreSQL performance on Google Cloud Platform using query optimization, indexing strategies, partitioning, and tuning techniques.
- Implement high availability, replication, and failover mechanisms for PostgreSQL on Google Cloud Platform.
Work closely with DevOps and Cloud Engineering teams to implement automated deployments and CI/CD pipelines for database changes. - Perform rigorous testing, validation, and performance benchmarking post-migration.
- Collaborate with application developers to refactor applications for PostgreSQL compatibility and ensure a smooth transition.
- Troubleshoot and resolve migration-related performance issues, query bottlenecks, and cloud configuration optimizations.
- Conduct in-depth assessment of Oracle databases, identifying challenges, dependencies, and optimization opportunities before migration.
- Design and implement schema migration strategies, ensuring efficient conversion of tables, indexes, constraints, and triggers.
- Convert and optimize complex PL/SQL stored procedures, packages, functions, and triggers into PostgreSQL PL/pgSQL.
- Develop and optimize SQL queries, indexing strategies, and partitioning in PostgreSQL for enhanced performance.
- Utilize tools like Ora2Pg, AWS DMS, Schema Conversion Tool (SCT), and custom scripts for automation and efficiency.
- Perform rigorous performance tuning, benchmarking, and query optimization in PostgreSQL.
Required Qualifications:
- 12 years of experience in database administration, development, and migration.
- Extensive expertise in Oracle (11g/12c/19c) and PostgreSQL (9.x, 10, 11, 12, 13, 14 ).
- Strong proficiency in PL/SQL to PL/pgSQL migration, including rewriting complex queries and stored procedures.
- Hands-on experience with Google Cloud SQL for PostgreSQL, Cloud Spanner, and BigQuery integration.
- Deep understanding of query execution plans, indexing strategies, and partitioning in PostgreSQL.
- Experience with high-availability architectures, replication (logical/physical), and disaster recovery planning.
- Strong knowledge of data modeling, normalization, and indexing strategies.
- Experience with PostgreSQL extensions (e.g., PostGIS, TimescaleDB, pg_stat_statements).
Proficiency in Google Cloud Platform database migration tools, including Google Database Migration Service (DMS), SCT, Ora2Pg, and pgLoader. - Deep knowledge of PL/SQL to PL/pgSQL migration, including complex query optimization and stored procedure conversion.
- Experience with Cloud-native architectures, IAM roles & permissions, and security best practices on Google Cloud Platform.
- Strong expertise in query execution plans, indexing, partitioning, and performance tuning in PostgreSQL.
- Experience with PostgreSQL high availability (HA) setups, replication (logical/physical), and disaster recovery strategies.
Experience with CI/CD pipelines for database versioning and deployments
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
