Source : JobIllico
The employer

s.i. systèmes

Job
View or Apply

Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector.

Reference number: 
911866080
Publication date: 
April 16 2024 
Main functions: 
Our public sector client requires an Enhanced Reliability Cleared Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector.

Responsibilities:

a. Develop, customize and implement data conversion procedures which extract, transform and load data from source systems to a data warehouse.
b. Generate new databases with the client.
c. Maintain data dictionaries.
d. Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database.
e. Develop and implement security procedures for the database, including access and user account management.
f. Advise programmers, analysts, and users about the efficient use of data.
g. Maintain configuration control of the database.
h. Perform and/or coordinate updates to the database design.
i. Control and coordinate changes to the database, including the deletion of records, changes to the existing records, additions to the database.
j. Develop and coordinate back-up, disaster recovery and virus protection procedures.
k. Monitor system performance and identify problems that arise.
l. Perform problem investigation and resolution, and provide support for applications and developers.
m. Report on metrics regarding usage and performance.

Must Have:
  • Experience controlling and coordinating changes to RDBMS databases
  • Experience working within an RDBMS database on a UNIX/Linux environment developing release packages
  • Experience developing and maintaining Extract Transform Load (ETL) scripts.
  • Experience identifying, investigating and resolving problems with data retrieval and design

Nice to Have:
Apply
Salary: 
to be discussed
Requirements
Education
Diploma: 
None
Working experience
Minimum experience required: 
None
Work place
Ottawa , ON