UTOUG Training Days 2025: Full Schedule

9:30am MDT

From Data Silos to Unified Platforms: Leveraging Oracle Autonomous Database for Cross-Cloud and Multiplatform Integration

Monday March 24, 2025 9:30am - 10:15am MDT

Room 213

In today’s multi-cloud, multiplatform environment, a unified data platform is critical for maximizing the potential of an organization’s data assets. Oracle Autonomous Database supports this all-data strategy by seamlessly integrating with OCI, Azure, GCP, AWS, and third-party platforms like Snowflake and Databricks.

This session explores how Oracle’s advanced data platform enables seamless data integration across clouds, unifying structured and unstructured data into a cohesive system. Highlights include the latest enhancements for managing unstructured data, such as full-text indexing and semantic vector search, along with automation tools for efficient metadata integration.

Learn how multiple Autonomous Databases can operate as a single, unified platform, delivering high-performance analytics and insights regardless of data location. Featuring real-world demonstrations, this session provides actionable strategies to leverage Oracle’s data platform for driving value across all data sources and environments.

Speakers

Alexey Filanovskiy

Senior Prinicipal Product Manager, Oracle

Alexey has more than 16 years of experience in data warehousing and data lakes, including 12 years at Oracle. He began as a data warehouse developer, working with technologies like Oracle Exadata, Teradata, and Apache Hadoop. In 2012, he became a sales consultant at Oracle, promoting... Read More →

Monday March 24, 2025 9:30am - 10:15am MDT
Room 213

Infrastructure (including database), Data (not database)

10:30am MDT

Case Study: Payment Processing Company Achieves 100% Uptime Migrating and Upgrading Database to Exadata

Monday March 24, 2025 10:30am - 11:15am MDT

Room 213

Learn how one of the largest payment processing companies migrated its mission-critical databases to the latest Exadata platform with zero downtime. During the migration, we upgraded databases from Oracle 12c (12.1) to Oracle Database 19c. This session will cover technical architecture details, how ultra-high availability was achieved, lessons learned, and, most importantly, how we mitigated risks related to performance.

Numerous challenges were overcome as the databases served a global financial client base. The production database migration to the Exadata environment was completed with zero downtime architecture, using a "live cutover" while continuing to process application data. The Exadata clusters consisted of two sets of ten-node RAC compute nodes across two data centers.

Technologies leveraged include:
- Datapump
- GoldenGate
- Real Application Testing
- 10-Node RAC Cluster
- Global Data Services
- 10-Node RAC Cluster Exadata replicating data to another 10-Node RAC Cluster Exadata

Speakers

Charles Kim

CEO, Viscosity North America

Charles Kim is an Oracle ACE Director, VMware vExpert, Oracle Certified DBA, and certified in Exadata, Oracle Linux, Oracle Cloud, and RAC. He joined the Oracle ACE Program in 2008 and became an Oracle ACE Director in 2009. Kim also became a VMware vExpert in 2013. He specializes... Read More →

Monday March 24, 2025 10:30am - 11:15am MDT
Room 213

Infrastructure (including database)

11:30am MDT

Streamlined Analytics: Maximizing the Oracle Database for In-Place Processing

Monday March 24, 2025 11:30am - 12:15pm MDT

Room 213

Learn how to leverage Oracle Database's powerful features to eliminate the need for transferring data between OLTP and OLAP/DW environments for analytics and reporting. This session will explore strategic use cases of Oracle's Materialized Views, In-Memory Column Store, Result Cache, Partitioning, and more, showing how these tools can significantly reduce data movement. The focus will be on the key benefits of in-place data processing, including minimized network traffic, reduced processing demands, and lower data redundancy. We will discuss how using these Oracle Database features not only streamlines analytics but also boosts efficiency and data integrity, enabling more agile business practices. Discover how to transform your data ecosystem into a more efficient, integrated environment that cuts costs, reduces complexity, and enhances analytical performance.

Speakers

Franky Weber Faust

Lead Database Consultant, Pythian

Franky Faust is a lead Oracle database consultant at Pythian, specializing in Oracle Exadata and high-availability technologies. He also has extensive expertise in databases such as Snowflake, MySQL, Cassandra, and SQL Server.Franky is dedicated to enhancing his skills, with a focus... Read More →

Monday March 24, 2025 11:30am - 12:15pm MDT
Room 213

Infrastructure (including database), Development

1:15pm MDT

"Rogue One" (2024) Best Security Practices for Oracle Databases and How to Use DBSAT

Monday March 24, 2025 1:15pm - 2:00pm MDT

Room 213

This conference covers general best practices for Oracle security and explores new features in database security from versions 12c, 18c, 19c, 20c, 21c, and 23c.

