A b s t r a c t 

Title: PostgreSQL Database for Oracle DBAs
Presenter: Shailesh Rangani
Organization: Datavail
Summary: Oracle Database is a multi-model DBMS owned by Oracle Corporation. Mainly it is used for running online transaction processing (OLTP), data warehousing (OLAP) and mixed database workloads. It's market-leading database technologies.

PostgreSQL is commonly known as Postgres is a open source database. It has over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. PostgreSQL has various forks like EDB, Redshift, AWS Aurora, Netezza, etc..

1000s of databases getting migrated to the PostgreSQL from Oracle in recent days. While number of PostgreSQL deployments and databases in increasing significantly, it is also attracting existing Oracle DBAs to learn PostgreSQL as their primary of secondary skills.

This session will cover the below PostgreSQL features with comparing them with Oracle.

• General Features
• Similarities
• Architectural differences
• Basic DBA Tasks
• Programming Features
• High Availability options
• Observability
• Concurrency control differences
Topic: Database/DBaaS Administration
Session Type: One Hour Session
Target Audience: Database Administration
Experience Level: Novice
Session: 7: 02/09/2024 10:10 am to 11:10 am
Location: Database/DBaaS Administration
Biographical Sketch: Shailesh Rangani is Global Practice Lead of PostgreSQL at Datavail. He leads a team of
PostgreSQL DBAs in the United States, Colombia and India working with customers around the
globe supporting their PostgreSQL environments. Shailesh has 18 years’ experience
with database administration. His expertise lies in the design, deployment,
administration, and management of data-intensive applications that enable
organizations to effectively analyze and process large volumes of structured
and unstructured data. Shailesh specializes in AWS, NoSQL, RDBMS and
Cloud platforms. He is able to deliver the data architecture strategy.
for projects and large-scale platforms.

Accomplishments: 1. AWS Certified Solutions Architect - Professiona + 6 AWS Certs
2. Certifications on DB2 LUW, Oracle, MongoDB, OCI and Azure
3. Presented multiple times in various conferences on topics like below.
3.1 PostgreSQL for Oracle DBAs
3.2 Tale of the PostgreSQL TOAST Table
3.3 PostgreSQL Blue/Green deployments
3.4.Top 10 Maintenance Tasks on the PostgreSQL PaaS
3.5 Migrating Oracle Databases to Amazon Aurora
4 Writing blogs on various PostgreSQL topics


RMOUG Training Days

Conference Administration Tool | Copyright © 2024, Prairie Systems Group, Limited