Senior Database Admin to optimize business rules and integrate functionality within their MS Access Database.
S.i. Systems
Ottawa, ON-
Number of positions available : 1
- Salary To be discussed
-
Contract job
- Published on September 20th, 2024
-
Starting date : 1 position to fill as soon as possible
Description
Our public sector client, is looking for a Senior Database Admin to optimize business rules and integrate functionality within their Database.
Our client has a letter of offer builder tool that was created for use by Human Resources advisors and assistants, and the development is currently ongoing in order to improve the tools, usability and stability, and customizability.
Task; but not limited to :
- Use Complex SQL views writing and MS-Access advanced developing
- Finalize Conversion Strategy from previous hardcoded development approach to database approach
- Generate new database with the client
- Maintain data dictionaries
- Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database
- Develop and implement security procedures for the database, including access and user account management
- Advise programmers, analysts, and users about the efficient use of data
- Maintain configuration control of the database
- Perform and/or coordinate updates to the database design
Must Haves
- Secret Clearance
- 5 years in Relational Database modeling
- 5 years in Complex T-SQL programming
- 5 years in SQL structural change Scripting
Requirements
undetermined
undetermined
undetermined
undetermined
Other S.i. Systems's offers that may interest you