administrator, database

Job Duration: Permanent

Working Language: English

Working Hours: 35 hours per week

Education

• Bachelor's degree

Work Setting

• Relocation costs covered by employer
• Consulting firm

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

Supervision

• 3-4 people

Computer and Technology Knowledge

• IBM DataStage
• Shell script
• iOS
• Data Warehouse
• DB2
• Dbase Plus
• MS SQL Server
• Security software

Work Conditions and Physical Capabilities

• Tight deadlines
• Attention to detail

Personal Suitability

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

Experience

• 1 year to less than 2 years

Other Benefits

• Other benefits

Support for Newcomers and Refugees

• Supports newcomers and/or refugees with foreign credential recognition

Support for Youths

• Offers on-the-job training tailored to youth

Support for Veterans

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

Support for Indigenous People

• Offers mentorship, coaching and/or networking opportunities for Indigenous workers

Support for Mature Workers

• Offers mentorship, coaching and/or networking opportunities for mature workers

Supports for Visible Minorities

• Offers mentorship programs that pair members of visible minorities with experienced employees