Database Developer

**ABOUT US**

AGAP2 is a European engineering and operational consulting group that is part of the MoOngy Group.

With a presence in 11 European countries and over 7,500 employees, we opened our first Italian office in Milan four years ago. Given our continued growth, we are strengthening and expanding our team with people who share the same values as our company: AMBITION, SMILES, DYNAMISM, WILLINGNESS TO GET INVOLVED, all in a constantly evolving environment where human relationships always come first.

We are looking for a hybrid Oracle PL/SQL Developer in Tirana for our partner company.

**🎯 Main responsibilities**

• Develop and maintain high-quality PL/SQL code, ensuring performance, reliability and scalability

• Design and optimise database schemas and data models in line with business requirements

• Define procedures to achieve consistent data storage

• Perform code reviews and provide feedback on SQL and PL/SQL implementations

• Collaborate with architects and developers to ensure efficient data integration and application performance

• Analyse, troubleshoot and resolve database performance bottlenecks

• Ensure data consistency, integrity and security across all environments

• Contribute to the definition and improvement of database development standards and best practices

**✅ Essential requirements (Must-Have)**

- Excellent knowledge of Oracle SQL and PL/SQL (packages, procedures, triggers, functions, cursors)
- Ability to design, implement and optimise data models (conceptual, logical and physical)
- Experience in data migration, ETL logic and data validation
- Knowledge of indexing, partitioning and query performance optimisation strategies
- Familiarity with Oracle tools such as SQL Developer, Data Modeler or TOAD
- Solid knowledge of relational database design principles and normalisation
- Experience in creating ER diagrams and managing data dictionaries
- Ability to translate business requirements into data structures and optimise schema design
- Knowledge of data integrity, referential constraints and metadata management

The world needs you

AGAP2 is an equal opportunities employer: we believe that all forms of diversity are a source of mutual enrichment. We are committed to ensuring an inclusive working environment in which every single resource can bring unique value to our organisation. Therefore, we welcome applications regardless of age, gender, nationality, disability, sexual orientation, religion or marital status.

Furthermore, we honour our commitments by paying attention to employees belonging to protected categories pursuant to Articles 1 and 18 of Law 68/99.

Personal data will be processed in accordance with the provisions contained in EU Regulation 2016/679.