Web Application Engineer (Oracle, SQL, PL/SQL)

Job Introduction

Serco is a specialist at delivering vital services on behalf of European, National and Local Governments.

Serco Europe employ’s a large workforce in Belgium, Luxembourg, France, Switzerland, Germany, Holland, Spain, Italy and the UK.

Our European operations have ca. 2,000 employees delivering critical services to public institutions throughout Europe. 

Role Responsibility

For our activities in ESTEC, we are currently looking for a Web application Engineer (Oracle, SQL, PL/SQL).

The holder of the above-mentioned position will support ESA/ESTEC’s Directorate of Technical and Quality Management (TEC) in the maintenance, operations, and evolution of the Directorate’s Management Information Systems. This includes updates and/or development of new applications and databases covering the following business needs:

• Planning, controlling and reporting of activities or programmes;

• Planning, controlling and reporting budget and financial resources;

• Resource management, manpower planning, time recording & charging, etc.

• Data Warehouse concepts Extract/Transform/Load applications to support reporting and business intelligence needs.

The work will be divided into the following tasks.

Task 1: Application Development.

• Support  product  owners  in  producing  software  requirements and implement  the  requirements  for  the  software  product  into  an  architecture design  and  a software design, following best software engineering practices and in agreement with ESA.
• Establish a software development methodology and document the architectural  design and software  design.
• Establish  and  maintain  development,  testing  and  production environments  suitable to  install  and  execute  source  code  components.
• Document  and  execute  tests  for  each  software  unit  and integrated software component ensuring that  it satisfies its requirements  and document the results.
• Document  and  establish  a  deployment  plan  in  agreement  with ESA before each software rollout.
• Provide  a  user  manual  and  an  operations  and  maintenance manual  for each  stand-alone  software  product  developed.

Task 2: Application Maintenance and Operations.

• Perform  corrective  maintenance  in  response  to  user  reported problems for applications.
• Software Problem Reports raised by the users, the successful applicant shall take immediate action to find and implement the solution in the shortest possible time.
• Define the criteria for software problem (bug) criticality.
• Define  the  criteria  for  bug  reporting,  fixing  and  deployment  in production  environment.
• Establish and maintain  a software configuration control and operational plan.

Task 3: Application and User Support.

• Provide a first line of support to the user community to:

1. Provide assistance   to   the   user   community   in   the   technical   and   functional  use   of   the applications  under  the  successful candidate’s  responsibility.
2. Address requests related to applications and products out of his scope to the relevant support groups in ESA.

• Provide  second  line  support  guaranteeing  specialized competencies  in all the applications in scope.
• Provide  training  on  request  to  the  user  community  for  all  the applications  in  scope.
• Log all the requests received either by phone or by email, from and sent to customers  in  the ticketing  system and perform all the necessary tasks to resolve the problem remotely either by phone or via  email in  customer  priority order.
• Provide  expert  advice  regarding  current  system  functionality:

1. for  manipulation  of    the    database    (e.g.    generation  of    specific    script    for    data upload, application  configuration,  etc.);
2.  for  configuration request  at database  level.

Successful Candidate

The successful candidate will bring a PhD or Msc Engineering from a recognised Institute of secondary studies or equivalent and minimum 4 years of experience in the tasks similar to the ones described above.

Additionally, the person shall have competence in the development of web applications and databases:

• Strong  Oracle  database  development  experience  including  SQL,  PL/SQL, performance tuning  etc.  Expert  skill  level  with  Oracle’s  Application  Express framework  (Oracle  APEX). Some  knowledge of  Oracle  RESTful  services programming.
• Strong knowledge of HTML5, JavaScript, Ajax, CSS, and JSON.
• Strong  understanding of  relational  database concepts and  data  modelling.
• Knowledge  of  Microsoft  Office  package  (Word  and  Excel),  in  particular merging  data  with templates.
• Microsoft and IBM integration via Ole automation.
• SMTP.

Moreover, applicants should have expert  knowledge  of  Data  Warehousing  principles  and concepts, and  a  strong  experience  in  Business  Intelligence  reporting  and  dashboard design  and  ETL processes and industry best practices.

The  successful candidate shall  liaise  with  the  ESA  Technical  Responsible  for  any  activity requiring coordination  with the  ESA IT corporate infrastructure  and services.

-------------

Important

Any offer of employment is contingent upon you providing documents to verify your identity and employment eligibility, as required by law.

Applicants are reminded that they will be requested to produce such documentation during the recruitment process.

Please contact a member of the recruitment team if you require further details of acceptable types of documentation required for verification of identity and work authorization. 

For positions located within the Darmstadt Support Office please note that only applicants with no family affiliation within the Company will be considered.

Data Protection:

When creating a profile on the Serco Career Centre you agreed to the Data Protection policy, a copy is available upon request.

You may submit a written request revoking your consent to this agreement at any time.

Package Description

Full details on application.

Relocation assistance provided (if applicable).

About the Company

Serco Services GmbH, part of the Serco group, A FTSE250, Multi-national Service Provider with over 50,000 employees worldwide.

Serco’s space heritage over the last 40 years has placed us in the Space News Top 50 Space Industry Manufacturing and Services Companies - We work alongside EUMETSAT and the European Space Agency, where we are the largest on-site service provider with ca. 300 staff.

What connects the ever growing Serco workforce is a passion for delivering great service – To keep ahead we have to constantly evolve and enhance the way we deliver our services and everyone in Serco has a role to play here.

Serco provide the right environment to encourage ideas and a comprehensive Best Practice support network that enables them to put their ideas into action.

If you share our values then join with over 50,000 colleagues globally who are equally as passionate about delivering great service as you.

Serco European Agencies