Sobre esta vaga de Senior Oracle PL/SQL Engineer – Global Asset Servicing Platform na Capco
CAPCO POLAND - WARSAW
*We are looking for Poland based candidate.
At Capco Poland, we’re not just another consultancy - we’re the spark behind digital transformation in the financial world. As a global leader in technology and management consulting, we thrive on helping clients tackle the toughest challenges across banking, payments, capital markets, wealth, and asset management.
Role Overview
We are seeking a Senior Oracle PL/SQL Engineer to join our Global Asset Servicing Platform team. You will work alongside Java/React full-stack engineers to design, develop, optimise and maintain the database components of a scalable and reliable financial services application.
This is a hands-on engineering role with strong ownership of database code quality, performance, testing and production support.
Key Responsibilities
- Design, develop and maintain complex Oracle PL/SQL packages, procedures, functions and database-side business logic.
- Analyse and optimise SQL queries and database operations to improve application performance and scalability.
- Collaborate with Java backend engineers to ensure efficient integration between application services and the Oracle database.
- Develop automated database tests, investigate defects and support root-cause analysis.
- Participate in Agile delivery, technical design discussions and continuous improvements to database code quality.
- Advanced Oracle SQL and PL/SQL development, including packages, procedures, functions, triggers and exception handling.
- Strong SQL performance tuning, execution plan analysis, indexing and query optimisation.
- Experience designing and maintaining complex relational data models and transactional database applications.
- Practical knowledge of transaction management, concurrency, locking and data integrity.
- Experience with database debugging, code reviews, version control and automated testing.
- Ability to collaborate effectively with Java engineers and business analysts.
- Experience in financial services, particularly asset servicing or securities processing.
- Familiarity with Java-based applications and database integration patterns.
- Experience with Oracle performance diagnostics and profiling tools.
- Knowledge of database deployment automation and CI/CD practices.
- Familiarity with PostgreSQL or database migration initiatives.
B2B cooperation in a hybrid model, with the option to provide services from the Warsaw office to the extent agreed based on project needs.
Recruitment Process:
- HR Interview with the recruiter
- Technical Interview
- Client Interview
- Feedback and offer
#LI-HYBRID