Database Developer 100% remote

For project of United Nations and to perform 100% remote, Norconsulting Group is looking for a Database Developer

📍 100% Remote project📜 Freelance (b2b) Contract. 12+ months + extensions💰 Rate: 100 usd/day (1800 usd/month) ❗ 4+ years of professional experience

Job Description

Objective

United Nations requires a full-time database developer to work on a high profile project. The ideal candidate will have Oracle PL/SQL and Salesforce data integration experience where data is moved from source to staging and further transformed into reporting schemas.

This is a remote full-time position. The consultant will report to a section manager and work within a team dedicated to the ramp up of an initiative called Supporter Engagement Strategy (SES) at United Nations.

Key Deliverables - The selected resource will perform the following activities:

• Collaborate with the project manager, business analyst and Salesforce team to analyze SES requirements from the respective United Nations country offices.• Design and implement new roll-up calculations in collaboration with the in-house backend team and the project manager.• Integrate with Azure ADF pipelines to facilitate the extraction, movement, and loading of Salesforce data.• Write UNIX/LINUX Korn shell scripts to schedule data processing and data loads.• Enhance PL/SQL and TSQL procedures in Oracle and Azure SQL DB/Synapse respectively to maintain and enhance SES structures.• Perform unit testing to ensure the salesforce data integration into United Nations data warehouse.• Maintain existing SES instances that are already deployed on Oracle databases and the Azure cloud databases (Microsoft SQL Server and Azure Synapse).• Write documentation to describe the process and to record production configuration including ER models, data models, and production procedures.• Regularly monitor the data loads and tune performance as needed for the SES refresh database and reporting environment.

The skills and experience required for this assignment are:

• 4 years or more hands-on experience in PL/SQL development on Oracle.• 4 years or more hands-on experience in T-SQL development on Azure SQL.• Expert knowledge of Salesforce and data integration in Oracle and Azure Synapse.• Advanced knowledge of Oracle internals and database tuning including hands-on experience creating database schemas, tablespaces, and all other related DDL.• Proven experience in UNIX/LINUX shell scripting.• Knowledge of ETL with hands-on experience using ETL.• Knowledge of cloud tools with experience using Microsoft Azure, preferably Azure ADF.• Knowledge of sales cloud and marketing cloud, as well as Salesforce Object Query Language (SOQL) language.• Experience with the complete systems development lifecycle process.· Excellent communication skills (written and verbal).• Ability to write technical documentation (use cases, configuration instructions, and models) for both technical and non-technical audiences.• Ability to work with a team as well as independently in an overall multi-cultural environment and gender sensitive work environment.

Language Requirements: Fluency in English is required.

Engagement type:This engagement will be contracted on a full-time basis for 5 days per week Monday-Friday.The candidate should be prepared to work to cover CET and EST time zones (until noon).

Key Skills

• Azure