Oracle DB Developer in Bengaluru

Job description

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

How to apply

Apply online on this page, email your CV to Mancraft@mancraftconsulting.com, or WhatsApp Mancraft Consulting on +91 99530 68212.