Database Migration Engineer – Oracle to PostgreSQL

2 days ago


tamil nadu, India TECEZE Full time

Role Overview

We are seeking a skilled Database Migration Engineer to lead and execute the migration of databases from Oracle to PostgreSQL. The ideal candidate will possess hands-on experience in database administration, migration strategies, and performance optimization, ensuring a seamless transition with minimal downtime.


Key Responsibilities


Database Migration: Plan and execute the migration of databases from Oracle (11g/12c/19c) to PostgreSQL (12+), including schema, data, and logic conversion


Code Refactoring: Convert and optimize PL/SQL code to PL/pgSQL, ensuring functional equivalency and performance improvements.


Performance Tuning: Analyze and optimize database performance post-migration, addressing issues related to query performance, indexing, and data retrieval


Required Skills & Qualifications


Experience: Minimum of 3–8 years in database migration and administration, with a focus on Oracle to PostgreSQL migrations

Database Proficiency: Strong command of SQL, PL/SQL, and PL/pgSQL.

Migration Tools: Experience with tools like ora2pg, pgLoader, AWS DMS, and Flyway.

Performance Optimization: Proficiency in PostgreSQL performance tuning, indexing, and replication



  • tamil nadu, India Essex Pvt Ltd Full time

    Job Description :- Install, configure, and upgrade Oracle Database software across various environments.- Optimize database performance through tuning, indexing, and monitoring. - Design and implement robust backup and recovery strategies for Oracle databases.- Implement and manage security measures, including user access controls, encryption, and auditing.-...


  • Tamil Nadu, India Qode Full time

    **Location**: Chennai, India Workplace Type: Hybrid **About the Role**: **Key Responsibilities**: - Administer and maintain PostgreSQL databases, ensuring their availability, performance, and security. - Implement and maintain database security measures, including user access controls and encryption. - Monitor database performance and identify areas for...


  • tamil nadu, India Softone HR Solutions Full time

    Dear All,We are hiring for PostgreSQL Database AdministratorRole : PostgreSQL AdministrationLocation : Chennai Experience : 4 to 10 Years Mode : Work from Office Job description:Minimum of 4+ years of professional experience in PostgreSQL AdministrationExpert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and database...

  • PostgreSQL Dba

    1 week ago


    Coimbatore, Tamil Nadu, India Future Forward Technologies Full time

    **Postgres DB | 3 to 6 Years | Remote | Work Timings: Standard IST** **Key Responsibilities**: - Write efficient SQL queries, stored procedures, and triggers to support business logic. - Monitor database performance, tune queries, and optimize indexing and schema design. - Ensure data integrity and implement backup and recovery strategies. - Manage user...


  • Chennai, Tamil Nadu, India Teceze Ltd Full time

    **Title**:Database Administrator / PostgreSQL Admin **Experience**: 7+ **Location**:Chennai **Mode**:Full Time **Notice Period**:15 days - 45 days **Key Responsibilities**: - Administer, maintain, tune, and troubleshoot PostgreSQL databases in production, staging, and development environments. - Implement and manage high availability, backup/recovery,...

  • Oracle Gcp

    1 week ago


    Chennai, Tamil Nadu, India SKYLARK HR SOLUTIONS Full time

    Oracle SQL+ GCP II JC: 2074679 Role: Oracle SQL+ GCP Location: Chennai Only Database migration is must at least for one project Target 6+ Years of experience - JD: - Ability to translate business requirements into technical specifications - Ability to build tactical and strategic roadmap on GCP platform - Experience in defining the technical...


  • Chennai, Tamil Nadu, India Yaanar Technologies Pvt Ltd Full time

    Job Title: Oracle Database Adminstrator Experience: 5-10years Location: Ambattur, Chennai Notice period: Immediate-1week **Job Description**: **Responsibilities**: Provision MySQL instances, both in clustered and non-clustered configurations Ensure performance, security, and availability of databases Prepare documentations and specifications Handle common...


  • tamil nadu, India Fiserv Full time

    Job DescriptionWhat does a successful Sr. Database Manager do? The Senior Database Manager will oversee the design, implementation, maintenance, and performance of Oracle database systems. This role ensures high availability, security, and optimal performance of enterprise databases while leading a team of DBAs and collaborating with cross-functional...

  • Database Architect

    1 week ago


    Chennai, Tamil Nadu, India MPowerUrge Full time

    Responsibilities: - Assess DB migration from on-premises to Cloud - Assess DB modernization and consolidation requirements from customers - Assess DB structures, data size, RTO and RPO values with feasibility under current environment - Design database blueprint, cutover strategy for migration, modernization and consolidation - DB configuration, Set up and...

  • Oracle Dba with Rac

    1 week ago


    Chennai, Tamil Nadu, India Cognizant Full time

    **Experience:4 to 8 Years** **Location: Hyderabad, Chennai & Bangalore** **Notice period:45 days** Responsible for designing, implementing and maintaining all functions of database systems according to business needs; - Managing Oracle 11g and 12c, 19c databases on HP UNIX and LINUX environments. - Design and implement database backups using Oracle...