PL/SQL Experts in Switzerland
matched in minutes by AIHire experts who design stored procedures, optimize Oracle SQL and modernize database applications across finance, insurance and enterprise operations. FRATCH precisely matches you with vetted, available freelancers who fit your project and can start quickly.
Meet FRATCH Experts in Switzerland, who have recently used PL/SQL
Marco S.
Last position:
Business Analyst, Data Warehouse Developer at NRW.Bank
Business analysis for risk controlling.
Development of a data warehouse based on MS SQL Server with data from the FIS Cross-Asset Trading and Risk Platform (formerly Front Arena).
Implementation of ETL and transformation logic with T-SQL and Python (Jinja2 template engine).
Modeling and automation of data structures with Data Vault.
Creation of reporting and analysis reports with Microsoft Power BI, including user training and implementation.
Peter W.
Last position:
IT Consultant at WYP-Consulting
Piotr S.
Last position:
CTO Program Manager, Theme Owner / Senior Project Manager at Avaloq Group AG
- Clients: Central banks of the most developed economies in the world, German, Swiss, Luxembourgish, Monegasque, Singaporean, Japanese wealth managers and universal/private banks, world’s largest investment banks
- Accountable for managing the delivery of a portfolio of digital wealth and consumer relationship management initiatives
- Project managing portfolios of projects within CTO product and technology business area (cyber security, architectural changes, re-organisational transformation, 3rd party apps)
- Products: Kernel & Parametrisation for Core Avaloq Banking Platform; modules: CRM, client data management, wealth management, portfolio management (generating over 90% of company revenues)
- Key responsibilities:
- Reporting to Head of Disruptive Innovation Division; stakeholder to five product owners & two domain owners
- Accountable for delivery of annual themes and quarterly key deliverables
- Managing demand vs supply via QBR process: book of work, execution, reporting, risk management
- Directly managing around 40 external consultants (front-end/back-end engineers, BAs, designers)
- Hiring and managing resources in eight countries
- Running quarterly divisional closure meetings presenting achievements and challenges
- Resolving cross-team dependencies and internal/external conflicts
- Owning and controlling maintenance budget; planning, forecasting, execution; ensuring demand matches supply
- Identifying and staffing key roles with chapter leads
- Approach: Agile, Scrum of Scrums, QBR/OKRs
- Technology: Angular, PL/SQL, JavaScript, Confluence, JIRA (JQL)
Reinhold S.
Last position:
Senior Software Developer at Hitachi Energy
- Support and further development of the Leegoo Builder
- Handling ad hoc requests
- Definition of rules/attributes and their rules
- Optimizing and managing SQL queries
Roland A.
Last position:
Project Manager and Senior Business Analyst at Init Services GmbH
- Project management: Implementation of SAP & EBX integration for master and reference data management and led development of AI supported services for data management and privacy-oriented solutions
- Business analysis: Executed in-depth requirement gathering and data analyzes for MDM implementation, supported service integration using REST APIs to enhance service interoperability, led the requirement gathering, analysis, and implementation of agent-based AI services
- Technologies: SAP BP & FICO & MM, Tibco EBX, n8n, custom AI development in Java, Python, RDBMS, cloud
Claus N.
Last position:
Oracle Database Engineer at BBV.ch
- Migration of databases from ODA to ExaData
- Migration of databases from ExaData to ExaCC/OCI
- Decreased UCC usage by 10%
- Developing automation scripts using Python
- Performance tuning
- Shrunk development databases from 6 TB to 3 TB using Exadata columnar compression
- Tuned application performance by 30% using inmemory option
- Tuned non-production Exadata by 20% to release CPU resources before ExaCC migration
- Database patching of Oracle 19c
- Basic Ansible scripting for deployments and database cloning
- Developing acconting model for shared Oracle platform
- Migrating single-instance databases to Oracle RAC
- Analysis of RAC issues
- Advising development teams of how to migrate to RAC
Michael T.
Last position:
Senior Consultant, Developer, Business Analyst at Swiss Army, Federal Office for Informatics
- Maintained PeopleSoft HCM 9.2/Tools 9.59.08 for batch and interface programs
- Used Application Designer, Application Engine/Packages, PeopleCode
- Developed BI/Excel reporting and proof of concept
- Performed business analysis, SQL reports and documentation
Dariusz K.
Last position:
Business System Analyst at Zurich Insurance
Participating in a strategic enterprise project to introduce a centralized customer data platform ("Single Source of Truth") to eliminate redundant data storage and accelerate digital services
Analyzing and documenting business and system requirements for migrating large, heterogeneous data sets (ETL) and for continuous data synchronization between core systems and the new platform
Close collaboration with business units, data engineers and architects to gather and validate requirements, and to ensure data quality, consistency and regulatory compliance
Defining the migration strategy, specifying ETL processes and synchronization mechanisms, and documenting technical interfaces
Developing and executing test cases for migration and synchronization processes, and performing defect analysis to ensure data integrity and system stability
Technologies: SQL, Microsoft SQL Server, Azure DevOps, Confluence, UML, RESTful Services, Swagger, Postman
Reto B.
Last position:
Managing Director at Atsoft GmbH
- Consulting in ICT, business processes, system architecture, web integration, client-server computing, cross-platform development, responsive web design, social media integration, GUI
- Custom and specialized solutions
- Applications for small and medium-sized enterprises
- Web services, web applications, portals, application extensions (add-ins, plug-ins)
- Database design, interface solutions
- Outsourcing in various industries
- Solutions for other software houses
- Project management and project support (software engineering, coding)
Oliver S.
Last position:
Managing Director and Employed Actuarial Consultant at ARCS Actuarial and Risk Consulting Stoll GmbH
- Advising insurance companies on modeling, reporting, valuations, risk management and acting as the responsible actuary
- 2023–2025: Improving Solvency II software, annual financial statements (HGB, SII), process optimizations, pricing, SQL and Python-based reports for AXA Germany, Cologne
- 2022–2023: Support for portfolio transfer (RAFM optimization; impact on HGB balance sheet, SII, reinsurance; migration to msg.Life Factory) for Zurich Germany, Cologne
- 2021 and 2024: Redesign of Solvency II model, implementation in Python and model extensions; testing and documentation for PK Rück, Zurich
- 2021–2023: Control calculations for maturity benefits of contracts; specification and testing of policy administration system for product launch at Youplus, Liechtenstein
- 2021: a) Support in preparing a reinsurance treaty: project management and analyses; b) assistance with Solvency II reporting and multi-year planning for Allianz Leben, Stuttgart
- 2020–2021: Further development and optimization of models with Risk Agility FM (RAFM), integration into IFRS 17 reporting process using Unify for Allianz Slovakia and Bulgaria
- 2017–2023: Quality improvement of the RAFM model; methodology development; documentation; process optimization in reporting and planning; automation with Excel and Oracle SQL (on COR-Life); implementation of a life reinsurance treaty; validation of numerical results in the policy administration system for SV Versicherung, Stuttgart and Mannheim
- 2015–2017: Project management and senior actuary in developing an actuarial projection tool and in the IMAP process with the regulator; guiding the reporting team; analyses; methodology development; process design; coordination with IT, asset and risk management for Allianz Leben, Stuttgart
- 2016–2020: Review of cash flow models for investment projects for B Capital, Zurich
- 2015: Redevelopment of MCEV calculation methodology based on MVBS; weakness analysis and collaboration on fixes for Allianz SE, Munich
- 2014: Solvency II risk capital reporting project: validation of data deliveries; analyses for management and regulator; tool development; process and documentation improvements; training of team members for Aegon Group, The Hague, Netherlands
Christoph W.
Last position:
System Architect / System Engineer / Programmer at Deutsche Vermögensberatung (DVAG)
- Create requirements for the modularization of the promotion forecast.
- Set up and expand the various competitions for 2024.
- Customize and test the CICS dialog.
- Create various reports for the department using SQL.
- Implement and test new requirements in batch processes with IWS.
- Update documentation for the new requirements.
- Provide on-call support for daily and monthly production.
- Technologies used: SCRUM, Jira, Confluence, Windows 11, Unix, Enterprise Developer, z/OS, GIT, Mineral, Moped, IWS/TWS, JES, COBOL, CICS, DB2, SQL, Rocket, FortiClient, Citrix.
Andrew L.
Last position:
Service Manager - Testing at Takeda Pharmaceutical International AG
- Managing the Testing services for the Global IT Testing Centre of Excellence (TCoE) team, which is responsible for managing and supporting the Product & Project Testing Workstreams on various Regional Projects, especially in Pharmacovigilance, Digital Supply Chain, Clinical Practice and R&D, etc.
- Managing Client relationships, escalations and continuing to grow the project services globally, while also driving the testing efforts on Takeda’s AI, DevOps, Agile, and Digital projects.
- Led the implementation of a Quality Management System (QMS), ensuring compliance with GCP, GMP, and Swiss and EU regulations, resulting in a huge improvement in audit readiness.
- Overseeing projects for systems including ERP, EDGE, SAP ECC, SAP Transportation Management, S/4 HANA migration etc.
- Led an AI/ML PoC for AI implementation.
- Led a cross-functional team to ensure compliance with MDR, FDA regulatory guidelines and achieved successful project deliveries.
- Led and managed change management and communication for TCoE, keeping the Takeda organisation informed of change communication and practices, including presentations to various stakeholders.
- Ensuring TCoE outsource vendor resources adhere to regulatory, compliance and quality system standards and practices for GxP & non-GxP System Development Life Cycle (SDLC) including aSDLC and TCoE Global Standards.
- Translated the product vision, strategy and requirements into backlog items, which were prioritised based on potential business impact and customer value.
Zafer B.
Last position:
Lead Test Automation Engineer at Unknown
- Playwright-based API test automation for the Oracle JD Edwards ERP system
- Development of a TypeScript/Node.js test framework with MSSQL database integration
- End-to-end business process automation for order processing, customer management, etc.
- OpenAI integration for automatic PDF document validation
- Jira/Xray integration for automated test reporting with dashboard
- REST API client development with role-based authentication
- Test data management, dynamic ID validation, and cross-test data sharing mechanisms
Mathias D.
Last position:
Independent contractor at Allianz-Technology
- Developed a massive web application for second pillar retirement insurances (Swiss BVG, Kollektivleben) with over 1000 web pages using an in-house model language and Angular for front-end and back-end
- Fixed bugs in the code generator and enhanced and re-engineered the application
- Built an automated testbed
- Implemented PDF document generation with XML and Thunderhead
- Resolved issues due to the switch to Java 21
- Replaced middleware server for insurance base data (customers, contracts) using Java/Spring, REST, OpenAPI, Docker, Kubernetes, OpenShift, Azure CI/CD pipeline, Jenkins, and GitHub
Ferran S.
Last position:
Senior Software Engineer at Personal time off / Private projects
- Took on and completed private/organizational projects.
- Continued self-training, e.g., in cloud and reactive architectures.
- Focused deepening of knowledge in areas like Kafka and modern Java 17 enterprise architectures.
Discover over 15,000 top freelancers
Statistics of experts using PL/SQL
Aggregated from the professional profiles of matched freelancers.
Experience
27 years
Position duration
2.5 years
Positions per freelancer
14
Top business areas
Information Technology, Product Development, Project Management
Top industries
Banking and Finance, Information Technology, Insurance
Certification focus areas
Information Technology, Product Development, Project Management
Bachelor's degree or higher
87%
Master's degree or higher
53%
Doctorate
7%
Certifications per freelancer
4
Most common languages
English, German, French
Speak two or more languages
100%
Based on our profile pool as of 19 Sep 2026.
Daily rate distribution
The chart shows how the daily rates of freelancers in this technology in Switzerland are distributed, based on recent contracts on our platform. Each bar covers a rate range — its height shows how many freelancers charge within that range.
Average rates of experts in Switzerland using PL/SQL
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 19 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
PL/SQL experts industry focus
See which industries our matched freelancers work in most often — every figure is calculated live from the freelancers on FRATCH.
- Banking and Finance (80%)
- Information Technology (80%)
- Insurance (65%)
- Government and Administration (55%)
- Manufacturing (40%)
- Professional Services (40%)
- Healthcare (35%)
- Telecommunication (30%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
Oracle’s procedural language
PL/SQL is Oracle Database’s procedural extension to SQL. It combines queries and data changes with variables, conditions, loops, exception handling and reusable program units. Companies use it to keep business rules close to transactional data and to build dependable database-backed systems.
Typical deliverables
PL/SQL specialists create and maintain the database logic that supports critical operations:
- Stored procedures, functions and packages for business workflows
- Triggers, jobs and validation routines for controlled data changes
- Data migration, reconciliation and batch-processing scripts
- Reporting queries and database APIs for enterprise applications
Oracle ecosystem
Effective work with PL/SQL requires more than syntax knowledge. Specialists commonly use Oracle SQL, views, indexes, sequences, constraints and transaction controls alongside tools such as SQL Developer, SQL*Plus and Oracle Database utilities. They may also connect database logic to Java, .NET, REST services, ETL pipelines or reporting platforms.
When companies need help
Companies often bring in freelance PL/SQL expertise during Oracle upgrades, application modernization and complex data migrations. Support is also valuable when slow queries, blocking sessions, fragile batch jobs or difficult-to-test business rules threaten daily operations. In Switzerland, specialists may collaborate remotely or work with teams on site where secure access and close coordination matter.
What strong specialists do
Strong professionals separate data access from business logic, write readable packages and handle transactions and exceptions deliberately. They inspect execution plans, choose indexes based on evidence and protect data integrity under concurrent workloads. Good specialists also document dependencies, create repeatable deployment scripts and explain database behavior clearly to application teams.
Hiring considerations
Look for experience with the Oracle version, data volume, integration pattern and release process used in your environment. Ask for examples of query tuning, migration controls, testing strategy and production troubleshooting rather than relying on code samples alone. For Swiss projects, clarify remote access, security procedures, collaboration hours and the working languages needed by stakeholders.
Frequently asked questions
The facts hiring teams ask for most often when it comes to PL/SQL.
PL/SQL is used to run procedural logic inside Oracle Database. Companies use it for stored procedures, functions, triggers, batch processing, validation and data-intensive workflows where close control of transactions and data integrity is important.
PL/SQL keeps selected business and data-processing logic close to Oracle data, which can reduce data movement and centralize transactional rules. Java or another application language may be better for user interfaces, service orchestration and broader integrations, so many systems use both rather than treating them as direct substitutes.
PL/SQL work often benefits from strong Oracle SQL, data modeling, indexing, execution-plan analysis and transaction management. Depending on the project, useful adjacent skills include Oracle performance tools, ETL, REST integration, Java, reporting systems, version control and automated database deployment.
PL/SQL requirements depend on the risk and scope of the work. A specialist handling a simple report differs from one responsible for migration, performance remediation or financial transaction logic; ask for evidence with comparable Oracle versions, workloads and release controls.
PL/SQL work can usually be performed remotely when secure database access, test data and deployment procedures are available. Swiss teams should also agree on access controls, collaboration hours, documentation standards and whether German, French, Italian or English is needed for communication.
PL/SQL quality shows in clear package structure, safe transaction handling, predictable exception behavior and maintainable SQL. Review how the specialist measures query performance, tests rollback and edge cases, documents dependencies and manages changes through controlled releases.
PL/SQL remains relevant when an Oracle estate contains valuable rules, scheduled processing or transaction logic that cannot be replaced safely in one step. A capable specialist can assess what to retain, expose through services, test, refactor or gradually move into application components.
PL/SQL specialists should clarify the Oracle editions and environments involved, access restrictions, deployment ownership, performance targets and rollback expectations. They should also understand dependencies on applications, ETL jobs, reports and upstream data before changing packages, triggers or schema objects.
The average hourly rate of freelancers in Switzerland who have used PL/SQL in their recent projects is 122 €, which corresponds to a daily rate of about 976 € based on an 8-hour working day.
Of the freelancers in Switzerland who have used PL/SQL in their recent projects, 87% hold at least a Bachelor's degree, 53% hold at least a Master's degree, and 7% hold a doctorate.
On average, freelancers in Switzerland who have used PL/SQL in their recent projects have 27 years of professional experience, with a single engagement typically lasting around 2.5 years.
The most common languages among freelancers in Switzerland who have used PL/SQL in their recent projects are English (100%), German (95%), and French (50%).
The most common industries among freelancers in Switzerland who have used PL/SQL in their recent projects are Banking and Finance (80%), Information Technology (80%), and Insurance (65%).
The most common business areas among freelancers in Switzerland who have used PL/SQL in their recent projects are Information Technology (95%), Product Development (85%), and Project Management (80%).
Main locations of FRATCH Experts, who have recently used PL/SQL
Our freelancers and interim experts are at home across the DACH region — available on-site in the major business hubs or fully remote. Choose a location to discover matched specialists, local market insights and up-to-date availability.
Zurich Request a free demo
Get in touch with the FRATCH team and we will get back to you within 4 hours.
Would you rather directly get in touch?
We always have the time for a call or email!
Philipp Thomaschewski
FRATCH CEO
