Principal Database Engineer (Oracle, PL/SQL, Snowflake)- Galway,Ireland

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

Principal Database Engineer (Oracle, PL/SQL, Snowflake)- Galway,Ireland

Ireland

Job Description

**Job Description: **

The Senior Database Developer will be responsible for designing, developing, and maintaining complex database systems to support our business operations. You will collaborate with cross-functional teams to ensure data integrity, performance, and security. Your expertise in Oracle, PL/SQL, and Snowflake components, along with your understanding and experience in CI/CD processes and Jenkins, will be critical in driving our database initiatives and achieving our organizational goals.

Key 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.

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.
• Strong understanding of database design, modeling, and optimization techniques.
• Experience with database performance tuning and query optimization.
• Proficiency in SQL and database management tools.
• Knowledge of database security best practices.
• Excellent problem-solving and analytical skills.
• Strong communication and teamwork abilities.
• Ability to work independently and manage multiple tasks effectively.

Preferred Qualifications

• Experience with other database technologies such as MySQL, PostgreSQL, or SQL Server.
• Knowledge of cloud-based database solutions (e.g., AWS RDS, Azure SQL Database).
• Certification in Oracle Database (e.g., Oracle Certified Professional).