DBA (database analyst)

Work setting

• Private sector

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
• Compile records for analytical studies
• Leverage existing natural language processing (NLP) technologies and artificial intelligence (AI) solutions to develop communication assistance features

Computer and technology knowledge

• iOS
• Data Warehouse
• MAC
• Device drivers
• MS Access
• Networking software
• Networking hardware
• Networking security
• Internet
• Desktop applications
• File management software
• Security software
• Communication software
• Project management software
• Programming software
• HTML editing software
• Desktop publishing software
• Database software
• Programming languages
• Data analysis software
• MS Office
• MS Windows
• Basic
• HTML
• XSL
• Electronic mail
• API
• Salesforce

Type of online databases

• CIDOC-CRM

Specialization or experience

• Green economy sector
• Specialized environmental skills and knowledge

Security and safety

• Criminal record check

Personal suitability

• Accurate
• Client focus
• Efficient interpersonal skills
• Excellent oral communication
• Excellent written communication
• Initiative
• Judgement
• Organized
• Team player
• Adaptability
• Accountability
• Quick learner

Screening questions

• Are you available to start on the date listed in the job posting?
• Do you have experience working in this field?
• Do you have the equipment you need to work from home (like internet and a workspace)?
• Do you have the required certifications listed in the job posting?
• Do you meet the language requirements listed in the job posting for the position (English or French)?

Employment terms options

• Day

Green job

• Involves duties and responsibilities that lead to positive environmental outcomes

Workplace information

• Hybrid

Health benefits

• Dental plan
• Disability benefits
• Health care plan
• Paramedical services coverage
• Vision care benefits

Financial benefits

• Group insurance benefits
• Life insurance

Long term benefits

• Long-term care insurance

Other benefits

• Learning/training paid by employer
• Paid time off (volunteering or personal days)
• Team building opportunities
• Wellness program

Support for persons with disabilities

• Provides physical accessibility accommodations (for example: ramps, elevators, etc.)
• Provides visual accessibility accommodations (for example: braille, screen readers, etc.)
• Provides awareness training to employees to create a welcoming work environment for persons with disabilities
• Applies accessible and inclusive recruitment policies that accommodate persons with disabilities

Support for newcomers and refugees

• Supports social and labour market integration of newcomers and/or refugees (for example: facilitating access to community resources, language training, skills training, etc.)

Support for youths

• Offers on-the-job training tailored to youth
• 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

Support for mature workers

• Applies hiring policies that discourage age discrimination
• Provides workspace accommodations, such as age-appropriate ergonomic considerations, to meet the physical needs of mature workers (for example: adjustable desks and chairs, accessible parking, etc.)

Supports for visible minorities

• Applies hiring policies that discourage discrimination against members of visible minorities (for example: anonymizing the hiring process, etc.)
• Provides diversity and cross-cultural training to create a welcoming work environment for members of visible minorities