database administrator (DBA)

Job description
• Work Term: Permanent
• Work Language: English
• Hours: 37.5 hours per week
• Education: Secondary (high) school graduation certificate
• Experience: 3 years to less than 5 years
• Work setting
• Financial technology
• Tasks
• Collect data to identify areas for improvement within an organization's IT infrastructure
• Develop and implement a strategic blueprint to follow when deploying databases within their organization
• Develop and maintain computer databases
• Document customers' requirements for projects
• Document reporting needs, queries, logic, results and recommendations to other information systems professionals
• Enact measures to make sure unauthorized users cannot access the data
• Liaise with staff on data requirements, collection and availability
• Provide advice to other informatics professionals regarding database management tools
• Setup the IT infrastructure to allow applications to access databases
• Test data models and database management systems
• Design and develop database
• Operate database management systems to analyze data
• Develop and implement data administration policy, standards and models
• Research and document data requirements, data collection and administration policy, and data access rules
• Develop policies and procedures for network access and usage and for the backup and recovery of data
• Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models
• Write scripts related to stored procedures and triggers
• Maintain and manage digital database
• Develop financial procedures
• Implement data, software and hardware security procedures
• Computer and technology knowledge
• R
• MS SQL Server
• MySQL
• Mapping and data visualization software
• .NET
• Angular.js
• C#
• CSS
• Git
• HTML
• JavaScript
• Python
• Business intelligence
• Database
• API
• Development and operations (DevOps)
• Work conditions and physical capabilities
• Work under pressure
• Attention to detail
• Personal suitability
• Accurate
• Efficient interpersonal skills
• Organized
• Team player
• Accountability
• Screening questions
• Are you currently legally able to work in Canada?
• Do you have previous experience in this field of employment?
• Health benefits
• Dental plan
• Health care plan
• Vision care benefits
• Support for newcomers and refugees
• Offers 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
• Does not require Canadian work experience
• Support for youths
• Offers mentorship, coaching and/or networking opportunities for youth
• Provides awareness training to employees to create a welcoming work environment for youth
• Support for Indigenous people
• Offers mentorship, coaching and/or networking opportunities for Indigenous workers
• Provides cultural competency training and/or awareness training to all employees to create a welcoming work environment for Indigenous workers
• Supports for visible minorities
• Applies 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 employees
• Provides diversity and cross-cultural training to create a welcoming work environment for members of visible minorities