Database Analyst

Company: Data & Scientific Inc

Business Information: At Data & Scientific Inc., we prioritize your security above the rest. That is why we work tirelessly to ensure that your data never gets breached. Backed by science and innovation, we deliver custom solutions to secure sensitive data and information, giving you more time to focus on what’s important

Business address: 18 Wyndford Dr, Unit 144, North York, ON, M3C 3S2

Work location: Same as above

Type of Employment: Full Time - Permanent

Estimated Start Date: As soon as possible

Job Description:

Collect data to identify areas for improvement within an organization’s IT infrastructure

Develop and implement a strategic blueprint to follow when creating or 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 – Security and access control

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 database administrators in the development and implementation of data policies, standards and models

Write scripts related to stored procedures and triggers

Diagnose problems and resolve issues across various tiers (application, network, database, sever, or storage tiers)

Deal with complex data models and object relational database mapping, while producing complex reports

Data Analytics

Process automation using PERL

Understanding of data modeling, database design principles, data security practices, backup and recovery procedures, and the ability to troubleshoot database issues

Requirements

Education: A bachelor's degree or college program, usually in computer science, computer engineering, or mathematics is usually required.

Experience: A minimum of three years of experience in the field is required

three implementation cycles of Oracle database Management System are required

Work conditions and Physical capabilities: Fast-paced environment, Work under pressure, Tight deadlines, Repetitive tasks, Attention to detail, Combination of sitting, standing, walking.

Personal suitability: Accurate, Client focus, Efficient interpersonal skills, Excellent written and oral communication, Initiative, Judgement, Organized, Team player, Adaptability, Accountability, Quick learner.

Ability to supervise up to 6 people

Language: English is required.

Computer and technology knowledge: SQL (Structured Query Language), proficiency with database management systems like Oracle, MySQL or Postgres, knowledge of operating systems - Linux or UNIX, PERL Language, Data Analytics

Salary: $43.96 hourly, 35 – 37.5 hours per week

Benefits: Dental plan, Health care plan, Paramedical services coverage, Bonus, Registered retirement savings plan (RRSP), Group insurance benefits – applicable after six months on the job, Pension plan, Registered Education Savings Plan, Parking and Free parking available, Team building opportunities, On-site recreation and activities, Paid time off (volunteering or personal days),Wellness program, Learning/training paid by employer.

Important Information. Flexibility in schedule is required. The worker will work from Monday to Friday in one of two shifts; from 9:30 AM to 6:00 PM or from 5:00 PM to 12:00 AM. Work on weekends and holidays may be required depending on the business needs.

Apply by e-mail to: petax@thecanadianvanguard.ca

CanadaJobs