Description
The customer operates in environmental services, combining scientific expertise and technology to help organizations address operational and sustainability challenges. Its activities include environmental monitoring, research, and data analysis, supported by digital solutions and effective data management. The project modernizes a regulatory software platform used by a trade supervisory authority, consolidates systems, and maintains secure on-premises infrastructure.
Responsibilities
•Maintain and evolve database schemas
•Monitor and optimize database performance
•Plan and execute database and data migrations, including go-live migrations and a potential Oracle-to-PostgreSQL migration
•Support platform, system, and database updates
•Manage database backup and recovery processes and TDE (Transparent Data Encryption)
Requirements
•At least 5 years of experience in Oracle database development and administration
•Strong hands-on experience with Oracle SQL and PL/SQL
•Experience with Oracle Spatial and Oracle XE
•Experience with PostgreSQL and PostGIS
•Strong knowledge of data modeling and database schema design
•Hands-on experience with database backup and recovery processes
•Experience with Transparent Data Encryption (TDE) and database security practices
•English at Intermediate+ level or above
•German at Upper-Intermediate level or above
Nice to have
•Oracle-to-PostgreSQL database migration experience
•GIS/spatial data experience with Oracle Spatial and/or PostGIS, preferably in public sector applications
Conditions
•Up to an additional 1,000 EUR per month, depending on expertise, included in the annual bonus
•Professional, financial, and career growth opportunities
•Mentoring and onboarding systems for each new employee
•Access to the corporate training portal
•Corporate events and amenities, including parties, pizza days, PlayStation, fruit, coffee, snacks, and movies
•Certification compensation (AWS, PMP, etc.)
•Referral program
•Private health insurance and sports compensation, depending on the type of employment
•Work can be fully remote, from the office, or hybrid
•Work location: Germany
