Senior Database Developer (Oracle + PostgreSQL)

Quick Facts

Senior Database Developer position focused on designing and maintaining Oracle and PostgreSQL database solutions for public-sector IT projects.

Role description

You will design, develop, optimize, and maintain Oracle and PostgreSQL-based database solutions. The role covers SQL and procedural development, performance diagnostics, data modeling, and deployment of database changes via migration scripts.

Responsibilities

• Design, create, develop, and maintain database solutions based on Oracle and PostgreSQL.
• Write and optimize SQL queries, stored procedures, functions, triggers, and other database objects.
• Analyze database performance, identify bottlenecks, and optimize database code and structures.
• Design and modify data models and relational database structures.
• Prepare, test, and deploy database changes and migration scripts.
• Diagnose application issues related to the database layer.
• Ensure data integrity, consistency, and security.
• Collaborate with developers, analysts, and database administrators on the development, integration, and maintenance of IT systems.

Requirements

• Minimum 5 years of experience as a Database Developer.
• Very strong practical knowledge of Oracle, SQL, and PL/SQL, including building/modifying procedures, functions, packages, triggers, views, and other database objects.
• Practical knowledge of PostgreSQL and PL/pgSQL for building, developing, and maintaining database solutions.
• Experience with SQL performance analysis and optimization (execution plans, bottleneck identification, index selection).
• Experience in data modeling and relational database design (tables, relationships, indexes, views).
• Knowledge of transactions, data integrity, locks, concurrency, and security/permission management.
• Experience preparing, versioning, testing, and deploying database changes and migration scripts.
• Knowledge of Git and deployment processes for database changes to test and production environments.

Benefits

• Benefits package: Udemy for Business, private medical care, Multisport card, veterinary package, language lessons, shopping vouchers.
• Flexibility: flexible working hours and remote/hybrid options tailored to your lifestyle and location.
• Career growth: training and certification access; collaboration with global IT partners (Microsoft, AWS, Snowflake, Salesforce).
• Community involvement: team-building events, hackathons, and CSR initiatives.
• Company traditions: annual integration event in Masuria.