Data Devops => Please read the job description thoroughly
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 case files related to areas such as cybercrime, terrorism, major crime, drug trafficking, and many others. It provides support and expertise to the entire integrated police force, 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 is, among other things, to set up, industrialize, and maintain transversal IT resources serving the entire integrated police, thereby also supporting the operational processes of the DGJ. To ensure optimal support for these processes, certain resources under the DGJ are directly integrated into the DRI and mobilized on the most critical tasks responding to operational needs. You will thus be attached to the DRI, providing direct support to 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 matters related to their performance and security.

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

Main Tasks

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

• Get familiar with the existing systems and the various 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 others).

• Provide support to the 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 the replacement of 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 assignment:

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

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

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

• You will participate in the establishment of environments dedicated to specialized databases, such as Graph DB (Neo4j) and Vector DB (Milvus), to support the projects of the Data departments.

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

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

Profile Sought

• You hold a bachelor's degree in computer science (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 such environments and industrialize them, 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 in a code-first approach comes naturally to you.

• You have knowledge of Graph DB (Neo4j) and Vector DB (Milvus), or are willing to acquire them quickly in order to contribute to the implementation of these platforms.

• You are able to participate in the modeling of data structures and to implement standardization across the different systems used in the projects.

• You are also proficient with the versioning platform Git and the strategies to apply regarding 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 can quickly adapt to a change in technical direction during a project, or even to a technology you are not yet familiar with.

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

• You are proficient in English and one of the two national languages. Active knowledge of one national language and passive (at minimum) 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 of technology or strategy.

• Perseverance: Not giving up at the slightest difficulty.

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

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

• Technical curiosity: Not staying confined to what you already know.

• Creativity: Thinking outside the box to propose original solutions.

• Solution-oriented: Detecting problems but above all proposing solutions.

• Ease of integration: Integrating easily into a new environment.

• Communication: Being able to communicate easily and whenever necessary.