Database Engineer (working with PostgreSQL)
⚲ Warsaw
18 000 - 22 000 PLN (B2B)
Wymagania
- SQL
- Python
- Kubernetes
- AWS
Opis stanowiska
Our client is an innovative company that has been dynamically contributing to the digitalization processes of enterprises, offering advanced solutions in the areas of Big Data, Kubernetes, cloud services, and microservices technology. Through collaboration with certified partners, such as the Snowflake platform, the company enables its clients to effectively implement and integrate cutting-edge technologies, supporting them in becoming more competitive in the digital market. We are looking for talented IT specialists who would like to join our team and work on digital transformation projects, cloud solution implementations, Kubernetes cluster audits and optimizations, as well as developing platforms for ESG reporting and commission calculation automation. If you are ready for challenges in a rapidly developing industry and want to have a real impact on shaping the future of technology, join us!
Database Engineer (working with PostgreSQL)
We offer:
- Attractive salary
- Clear plan and support for professional development;
- Technological and development challenges, including in the areas of data and data analysis;
- Benefits package: medical care, insurance, sports card;
- Unrivaled working atmosphere.
Responsibilities:
- Working on projects based on PostgreSQL, data warehouses, and systems processing very large volumes of information
- Co-developing a key banking application responsible for revenue management and stock reconciliation, working in a unique multi-cloud environment (AWS and GCP)
- Developing competencies in DWH, data integration, and database solutions
- Working on advanced PostgreSQL engine management, including MVCC mechanisms (Xmin/Xmax), Vacuum processes, and the selection of custom indexes such as BRIN
Requirements:
- At least several years of experience working with SQL, PL/SQL, or PostgreSQL
- Working with structures containing billions of records and terabytes of data, understanding how to ensure their efficient processing
- Optimizing queries and long-running processes, even those lasting many hours
- Ability to analyze query execution plans and quickly identify bottlenecks
- Familiarity with working with stored procedures and the ability to use them effectively
- Good knowledge of Python
- Ability to handle L2-level performance problem solving
- Ability to analyze data and problems from various sources
- Ability to analyze system logs and use extensions such as pg_stat_statements to identify blocking processes and bottlenecks.
- Knowledge of data partitioning (especially by date) to optimize searches in terabyte-sized tables
- Experience working at the L2 level, i.e., solving problems and maintaining processes in a production environment
- Very good English skills (B2/C1)
Database Engineer (working with PostgreSQL)
We offer:
- Attractive salary
- Clear plan and support for professional development;
- Technological and development challenges, including in the areas of data and data analysis;
- Benefits package: medical care, insurance, sports card;
- Unrivaled working atmosphere.
Responsibilities:
- Working on projects based on PostgreSQL, data warehouses, and systems processing very large volumes of information
- Co-developing a key banking application responsible for revenue management and stock reconciliation, working in a unique multi-cloud environment (AWS and GCP)
- Developing competencies in DWH, data integration, and database solutions
- Working on advanced PostgreSQL engine management, including MVCC mechanisms (Xmin/Xmax), Vacuum processes, and the selection of custom indexes such as BRIN
Requirements:
- At least several years of experience working with SQL, PL/SQL, or PostgreSQL
- Working with structures containing billions of records and terabytes of data, understanding how to ensure their efficient processing
- Optimizing queries and long-running processes, even those lasting many hours
- Ability to analyze query execution plans and quickly identify bottlenecks
- Familiarity with working with stored procedures and the ability to use them effectively
- Good knowledge of Python
- Ability to handle L2-level performance problem solving
- Ability to analyze data and problems from various sources
- Ability to analyze system logs and use extensions such as pg_stat_statements to identify blocking processes and bottlenecks.
- Knowledge of data partitioning (especially by date) to optimize searches in terabyte-sized tables
- Experience working at the L2 level, i.e., solving problems and maintaining processes in a production environment
- Very good English skills (B2/C1)
🔍 Dekoder Ogłoszenia
🔴
innovative company that has been dynamically contributing to the digitalization processes of enterprises, offering advanced solutions in the areas of Big Data, Kubernetes, cloud services, and microservices technology.
Firma może być innowacyjna, ale opisuje szeroki zakres technologii, co może sugerować, że nie są one dogłębnie zaimplementowane lub że projekt jest bardzo zróżnicowany.
🔴
If you are ready for challenges in a rapidly developing industry and want to have a real impact on shaping the future of technology, join us!
Może oznaczać, że firma jest w fazie rozwoju, gdzie procesy nie są jeszcze ustabilizowane, a pracownik będzie musiał radzić sobie z niepewnością i brakiem jasnych struktur.
🔴
Clear plan and support for professional development;
Może oznaczać, że plan rozwoju jest ogólny i niekonkretny, a wsparcie może być ograniczone do podstawowych szkoleń.
🔴
Technological and development challenges, including in the areas of data and data analysis;
Może oznaczać, że praca będzie polegać na rozwiązywaniu problemów, które nie zostały jeszcze rozwiązane lub są bardzo złożone, co może wymagać dużego nakładu pracy i czasu.
🔴
Unrivaled working atmosphere.
Często używany zwrot, który może oznaczać po prostu dobrą atmosferę, ale też może być próbą zatuszowania innych, mniej atrakcyjnych aspektów pracy.