IS Senior Technical Expert- PL/SQL Developer

IS Senior Technical Expert- PL/SQL Developer
Barcelona, Spain Hybrid

Our Digital team doesn’t just see the future – they create it.
As our IS Senior Technical Expert- PL/SQL Developer, you will be a key part of our diverse digital workforce and ensure that dsm-firmenich will make a big shift in an agile way of working. You’ll be one of the innovative minds behind leading dsm-firmenich to ensure our products are developed, produced, and labelled according to legal, regulatory and compliance standards. You will understand and develop digital solutions to facilitate product compliance processes.

If you’re passionate about the future of our society and the planet we all share, and you want to make your mark on the world, you’ve found the right match in the dsm-firmenich family.

At dsm-firmenich, being a force for good is not optional. Diversity, Equity & Inclusion is a shared responsibility woven into our daily work, benefiting to our People, Customers & Communities and driving business value.
Equal access to opportunities is a given, belonging is a shared feeling, authenticity is celebrated.

As our IS Senior Technical Expert in this cluster you will focus on designing, building, and maintaining compliance solutions for product and ingredient management. Your Key Responsibilities:

• Together with product development and compliance teams across our businesses understand new opportunities and translate them into digital solutions.
• You will collaborate closely with stakeholders to understand business requirements and desired capabilities, understand the value to dsm-firmenich and provide constructive challenge where appropriate.
• Be accountable for executing the technical solution design considering customer & user experience, target audiences, data modelling and relationships. This includes integration implications with other internal and external platforms, functional logic, etc.
• You will own and manage the performance & support of key applications, provide technical knowledge to the Business and within the IS team to ensure project delivery & sustainable support of our solutions.
• Be accountable for technical development of new and improvements of existing applications as part of projects, ensuring coordination with other team members. In particular:
  • Act as a full-stack developer to design innovative solutions and maintain applications & services hosted on Oracle database and various front end (View JS, Oracle Forms …)
  • Modelize the data, build and manage DB schema on Oracle DB.
  • Contribute to the UI/UX design of new applications.
  • Implement API (stored procedures, functions, triggers) using PL/SQL or Web Service (Json, XML …)
  • Monitor and troubleshoot issues on batch data jobs.
  • Design, Develop and maintain Oracle database applications using the PL/SQL programming language.
  • Optimize database performance by tuning SQL queries and PL/SQL code.
  • Develop & execute test plans to ensure quality and accuracy of applications and PL/SQL code.
  • Troubleshoot and resolving issues on heterogeneous set of system (Oracle DB, Unix, Windows, ESB, Rabbit MQ …)

    We’re creating the pipeline of the future by digitizing everything we do – from our scientific solutions right through to finance and manufacturing.
    Our digital shift focuses on five key areas:

    • Automation at scale, no manual repetitive work.
    • Analytics at scale, insight driven decision making.
    • Partnerships and ecosystems, working closely and integrated with strategic partner.
    • Truly agile in business, multiple cross functional teams, working in an agile way.
    • Workforce of the future, all business roles digital capable.

      We’re led by an inclusive group of digital entrepreneurs who use insight to drive our business forward, meaning you can be part of a digital community that combines big ideas with bright solutions for all parts of our business. Together, we can build our capabilities using cutting-edge technology and shape an agile business that’s ready for what’s ahead.

      What does this all mean for you? Because of these developments you will be able to learn and grow, expanding your expertise and career, all with support from our internal learning and development opportunities.

      As our IS Senior Technical Expert- PL/SQL Developer, you will be part of the Digital and Tech function, reporting directly to the Chapter Lead. We bring:

      • A rich history and a promising future of bold scientific innovation and passionate creation with our customers.
      • The opportunity to work for a company where sustainability is much more than a claim and is core to our strategy and purpose.
      • A space to grow by encouraging and supporting curiosity and an open mindset.
      • A flexible work environment that empowers people to take accountability for their work and own the outcome.
      • Barrier-free communities within our organization where every employee is equally valued and respected – regardless of their background, beliefs, or identity.
      • A firm belief that working together with our customers is the key to achieving great things You bring:
        • Working experience in application development (i.e., Chemical Industry, Pharma, Healthcare, Consumer Packaging Goods Co, or Consultancy).
        • A solid understanding of digital product development in the process industry.
        • Experience in turning business ideas into digital tools.
        • Primary Development Skills and experience: ETL and PL/SQL, Data analysis/ Tuning.
        • A solid understanding of IT infrastructure (network, middleware technology, cyber security aspects).
        • Minimum bachelor’s degree with technical focus.
        • Fluency in English. Desirable:
          • Development skills (e.g., Python / VueJS).
          • Experience in application infra-structure support.
          • Interest in ElasticSearch, AI, Queueing technology.

            dsm-firmenich is fully dedicated to inclusion because when people feel engaged and empowered, their creativity and innovation drives unprecedented progress. We aim to build a workplace where opportunity really is equal, so everyone can thrive. We do not discriminate: (here,) there’s a place for everyone with us.

            dsm-firmenich is an Equal Opportunity and Affirmative Action Employer. Our people are as diverse as our customers. For us that includes a commitment to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job-related reasons regardless of an applicant's race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, marital status, genetic information, protected veteran status, or any other status protected by law.

            We are committed to providing reasonable support for disabled applicants in our recruiting process. Should you need assistance, and are comfortable to share this, please let us know.

            As innovators in nutrition, health, and beauty, dsm-firmenich reinvents, manufactures, and combines vital nutrients, flavors, and fragrances for the world’s growing population to thrive.
            With our comprehensive range of solutions, with natural and renewable ingredients and renowned science and technology capabilities, we work to create what is essential for life, desirable for consumers, and more sustainable for the planet.

            dsm-firmenich is a Swiss-Dutch company, listed on the Euronext Amsterdam, with operations in almost 60 countries and revenues of more than €12 billion.
            With a diverse, worldwide team of nearly 30,000 employees, we bring progress to life™ every day, everywhere, for billions of people. www.dsm-firmenich.com

            Please note this is a direct search led by dsm-firmenich. We only accept applications from candidates, not from agencies nor subject to agency’s fees, percentages or similar.

            #ext

            #ext