Database Migration Specialist

2 weeks ago


Bengaluru, India Mobile Programming LLC Full time

Job Description :

Job Title : Database Migration Specialist

Experience : Overall 6+ Years, 5+ Years Relevant

Location : Bangalore

Budget : 21 LPA Max

Job Role :

We are seeking a skilled Database Migration Specialist to lead the migration of Oracle databases to open-source solutions like PostgreSQL. The ideal candidate should have strong expertise in SQL, PL/SQL, and PL/pgSQL, along with experience handling database structures, scripting, and performance :

- Migrate Oracle databases to open-source databases (e.g., PostgreSQL).

- Develop and manage schemas, tables, triggers, indexes, sequences, and constraints in Oracle and PostgreSQL.

- Analyze business requirements and design appropriate database models and schemas.

- Write and optimize database scripts, including stored functions, procedures, packages, and triggers.

- Provide optimal database design solutions to improve system quality and efficiency.

- Write ETL scripts, update SQL statements, and develop shell scripts for automation.

- Follow best practices for database design, security, and optimization.

- Maintain comprehensive technical documentation for reference.

- Collaborate effectively with the team to ensure seamless database migration and :

- Strong experience in Oracle DB Versions 11G, 12C, 19C with hands-on SQL and PL/SQL.

- Expertise in PostgreSQL Version 12+ with hands-on PL/pgSQL development.

- Proficiency in database migration tools like Ora2Pg, PGLoader, or any Azure migration tools (added advantage).

- Knowledge of additional tools: SQL-Plus, SQL Developer, PLSQL Developer, TOAD for Oracle (minimum two), pgAdmin, OmniDB.

- Basic understanding of Java, Shell Scripting, Jenkins (added advantage).

- Experience in the EDI domain (added advantage).

Technical Skills :

Mandatory Skills :

- Oracle DB (11G, 12C, 19C) - SQL, PL/SQL

- PostgreSQL (12+) - PL/pgSQL

- Database tools - SQL-Plus, SQL Developer, PLSQL Developer, TOAD for Oracle (minimum two), pgAdmin, OmniDB

Added Advantage :

- Database Migration Tools - Ora2Pg, PGLoader, Azure Migration Tools

- Basics of Java, Shell Scripting, Jenkins

- EDI Domain Knowledge

(ref:hirist.tech)

  • Bengaluru, India iit matrix Full time

    Cloud Engineer Cloud Database Migration SpecialistPosition Overview :We are seeking a skilled Cloud Engineer with expertise in Azure cloud migration, Cloud migration tools, and strong experience in Oracle, PostgreSQL and MS SQL Server database administration. The ideal candidate will lead the migration of on-premises databases to Azure, optimize cloud...

  • Migration Specialist

    2 weeks ago


    Bengaluru, India Sonata Software Full time

    Sonata Software Overview In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers. As a leading Modernization Engineering company, we aim to deliver modernization-driven...


  • Bengaluru, India Sonata Software Full time

    Sonata Software OverviewIn today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.As a leading Modernization Engineering company, we aim to deliver modernization-driven...

  • Migration Specialist

    3 weeks ago


    Bengaluru, Karnataka, India Sonata Software Full time

    Sonata Software OverviewIn today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.As a leading Modernization Engineering company, we aim to deliver modernization-driven...

  • Migration Specialist

    3 weeks ago


    Bengaluru, Karnataka, India Sonata Software Full time

    Sonata Software OverviewIn today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.As a leading Modernization Engineering company, we aim to deliver modernization-driven...


  • Bengaluru, India Sonata Software Full time

    Sonata Software OverviewIn today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.As a leading Modernization Engineering company, we aim to deliver modernization-driven...

  • Migration Specialist

    2 weeks ago


    Bengaluru, India Sonata Software Full time

    Sonata Software Overview In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers. As a leading Modernization Engineering company, we aim to deliver modernization-driven...

  • Migration Specialist

    16 hours ago


    Bengaluru, Karnataka, India Sonata Software Full time ₹ 1,50,000 - ₹ 28,00,000 per year

    About the RoleThe Data Migration Specialist will be responsible for overseeing the migration of data from AWS to Azure, ensuring that all processes are executed smoothly and efficiently.Database Management: MySQL, Oracle, MongoDB, PostgreSQL proficiency.Data Migration Experience, hybrid cloud migration knowledgeScripting: Python, Bash, PowerShell; automation...

  • Migration Specialist

    2 weeks ago


    Bengaluru, India Sonata Software Full time

    Sonata Software OverviewIn today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.As a leading Modernization Engineering company, we aim to deliver modernization-driven...

  • Migration Specialist

    2 weeks ago


    Bengaluru, India Sonata Software Full time

    Sonata Software OverviewIn today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.As a leading Modernization Engineering company, we aim to deliver modernization-driven...