Database Migration Specialist

12 hours ago

Bengaluru, Karnataka, India Programming Full time ₹ 18,00,000 - ₹ 36,00,000 per year

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 optimization.

Responsibilities :

- 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 integration.

Requirements :

- 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 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

  • Migration Specialist

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka 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...

  • Database Migration Engineer

    2 weeks ago

    Bengaluru, Karnataka, India TECEZE Full time ₹ 1,20,000 - ₹ 3,00,000 per year

    Job Role:Database Migration Engineer.Job Location-BengaluruWork Mode: On-SiteExperience: 3-8Job Description-Role OverviewWe 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...

  • PHP MySQL Migration Specialist

    4 days ago

    Bengaluru, Karnataka, India Swift Strategic Solutions Inc Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Our technology services client is seeking multiplePHP MySQL Migration Specialistto join their team on a contract basis. These positions offer a strong potential for conversion to full-time employment upon completion of the initial contract period. Below are further details about the role:Role: PHP MySQL Migration SpecialistExperience: 3- 7 YearsLocation: PAN...

  • Database Migration Engineer

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka TECEZE Full time

    Job Role: Database Migration Engineer.Job Location- BengaluruWork Mode: On-SiteExperience: 3-8Job Description-Role OverviewWe 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...

  • Database Migration Engineer

    2 weeks ago

    Bengaluru, Karnataka, India Insightek Global Consulting Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Key Responsibilities:Schema Conversion & OptimizationTranslate Sybase-specific database objects to MSSQL-compatible syntax.Redesign schema elements where required for MSSQL optimization (e.g., indexes, partitioning).Convert stored procedures, triggers, views, and cursors from Sybase to T-SQL.Map Sybase data types to their closest MSSQL equivalents.Handle...

  • Corporate Sales Specialist in Bangalore

    2 weeks ago

    Bengaluru, Karnataka, India XIPHIAS Investment Migration Inc. Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Company DescriptionXIPHIAS Investment Migration Inc. is a highly reputed and award-winning Investment Migration firm based in India, specializing in immigration services for permanent resident visas, student visas, work permits, and business/investment immigration. We serve clients interested in relocating to popular destinations including Canada, Australia,...

  • Azure Cloud Migration Specialist

    2 weeks ago

    Bengaluru, Karnataka, India SP Software Pvt Ltd Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Azure Cloud Migration Specialist Primary Skill Set:4+ years of exp in Azure engineering/migration, strong knowledge of Azure infra (VMs, Networking, Storage, Security), Hands-on experience with Azure Migrate, DMS, Azure Site Recovery and Terraform. Good to have Azure Solution Architect or Azure Administrator certification Total Experience : 6+...

  • Cloud Migration Specialist

    1 week ago

    Bengaluru, Karnataka, India Persistent Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    About Position:We are looking for a highly capable Cloud Migration Specialist to lead and support our transition to cloud-based infrastructure. This role is critical in ensuring a seamless migration of applications, data, and services to cloud platforms such as AWS, Azure, and Google Cloud. You will work closely with cross-functional teams to align cloud...

  • Data Migration Specialist

    1 week ago

    Bengaluru, Karnataka, India Skills Connect Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Must have : Strong Data Migration Specialist - Syniti ADMM Profile Mandatory (Experience 1) - Must have minimum 4 years of total IT experience, with at least 3 years of experience of end-to-end data migration using Syniti ADMM Mandatory (Experience 2) - Must have experience with SAP BODS ((BusinessObjects Data Services)) for data extraction,...

  • Cloud Migration Specialist

    5 days ago

    Bengaluru, Karnataka, India, Karnataka Persistent Systems Full time

    About Position:We are looking for a highly capable Cloud Migration Specialist to lead and support our transition to cloud-based infrastructure. This role is critical in ensuring a seamless migration of applications, data, and services to cloud platforms such as AWS, Azure, and Google Cloud. You will work closely with cross-functional teams to align cloud...