Resume Score
CV/Résumé Score
  • Expertini Resume Scoring: See how well your CV/Résumé matches this job: Database Migration Specialist Oracle DB.
Bengaluru Expertini

Urgent! Database Migration Specialist - Oracle DB Job | Mobile Programming LLC

Database Migration Specialist Oracle DB



Job description

<p><b>Job Description :</b><br/><br/>Job Title : Database Migration Specialist<br/><br/>Experience : Overall 6+ Years, 5+ Years Relevant<br/><br/>Location : Bangalore<br/><br/>Budget : 21 LPA Max<br/><br/><b>Job Role :</b><br/><br/><b></b>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 :<br/><br/>- Migrate Oracle databases to open-source databases (e.g., PostgreSQL).<br/><br/>- Develop and manage schemas, tables, triggers, indexes, sequences, and constraints in Oracle and PostgreSQL.<br/><br/>- Analyze business requirements and design appropriate database models and schemas.<br/><br/>- Write and optimize database scripts, including stored functions, procedures, packages, and triggers.<br/><br/>- Provide optimal database design solutions to improve system quality and efficiency.<br/><br/>- Write ETL scripts, update SQL statements, and develop shell scripts for automation.<br/><br/>- Follow best practices for database design, security, and optimization.<br/><br/>- Maintain comprehensive technical documentation for reference.<br/><br/>- Collaborate effectively with the team to ensure seamless database migration and :<br/><br/>- Strong experience in Oracle DB Versions 11G, 12C, 19C with hands-on SQL and PL/SQL.<br/><br/>- Expertise in PostgreSQL Version 12+ with hands-on PL/pgSQL development.<br/><br/>- Proficiency in database migration tools like Ora2Pg, PGLoader, or any Azure migration tools (added advantage).<br/><br/>- Knowledge of additional tools: SQL-Plus, SQL Developer, PLSQL Developer, TOAD for Oracle (minimum two), pgAdmin, OmniDB.<br/><br/>- Basic understanding of Java, Shell Scripting, Jenkins (added advantage).<br/><br/>- Experience in the EDI domain (added advantage).<br/><br/><b>Technical Skills :</b><br/><br/><b>Mandatory Skills :</b><br/><br/> - Oracle DB (11G, 12C, 19C) - SQL, PL/SQL<br/><br/> - PostgreSQL (12+) - PL/pgSQL<br/><br/> - Database tools - SQL-Plus, SQL Developer, PLSQL Developer, TOAD for Oracle (minimum two), pgAdmin, OmniDB<br/><br/><b>Added Advantage :</b><br/><br/> - Database Migration Tools - Ora2Pg, PGLoader, Azure Migration Tools<br/><br/> - Basics of Java, Shell Scripting, Jenkins<br/><br/> - EDI Domain Knowledge</p> (ref:hirist.tech)


Required Skill Profession

Computer Occupations



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your Database Migration Potential: Insight & Career Growth Guide


Advance your career or build your team with Expertini's smart job platform. Connecting professionals and employers in Bengaluru, India.