database analyst (DBA)

Work Term: PermanentWork Language: EnglishHours: 40 hours per weekEducation: Bachelor's degreeExperience: 2 years to less than 3 yearsTasksData ScienceDevelop and implement a strategic blueprint to follow when deploying databases within their organizationDevelop and maintain computer databasesDocument reporting needs, queries, logic, results and recommendations to other information systems professionalsEnact measures to make sure unauthorized users cannot access the dataLiaise with staff on data requirements, collection and availability Provide advice to other informatics professionals regarding database management toolsSetup the IT infrastructure to allow applications to access databasesTest data models and database management systemsDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for network access and usage and for the backup and recovery of dataWrite scripts related to stored procedures and triggersComputer and technology knowledgePowerBuilderShell scriptLinuxMS SQL ServerMySQLOracleDatabase softwareMS OfficeSQLElectronic mailPersonal suitabilityAccurateEfficient interpersonal skillsInitiativeOrganizedTeam playerAdaptabilityAccountabilityHealth benefitsDental planHealth care planVision care benefitsSupport for persons with disabilitiesProvides physical accessibility accommodations (for example: ramps, elevators, etc.)Provides awareness training to employees to create a welcoming work environment for persons with disabilitiesApplies accessible and inclusive recruitment policies that accommodate persons with disabilities Support for newcomers and refugeesSupports newcomers and/or refugees with foreign credential recognitionOffers mentorship programs that pair newcomers and/or refugees with experienced employees Provides diversity and cross-cultural trainings to create a welcoming work environment for newcomers and/or refugees Support for youthsOffers mentorship, coaching and/or networking opportunities for youthProvides awareness training to employees to create a welcoming work environment for youthSupport for Indigenous peopleProvides cultural competency training and/or awareness training to all employees to create a welcoming work environment for Indigenous workers Facilitates access to Elders who can offer support and guidance to Indigenous workers Supports for visible minoritiesParticipates in a government or community program or initiative that supports members of visible minoritiesApplies hiring policies that discourage discrimination against members of visible minorities (for example: anonymizing the hiring process, etc.)Offers mentorship programs that pair members of visible minorities with experienced employeesProvides diversity and cross-cultural training to create a welcoming work environment for members of visible minorities