Freelance Database Architect / Open Source DBA
Greater Copenhagen 10-04-2019 One year
Our finance client needs to move from Oracle DB to Open Source and need a freelance Data Architect with ten to 15 years of experience / Open Source DBA.
- Must be able to make the change from Oracle to Open Source and must know the three to five best open source products and their pros and con, compared to Oracle.
- Must have seen and tried how a DB Oracle landscape can be transformed into open source databases.
- Knowledge of finance
- You have done this before
- Nice to have: Offshore / nearshore experience
Phase 1: Make an assessment and describe how the database structure should be in the future
Phase 2: Describe and build the platform
Phase 3: Take care of all the integrations and the data migration.
End of phase 1: 30-06-2019
Phase 2: August 2019 – 31-12-2019 – Building the platform
Phase 3: 1-1-2020 – The migration starts
|• Analysing and migrating data from legacy systems to new solutions|
|• Designing conceptual and logical data models and flowcharts|
|• Improving system performance by conducting tests, troubleshooting and integrating new elements|
|• Optimising new and current database systems|
|• Coordinating with the Data Science department to identify future needs and requirements|
|• Developing strategies for data acquisitions, archiving recovery and implementing a database|
|• Developing key metrics for tests on data and ensuring integrity of same on data architecture|
|• Preparing documents for data architecture and maintaining knowledge on large data structure as well|
|• Analysing information flow and recommending appropriate technology to provide support
to all business processes
|• Participating in all technical discussions and providing technical inputs wherever possible|
|• Being able to address issues of data migration (validation, clean-up and mapping)
and understanding the importance of Data Dictionaries
|• Software installation and maintenance, data extraction, transformation and loading
with Specialized Data Handling.
Support new schema models and support new application issues related to new DB.
|• Newer role, but responsible for merging data from multiple sources into a data warehouse.
May have to design warehouse, but cleans, standardises and scrubs data before loading.
In SQL Server, this DBA would use DTS heavily.
|• Works on building queries and stored procedures etc. that meet business needs.
This is the equivalent of the programmer. You primarily write T-SQL.
|• Design schemas. Build tables, FK’s and PK’s etc. Work to build a structure that meets the business needs
in general. The design is then used by developers and development DBA’s to implement the actual application.
Heidi Kelman Christensen
T: +45 5352 8899
Please also upload your CV at https://lnkd.in/ervSi52
Ønsker du at søge stillingen, eller har du spørgsmål kan du kontakte Heidi Kelman Christensen og høre nærmere. Hvis du ansøger pr. mail, så husk at vedhæfte dit CV.