Database Migration Specialist - Oracle DB

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