Required skills
- PostgreSQL
- Java
- PL/SQL
- PL/pgSQL
- Database Migration
- Oracle Database
- EXPLAIN ANALYZE
- Server Configuration
- Database Indexing
- Locking Mechanisms
Languages: German
Job description
Experienced PostgreSQL developer needed for a remote project involving Oracle to PostgreSQL database migrations and optimizations.
Project overview
We are looking for an experienced software developer with a focus on PostgreSQL for a remote project with occasional on-site presence. You will be involved in the migration and optimization of database environments, playing a central role in the conversion of Oracle databases to PostgreSQL.
Your tasks include the conception and execution of complex database migrations, including schema, data, and logic transfer. You will optimize PostgreSQL environments, analyze and improve slow queries using EXPLAIN ANALYZE, and work on index structures as well as server configurations. Furthermore, you will port complex PL/SQL code to performant PL/pgSQL and use professional migration tools.
A minimum of three years of professional experience as a software developer in a Java environment is required, as well as several years of practical experience with PostgreSQL. Two successfully completed Oracle-to-PostgreSQL migrations, solid knowledge of locking mechanisms, advanced index types, and CI/CD tools for databases are advantageous. Experience with microservices and containers is desirable. Experience in the public sector is a plus.
The project runs until the end of 2027 with full-time utilization. Collaboration with the on-site team is desired but will be predominantly remote. Start date is as soon as possible.
Project details
- Start: asap
- Duration: asap - 31.12.2027
- Remote: onsite
- Location: Wiesbaden, DE
- Rate: unknown-70 EUR/h
- Languages: German
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on nexus.webconia.de