Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector.
S.i. Systems
Ottawa, ON-
Number of positions available : 1
- Salary To be discussed
-
Contract job
- Published on November 4th, 2024
-
Starting date : 1 position to fill as soon as possible
Description
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:
Nice to Have:
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
Requirements
Level of education
undetermined
Work experience (years)
undetermined
Written languages
undetermined
Spoken languages
undetermined
Other S.i. Systems's offers that may interest you