📍 Job Overview

Job Title: PostgreSQL Developer
Company: Booming Games
Location: Barcelona, Catalonia, Spain
Job Type: Full-Time
Category: Database Administrator / Engineer
Date Posted: 2025-06-13
Experience Level: Mid-Senior level (5-10 years)
Remote Status: On-site (ideally located in Prague)

🚀 Role Summary

Key Responsibilities: Design and evolve relational data models, write performant PL/pgSQL code, collaborate with cross-functional teams, and contribute to database refactoring and optimization.
Key Technologies: PostgreSQL, SQL, PL/pgSQL, Git, Linux, Bash, Python (bonus), Docker, microservices (strong plus).
Impact: Shape the data lakehouse platform that powers analytics, operations, and product development across the company.

📝 Enhancement Note: This role requires a blend of structured data modeling, creative problem-solving, and a strong sense of ownership. It's ideal for a PostgreSQL specialist who enjoys working on clean architecture and well-structured code.

💻 Primary Responsibilities

Database Design & Evolution: Design and evolve relational data models and database architecture to support business needs and growth.
Code Development: Write performant, maintainable PL/pgSQL code to power business logic and data flows, ensuring optimal database performance.
Collaboration: Work closely with BI, backend, and product teams to shape how applications interact with the database and ensure data integrity.
Refactoring & Optimization: Contribute to refactoring and optimization of existing database structures and processes to improve performance and scalability.
Automation: Implement automated tests and CI/CD pipelines for database development to ensure consistent, reliable, and efficient processes.
Solution Design: Help design solutions that extend beyond traditional RDBMS boundaries, leveraging modern technologies and best practices.

📝 Enhancement Note: This role involves a mix of greenfield development and brownfield optimization. You'll need to balance innovation with maintaining and improving existing systems.

🎓 Skills & Qualifications

Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Relevant experience may substitute for formal education.

Experience: 4+ years of experience in relational database development, with a strong preference for PostgreSQL.

Required Skills:

Proven expertise in SQL and PL/pgSQL.
Solid understanding of database performance and storage optimization.
Experience with version control (Git) and modern development workflows.
Working knowledge of Linux environment.
Fluent English communication skills (written and spoken).

Preferred Skills:

Scripting skills in Bash and/or Python.
Familiarity with CI/CD pipelines, preferably GitLab CI/CD.
Experience with Docker and microservices.
Knowledge of data warehousing and ETL processes.

📝 Enhancement Note: While not required, experience with data warehousing and ETL processes can be beneficial for this role, as the data lakehouse platform processes large volumes of data.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

Database Design: Include examples of your database design work, showcasing your ability to create efficient and scalable relational data models.
PL/pgSQL Code: Demonstrate your proficiency in writing performant PL/pgSQL code by including examples of complex business logic implementations.
Optimization & Refactoring: Highlight projects where you've optimized existing database structures or refactored code to improve performance.
Collaboration: Showcase your ability to work effectively with cross-functional teams by including projects where you've collaborated with developers, data analysts, or other stakeholders.

Technical Documentation:

Code Comments & Documentation: Include examples of well-commented and documented PL/pgSQL code, demonstrating your attention to detail and commitment to code quality.
Version Control & CI/CD: Showcase your experience with version control (Git) and CI/CD pipelines by including examples of automated testing and deployment processes.
Database Performance Metrics: Include metrics demonstrating the performance improvements you've achieved through optimization and refactoring efforts.

📝 Enhancement Note: For this role, it's crucial to emphasize your problem-solving skills and ability to work with diverse teams. Highlight projects that demonstrate these qualities in your portfolio.

💵 Compensation & Benefits

Salary Range: €45,000 - €60,000 per year (based on market research for mid-senior level PostgreSQL developers in Barcelona)

Benefits:

Competitive package.
Educational allowance per year.
Family-friendly policies.
Career growth opportunities.
Knowledge sharing opportunities.
Company social events for team bonding.

Working Hours: Full-time (40 hours per week), with flexible working hours and a results-driven approach.

📝 Enhancement Note: While the salary range is an estimate based on market research, the actual salary may vary depending on the candidate's experience and skills. Booming Games offers a competitive package and various benefits to attract top talent.

🎯 Team & Company Context

🏢 Company Culture

Industry: Booming Games is a game development company that focuses on creating high-quality, innovative casino games for the online gaming industry.

Company Size: Medium-sized company (around 250 employees), offering a dynamic and collaborative work environment.

Founded: 2014, with a strong focus on growth and innovation in the gaming industry.

Team Structure:

The Data Lakehouse team consists of database engineers, data analysts, and data scientists working together to build and maintain the data platform that powers analytics, operations, and product development.
The team follows an Agile/Scrum methodology, with regular sprint planning and code reviews to ensure high-quality, efficient, and maintainable code.

Development Methodology:

Agile/Scrum: The team follows an Agile/Scrum methodology, with regular sprint planning, daily stand-ups, and sprint retrospectives to ensure continuous improvement.
Code Review & Testing: The team emphasizes code review and automated testing to ensure code quality, performance, and maintainability.
CI/CD Pipelines: The team uses CI/CD pipelines to automate deployment processes, ensuring consistent and reliable releases.

