DBA (database administrator)

Education:

Bachelor's degree.

Work setting:

• Consulting firm.
• Software company.

Tasks:

• Collect data to identify areas for improvement within an organization's IT infrastructure.
• Data Science.
• 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.

Computer and technology knowledge:

• Data Warehouse.
• DB2.

Area of specialization:

Scrum.

Work conditions and physical capabilities:

• Work under pressure.
• Tight deadlines.
• Attention to detail.
• Sitting.

Personal suitability:

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

Employment terms options:

• Evening.
• Shift.

Experience:

2 years to less than 3 years.

Employment terms options:

• Morning.
• Day.
• Weekend.

Other benefits:

• Free parking available.
• Learning/training paid by employer.
• Other benefits.

Support for persons with disabilities:

• Offers mentorship, coaching and/or networking opportunities for persons with disabilities .
• Provides awareness training to employees to create a welcoming work environment for persons with disabilities.

Support for newcomers and refugees:

• Supports newcomers and/or refugees with foreign credential recognition.
• Offers mentorship programs that pair newcomers and/or refugees with experienced employees .

Support for Veterans:

• Offers mentorship, coaching and/or networking opportunities for Veterans.
• Offers workshops, counselling services or other resources to help Veterans navigate their transition into the civilian workforce (for example: adapting to different organizational structures) .

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 .