Required skills
- PL/SQL
- Oracle SQL
- SQL
- SQL Query Tuning
- Execution Plan Analysis
- Stored Procedures
- Table Partitioning
- Database Indexing
- Database Performance Monitoring
- Oracle Database
Languages: Polish · English
Job description
We are looking for an experienced Senior PL/SQL Developer for a project focused on developing, maintaining, and optimizing Oracle databases handling large data volumes. The role involves designing complex database logic, writing efficient PL/SQL procedures and packages, and ensuring high operational performance.
Project overview
We are looking for an experienced Senior PL/SQL Developer to join a project focused on the development, maintenance, and performance optimization of Oracle databases processing large data volumes. In this role, you will be responsible for designing complex database logic, writing efficient PL/SQL procedures and packages, and ensuring the highest operational efficiency of the production environment.
Responsibilities
- Creating, developing, and maintaining complex stored procedures, functions, triggers, and packages in PL/SQL.
- Analyzing, diagnosing, and advanced optimization of Oracle SQL queries operating on large datasets.
- Designing and managing database structures with an emphasis on performance and scalability, including table partitioning and appropriate indexing.
- Monitoring database performance, identifying bottlenecks (execution plan analysis), and implementing improvements.
- Collaborating with development and analysis teams on changes to data models and processing.
Requirements
- Oracle SQL & PL/SQL: Extensive commercial experience in designing and developing solutions in the Oracle database environment.
- Performance Optimization: Deep knowledge of performance issues (SQL query tuning, execution plan analysis, resource optimization).
- Large Data Volumes: Documented experience working with databases processing high data volumes.
- Structures and Partitioning: Practical knowledge of table partitioning techniques and designing efficient schemas and indexes.
- Independence and Quality: Ability to write clean, well-documented, and maintainable database code.
Project details
- Role: Senior PL/SQL Developer
- Level: Senior
- Rate: 90 – 130 PLN/h net B2B (depending on experience)
- Cooperation form: B2B Contract
- Work mode: 100% remote
- Start: flexible
- Remote: remote
- Location: Warszawa, x, PL
- Rate: 90-130 EUR/h
- Languages: Polish, English
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on justjoin.it