Database Developer
Database Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Mandatory:
* Expertise in Oracle DB Versions 11G 12C19C 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 OmniDB etc.
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
Employment Type
Full Time
