database analyst

1 day ago

Nepean, Ontario, Canada Lumentum Operations Full time $114,500 - $142,000 per year
  • Work Term: Permanent
  • Work Language: English
  • Hours: 37.5 hours per week
  • Education: Bachelor's degree
  • Experience: 5 years or more
  • 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
  • R
  • MySQL
  • Database software
  • Amazon Web Services (AWS)
  • Big data
  • Python
  • Health benefits
  • Dental plan
  • Disability benefits
  • Health care plan
  • Paramedical services coverage
  • Vision care benefits
  • Financial benefits
  • Bonus
  • Group insurance benefits
  • Life insurance
  • Registered Retirement Savings Plan (RRSP)
  • Stocks/shares
  • Long term benefits
  • Long-term care insurance
  • Maternity and parental benefits
  • Other benefits
  • Free parking available
  • On-site amenities
  • Paid time off (volunteering or personal days)
  • Team building opportunities
  • Parking available
  • Wellness program

  • Inventory Analyst

    3 days ago

    Nepean, Canada Armstrong Monitoring Corporation Full time

    **Position Summary**: The Inventory Analyst is in charge of assisting in ordering, receiving, and counting all types of products for our organization and is also responsible for ensuring that inventory records are accurate at all times, which they do through monthly counts of all products, and variance analysis. This individual monitors and maintains...

  • Financial Reporting Analyst

    1 week ago

    Nepean, Canada VISTA SERVICES Full time

    **About Vista Services** Vista Services is more than just a financial partner - we are helping communities, the people that live within them and the local contractors that service the area. Our dealers are experts in the water heater, HVAC, and residential infrastructure sector. Having both ownership from local management and an infrastructure fund managed...