Randy

lniked in
Article by: Randy Peckham
Email: rpeckham@idssystems.com

Database Administrator & Developer

As a member of IDS Systems’ Data Analytics and Business Intelligence division, you will be working alongside a team of dedicated data lovers that enjoy munging data. The role will be helping companies capture, transform and leverage their data to derive actionable intelligence that will transform their businesses.

Responsibilities

  • Manage and maintain on premise or Azure SQL databases including database storage management, procedures and tools for access, database security, monitoring and tuning the databases to ensure ongoing operation and access
  • Analyzing system storage capacity and recommending improvements to ensure efficiency
  • Develop database queries and perform backup/recovery
  • Develop maintenance plans and scripts and migrate databases as necessary
  • Develop and test stored procedures, SSIS packages, triggers, queries, and scripts
  • Ensuring the safety and security of information systems assets and protecting the system from inappropriate access or destruction
  • Develop data flow diagrams and acquisition strategies that facilitate the capture and sharing of data and analytics within the organization to drive intended business output
  • Collaborate extensively with stakeholders, program management, and software development team members to ensure that solutions meet business needs
  • Document the technical details of your work to improve collaboration with other team members
  • Provide database support

Desirable Qualifications

  • Bachelor’s Degree in Computer Science or applicable experience is desired
  • Minimum 3 years experience in designing / modeling, managing SQL databases
  • Experience with DTS, SSIS, SSRS, SSAS, data mapping and requirements definition
  • Exposure to High Availability and Disaster Recovery strategies such as clustering, database mirroring, log shipping, and replication.
  • Experience in Azure SQL and other Microsoft Cloud services
  • Strong analytic and critical thinking, writing, communication and consulting skills
  • Ability to multitask while maintaining a focused attention to detail
  • Highly motivated individual always looking to grow and learn.
  • .Net programming
  • JavaScript
  • Experience with other DB platforms (NoSQL, Hadoop, Redshift, MySQL etc…)
  • IIS knowledge – deploying/configuring ASP.Net web apps
  • PowerShell

Job Benefits

  • Collaborate within a team of passionate technologies and business leaders
  • Contribute to building software that significantly impacts the effectiveness of all types of businesses
  • Fun and exciting atmosphere where hard work is recognized and rewarded

Location

The successful candidate will work from our Ottawa, Ontario office


Reply to this posting

Name *
Email *
Phone *
Message:
Attach Resume – Microsoft Word format preferred