Associate/Senior Associate, PL/SQL Developer, Wealth Management Technology

Business Function

Group Technology and Operations (T&O) enables and empowers the bank with an efficient, nimble and resilient infrastructure through a strategic focus on productivity, quality & control, technology, people capability and innovation. In Group T&O, we manage the majority of the Bank's operational processes and inspire to delight our business partners through our multiple banking delivery channels.

Wealth Management Technology

As leaders in financial technology, we architect scalable investment and wealth solutions for our mass-affluent clients and offer unparalleled, personalised advice to high-net-worth investors. Our strategic commitment to relentless innovation ensures we actively cultivate a diverse team to transform the financial ecosystem and ensure equitable access to wealth management expertise.

As we strategically grow our technological capabilities, we are seeking exceptional Wealth Management experts and Avaloq technologists -trailblazers, change-makers, and future leaders-to drive our next phase of innovation, and we believe your network might include such transformative talent.

Roles and Responsibilities:

• Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Develop and optimize complex SQL queries for high-volume transactional systems.
• Analyze business requirements and translate them into technical database solutions.
• Perform database performance tuning and query optimization.
• Create and maintain database objects following coding standards and best practices.
• Support production issues, troubleshoot data-related problems, and implement fixes.
• Work closely with business analysts, application developers, QA teams, and stakeholders.
• Participate in code reviews and ensure high-quality deliverables.
• Prepare technical documentation and support knowledge transfer activities.

Requirements

• 3-7 years of Oracle PL/SQL development experience.
• Minimum Graduation or Post Graduation with preferred in Computer Science
• Oracle database development experience in production environments.
• Excellent debugging and troubleshooting capability.
• Strong experience in Oracle Database and PL/SQL Development.
• Good understanding of Stored Procedures, Functions, Packages, Triggers, Views, Indexes, Sequences, Cursors
• Expertise in writing complex SQL queries and query tuning.
• Experience with performance optimization using Explain Plans and indexing strategies.
• Good understanding of database concepts, normalization, and relational database design.
• Experience in handling large datasets and bulk processing.
• Knowledge of Unix/Linux commands and shell scripting.
• Experience with version control tools such as Git, SVN, or similar.
• Should have strong expertise in designing, developing, optimizing, and maintaining Oracle database solutions

Preferred Skills

• Experience as Avaloq developer or Test Master
• Experience in Financial Services, Banking, Asset Management, or Capital Markets domain.
• Knowledge of ETL processes and data migration activities.
• Experience working with Oracle SQL Developer, TOAD, or similar tools.
• Basic knowledge of Java or application integration technologies is an advantage.

• Strong analytical and problem-solving skills.
• Ability to understand complex business requirements.
• Excellent communication and stakeholder management skills.
• Eagerness to learn new technologies and domains.
• Ability to work independently as well as in a collaborative team environment.
• Prior experience in financial services projects will be an added advantage.

Location:

Job:

Schedule:

Employee Status: