Sharepoint Database Administrator
CurrentResponsible for supporting the Department of National Defence within the Canadian School of Aerospace Technology and Engineering (CFSATE). Key accountabilities include:- Develop, design, implement, and maintain existing and new database solutions and provide reliability, availability and data protection, while ensuring database integrity.- Work closely with the database users in order to maintain and safeguard the integrity of the database.- Identify requirements for improvements to existing databases by determining users' information requirements and system performance and functional requirements.- 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 efficient use of data.- Maintain configuration control of the database. Perform and/or co-ordinate updates to the database design.- Control and coordinate changes to the database, including the deletion of records and changes to existing records.- Develop and coordinate back-up and disaster recovery for all databases.- Develop user-friendly front ends for existing and new databases.- Develop learning materials, SOPs, job aids and Work Instructions as required.- Provide training and support to the users of Monitor Mass and associated software.- Track and monitor data collection ensuring security and data integrity.- Develop automated reporting procedures and data mining for requested information as required by senior management, enabling a self-serve environment