Database Migration Specialist

2 weeks ago

Delhi, Delhi, India Funic Tech Full time

Job Title : Database Migration Specialist

Experience Required : Min 7 Years

Location : Remote/Hybrid

Employment Type : Full-Time

Job Summary :

We are looking for an experienced Database Migration Specialist to lead and execute complex migration projects from SQL Server, DB2, and Oracle to PostgreSQL.

The ideal candidate will have deep expertise in data modeling, schema conversion, performance tuning, and automation of migration workflows.

Hands-on experience as a PostgreSQL DBA, particularly in AWS environments such as RDS or Aurora, is essential. The role also requires strong skills in data validation and integrity checking to ensure the accuracy and reliability of all migrated systems

Key Responsibilities :

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

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

- Use tools such as AWS DMS, ora2pg, pgloader, or native scripts to automate and manage migrations.

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

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

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

- Serve as a PostgreSQL DBA, including AWS RDS administration, configuration, monitoring, and troubleshooting.

- Collaborate with application and infrastructure teams to support the entire migration lifecycle.

- Document migration processes, encountered issues, and applied mitigation strategies.

- Design and implement rollback strategies and disaster recovery procedures during migration phases.

Required Skills and Qualifications :

- Min 8 years of experience in database migration and administration.

- Proven track record of migrating databases from SQL Server, DB2, or Oracle to PostgreSQL.

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

- Hands-on experience with PostgreSQL performance tuning, indexing, and replication.

- Experience with migration tools like AWS DMS, ora2pg, pgloader, SQL Developer, etc.

- Practical experience working with Linux environments.

- Proficient in data validation, integrity checking, and ensuring consistency in migrated datasets.

- Strong scripting skills in Bash, Python, or similar for automation and transformation tasks.

- Solid understanding of ETL processes, data pipelines, and schema refactoring.

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

- Experience as a PostgreSQL DBA, particularly with AWS RDS or Aurora PostgreSQL.

Preferred Qualifications :

- Experience with cloud database migration, especially AWS RDS for PostgreSQL or Aurora.

- Exposure to DevOps tools, CI/CD pipelines, and version control systems like Git.

- Familiarity with PostgreSQL extensions such as PostGIS, pg_partman, etc.

- Certifications in PostgreSQL or cloud platforms like AWS or Azure.

(ref:hirist.tech)

  • Database Migration Expert

    1 week ago

    Delhi, Delhi, India beBeeDataMigration Full time ₹ 18,00,000 - ₹ 25,00,000

    Database Migration SpecialistWe are seeking a highly skilled Database Migration Specialist to lead and execute database migrations across diverse technologies.Key Responsibilities:Develop comprehensive migration strategies, including data mapping, transformation, and validation processes.Ensure optimal performance of source and target databases during and...

  • Data Migration and Integration Professional

    2 weeks ago

    Delhi, Delhi, India beBeeData Full time ₹ 1,20,00,000 - ₹ 2,00,00,000

    Job TitleIntegration SpecialistWe are seeking a highly skilled Integration Specialist to lead our data migration and integration projects. The ideal candidate will have expertise in Salesforce data migration, integration, and Apex integration.Key Responsibilities:Design and implement Salesforce data migration projects for seamless transition and...

  • Database & Cloud Advisory Specialist - SQL Server/Oracle DB

    2 weeks ago

    Delhi, Delhi, India CliqHR Full time

    Database & Cloud Advisory SpecialistWe are seeking an experienced Database & Cloud Advisory Specialist with strong expertise in SQL Server and Oracle, along with working knowledge of MongoDB (optional). The role is primarily advisory in nature, focusing on Google Cloud Platform (GCP) services such as Compute Engine, Cloud SQL, Observability, Backup &...

  • Database Expert

    2 weeks ago

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

    Senior Oracle Database SpecialistWe are seeking a seasoned Oracle database specialist to lead the administration, optimization, and security of our Oracle database landscape. This includes mission-critical systems supporting enterprise applications like SAP.The ideal candidate brings a strong background in Oracle database technologies, high availability...

  • Data Migration Specialist

    2 weeks ago

    Delhi, Delhi, India beBeeDataMigration Full time ₹ 15,00,000 - ₹ 25,00,000

    Job Title: Senior SAP Data Migration ConsultantAbout the Role:We are seeking a seasoned professional to lead and execute SAP data migration activities. The ideal candidate will have extensive experience in SAP data migration and strong functional knowledge in one or more SAP modules.Lead and execute SAP data migration activities across multiple functional...

  • DATABASE SPECIALIST

    2 weeks ago

    Delhi, Delhi, India beBeeDatabase Full time ₹ 20,00,000 - ₹ 25,00,000

    Job Title:DATABASE SPECIALISTWe are looking for a highly skilled Database Specialist to play a key role in the development, optimization, and maintenance of complex database systems. As part of our team, you will be responsible for designing, implementing, and maintaining databases to support business applications.The ideal candidate will have a strong...

  • Data Migration Professional

    2 weeks ago

    Delhi, Delhi, India beBeeDataMigration Full time ₹ 10,00,000 - ₹ 15,00,000

    As a Data Migration Specialist, you will be responsible for designing, managing, and optimizing complex data migrations. You will develop and maintain ETL/ELT processes using dbt, AWS, and Redshift to efficiently manage and transform large datasets.About the RoleThe successful candidate will have experience with customer migration or internal migration as a...

  • Database Solutions Specialist

    7 days ago

    Delhi, Delhi, India beBeeData Full time ₹ 45 - ₹ 55

    Job Opportunity:We are seeking a skilled Data Architect to join our team. The ideal candidate will possess expertise in database solutions, data modeling, and system implementation.About the Position:This role involves creating database models, evaluating requirements, and preparing design reports. Additionally, the Data Architect will oversee data...

  • Cloud Services Migration Specialist

    2 weeks ago

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

    Job Title: Cloud Services Migration SpecialistAbout the Role:The Project Lead will act as a trusted advisor with a strong customer focus in onboarding/migration into SAP GCE. They will support ECS customer migration into the Private Cloud from a project and program perspective, while advocating for the customer and bringing the power of GCE to ensure a...

  • NoSQL Database Administrator

    1 week ago

    Delhi, Delhi, India Sheryl strategic solutions Pvt. LTD. Full time

    Title : NoSQL DBA (Migrations)Location : Remote - the Role :We are seeking a highly skilled and experienced NoSQL DBA with a strong focus on database migrations to join our dynamic team. As a NoSQL DBA (Migrations), you will be responsible for leading and executing the migration of data across a diverse range of NoSQL technologies. This is a critical role...