DBA process and tasks

Owned by Maria Martinez (Unlicensed)
Last updated: Aug 02, 2022 by Noreen Dertinger
2 min read

New process (in review)

  1. *In blue, is a task assigned to Data Management Team.

 

*Currently (this can be changed):

For database changes in DML (Data Manipulation Language such as

Select, Insert, Update, Delete …), we can change production database ourselves if these are simple changes. For complicated changes or requesting reviews, we can create an SGMS request.

For database changes in DDL (Data Definition Language such as Create, Alter, Drop, Truncate…), store procedure changes we need to create an SGMS request and send it for Data Management team for review.

Example of database script: C254092
July 2022: For a change to the DDL (Alter) I followed the steps below:
1. emailed DataManagement Team to confirm that the model I was modifying (obtained from the repos) was the latest correct one. They confirmed, also sent me copy of the same model.
2, Made the model change in ERWIN.,
3. Sent the updated model to the Datamanagement team as requested (confirmed this process on Aug 2nd with Jen Xiong).

Please send your updated model to our group email address DSDDataManagement-GestiondonneesDGSN@tc.gc.ca

Once the model is approved then you can generate the alter scripts and send the scripts to our group email address again to post for DBA to execute. Do you have a Change Request created in SM-GS? We will post the scripts after the change is approved and task is assigned to us.

Please let us know if you need further information.

4. Updated the corresponding step in the process diagram.

 

 

*Database Repo
https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CivAv_Database

 

*Database Management Team: DSDDataManagement-GestiondonneesDGSN@tc.gc.ca

 

 

Tasks