Senior Applications Engineer
The Australian Oracle User Group, AUSOUG, have a focus on bringing together our Oracle community and servicing their core technical, development and applications needs. A balanced program is aimed at all levels of skill and experience within a forum of User led independent knowledge sharing.
AUSOUG will be hosting a series of webinars to be held every Wednesday commencing on 10th February 2021 whereby each week will focus on a particular area.
We invite Oracle professionals to submit abstracts for the Webinar Series.
Area of Interest
We are constantly seeking presenters for the Webinar Series.
If you are interested in presenting a webinar, please submit your paper/abstract via this link.
|On the way to the “Least Privilege Principle” – Privilege Analysis with the Oracle Database by Markus Flechtner
As a DBA you probably know the situation: one of the first SQL commands when installing third-party software is “GRANT DBA TO ..”. Or: the developers in your own development department don’t know which privileges they need in the database – and first demand DBA rights in the development environment. |
And then the security officer appears on stage and says “everyone may only get the rights he really needs” – the well-known least privilege principle is required.
But how can this be found out?
Since database version 12c Oracle offers the feature “Privilege Analysis” for this purpose.
Unfortunately, the use of this feature was originally linked to the Database-Vault-License – and therefore not (legally) applicable for most DBAs.
This restriction was lifted in November 2018: all customers with Enterprise Edition are allowed to use the feature.
Reason enough to take a closer look at this functionality in the presentation: how can the DBA determine which rights the applications and users really need and set up a suitable rights concept for them?
|5/10/2022||7:00pm AEDT||1 hour||Register|
|The new norm: Optimising Oracle workloads to do more with less by Chris Bannayan
Evolving business pressures and economic uncertainties are creating new challenges for IT departments to do more with less. To support businesses in this new norm a simple, resilient and agile infrastructure is needed now more than ever.
You’re invited to join Pure Storage’s webinar on database and data centre consolidation where Chris Bannayan, Database Solutions Architect, Asia Japan & Pacific at Pure Storage, will unveil how you can get the most out of your Oracle database workloads and support evolving business demands of this new norm.
During the session we’ll cover:
· Cost reduction strategies: Identifying cost savings through removing unnecessary software licenses, data reduction capabilities and data centre consolidation.
· Streamlining systems: Consolidating your Oracle database workloads effectively to simplify management and free up time for strategic initiatives to support globalization.
· Agile performance optimisation: Removing roadblocks such as downtime and lengthy clone cycles to ensure you’re getting the most out of your system, without compromise.
|10 February 2021|
|How to work smarter with Payables by Nigel Grange Processing invoices can feel like a formidable task, the share amount of data that must be collected, verified, and processed is massive. What if there was a better way to streamline invoice processing? See how to get the most out of the industry-leading More4apps AP Invoice wizard and transform your workday in this 35-minute session. Filled with practical hints, tips, and tricks from product expert Carlos Urtubia, attendees will develop an understanding of best practice methods designed to ensure they get the best out of this popular software solution. Webinar attendees will have the opportunity to see how AP Wizard has transformed business practices for leading from customers and take away key learnings from their success. What you will learn: - Demonstration of practical real world scenarios - How to save time when matching invoices - Tips and tricks so your organization and team get the most out of their Oracle EBS Investment||17 February 2021|
|ZDLRA, What you need to know to understand it by Fernando Simon Zero Data Loss Recovery Appliance (ZDLRA) is an Oracle Engineered System and part of MAA family that was built to protect your databases for several kinds of outages and provide reliable recovery options. But what is ZDLRA? And how the features work to allows you to reach the zero data loss? This session addresses what it is and how ZDLRA works, helping you hat will help you to understand it covering features like: Incremental Forever strategy and the Virtual Full Backup, Real-Time Redo, Multi ZDLRA Replication, ZDLRA Catalog management, MAA Integration, and some internal details about architecture. But besides the tech part, this presentation shows how you can use all these features to protect your databases.||03 March 2021|
|DevOps and Agile in the Oracle Cloud - A day in the life of a dev team by Shay Shmeltzer Get an overview of the DevOps and Agile platform included in Oracle's Cloud - Visual Builder Studio - and how a typical development team can leverage it. Learn about the integrated platform offering issue tracking, development sprint management, code artifact versioning, and continuous delivery automation. We'll focus on a demo showing the full development cycle from planning to deployment in an integrated way.||10 March 2021|
|OAF Personalizations 2021 - New Advanced Examples by Susan Behn Have you ever wanted to add an LOV to an OAF page without using jDeveloper? This and many other examples in this presentation can be easily replicated to streamline the user experience. The primary purpose of this presentation is to promote personalization over customization or extension. Oracle has continued to improve the personalization functionality especially for OA Framework. However, while Oracle provides some documentation on these new features, this presentation provides some real world examples with detail step by step instructions specifically for the E-Business Suite using the Vision database.||17 March 2021|
|Oracle Linux DevSecOps: Staying Ahead of Cyberthreats by Nirav Kamdar Oracle Linux (OL) Premier Support includes KVM and server virtualization manager, Oracle Linux Cloud Native Environment which includes Kubernetes, Kata Containers, and more. IT systems require regular patching for security, performance, and compliance reasons. OL Premier support also includes zero-downtime kernel and user-space updates with Oracle Ksplice. 1. Secure Linux: Oracle Linux is certified under Common Criteria and FIPS 140-2, as well as Listed on NIAP product compliant list. 2. Securing Linux Kernel: Non-Disruptive kernel patching, Ksplice supports critical user space packages such as Glibc and OpenSSL, KVM and Xen hypervisors. Ksplice also delivers Known exploit detection for privilege escalation vulnerabilities. 3. Secure Containers: Kata containers are lightweight VMs, which behaves like containers with the isolation of VMS. With Kata containers, get security for workload while running them on Kubernetes. 4. Secure Code: Istio can help secure application/code, while delivers automatic encryption of communication between services. There is no silver bullet to Cyber Security, hence leveraging defence-in-depth approach will at least improve security posture.||24 March 2021|
|Converged Database by Arvind Bhope Modern data driven applications are bringing in a lot more complexity with different data types like Relational,Document,Spatial,Graph, etc and workloads Transactions ,analytics, ML,IOT to name a few. This data and workload require different database algorithms to solve with unique development paradigms and the two possible data strategies are Single Purpose purpose built databases which are best of breed for individual data types and workload OR use a Converged database for all data types and workloads. Problems ? Once we have a single purpose individual db for Spatial,ML, Blockchain, JSON, Graph etc.. we are actually introducing a lot many variables to the ever changing components in existing infrastructure which inherently is increasing the complexity. Single purpose Database would eventually end up doing a lot of custom work, writing more code independently using individual Proprietary API's and transaction models. Propagating and transforming all these changes with fragmented data all over the place creates lot more complexity and there is definitely a need to integrate it with a lot of customization. This Integration is a job that never ends. The necessary features like security, availability,scalability are just very complex to achieve,as each of them has its own models to be built. Later, to propagate any of the smallest change and integrate its a huge activity. Availability,scalability,consistency,End to End security etc are very limited in their areas by weakest of their databases that are implemented. Combining all of them gives worst of weakness. These systems are JUST NO economies of scale. Solution: What if we say all the above challenges are addressed in Converged database. Oracle Converged Database is a data innovation platform ,an ecosystem which increases the strategic business value of data. Click here for more information on solution - https://www.ausoug.org.au/paper/converged-database/||31 March 2021|
|Unleash the Top 19 New Features of Oracle Database 19c by Charles Kim Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2/18c/19c database features. Be prepared to have mind overloaded with the following focused areas: 1. Oracle 20c New Features 2. Oracle 19c New Features 1. Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2/18c 3. Oracle 18c New Features 4. Upgrade to Oracle 12.2/18c/19c/20c a. Upgrade considerations b. Zero downtime upgrade options 5. Multi-Tenancy (PDB) Option 1. Elimination of support for non-container databases in Oracle 20c 2. Changes in Oracle licensing policy with Oracle19c 6. Online Improvements 7. Partitioning Option 8. Data Guard 9. RMAN 10. General Database 11. RAC 12. ASM/ACFS 13. In-Memory Oracle DBAs/Developers can take immediate advantage of these new features. We will rapid fire all the new features to the audience. We will share all of the code from our presentation so that you can add them to your arsenal.||07 April 2021|
|Automating Invoice Processing in Oracle Cloud ERP Leveraging Bots by Dr. Nikhil Jain and Vishal Saxena Organizations embracing automation into their finance function have experienced reduction in process cycle time and costs up to 70% - 80%. When your team spends less time processing invoices, they can focus on more value-generating tasks. Join our subject-matter experts – Dr. Nikhil Jain, Solution Architect in conversation with Vishal Saxena, Finance and Supply Chain Specialist, as we bring to you an exciting session on how you can achieve Invoice Process Automation within Oracle Applications. 1. Minimize invoice processing effort and time 2. Eliminate manual data entry and errors 3. Improve vendor association 4. Improve visibility across the Accounts Payable process 5. Improve reconciliation Learn how our Bot based solution can transform Finance and Accounting to ensure faster, error-free tasks and process optimization in your Enterprise. We will also walk you through a short demo automating invoice processing using our Bot based solution.||14 April 2021|
|What’s new with the World's fastest EBS reporting solution? by Beth Skerrett / Andy Haack World’s fastest EBS reporting solution – Increase your team efficiency by getting end-user operational reports faster than ever before with modern, easy to use reporting. This presentation shows how a new approach can provide easier, faster, more efficient access to data in an instantly usable format that end users love. See how to migrate reports from existing ageing and inefficient EBS reporting tools like Discoverer, Polaris, Report Wands, and BI Publisher. With the ability to export over one million transactions in less than 10 seconds, and with our unlimited data output, it is an option that users of large volumes of data need to see to believe! This presentation will demonstrate how job satisfaction and productivity can be increased for all EBS business users and developers. We demonstrate Blitz Report™, a reporting option available to EBS operational users looking to manage large volumes of transactional data quickly and efficiently, and how using this solution with Oracle's Enterprise Command Centers is a game-changer for EBS teams. Objective: The objective is to help EBS business users and developers increase their job satisfaction and productivity by adding a new transactional reporting solution to their current reporting and analytics tools.||21 April 2021|
|Running Oracle Databases on Containers and Kubernetes with Pure Storage by Chris Bannayan Gartner predicts that by 2022, more than 75% of global organisations will be running containerised applications in production, up from less that 30% today. Businesses now, more than ever should be putting together a strategy of how they will embrace this world of containers and Kubernetes to optimise their workloads in the transforming world. See how Pure integration with Containers and Kubernetes, coupled with its simplicity, efficiency and performance will modernise your data centre, reduce your complexity and increase your agility, so that your business can focus more on innovating and less on managing. During the session we’ll cover: ● How to create Docker containers using the Pure Storage plugin ● How to create persistent volumes using the Pure plugin ● How to create Oracle containers with persistent storage ● How to clone Oracle containers to create Dev/Test environments ● How to refresh Dev/test containers from a prod container||19 May 2021|
|Ensure a Successful Oracle Cloud Migration by Peter Earnshaw The move to enterprise applications such as Oracle Cloud can offer many benefits along with a myriad of challenges, many of which may be unknown until you are knee-deep into the project. Up to 80 percent of problems with enterprise systems are related to human error and unidentified technical issues. Before you get started, it is imperative to carefully plan and make sure you have the capability and visibility to measure user behaviour, workflows, interaction, adoption, and most importantly, how they can impact productivity and profitability. In this webinar we are going to answer 5 critical questions you should ask before embarking on your Oracle Cloud project: Where should we start? How do we mitigate risk? How do we know what processes and transactions need to be prioritized? How can we maximize adoption? How can we measure ROI? This webinar will give you some answers to these questions along with showing you the benchmark data needed to get you started on your journey.||02 June 2021|
|Securing your mission critical systems running Oracle from cyber attacks by Trichy Premkumar Until recently, organizations have focused on trying to prevent cyberattacks, which come primarily from hacking and malware. However, the likelihood that all malware will be discovered before harm is done is slim, particularly for slow-moving and sophisticated attacks. This difficulty of detecting malware early gives hackers time to orchestrate attacks ranging from extortion to outright destruction of mission-critical systems. Such cyberattacks can cripple an organization, leading to revenue loss, negative publicity, and lasting customer distrust. In this session we will review how Oracle data protection can be simplified, secured and enhanced to include comprehensive cyber recovery protection.||09 June 2021|
|Containerization 101 by Osama Mustafa Containerization is the process of packaging software code, its required dependencies, configurations, and other detail to be easily deployed in the same or another computing environment. In simpler terms, containerization is the encapsulation of an application and its required environment, Learn about the docker , and what is Containerization such as Docker swarm and kubernetes.||16 June 2021|
|How Does Oracle Cloud Costing Stack Up Against Oracle EBS Costing? by Doug Volz Oracle keeps on "banging on" about the Cloud Applications. Are you curious what it looks like or how it compares to Oracle EBS? This webinar session moves beyond the fluffy sales presentations and dives into the details, directly comparing Oracle EBS to Oracle Cloud Costing. Including many of the Cloud Costing setup steps, so you can see what is actually involved. Objectives: 1) Find out if Cloud Costing is really different from EBS Costing 2) Compare Oracle EBS to Oracle Cloud Costing 3) Learn about the Cloud Costing setup steps 4) Get an overall impression for how Cloud Costing helps and doesn’t help you||23 June 2021|
|Automate Database Provisioning for DevOps using Database-as-a-Service - Chetan Vithlani/Venkata Bandaru/Maniselvan Kannimuthuraj Often DBAs want to allow self-service access to certain database operations. By doing so, the DBAs can free-up their own time while enabling others to do their jobs faster. Self-service access (SSA) is enabled right from the Oracle Enterprise Manager. The Self-Service Portal allows users to create new service instances (Databases or Pluggable Databases) based on Service Template configured by SSA administrators. Additionally, Oracle Enterprise Manager Database as a Service Snap Clone is a ‘self-service’ solution for enabling rapid creation of space efficient clones for large, multi-terabyte databases. Snap Clone can improve the efficiency and agility of administrators and QA engineers while reducing storage-related CAPEX. Database as a Service Snap Clone allows administrators to create fully functional copies of databases using the copy-on-write (CoW) capabilities of the underlying storage layer. Users can request databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum. This Session will cover database automation for devops: 1) self-service users such as developers and QA can leverage DBaaS (Database-as-a-Service) to quickly provision databases 2) create storage efficient thin clones for development purposes, and 3) chargeback/show back of resources used at the OS and DB level to ensure that proper accounting is kept for resource usage in your private cloud.||07 July 2021|
|Information Life Cycle Management : Manage Exponential Data Growth (Live Demo) by Chandan Tanwani The exponential increase of data volumes puts enterprise IT infrastructures under pressure in cost, performance, scalability, and manageability. The regulatory requirements are changing, like how and why data are retained. Many organizations are now required to maintain and control more information for a more extended period. Information Lifecycle Management (ILM) is applying policies for the effective management of information throughout its useful life. Oracle's Advanced Compression and Data Partitioning help organizations to deploy ILM policy. The benefits include improving enterprise application's performance, reducing infrastructure cost, providing governance, risk, and compliance framework for enterprise data. In this session I will cover in-depth of advance compression and database performance benefits. I will also discuss Automatic Data Optimization and Heat Map to define policies, move data to different storage tires with Live Demo.||21 July 2021|
|Magic of Oracle Cloud Infrastructure with Ansible by Arpit Agrawal This session would cover the aspects of Infrastructure provisioning in OCI using Terraform on the fundamentals of Infrastructure as a code. Why automate OCI Provisioning? Real world Terraform OCI Examples Terraform Installation and Best practices Tip and Tricks on Infrastructure as a code.||04 August 2021|
This year we’ve been able to secure some of the worlds best speakers to present the Webinar Series 2021.
To find out more about each speaker, read the their bio and see what papers they will be presenting, simply click on the desired speaker.
Senior Applications Engineer
Principal Software Engineer
Principal Product Manager
President, Douglas Volz Consulting
Douglas Volz Consulting, Inc
Database Solution Architect
Principal Sales Consultant
Director of Product Management
Senior Database Architect
Principal Solution Engineer
National Sales Director
More4apps Product Expert
Viscosity North America
Finance and Supply Chain Specialist
Technical Director and Principal Instructor
Senior Staff Solution Architect & Global Oracle Practice Lead
Senior Solution Engineer, Database
Sales Director, APJ