DBA & Data Modeller - (12 Month project - Contractor)

hace 2 semanas

Barcelona, Barcelona, España Robert Walters A tiempo completo

Overview

This newly established position is designed to optimise data ownership and accountability, as well as the management of data models. The role encompasses designing and maintaining data models for transactional and analytical data stores, administering operational databases, and supporting advanced analytical workloads across cloud platforms. Additionally, it involves global oversight as an account administrator for Databricks environments.

Key Responsibilities

  • Develop new, or update existing, conceptual, logical, and physical data models as required to support core business applications and analytical tasks.
  • Administer relational databases such as Oracle, PostgreSQL, SQL Server, or MySQL to maximise reliability, performance, and data resilience.
  • Manage NoSQL databases and Databricks Delta Lake models for analytical workloads.
  • Execute performance tuning activities at the database, pipeline, and data model levels, including indexing, partitioning, caching, and compute scaling.
  • Oversee security and compliance standards, such as IAM roles, encryption policies, auditing, and implementation of least-privilege access protocols.
  • Assist with backup and disaster recovery planning to ensure business continuity within cloud environments.

Technologies & Tools

  • Databricks / Delta Lake / Spark / NoSQL
  • Cloud Platforms: AWS / Azure / GCP
  • RDBMS: PostgreSQL, MySQL, Oracle, SQL Server
  • Data Modelling: ER/Studio, ERwin, or open-source tools
  • DevOps: Git, CI/CD frameworks, Terraform
  • Scripting: SQL, Bash, Python

Required Skills

  • Advanced
    DBA
    expertise within cloud environments, demonstrating ownership of production databases.
  • Experience managing
    Databricks accounts
    and collaborating internally to advance best practices.
  • Proven ability to optimise existing
    OLTP entity-relationship (ER) data models
    and design new OLTP schemas.
  • Proficiency with ERD modelling tools (e.g., ER/Studio, Lucidchart, , or similar).
  • Skilled in designing and maintaining OLAP, NoSQL, and Data Warehouse/Data Lake architectures.
  • Strong understanding of common
    OLTP and OLAP modelling techniques
    , including Star, Snowflake, and Dimensional models.
  • Extensive technical knowledge of SQL and NoSQL databases, together with modern Data Warehouse platforms and Databricks environments.

  • Senior DBA

    hace 13 horas

    Barcelona, Barcelona, España Robert Walters A tiempo completo

    Senior DBA & Data Modeller - Contractor SpecialistClient Location: Barcelona, SpainProject Duration: 12 monthsRole Type: Contract / FreelanceOverviewEngaged as aSenior Database Administrator & Data Modellersupporting enterprise data transformation initiatives. Responsible for designing scalable data models, administering operational databases, and enabling...

  • CONTRACTOR Global Event Specialist

    hace 2 semanas

    Barcelona, Barcelona, España Quorum Software A tiempo completo

    CONTRACTOR Global Event Specialist – 6-7-month fixed term contractLocation: Barcelona, SpainModel of Work: HybridAre you excited by challenges? Do you enjoy working in a fast-paced, international and dynamic environment? Then, now is the time to join Quorum Software, a rapidly growing company and industry leader in oil & gas transformation.Quorum Software...

  • Solutions Architect

    hace 7 días

    Barcelona, Barcelona, España TechShack A tiempo completo

    Solutions Architect (Marketing/CDP) – Remote – €350-€400/day – 12 monthsI'm working with a consultancy who are looking to hire aSolutions Architect (Marketing/CDP)on a contract basis for an initial 12-month assignment. The role is fully remote, with occasional paid travel to Barcelona for key project sessions.Skills required:Experience designing...

  • Contractor Fullstack Developer

    hace 7 días

    Barcelona, Barcelona, España Codurance A tiempo completo

    Remote: you can be based from anywhere within Spain. We mention Barcelona (where we have the main office) as some job boards require a specific city to be listed.About usCodurance is a boutique IT consultancy. One of the good onesIt's not just about making code that works, we're passionate about crafting quality software which translates to applying Extreme...

  • DBA Architect

    hace 7 días

    Barcelona, Barcelona, España Page Personnel A tiempo completo

    Perfil buscado (Hombre/Mujer)• Achieves organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases.• Maintains database by determining structural requirements, and developing and installing solutions.• Ensures security of all information and computer systems and digital...

  • Digital Project Manager

    hace 1 semana

    Barcelona, Barcelona, España OgilvyES A tiempo completo

    Imagine yourself at Ogilvy.Imagine you can help brands grow and increase their positive impact on society in a creative and relevant way. And at the same time, you also grow. At Ogilvy, that's our mission. We achieve this by bringing in people who are creative, strategic, bold, disruptive, curious, detail-oriented, proactive, enthusiastic, analytical,...

  • Data Scientist

    hace 1 semana

    Barcelona, Barcelona, España ERNI Spain A tiempo completo

    Can you imagine contributing to an exciting project in the field of data science and robotics? Join our expert team to work in the robotics sector, contributing to the optimization and analysis of data for intelligent systems. You'll apply your knowledge in data science and machine learning to extract valuable insights and improve processes.At ERNI, you're...

  • Data Scientist

    hace 7 días

    Barcelona, Barcelona, España ERNI Schweiz AG A tiempo completo

    About the positionCan you imagine contributing to an exciting project in the field of data science and robotics? Join our expert team to work in the robotics sector, contributing to the optimization and analysis of data for intelligent systems. You'll apply your knowledge in data science and machine learning to extract valuable insights and improve...

  • Project Manager Logistic

    hace 1 semana

    Barcelona, Barcelona, España Turner & Townsend A tiempo completo

    Description de l'entreprise Turner & Townsend is a global professional services company with over 22,000 people in more than 60 countries.Working with our clients across real estate, infrastructure, energy and natural resources, we transform together delivering outcomes that improve people's lives. Working in partnership makes it possible to deliver the...

  • Project Manager Logistic

    hace 5 días

    Barcelona, Barcelona, España Turner & Townsend A tiempo completo

    Description de l'entreprise Turner & Townsend is a global professional services company with over 22,000 people in more than 60 countries.Working with our clients across real estate, infrastructure, energy and natural resources, we transform together delivering outcomes that improve people's lives. Working in partnership makes it possible to deliver the...