Database Expert (PostgreSQL)

Senior • Remote

Warszawa, Poland

Your responsibilities:

Design, optimize, and maintain relational database structures supporting large-scale distributed data processing systems.
Analyze and improve SQL query execution plans to ensure top performance.
Implement indexing, partitioning, and server configuration best practices for PostgreSQL.
Develop and optimize data models for complex and high-volume systems.
Ensure data security, integrity, and availability across multiple environments.
Work with very large datasets (hundreds of millions of records) efficiently and reliably.
Collaborate with development and DevOps teams to integrate database solutions with CI/CD pipelines.
Support ongoing system development and maintenance of a distributed platform that processes data from multiple independent sources.

We are looking for you, if you have:

Minimum 7 years of experience working with relational databases.
Excellent knowledge of PostgreSQL, including query optimization, indexing, partitioning, and server configuration.
Proven ability to analyze and improve SQL execution plans.
Experience designing and optimizing data models for large and complex systems.
Understanding of data security and integrity principles.
Hands-on experience working with large datasets (hundreds of millions of records).
Knowledge of index design and relational schema modeling.
Experience with CI/CD tools and Git/GitLab.
(Nice to have) Experience in PostgreSQL administration (configuration, monitoring, replication, backups).
(Nice to have) Familiarity with monitoring and diagnostic tools for database performance.

We offer:

Participation in interesting and challenging projects.
Flexible working hours.
A great, non-corporate atmosphere.
Opportunities for development and promotion.
Attractive package of benefits.
Remote work.

We reserve the right to contact the selected candidates.

Transition Technologies MS

Transition Technologies MS is a company operating in the software development industry, focusing on enterprise projects and products. The company values flexibility, offering remote or hybrid work models, and emphasizes a non-corporate atmosphere, suggesting a more relaxed and innovative work environment. Transition Technologies MS is committed to stable employment conditions and career development opportunities for its employees. While the company does not require experience in healthcare, it acknowledges the value of familiarity with healthcare systems, indicating a potential focus or interest in this sector. The company is distinguished by its involvement in interesting and challenging projects, and it provides a comprehensive benefits package to its employees.