Database Migration Specialist

4 weeks ago

Delhi, Delhi, India Funic Tech Full time

Job Title : Database Migration Specialist - SQL/DB2/Oracle to PostgreSQL

Experience Required : 4+ Years

Location : Remote/Hybrid

Employment Type : Full-Time

Job Summary :


We are looking for an experienced Database Migration Specialist to lead and execute database migration projects from SQL Server, DB2, and Oracle to PostgreSQL. The ideal candidate will have hands-on expertise in data modeling, schema conversion, performance tuning, and automation of migration processes.

Key Responsibilities :


- Analyze legacy databases (SQL Server, DB2, Oracle) to identify schema, data, stored procedures, and dependencies.

- Plan and execute seamless database migrations to PostgreSQL with minimal downtime.

- Use tools like AWS DMS, ora2pg, pgloader, or native scripts to automate migration.

- Convert and optimize PL/SQL or T-SQL procedures/functions to PL/pgSQL.

- Conduct data validation, integrity checks, and reconciliation post-migration.

- Tune queries, indexing strategies, and PostgreSQL configurations for optimal performance.

- Work closely with application and infrastructure teams to support end-to-end migration.

- Document migration processes, issues encountered, and mitigation steps.

- Implement rollback and disaster recovery strategies for migration phases.

Required Skills and Qualifications :

- 4+ years of experience in database migration and administration.

- Proven experience migrating databases from SQL Server, DB2, or Oracle to PostgreSQL.

- Strong command of SQL, PL/SQL, T-SQL, and PL/pgSQL.

- Proficiency in PostgreSQL performance tuning, indexing, and replication.

- Experience with data migration tools (e.g., AWS DMS, ora2pg, pgloader, SQL Developer).

- Familiarity with database design, normalization, and schema refactoring.

- Hands-on experience with Linux-based environments.

- Good understanding of ETL processes, data pipelines, and scripting (Bash, Python, or similar).

- Excellent problem-solving, communication, and documentation skills.

Preferred Qualifications :

- Experience with cloud database migration (AWS RDS for PostgreSQL or Aurora).

- Exposure to DevOps tools, version control (Git), and CI/CD pipelines.

- Knowledge of PostgreSQL extensions (PostGIS, pg_partman, etc.) is a plus.

- Certifications in PostgreSQL or cloud platforms (AWS, Azure) are an added advantage.

(ref:hirist.tech)

  • Data Migration Specialist Lead

    2 days ago

    Delhi, Delhi, India beBeeMigration Full time ₹ 9,00,000 - ₹ 12,00,000

    Job DescriptionAs a seasoned data migration specialist, you will lead and manage comprehensive Teamcenter data migration initiatives across various versions and platforms. Your expertise in formulating effective migration strategies that maintain data integrity, optimize performance, and ensure seamless business continuity is essential for our...

  • Senior SAP Basis Migration Specialist

    3 days ago

    Delhi, Delhi, India beBeeMigrationspecialist Full time

    Job SummaryWe are seeking an experienced Senior SAP Basis Migration Specialist to join our team. The successful candidate will have a strong background in SAP Basis and migration projects, with expertise in system configuration, data migration, and troubleshooting.About the Role:SAP Basis Migration: Lead and support SAP migration projects, ensuring smooth...

  • Database Management Specialist

    1 day ago

    Delhi, Delhi, India beBeedatabase Full time ₹ 12,00,000 - ₹ 15,00,000

    Database Management SpecialistWe are seeking an experienced Database Management Specialist to join our team. As a key member of our database administration group, you will be responsible for designing, implementing, and maintaining high-performance databases.Your primary focus will be on ensuring the reliability, security, and scalability of our database...

  • Migrate Large-Scale Atlassian Systems

    2 days ago

    Delhi, Delhi, India beBeeMigration Full time ₹ 9,00,000 - ₹ 12,00,000

    Job Title:Migrating Atlassian Tools SpecialistThis role requires planning, executing and validating end-to-end Jira and Confluence migrations to the cloud.The ideal candidate will have expertise in migration planning, dependency management and execution strategies.Predicting dependencies for third-party add-ons, especially testing tools.Crafting...

  • Lead Payment Migration Engineer

    3 weeks ago

    Delhi, Delhi, India Net2Source Full time

    Lead Payments Migration EngineerLocation : RemoteExperience : 8 to 10 YearsDuration : 6 Months ContractJob Overview : We are seeking a highly experienced and technically proficient Lead Payments Migration Engineer with 8 to 10 years of experience to spearhead the bank's critical payments platform transition. Your primary responsibility will be to orchestrate...

  • Brightedge - Database Engineer

    1 week ago

    Delhi, Delhi, India brightedge Full time

    Database Engineer (Python) Remote As a Database Engineer at BrightEdge, you will be responsible for the design, development, maintenance, and optimization of database systems critical to the organizations data management needs. Your role will involve working with various database technologies such as MySQL, MS SQL, PostgreSQL, and BigQuery, as well as coding...

  • SQL Server Database Specialist

    16 hours ago

    Delhi, Delhi, India beBeedatabase Full time ₹ 9,00,000 - ₹ 12,00,000

    Job Title: SQL Server Database SpecialistWe are seeking a highly skilled SQL Server Database Specialist to join our team. The successful candidate will be responsible for designing, implementing and maintaining large-scale databases that meet the highest standards of performance, security and reliability.Main Responsibilities:Database Maintenance: Ensure...

  • Expert Data Migration Specialist

    18 hours ago

    Delhi, Delhi, India beBeeDataMigration Full time ₹ 80,00,000 - ₹ 1,20,00,000

    Job OpportunityWe are seeking a highly skilled data migration expert to join our organization. The ideal candidate will be responsible for designing, managing, and optimizing complex data migrations using technical skills in conjunction with AI coding assistants.The successful applicant will have experience transforming and migrating data as a part of a data...

  • Senior Oracle Database Specialist

    2 days ago

    Delhi, Delhi, India beBeedatabase Full time

    Job Description\We are seeking a seasoned Database Administrator to oversee and optimize our critical Oracle database systems. This role involves working with relevant technologies, ensuring smooth operations, high availability, and optimal performance of Oracle databases.\\Key Responsibilities:\\\\Database Administration: Install, configure, upgrade, and...

  • Senior Linux Database Specialist

    1 day ago

    Delhi, Delhi, India beBeeDatabase Full time ₹ 1,50,00,000 - ₹ 2,50,00,000

    Database AdministratorWe are seeking a highly skilled Database Administrator to provide technical expertise in database planning and design. The successful candidate will have significant experience in Linux Administration and will be responsible for managing the day-to-day operations of the database.Key Responsibilities:Provide adequate support in...