Database analyst

MOBMAXIME INC; Charlottetown; On-site; CAD 65,000 - 95,000; Full time

Benefits offered by this job

Health care plan

Job summary

MOBMAXIME INC is seeking a data-focused professional to collect data for IT infrastructure improvements and to design, develop, and maintain databases. The role involves documenting customer requirements, reporting needs, and ensuring data access controls, with collaboration across IT teams.

Responsibilities include developing deployment blueprints for databases, testing data models, and leading data administration efforts to establish data policies and standards.

Qualifications

• Bachelor's degree required.
• 3 years to less than 5 years of experience required.

Responsibilities

• Collect data to identify IT infrastructure improvement areas.
• Develop and implement database deployment blueprint.
• Develop and maintain computer databases.
• Document customers' requirements for projects.
• Document reporting needs, queries, logic, results and recommendations.

Skills

Database design

Stored procedures

Data modeling

Education

Bachelor's degree

Tools

DBMS

Job description

• Education: Bachelor's degree
• Experience: 3 years to less than 5 years

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

Screening questions

• Do you have experience working in this field?
• Do you meet the language requirements listed in the job posting for the position (English or French)?

Health benefits

• Health care plan
• Work Term: Permanent
• Work Language: English
• Hours: 35 hours per week