Technical Skills:
Mandatory:
* Expertise in Oracle DB Versions - 11G, 12C,19C with hands on SQL, PLSQL
* Experience in PostGreSQl Version - 12 and above with hands knowledge of PL/pgSQL
* Additional tools:
- SQL*Plus/SQL Developer/PLSQL Developer/TOAD for Oracle (minimum two)
- pgAdmin for Postgres
- GHCP (GitHub CoPilot), GIT repository
- Any other AI tools
Added Advantage:
* Knowledge on Migration Tool can be added advantage: Ora2Pg, PGLoader or any migration tools used in Azure.
* Basics of Java, Shell scripting, Jenkins etc.
* EDI domain
Tasks:
* Migration of Oracle Databases to an OpenSource Database (E.g. PostGreSQL)
* Develop and Understands schemas, tables, triggers, indexes, sequences, constraints in any of the DBs (Oracle , PostgreSQL , MariaDB)
* Understand business requirements and accordingly develop and design database models and schemas.
* Knows Database scripting with stored functions/procedures/packages/triggers etc
* Provide optimal design solutions to improve system quality and efficiency.
* Write ETL codes, update SQL statements and create shell scripts.
* Follow best practices for database design.
* Maintain technical documentations for reference purposes.
* Coordinate activities with Team
Soft Skills:
* Fluent in English
* Ability to work on complex issues with Strong problem-solving skills
* Good inter-departmental communication skills
* Good Team Player
Apply online on this page, email your CV to Mancraft@mancraftconsulting.com, or WhatsApp Mancraft Consulting on +91 99530 68212.