Senior Software Development Engineer

Workday; Ireland; On-site; EUR 90,000 - 135,000; Full time

Job summary

Workday in Ireland is seeking an experienced PostgreSQL Engineer to join a team focused on stable, scalable database infrastructure for our Rails-based product. You will optimize, shard, and grow our PostgreSQL deployment in line with rapid product growth.

You will work with AWS/RDS, monitor performance, tune configurations, and partner with DevOps to predict capacity and provision resources. We value self-sufficiency, collaboration and teaching others.

Qualifications

• 5+ years experience with PostgreSQL, planning and provisioning database instances.
• Experience with cross-region/datacenter databases.
• Experience tuning and configuring PostgreSQL, ideally in AWS.
• Familiar with monitoring tools and connection management.
• Ability to predict capacity and work with DevOps to provision it.
• Interest in teaching others and teamwork.

Responsibilities

• Scale, optimize and shard PostgreSQL infrastructure for our Rails-based app.
• Collaborate with DevOps to provision capacity and manage resources.
• Monitor database performance and tune configurations for efficiency.
• Contribute to DB tooling and monitoring for reliability and scalability.

Skills

PostgreSQL

AWS

RDS

DB tuning

Monitoring

Capacity planning

DB provisioning

Cross-region DBs

Rails ORM

Self-motivated

Job description

• You would be joining a team that is responsible for a wide range of tasks to ensure stability, performance and scalability of our systems and engineering practices. Lately we have been busy working on our codebase modularisation and ensuring we have a durable, self-healing background processing system just to name a few
• We face daily challenges with problems that do not have obvious or simple solutions. We are excited to meet team members that are self-sufficient and purpose driven and able to align to the business goals and long term strategic direction
• You will be working with the latest versions of PostgreSQL database which is the main persistence store for our Ruby on Rails application. We are looking for a talented engineer to help us scale, optimize and shard our database infrastructure in line with the significant growth our product area is currently seeing
• This role requires a person that understands database performance and our current workloads
• Has a good knowledge of a connection management and how system resources are used on a database server
• Is familiar, and can suggest related tooling (including monitoring solutions)
• Is capable of tuning and configuring PostgreSQL (ideally within AWS)
• Predicting the required capacity and helping DevOps to provision it

You seek innovative solutions to problemsYou propose pragmatic solutions to painful problemsYou are responsible, helpful, and kindYou have worked with database deployments in public clouds (preferably AWS and their RDS offering)You find opportunities to teach othersYou are a team player, you motivate your teammates5+ years experience working with PostgreSQL, planning and provisioning database instancesWorking with databases that cross-regions/datacentersWe are also interested to hear about:Working with teams that use ORMs (AR in rails) or other application frameworkWe do not believe in the ‘perfect’ candidate and are happy to teach. So however you identify and whatever background you bring with you, apply and see what we are all about