The Oracle PL/SQL Developer is responsible for helping enhancing functionality and improving performance of one huge PL/SQL code set that is used in multiple, globally located production databases. The PL/SQL developer should help to enhance the code by using Oracle Enterprise Edition features such that the decentralized standard edition architecture can change into a high performance, enterprise database for many, many offices, projects and users.
The database code set is used for EDB, a homegrown Engineering Data Base System which manages piping lists, valve lists, equipment lists, Instrument lists, datasheets and requisition documents. The system is a configurable system which can be customized per project, per client by administrators and key users. It also has many interfaces to other applications and engineering systems. These interfaces can also be customized per project, per client. The system has been developed by a small number of people (The Netherlands, India, Canada) and is being used by many Jacobs offices in many countries (England, Ireland, India, US). The target is to grow the current user base, and support more projects every day.
The database code set is also used with Endeavour which uses the database to load engineering data from several engineering systems, compare the data, guarantee quality etc. When engineering data is to be handed over to Jacobs's clients, the database is used as central delivery system.
- Maintaining the Oracle database tables (> 100 tables)
- Maintaining the PL/SQL stored procedures, functions and packages (> 600 procedures/packages, > 500,000 lines of code)
- Improve performance by using Oracle Enterprise Edition features
- Writing scripts/procedures to archive/restore/copy projects
- Writing scripts/procedures to update project definitions
- Redesign areas of the database to improve performance
- Requires 5+ years experience with complex Oracle databases as PL/SQL developer
- Excellent conceptual thinker as the database is very abstract
- Can understand work-processes and data integration issues
- The ability to work within a team environment or autonomously as required
- Great communication skills in English to facilitate working with a team located all over the globe
- Master's degree in Computer Sciences or any Engineering Discipline
- International working environment and unique company culture.
- Personal development opportunities.
- Friendly atmosphere in dynamic team.
- Full time employment contract with salary corresponding to qualification.
- Benefits package including medical care, insurance, sport activities and other.
- Independent role and flexible working hours.