Senior Data Engineer (Oracle / PL/SQL) – Data Warehouse v Česko
COMMERZBANK Aktiengesellschaft, pobočka Praha
Na dálkuPráce odkudkoli
Plný úvazekStandardní týdenní pracovní doba
SmlouvaNa dobu určitou nebo freelance
Česko
We are seeking an experienced Database Developer with a proven track record in Data Warehouse development and strong Oracle / PL/SQL skills to join our Finance / Data Platform development team.
In this role, you will design, develop, optimize, and maintain complex database programs and data processing logic within a large‑scale enterprise Data Warehouse environment. You will work on both existing (legacy) components and future‑oriented solutions, ensuring stability, performance, and long‑term maintainability.
What we expect from you:
Design, develop, and maintain complex PL/SQL programs, packages, procedures, and functions in an enterprise Oracle environment
Develop and optimize data transformation and loading logic for Data Warehouse and analytical use cases
Analyze, refactor, and stabilize existing database code with a strong focus on maintainability and performance
Ensure high performance and scalability, especially for large data volumes and batch‑oriented processing
Actively support production operations by analyzing and resolving database‑related incidents and performance issues
Collaborate closely with business analysts, ETL developers, and application teams to translate business requirements into robust database solutions
Contribute to technical design discussions, code reviews, and architecture decisions
Support the continuous evolution of the Data Warehouse towards modern, future‑proof architectures
We prefer candidates with:
Strong hands‑on experience database development later in complex enterprise environments using PL/SQL and SQL, preferably 19c and later
Proven experience in Data Warehouse development, including data modeling and large‑scale data processing. Experience with modern data architectures (Data Lake, Data Mesh and hybrid approaches) is a plus.
Solid understanding of SQL performance tuning, execution plans, indexing strategies, and partitioning
Experience working with data governance, data quality checks, and reconciliation logic
Familiarity with various data processing patterns (ETL,ELT, streaming, etc.) and interaction with upstream/downstream systems (microservices, APIs)
Experience in maintenance of long‑living systems while contributing to modernization initiatives
Ability to understand and improve complex, historically grown database landscapes
Proficiency in Unix/Linux environments, including the ability to create and modify shell scripts. Proficiency in other programming languages (Python, Java, etc.) is an advantage.
Knowledge and experience with Oracle Exadata systems, as well as familiarity with cloud-based technologies and architectures, are considered a plus.
Proficiency in English at a minimum B2 level is required; knowledge of German is an advantage.
Willingness to learn new technologies, including other database systems and cloud environments
Proactivity in identifying potential challenges and delivering solutions in complex environments.
Strong commitment to continuous learning and professional development.
Ability to work in international and agile environment.
Eligibility to work in the EU.
We offer:
Home office to make sure you can have the right balance.
Flexible working hours within agile setup.
Generous package of 6 weeks of vacation, 6 sick days and up to 30 days of paid sick leave.
A competitive salary with a very decent annual bonus system.
Special financial conditions and mortgage discount.
Prague offices to meet your team at the Charles Square Center, Karlovo náměstí within the reach of metro B line.
A sophisticated program of further professional training and personal growth.
Sponsored public transport card, Multisport card, retirement savings contribution, cafeteria system benefits, children summer camps contribution and free coffee.
Opportunity to travel to our Frankfurt headquarters.
A friendly, inclusive and open-minded company culture.
Amazing multicultural colleagues and so much more!
... development and testing teams to ensure consistent, high-quality deliveries Ukázat vše (10) O pozici / o projektu Původní popisek. ParTech, Inc. is seeking a Senior Full Stack Engineer to join our PAR OPS software development team to deliver solutions that connect people to the restaurants, meals, and moments they love. ...
... danych. - Wdrażanie oraz utrzymanie baz danych w środowiskach rozproszonych. - Projektowanie, wdrażanie i zarządzanie rozwiązaniami wysokiej dostępności, w tym SQL Server Always On. - Planowanie pojemności i dostępności baz danych. Ukázat vše (13) O pozici / o projektu Původní popisek. Projekt obejmuje utrzymanie i rozwój ...
... are looking for a Database Administrator (MS SQL) . Your main tasks will be: - Write advanced T-SQL scripts for MS SQL Server 2008–2019. - Review developers’ SQL code, analyze execution plans, and resolve execution-plan issues (including stored procedures executed tens of millions of times per day). - Optimize database ...
... spolupráce a dobré komunikace. - Vnímání potenciálu AI a ML - rozumíte podstatě moderních AI nástrojů a víte, jak je prakticky zapojit do práce. - Přehled v relačních databázích (SQL, PL/SQL) . - Přehled v internetových a backendových technologiích (HTML, JS, PHP, Bash) pro pochopení celkového kontextu systému. - Základní přehled ...
... downstream data team) depends on. Collecting social data at this scale is a hard distributed-systems problem. APIs change without warning. Providers become unreliable. Platforms rate-limit requests. Data grows stale. A tiny inefficiency becomes expensive when repeated hundreds of millions of times. We need a senior engineer who ...
... stay reliable. - Architectural Ownership: You aren't just a coder; you are a system designer. You will take full responsibility for the technical design and implementation of features that handle high concurrency and mission-critical warehouse logic. - Data-Driven Performance: With a database in the terabyte range, SQL ...
... Experience with SQL + BigQuery dialect - understanding and ability to compute SaaS metrics like ROI, PNO, ROAS, CAC, CPA, etc. - Hands-on experience with Google Data Studio or other real-time data-presentation - You are able to implement, maintain and extend a set of prepared real-time reports across our products. - Ability ...
... Spolupráce s analytiky a BI týmem na přípravě dat pro reporting - Podíl na návrhu a rozvoji datové architektury Požadujeme: - Minimálně 3 roky zkušeností na pozici Data Engineer - Velmi dobrou znalost SQL - Zkušenost s programováním, ideálně v Pythonu - Praktickou zkušenost s cloudovými datovými sklady, například Snowflake, BigQuery, ...