Database Engineer

We are seeking an experienced and proactive Database Engineer to join our technology team. The successful candidate will be responsible for the migration and optimization of our application database schemas. This role is essential in ensuring the performance, reliability, and scalability of our database environment as we transition from on-premises Oracle databases to a cloud-based PostgreSQL infrastructure. The ideal candidate will have a strong background in working with the database, a deep understanding of cloud database technologies, and a collaborative mindset to work effectively with our DevOps and application development teams. Key Responsibilities: Cloud Migration: Take a significant part of the planned migration of our database environment from Oracle to Cloud SQL for PostgreSQL. Develop and implement migration strategies, ensuring data integrity and minimal downtime. Collaboration and Process Improvement: Employ a range of techniques to analyze problems and evaluate multiple solutions against engineering, business & strategic criteria Collaborate to achieve consensus on topics and issues and contribute to communities Identify and resolve barriers to business deliveries implementing solutions which iteratively deliver value Design solutions using common design patterns with a range of design tools & techniques Conduct peer reviews to ensure designs are fit for purpose, extensible & re-usable Deliver end-to-end first-class engineering solutions across a range of technology platforms Improve delivery standards, working practices, tools & solutions and driving adoption of automation tools Ensure stable and reliable production environments and high-quality service delivery to customers Investigate production incidents & lead remediation, analyze services & components Design & build solutions which are secure & controlled Investigate & report on issues and potential risk events within designs and solutions Qualifications: Excellent technical skills in PostgreSQL Strong understanding of relational databases Ability to design and develop application/components including packages, store procedures, functions, triggers Experience in working with Oracle SQL and PL/SQL Proficiency in scripting languages such as Python or Shell scripting Proficiency in data modelling and database design Open to learn Google Cloud technologies Data analysis general skills Analytical thinker experienced in a range of problem-solving techniques & approaches Team player who shares and collaborates, a keen listener and quick learner Communicates clearly and influences using coherent, fact and benefit-based proposals Enables experimentation and fast learning approaches to creating business solutions Understands key elements of security, risk & control