Database Developer
EUROPEAN DYNAMICS, Spain
Job Description
We currently have a vacancy for a Database Developer fluent in English, to offer his/her services as an expert who will work remotely. In the context of the first assignment, the successful candidate will be integrated in the team of the company that will closely cooperate with a major client’s IT team on site.
Your tasks
- Collaborate with the project manager, business analyst and Salesforce team to analyze SES requirements from the respective 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 as well as maintain existing SES instances that are already deployed on Oracle databases and the Azure cloud databases (Microsoft SQL Server and Azure Synapse);
- Perform unit testing to ensure the salesforce data integration into data warehouse;
- 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.
Requirements
- University degree and minimum 4 years of experience in PL/SQL development on Oracle and T-SQL development on Azure SQL;
- Experience in UNIX/LINUX shell scripting;
- Experience with the complete systems development lifecycle process as well as ETL processes;
- Experience using Microsoft Azure, preferably Azure ADF;
- Expert knowledge of Salesforce and data integration in Oracle and Azure Synapse as well as Oracle internals and database tuning including creating database schemas, tablespaces, and all other related DDL;
- Knowledge of sales cloud and marketing cloud, as well as Salesforce Object Query Language (SOQL) language;
- Excellent command of the English language.
Benefits
If you are seeking a career in an exciting and dynamic company, where you will offer your services as part of a team of a major European Institution, operating in an international, multilingual and multicultural environment where you can expect real chances to make a difference, please send us your detailed CV in English, quoting reference (16598/02/2024).
We offer a competitive remuneration (either on contract basis or remuneration with full benefits package), based on qualifications and experience. All applications will be treated as confidential.
EUROPEAN DYNAMICS (ED) (www.eurodyn.com) is a leading Software, Information and Communication Technologies company, operating internationally (Athens, Brussels, Luxembourg, Copenhagen, Stockholm, London, Nicosia, Hong-Kong, Valetta, etc). The company employs over 1000 engineers, IT experts and consultants (around 3% PhD, 36% MSc and 53% BSc or equivalent). We design and develop software applications using state-of-the-art technology. The group generates annual revenues in the range of EURO 40 million, with an EBITDA in the range of 20%. The value of our contract portfolio exceeds EURO 250 million. EUROPEAN DYNAMICS is a renowned supplier of IT services to government institutions, multinational corporations, public administrations and multinational companies, research and academic institutes.
As part of our dedication to the diversity of our workforce, we are committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, disability, sexual orientation, gender identity, or religion.
EUROPEAN DYNAMICS (ED) adheres to the General Data Protection Regulation principles by applying its Privacy Policy as published in www.eurodyn.com/privacy. By submitting an application to this position and by sharing your personal data with ED, you acknowledge and accept its Policy and authorise ED to process your personal data for the purposes of the company's recruitment opportunities, in line to the Policy.