Company Website: Booming Games

📝 Enhancement Note: Booming Games values a collaborative and innovative work environment. The company encourages employees to take ownership of their work and contribute to real product decisions.

📈 Career & Growth Analysis

Web Technology Career Level: This role is at the mid-senior level, requiring a strong foundation in PostgreSQL development and a proven track record of delivering high-quality, performant database solutions.

Reporting Structure: The PostgreSQL Developer reports directly to the Data Lakehouse Team Lead and works closely with BI, backend, and product teams to ensure data integrity and optimal performance.

Technical Impact: The PostgreSQL Developer plays a crucial role in shaping the data lakehouse platform, enabling analytics, operations, and product development across the company. Their work directly impacts the quality, reliability, and performance of the data that drives business decisions.

Growth Opportunities:

Technical Leadership: As the company grows, there may be opportunities to take on more technical leadership responsibilities, mentoring junior team members and contributing to architectural decisions.
Specialization: Depending on your interests, you may have the opportunity to specialize in specific areas, such as data warehousing, ETL processes, or data modeling.
Career Progression: Booming Games offers career growth opportunities, with the potential to progress to senior or principal database engineer roles as the company expands.

📝 Enhancement Note: Booming Games encourages employees to take ownership of their careers and provides opportunities for growth and development. The company values employees who are proactive, innovative, and committed to continuous learning.

🌐 Work Environment

Office Type: Booming Games is a remote-first company, with physical offices in Berlin and Malta that are dog-friendly. The company encourages a flexible and results-driven work environment, with a strong focus on collaboration and communication.

Office Location(s): Barcelona, Catalonia, Spain (ideally located in Prague)

Workspace Context:

Remote Work: Booming Games offers a best-in-class remote experience, with a focus on communication, collaboration, and work-life balance.
Equipment: The company provides the necessary equipment and tools for employees to work effectively, including multiple monitors and testing devices.
Collaboration: Booming Games encourages cross-functional collaboration, with regular team meetings, code reviews, and knowledge-sharing sessions.

Work Schedule: Full-time (40 hours per week), with flexible working hours and a focus on results and performance.

📝 Enhancement Note: Booming Games values a flexible and results-driven work environment. The company encourages employees to manage their time effectively and prioritize work-life balance.

📄 Application & Technical Interview Process

Interview Process:

Phone/Video Screen: A brief conversation to discuss your experience, skills, and motivation for the role.
Technical Assessment: A hands-on technical assessment, focusing on your PostgreSQL development skills, SQL proficiency, and problem-solving abilities.
Team Fit Interview: A conversation with the Data Lakehouse team to assess your cultural fit, communication skills, and ability to work effectively with cross-functional teams.
Final Decision: A final decision based on your technical skills, cultural fit, and alignment with the company's values and goals.

Portfolio Review Tips:

Database Design: Highlight your ability to design efficient and scalable relational data models by including examples of your work and explaining your design decisions.
PL/pgSQL Code: Demonstrate your proficiency in writing performant PL/pgSQL code by including examples of complex business logic implementations and explaining your approach to performance optimization.
Optimization & Refactoring: Showcase your ability to optimize existing database structures and refactor code by including examples of your work and explaining the performance improvements you've achieved.
Collaboration: Highlight your ability to work effectively with cross-functional teams by including projects where you've collaborated with developers, data analysts, or other stakeholders.

Technical Challenge Preparation:

SQL & PL/pgSQL: Brush up on your SQL and PL/pgSQL skills, focusing on complex queries, performance optimization, and efficient code design.
Database Design: Review your database design principles and ensure you're familiar with best practices for creating efficient and scalable relational data models.
Problem-Solving: Practice problem-solving exercises to hone your ability to think critically and find creative solutions to complex database challenges.
Communication: Prepare to clearly and effectively communicate your technical approach, design decisions, and performance optimizations during the interview process.

ATS Keywords: PostgreSQL, SQL, PL/pgSQL, Database Design, Database Performance, Database Optimization, Database Refactoring, CI/CD, Git, Linux, Bash, Python, Docker, Microservices, Data Warehousing, ETL, Agile, Scrum, Collaboration, Cross-Functional Teams, Data Integrity, Data Modeling, Data Analysis, Data Science, Gaming Industry, Remote Work, Flexible Hours, Results-Driven, Work-Life Balance.

📝 Enhancement Note: Booming Games values strong communication skills and the ability to work effectively with cross-functional teams. During the interview process, be prepared to discuss your technical approach, design decisions, and performance optimizations clearly and confidently.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

PostgreSQL: Proven expertise in PostgreSQL development, with a strong understanding of SQL and PL/pgSQL.
SQL: Proficiency in SQL, with a focus on complex queries, performance optimization, and efficient code design.
PL/pgSQL: Experience writing performant PL/pgSQL code to power business logic and data flows.

Development & DevOps Tools:

