DBA (database administrator)
Description
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 .