Data Devops => Please read the full job description carefully
Federal Police – General Judicial Directorate (DGJ)

Work Environment

The Federal Judicial Police is a specialized police force, mainly responsible for combating organized crime in all its forms. It is one of the three general directorates of the federal police and focuses on investigative files in areas such as cybercrime, terrorism, major organized crime, drug trafficking, and many others. It provides support and expertise to the entire integrated police, as well as to its national and international partners.

Within this directorate are the operational resources assigned to judicial police operations, the fight against serious and organized crime, special units, as well as technical and scientific police operations. To support these operational directorates, such as the DGJ, from an IT perspective, there is the Directorate of Police Information and ICT Resources (DRI). Its mission includes setting up, industrializing, and maintaining transversal IT resources serving the entire integrated police, thereby also supporting the operational processes of the DGJ. To provide optimal support to these processes, certain resources under the DGJ are directly integrated into the DRI and deployed on the most critical tasks responding to operational needs. You will therefore be attached to the DRI, in direct support of the DGJ's processes. Your priorities will be defined jointly with the DGJ, in a spirit of co-creation.

You will mainly be required to maintain existing systems while deploying new technologies in the field of databases, some of which will be specifically dedicated to data exploitation using artificial intelligence. As a liaison between the General Judicial Directorate and the Directorate of IT Resources, you will play a central role in these developments.

For certain transversal application projects integrating relational databases, you will be the reference person for aspects related to their performance and security.

In general, you will be involved throughout the entire technology cycle: from researching solutions to implementation, including backup management, structure or technology migrations, as well as the deployment and industrialization of solutions via CI/CD mechanisms.

Main Tasks

During the first phase of your mission, you will be required to:

• Get acquainted with the existing setup and familiarize yourself with the different environments.

• Participate in the maintenance and evolution of current database systems. These are mainly relational databases (PostgreSQL) and non-relational databases (Elastic Search). For some of them, such as those dedicated to R&D projects, it may be necessary to set up automated Backup procedures (which already exist for the others).

• Provide support to development teams responsible for maintaining legacy software. Due to the DB First approach used in these projects, an expert profile in databases is required, mainly for aspects related to data structure migration and replacing stored procedures with backend functionalities.

• Participate in the maintenance and integration of a centralized logging platform for application projects. This platform is based on Kafka.

During the second phase of your mission:

• You will continue your maintenance activities on the solutions described above.

• You will participate in the evolution of a widely deployed solution within the federal police for managing investigations and drafting official reports. In this context, you will be involved in aspects related to performance and security improvements.

• You will also be involved in continuous integration and continuous deployment (CI/CD) aspects. Deployments are performed both on traditional servers and on container orchestrators such as Kubernetes or OpenShift.

• You will participate in setting up environments for specialized databases, such as Graph DB (Neo4j) and Vector DB (Milvus), to support Data department projects.

• You will implement or maintain automated processes, particularly for managing migrations and backups.

• You will work in an agile mode, focusing on planned tasks and meeting established deadlines.

Profile Sought

• You hold a bachelor's degree in IT (at minimum) and have several years of experience in a similar role.

• You have strong knowledge of relational databases (PostgreSQL) and non-relational databases (Elasticsearch). You are able to install this type of environment and industrialize it, notably through scripting and development in Python.

• You have good knowledge of distributed messaging systems (Kafka) and are able to maintain and industrialize them.

• You have expertise in database migration, and working closely with developers using a code-first approach comes naturally to you.

• You have knowledge of Graph DB (Neo4j) and Vector DB (Milvus), or are willing to acquire it quickly in order to help set up these platforms.

• You are able to participate in data structure modeling and implement standardization across the various systems used in projects.

• You also master the Git versioning platform and the strategies to apply in branch management.

• Knowledge and experience in DevOps, CI/CD, GitOps, GitLab, Kubernetes cluster management are also desired.

• You are used to working in an agile environment, according to the Scrum methodology, and are able to quickly adapt to a change of technical direction during a project, or even to a technology you do not yet master.

• Persistent and solution-oriented, you easily integrate into a team with varied profiles.

• You are fluent in English and one of the two national languages. Active knowledge of one national language and passive (at least) knowledge of the other is a real asset.

Technologies

Relational Databases: PostgreSQL (Must have), MS SQL (Nice to have)

Non Relational Databases: Elastic Search (Must have)

Distributed Messaging System: Kafka (Must have)

Version Control: GIT (Must have)

DevOps: Gitlab, CI/CD, GitOps, Kubernetes, MinIO, Python Scripting (Should have)

Graph Databases: NEO4J (Nice to have)

Vector Databases: Milvus (Nice to have)

Message Broker: Rabbit MQ (Nice to have)

Soft Skills

• Adaptability: Ability to adapt to a change in technology or strategy

• Perseverance: Not giving up at the slightest difficulty

• Team spirit: Integrating into the team's vision and thinking collectively

• Autonomy: Able to work independently once things are aligned with the team

• Technical curiosity: Not staying confined to what one already knows

• Creativity: Thinking outside the box to propose original solutions

• Solution orientation: Detecting problems but above all, proposing solutions

• Ease of integration: Integrating easily into a new environment

• Communication: Knowing how to communicate easily and whenever necessary