enda

Freelance Database Architect / Open Source DBA

Greater Copenhagen 10-04-2019 One year
About the position

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.

Experience:

  • 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

Project Phases

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.

Language: English

Duration:

Starting: 10-04-2019

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

Responsibilities:

• 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.

Contact:

Heidi Kelman Christensen

T: +45 5352 8899

E: heidi@dba-consult.dk

Please also upload your CV at https://lnkd.in/ervSi52

Apply for job

If you want to apply for the job or have further questions, please contact Peter Heide Heidi Kelman Christensen and learn more. If you apply per. mail, please remember to attach your CV.

+45 5352 8899
heidi@dba-consult.dk