Oracle Database Administrator

The job

As part of our global ERM development team, you'll collaborate with a team of skilled software engineers in designing and implementing of both on Premise and Cloud solutions. You'll act as an expert and trusted advisor who provides guidance for transforming legacy database implementations to the cloud and migrating away for Oracle to PostgreSQL. This varied role will see you work closely with clients, partners and other internal teams to ensure consulting engagements are successful.

Key responsibilities

• Performance Tuning: Troubleshoot performance problems, fine-tuning database and index analysis, In Oracle.
• Support Cloud Databases hosted in AWS and Azure to support our SAAS solutions in cloud, as well as our on-premise infrastructure for development
• Participate in Scrum meetings with other team members including sprint planning and estimating; backlog refinement; daily Scrum meetings; sprint retrospectives and sprint reviews.
• Support developers in performance tuning PL/SQL, functions, packages, and procedures.
• Take part in the journey to move the product further towards a Cloud Native solution.

Ideal experience

• You have a solid understanding of Cloud Database and managed services, preferably in AWS and Azure.
• Have experience work with Postgres, and NoSQL database such as Mongo, DynamoDB, Cosmos.
• Understanding of data structures and algorithms.
• Required to have good working experience on performance tuning, troubleshooting, and debugging in Oracle.
• Understanding of Clean code, SOLID principles & Design patterns
• Good communication skills, working with a broad range of people, including Product Owners, Testers.
• Extensive experience in managing and tuning Oracle database.
• Positive approach to problem solving with a can do attitude.
• Ability to switch role as individual contributor as well as a team player with cross culture and distributed teams.
• Experience of software development methodologies and processes like Agile, SCRUM, Kanban is desirable.
• Experience in writing unit test cases will be an added advantage.
• Experience of working with Database in Containers such as Docker K8's is desirable too.

Great skills to have

• Organization: The pace at AVEVA can be exciting and fast, so whilst you will need excellent time management and effective prioritisation, we will do all we can to support a balanced portfolio of work, and your wellbeing.
• Customer focus: You'll be working directly with our customers. Being able to listen to them and understand their requests, and then address them in a proactive and consultative manner, will be part of your day-to-day.
• Problem-solving: You'll need to enjoy getting stuck into problems. Troubleshooting and solving challenging problems is a big part of this role.