I will explain the importance of protecting data, particularly sensitive information, in compliance with regulations like GDPR and others. The session will also provide a detailed overview of DBSAT, including its functionality, how to use it, and how it helps identify sensitive data within your database.

Additionally, I will cover the basics of database security, highlight key considerations, and briefly introduce DataSafe, an Oracle Cloud OCI tool based on DBSAT. This tool offers a graphical interface with enhanced capabilities.

Speakers

Roy Salazar

Senior Oracle Database Consultant, Pythian

Roy Salazar is a senior IT professional with experience working with Oracle products and technology since 1998. He spent the first six years as a consultant developer and systems analyst, followed by more than 18 years as a DBA and database consultant, working with Oracle versions... Read More →

Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 213

Infrastructure (including database)

2:15pm MDT

Hands-On With the New Oracle Multi-Cloud Services

Monday March 24, 2025 2:15pm - 3:00pm MDT

Room 213

Oracle now supports Oracle Database on Azure, Google Cloud, and AWS. What do these services look like, and how do they interact with other cloud services? What’s the difference between provisioning through a third-party cloud versus using Oracle Cloud Infrastructure (OCI) directly? This demo-heavy session will provide critical details and show live implementation steps in Google Cloud. Learn how to plan and provision Oracle Databases and APEX environments through these new services.

Speakers

Simon Pane

Principal Consultant, Pythian

Simon is an Oracle ACE Pro and Oracle Certified Professional with extensive experience presenting at major Oracle and PostgreSQL conferences, including Oracle CloudWorld. He has won multiple speaking and writing awards, including the UKOUG Best New Overseas Speaker in 2016. A former... Read More →

Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 213

Infrastructure (including database), Beyond Oracle

3:15pm MDT

Amazing Free Tools for Oracle DBAs

Monday March 24, 2025 3:15pm - 4:00pm MDT

Room 213

Our scripts utility belt doesn't have to cover it all! Know some outstanding free tools to manage your Oracle Database environment. In this session we'll get in touch with some amazing free tools to check on the database performance, issues, tracing things from your database and server perspectives.

Speakers

Matheus Boesing

Database Consultant, Aggrandize

A frequent speaker in the Oracle community across Latin America and Europe, Matheus is a computer scientist from PUCRS with 15 years of experience as an Oracle DBA. He is an Oracle Instructor and serves as a professor for the databases in cloud postgraduate program in Brazil. Matheus... Read More →

Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 213

Infrastructure (including database), Development

9:15am MDT

Cloud Migration –Migrating Oracle Database to OCI/AWS/Azure

Tuesday March 25, 2025 9:15am - 10:00am MDT

Room 213

With the current trend being "Cloud migrations"-- understanding the steps and details of planning and designing a successful migration is highly impertive to our success. Oracle database migration to the cloud can be stressful when we have to consider multiple cloud provider. Trying to assess and evaluate multiple providers like OCI, AWS & Azure takes time and can delay the project timeline. My presentation details all the know how on the different providers and the pros and cons for the different options available when we consider cloud migration of Oracle This will be beneficial to all technical & business folks.
Learning Objectives:
1. Details on requirements to be gathered, technical steps to be planned and analyzed
2. Questions like : "Is Oracle RDS on AWS a good fit or should one go down the path of EC2 and Active database guard to set up resilience and redundancy " will be explored and analyzed.
3. Differences between the cloud providers –nuances to pay attention to help implement Oracle database migration successfully on OCI/AWS & AZURE
4. Common issues, shortcomings that need attention so as to avoid pitfalls.

What are the key steps to follow for successfully migrating oracle from on-prem to the cloud ( OCI/AWS/AZURE) Presentation will illustrate the tasks to follow while planning a migration of an Oracle database to the cloud. Based on each provider there are differences in what can and can not be done.
Questions like : "Is Oracle RDS on AWS a good fit or should one go down the path of EC2 and Active database guard to set up resilience and redundancy " will be explored and analyzed.
What are the Do's and Don’t based on specific cloud provider to ensure the migration is successful?
How do we ensure we have a cloud-based database that is performing at its optimal irrespective of the provider? Once migrated how do we ensure efficient performance.
Presentation will illustrate all the above and give pointers on important tasks to help DBAs plan and implement cloud migration successfully.

Speakers

Valli Ramanathan

Sr Manager Engineering, Freddie Mac

Valli Ramanathan is an Oracle ACE Associate and Oracle Certified Cloud Architect Professional with over 20 years of experience in managing teams and designing complex database solutions. She has led large DBA teams (local and offshore) to implement innovative, cost-effective solutions... Read More →

Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 213

Infrastructure (including database), Development

10:15am MDT

