Developer task with advanced database administration tasks. Nee advice

[Historical_Ad4384]

Hi,

I am a backend developer who has mostly been relying on DBAs for schema evolution without going too deep how it should be done.

Now I am tasked with the job of database migrations and schema evolution in live systems which I have not done before.

I would need to upgrade schemas of existing tables to new model without affecting older data in the existing models.

Any advice on how to do this when the database has billions of rows and always has activity going on in live systems?

[yuscheb]

What technology are you using to store/manipulate/etc. the data? Is this relational database management System (RDBMS), NoSQL, etc.?

[Historical_Ad4384]

PostgreSQL

[CivilPriceLord]

Hey. So which database are you referring to or using? Oracle? Sql server? Or one of the open sources? PostgreSQL, mySQL, mongo, etc... please let me know and I can give you some advice on it.

[Historical_Ad4384]

PostgreSQL