Git: Experience with version control using Git and modern development workflows.
CI/CD: Familiarity with CI/CD pipelines, preferably GitLab CI/CD, to automate deployment processes and ensure consistent, reliable releases.
Bash & Python: Scripting skills in Bash and/or Python to automate tasks, improve efficiency, and maintain code quality.
Docker: Experience with Docker to containerize applications and ensure consistent deployment across different environments.
Microservices: Familiarity with microservices architecture to design and implement scalable, maintainable, and high-performing database solutions.

📝 Enhancement Note: Booming Games uses a modern technology stack, with a focus on automation, efficiency, and performance. Familiarity with these tools and technologies is essential for success in this role.

👥 Team Culture & Values

Web Development Values:

Innovation: Booming Games values innovation and encourages employees to think creatively and push the boundaries of what's possible.
Collaboration: The company fosters a collaborative work environment, with a strong focus on cross-functional teamwork and knowledge sharing.
Quality: Booming Games is committed to delivering high-quality products and services, with a focus on performance, reliability, and user experience.
Ownership: The company encourages employees to take ownership of their work and contribute to real product decisions.

Collaboration Style:

Cross-Functional Integration: Booming Games encourages collaboration between different teams, with a focus on data integrity, performance, and user experience.
Code Review Culture: The company emphasizes code review and automated testing to ensure code quality, performance, and maintainability.
Peer Programming: Booming Games encourages peer programming and knowledge sharing to ensure high-quality, efficient, and maintainable code.

📝 Enhancement Note: Booming Games values a collaborative and innovative work environment. The company encourages employees to take ownership of their work and contribute to real product decisions.

⚡ Challenges & Growth Opportunities

Technical Challenges:

Data Modeling: Design efficient and scalable relational data models to support business needs and growth.
Performance Optimization: Optimize existing database structures and processes to improve performance and scalability.
Refactoring: Contribute to refactoring efforts to maintain and improve existing systems, ensuring optimal performance and reliability.
Collaboration: Work effectively with cross-functional teams to ensure data integrity, performance, and user experience.

Learning & Development Opportunities:

Technical Skill Development: Booming Games encourages continuous learning and provides opportunities for employees to develop their technical skills and expertise.
Conference Attendance: The company supports employees' attendance at relevant conferences, workshops, and training events to stay up-to-date with the latest industry trends and best practices.
Mentorship & Leadership: Booming Games offers mentorship and leadership opportunities for employees who demonstrate strong technical skills, innovation, and a commitment to continuous learning.

📝 Enhancement Note: Booming Games encourages continuous learning and provides opportunities for employees to develop their technical skills and expertise. The company values employees who are proactive, innovative, and committed to staying up-to-date with the latest industry trends and best practices.

💡 Interview Preparation

Technical Questions:

SQL & PL/pgSQL: Be prepared to discuss complex SQL queries, performance optimization techniques, and efficient PL/pgSQL code design.
Database Design: Demonstrate your understanding of database design principles and best practices for creating efficient and scalable relational data models.
Problem-Solving: Prepare to discuss your approach to problem-solving, with a focus on critical thinking, creativity, and innovation.
Collaboration: Showcase your ability to work effectively with cross-functional teams, with a focus on data integrity, performance, and user experience.

Company & Culture Questions:

Company Values: Be prepared to discuss Booming Games' values and how they align with your personal and professional goals.
Team Dynamics: Demonstrate your understanding of Booming Games' collaborative work environment and how you can contribute to the team's success.
Growth Opportunities: Prepare to discuss your long-term career goals and how Booming Games can support your professional development.

Portfolio Presentation Strategy:

Database Design: Highlight your ability to design efficient and scalable relational data models by including examples of your work and explaining your design decisions.
PL/pgSQL Code: Demonstrate your proficiency in writing performant PL/pgSQL code by including examples of complex business logic implementations and explaining your approach to performance optimization.
Optimization & Refactoring: Showcase your ability to optimize existing database structures and refactor code by including examples of your work and explaining the performance improvements you've achieved.
Collaboration: Highlight your ability to work effectively with cross-functional teams by including projects where you've collaborated with developers, data analysts, or other stakeholders.

📝 Enhancement Note: Booming Games values strong communication skills and the ability to work effectively with cross-functional teams. During the interview process, be prepared to discuss your technical approach, design decisions, and performance optimizations clearly and confidently.

📌 Application Steps

To apply for this PostgreSQL Developer position at Booming Games:

Submit Your Application: Click the application link and submit your resume, highlighting your relevant experience, skills, and achievements.
Prepare Your Portfolio: Tailor your portfolio to showcase your database design, PL/pgSQL code, optimization, and refactoring skills, with a focus on collaboration and cross-functional teamwork.
Research the Company: Familiarize yourself with Booming Games' values, culture, and products to ensure a strong fit and demonstrate your enthusiasm for the role.
Prepare for Technical Assessment: Brush up on your SQL, PL/pgSQL, and database design skills, focusing on complex queries, performance optimization, and efficient code design.
Practice Problem-Solving: Engage in problem-solving exercises to hone your critical thinking, creativity, and innovation skills.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and web development industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.

PostgreSQL Developer