Which tasks were implemented

• Oracle database administration and optimisation
• Performance tuning and troubleshooting
• Creation of complex PL/SQL scripts and procedures
• Optimisation and debugging of PL/SQL code
• Working with triggers, functions and packages
• Creating and managing reports in SSRS
• Designing report layouts and formats
• Optimising report performance and troubleshooting
• Creating and optimising SQL queries for data evaluation
• Analysing and interpreting query results
• Creating reports and presentations based on query results
• Designing and developing customised reports in SSRS
• Validating and testing reports to ensure accuracy and performance
• Create and maintain technical documentation for all solutions and processes developed
• Conducting tests to ensure functionality and performance of developed solutions

Which technologies were used

• Microsoft Visual Studio
• Oracle 11g
• SQL
• T-SQL
• PL/SQL
• Micrsoft SQL Server
• Microsoft SQL Server Reporting Services (SSRS)
• ITIL