Retail & E-Commerce | Applications Support Engineer - Porto

at  Devoteam

• At Devoteam, we believe that technology with strong human values can actively drive change for the better. Discover how Tech for People unlocks the future, creating a positive impact on the people and the world around us. We are a global leading player in Digital Transformation for leading organisations across EMEA, with a revenue of €1B. We believe in transforming technology to create value for our clients, partners and employees in a world where technology is developed for people. We are proud of the culture we have built together. We are proud of our people at the service of technology. We are proud of our diverse environment. Because we are #TechforPeople. Join our multidisciplinary team of Cloud experts, Designers, Business consultants, Security experts, Engineers, Developers and other extraordinary talents, spread across more than 20 EMEA countries. Become one of our +10.000 tech and business leaders on cloud, data and cyber security. Let’s fuse creativity with technology together and build innovative solutions that actively change things for the better.
• Develop using PL/SQL to write complex queries and scripts to retrieve and manipulate data in Oracle databases;
• Analyze and ensure efficient transition of technical design documents and develop various SQL packages to provide support to application developers;
• Monitor and recommend changes if required to all PL/SQL packages and provide stored procedures and design and develop various relation database;
• Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components;
• Work with RMS or Retek applications and databases to provide technical support and ensure seamless integration with Oracle databases;
• Optimize SQL queries and database performance to ensure efficient data retrieval and processing;
• Collaborate with application developers to provide technical support and resolve issues related to PL/SQL packages and stored procedures;
• Participate in the design and development of new database applications, including data modeling and schema design;
• Monitor and analyze database performance metrics, identifying areas for improvement and implementing solutions to optimize database performance.
• A Bachelor’s degree in the IT area or equivalent;
• +2 years of experience with PL/SQL development;
• Experience with databases (Oracle and/or SQL);
• Experience with Oracle Forms and Oracle Reports;
• Detail-oriented, able to work independently as well as part of a team, and has strong problem-solving and analytical skills;
• Ability to communicate effectively with technical and non-technical stakeholders.
• The Devoteam Group works for equal opportunities, promoting its employees based on merit and actively fights against all forms of discrimination. We are convinced that diversity contributes to the creativity, dynamism and excellence of our organization. All of our vacancies are open to people with disabilities

Please refer the Job description for details