High Availability and Disaster Recovery Options in Oracle Cloud to Meet RPO and RTO Requirements

Tuesday March 25, 2025 10:15am - 11:00am MDT

Room 213

Oracle Gen 2 Cloud is more powerful, secure, and advanced than its Gen 1 counterpart. Available since 2019, it has seen numerous service and feature enhancements. One key area of progress is business continuity. Explore Oracle Cloud's High Availability and Disaster Recovery solutions to ensure your business meets its Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements. We'll also discuss the benefits of the Full Stack Disaster Recovery service on OCI.

Speakers

Biju Thomas

SVP of Digital Transformation, Data Intensity

Biju Thomas is an OCI technical solution expert and leads the Digital Transformation practice at Data Intensity. He has been recognized as an Oracle ACE Director since 2015 for his expertise and contributions to the Oracle community. Biju started as a developer, has extensive experience... Read More →

Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 213

Infrastructure (including database), Infrastructure (including database)

11:15am MDT

Multitenant 12.1 to Multitenant 23ai: Technical Deep Dive

Tuesday March 25, 2025 11:15am - 12:00pm MDT

Room 213

Oracle Database 23ai introduces new features for pluggable databases (PDBs), enhancing options for both cloud and on-premises environments. This session provides a deep dive into multitenant architecture, covering key concepts of container databases (CDB) and PDBs, their unique value, and how to manage shared and exclusive components. We’ll also explore methods for accessing and managing CDBs/PDBs and outline migration paths from earlier versions to 12c and 23ai.
Advanced features from Oracle 12c R2 and 23ai will be covered, including PDB relocation, lockdown profiles, memory and I/O prioritization, and snapshot carousel. New 23ai capabilities—Control PDB Open Order, Hybrid Read-Only Mode for PDBs, and Refreshable PDBs in DBCA—will be highlighted, demonstrating how Oracle Database 23ai provides greater flexibility, control, and efficiency in multitenant environments.

Speakers

Anuj Mohan

Principal Enterprise Architect, Big River Steel

Anuj is an Oracle ACE and a frequent speaker at major Oracle conferences, including Oracle OpenWorld, Collaborate, Great Lakes, East Coast, and local user groups. He is also a regular speaker at Northern Kentucky University (NKU). Anuj is the founder of Oracle19cSIG (Quest) and has... Read More →

Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 213

Infrastructure (including database), Data (not database)

1:30pm MDT

Gateway to Hell - Network Basics for DBAs, DEVs and DevOps

Tuesday March 25, 2025 1:30pm - 2:15pm MDT

Room 213

New environments are increasingly built on a software-defined data center, both on-premises and in the cloud. However, more traditional approaches still require database administrators or DevOps teams to understand and manage the network stack. Knowledge of this foundational technology is more important than ever, even though, at its core, it originated in the 1980s and ’90s.

With a lighthearted approach, we’ll answer questions like:
- What’s so great about the Classless Society?
- What does a salami pizza have to do with network technology?
- If Superman likes supernetting, who handles subnetting?
- How do nuclear weapons impact network design?
- If my routes come from GPS, what do I need a router for?
- Who has DNS in their DNA?

We invite DBAs, developers, and DevOps professionals to rediscover the basics of network technology through the practical lens of experienced, hands-on database experts. This session is designed for IT professionals with limited exposure to networking who want to expand their understanding.

Speakers

Martin Klier

Senior DB Expert, Performing Databases GmbH

Martin Klier has nearly 20 years of experience in Oracle database administration, focusing on high-availability solutions with RAC and Data Guard. In recent years, he has specialized in performance analysis and tuning of complex systems.Klier is an Oracle ACE Director and frequently... Read More →

Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 213

Infrastructure (including database), Beyond Oracle

2:30pm MDT

Liquibase With Oracle – Automating Your Schema Management

Tuesday March 25, 2025 2:30pm - 3:15pm MDT

Room 213

Managing a modern database schema can be complex, frustrating, and even risky. Schemas are at the core of application data and can either support or hinder application design. Oracle has integrated the open-source Liquibase into SQLcl, which has been included with Oracle 19c and SQL Developer for some time.

This session will teach you how to use SQLcl to track changes, manage schema and database code drift, make reliable changes, ensure consistent rollbacks, and more. Expand your DevOps methodology by fully automating schema updates.

Speakers

Gary Gordhamer

Managing Principal Consultant, Viscosity North America

Gary Gordhamer has spent much of his career focusing on enterprise application landscapes and business process digitization. His technical experience spans more than 30 years with Oracle E-Business Suite, middleware, databases, and related technologies. His professional background... Read More →

Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 213

Infrastructure (including database), Development

UTOUG Training Days 2025

From $50.00