SORIGO

SQL Developer / Developerka (PostgreSQL)

Brak informacji o wynagrodzeniu

SeniorHybryda·WarszawaFull-time

#393981·Dodano 3 miesiące temu·3

Źródło: nofluffjobs.com

Aplikuj teraz

Tech Stack / Keywords

SQL PostgreSQLPL/pgSQLPythonL2BigQuery AirflowdbtDWHAWS Azure

Firma i stanowisko

Sorigo Sp. z o.o. specializes in implementing innovative IT solutions and has many years of experience cooperating with large clients. The company values employee development and satisfaction, aiming to provide growth opportunities and benefits to its workforce.

Wymagania

Excellent knowledge of SQL and PL/pgSQL (PostgreSQL)
Experience working with very large databases (billions of records, terabytes of data)
Ability to optimize queries and long-running processing
Experience analyzing query execution plans and diagnosing bottlenecks
Experience with stored procedures
Proficiency in Python for business logic development
Ability to analyze data and problems from various sources
Knowledge of system log analysis and using extensions such as pg_stat_statements
Knowledge of data partitioning, especially by date
Experience working at L2 level supporting production environments
Fluent English at B2/C1 level

Nice to have:

Experience with BigQuery, Airflow, and dbt
Knowledge of cloud database specifics on AWS and Azure

Obowiązki

Work with large databases using SQL and PL/pgSQL (PostgreSQL), handling structures with billions of records and terabytes of data
Optimize queries and long-running processes
Analyze query execution plans and identify bottlenecks
Work with stored procedures effectively
Maintain and develop business logic using Python
Analyze data and issues from various sources
Analyze system logs and use extensions like pg_stat_statements to identify blocking and bottleneck processes
Manage data partitioning, especially by dates, to optimize large table searches
Provide L2 support to solve problems and maintain production processes
Co-create a critical banking application responsible for revenues management and stock reconciliation
Manage advanced PostgreSQL engine mechanisms including MVCC (Xmin/Xmax), Vacuum processes, and advanced indexes like BRIN
Develop competencies related to DWH, data integration, and database solutions

Benefity

Work on projects based on PostgreSQL, data warehouses, and systems processing very large volumes of information
Join a newly forming 5-6 person competency hub in Poland
Responsibility for a critical banking application in a multi-cloud environment (AWS and GCP)
Development in areas of DWH, data integration, and database solutions
Advanced management of PostgreSQL engine mechanisms including MVCC, Vacuum, and advanced indexes like BRIN
Clear career plan and professional development support at L2 level
Technological and developmental challenges in data analysis
Social package: private medical care, insurance, sport card
Work with the latest technologies and market trends
Competitive salary

Opieka zdrowotna

Ubezpieczenie

Karta sportowa

Inne informacje

Candidates must include in their CV consent to the processing of personal data for recruitment purposes compliant with Polish data protection law. The role requires fluent English (B2/C1).

SORIGO

42 aktywne oferty

Zobacz wszystkie oferty

Aplikuj teraz