Is it possible for a DBA/DBE to earn 1 million USD annual compensation ?
Table of Contents My journey from Traditional RDBMS DBA to Opensource DBE/DBA My journey in the field of database administration (DBA) commenced in 2006 when I took on the role of an IBM DB2 DBA. During the initial years of my career, I predominantly worked with commercial relational database management systems (RDBMS) such as DB2, […]
Postgres for Oracle DBAs – Parameter Changes
Table of Contents What is included in this blog post ? This is Part 6 of the “Postgres for Oracle DBAs” series where we compare ‘parameter changes’. We covered 1) Default tablespaces 2) Executing sql scripts 3) Shutdown modes 4) Startup modes 5) alert log vs postgres log 6) Pg_dump Vs Datapump backups 7) Pg_restore […]
Postgres for Oracle DBAs – impdp Vs Pg_restore
Table of Contents What is included in this blog post ? This is Part 5 of the “Postgres for Oracle DBAs” series where we compare logical backup restores – Data pump restore Vs pg_dump restore(pg_restore). In Part 4 we covered backup scenarios – Please read part 4 before reading this blog . We covered 1) […]
Postgres for Oracle DBAs – Datapump Vs Pg_dump
Table of Contents What is included in this blog post ? This is Part 4 of the “Postgres for Oracle DBAs” series where we compare logical backups – Data pump Vs pg_dump . We covered 1) Default tablespaces 2) Executing sql scripts 3) Shutdown modes 4) Startup modes 5) alert log vs postgres log in […]
Postgres for Oracle DBAs – Alert log vs Postgres log
Table of Contents What is included in this blog post ? This is Part 3 of the “Postgres for Oracle DBAs” series where we compare Postgres log and Oracle alert log. We covered 1) Default tablespaces 2) Executing sql scripts 3) Shutdown modes 4) Startup modes in part 1 and part 2 Oracle Alert log […]
Postgres for Oracle DBAs – Shutdown and Startup Modes
Table of Contents What is included in this blog post ? In part1 of this series(Postgres for Oracle DBAs) we covered two topics 1) Executing sql scripts 2) Default tablespaces . In this post we are going to compare startup/shutdown modes between Oracle and Postgres Oracle shutdown modes Oracle has different shutdown modes as detailed […]
Postgres for Oracle DBAs – Script execution and default tablespaces
Table of Contents What is included in this blog post ? We are starting “Postgres for Oracle DBAs” series with this post . In this post we compare two aspects – 1) Executing sql scripts 2) Default tablespaces Multiple script execution methods are compared with Postgres in this blog post . We also discuss about […]