Database Engineer (PostgreSQL & BigQuery)

Who we are

We are seeking an experienced and proactive Database Engineer to join our technology team. In this role, you will play a pivotal part in ensuring the performance, reliability, and scalability of our database environments during a critical transition from on-premises Oracle to cloud-based PostgreSQL infrastructure. Responsibilities will include the migration, refactoring, and continuous optimization of our application database schemas.

Additionally, as we implement Google Cloud BigQuery for reporting, experience or familiarity with BigQuery is highly valued. The ideal candidate possesses a strong background in database engineering, a deep understanding of cloud database architectures, and a collaborative mindset to work seamlessly alongside our application development squads.

What You’ll Be Doing

• 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
• 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

What We’re Looking For

• Bachelor’s degree in Computer Science, Engineering, or related field
• Minimum of 5 years of professional experience in a similar database developer role
• 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, BigQuery 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
• 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

Nice to have:

• Experience in banking projects
• Experience with Agile development environment