Required skills
- PostgreSQL
- Oracle to PostgreSQL Migration
- PL/SQL
- PL/pgSQL
- EXPLAIN ANALYZE
- Database Indexing
- Server Configuration
- Database Migration Tools
- CI/CD
- Database Locking
- Microservices
- Containers
Languages: German
Job description
Experienced PostgreSQL Developer sought for a challenging public sector database project involving Oracle to PostgreSQL migration. The role is primarily remote with occasional on-site presence.
Project overview
We are looking for an experienced PostgreSQL Developer for a challenging database project in the public sector. The position is remote with occasional on-site presence possible.
Responsibilities
You will support a development team in migrating a large Oracle database environment to PostgreSQL. Your main tasks include the conception and execution of the migration, including schema, data, and business logic. You will optimize the new PostgreSQL environment, analyze and improve slow queries using EXPLAIN ANALYZE, and optimize index structures as well as server configurations. Furthermore, you will port complex PL/SQL code structures into performant PL/pgSQL and use professional migration tools.
Requirements
We offer a remote-friendly way of working with flexible on-site presence. Teamwork and independent work are essential.
- At least 3 years of professional experience as a software developer, preferably in a Java environment
- Several years of practical experience with PostgreSQL
- Proven experience with Oracle to PostgreSQL migrations
- Solid knowledge of migration tools and CI/CD tools for databases
- Understanding of locking mechanisms and advanced index types
- Experience with microservices and container technologies
- Quick comprehension of complex data schemas
- Experience in the public sector is an advantage
Project details
- Start: flexible
- Remote: onsite
- Location: Wiesbaden, DE
- Languages: German
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on nexus.webconia.de