Principal DB Engineer - Oracle/PLSQL & Snowflake

Photon; Galway; Hybrid; EUR 100,000 - 160,000; Full time

Job summary

Photon in Galway, Ireland is seeking a Principal Database Engineer to lead design, development, and governance of mission-critical database systems across Oracle, PL/SQL, and Snowflake. You will drive CI/CD integration with Jenkins, ensure data integrity, performance, and security, and collaborate with software teams to deliver scalable data solutions.

The role demands a 12+ year track record, strong analytical mindset, and excellent communication skills to mentor juniors and align with business

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 12+ years of experience as a Database Developer or similar role.
• Expertise in Oracle Database and PL/SQL development.
• Strong knowledge of Snowflake components and their implementation.
• Understanding and experience with CI/CD processes and tools, particularly Jenkins.

Responsibilities

• Design, implement, and maintain database systems using Oracle and PL/SQL.
• Optimize database performance and ensure high availability.
• Develop and execute database scripts, stored procedures, and functions.
• Implement and manage CI/CD pipelines using Jenkins.
• Collaborate with software developers to integrate database systems with applications.
• Design and develop Snowflake data models, integrations, and transformations.
• Monitor database health and troubleshoot issues.
• Implement and enforce database security policies.
• Perform data modeling and design database schemas.
• Conduct database backups, recovery, and disaster recovery planning.
• Provide technical support and guidance to junior database developers.
• Stay updated with the latest database technologies and best practices.

Skills

Oracle Database

PL/SQL

Snowflake

Jenkins

SQL

Security

Performance tuning

Problem solving

Communication

Teamwork

Education

Bachelor's degree

Tools

Jenkins

Job description

Photon in Galway, Ireland is seeking a Principal Database Engineer to lead design, development, and governance of mission-critical database systems across Oracle, PL/SQL, and Snowflake. You will drive CI/CD integration with Jenkins, ensure data integrity, performance, and security, and collaborate with software teams to deliver scalable data solutions.

The role demands a 12+ year track record, strong analytical mindset, and excellent communication skills to mentor juniors and align with business