← Back to Job List

Database Administrator (QGIS)

IBI Group

  • Posted on: June 12, 2018

We are a global team of dedicated and experienced architects, engineers, planners, designers and technology professionals who share a common desire – to help our clients create livable, sustainable, and advanced urban environments.

From high-rises to industrial buildings, schools to state-of-the-art hospitals, transit stations to highways, airports to toll systems, bike lanes to parks, we design every aspect of a truly integrated city for people to live, work, and play.

Our values:
Integrity – We do what is right.
Partnerships – We work together.
Excellence – We pursue design excellence.
Innovation – We embrace ingenuity.
Community – We build community.

Our collaborative and combined approach focuses not only on creating the best solutions today, but also determining the right solutions for tomorrow. We believe cities in the future must be designed with intelligent systems, sustainable buildings, efficient infrastructure, and a human touch.

At IBI, we’re defining the cities of tomorrow!

Job Description

Job Description
The IBI Group Data Service team delivers complex solutions and pushes the limits of technology. We use technology, data warehouse and business intelligence tools to manage transportation corridors, transit systems, building infrastructure, energy and utilities.
IBI Group’s Intelligent Systems team in Toronto’s St Clair office is seeking a talented Data Waterhouse Developer/DBA with 3+ years’ experience in ETL Development and Database Administration to join our growing team.

You’ll call on a diverse set of data warehouse skills; we are looking for someone who has strong Data Warehouse, SQL Server, Oracle and MYSQL Database experience to work in our mission critical Systems!

Responsibilities: 

  • Participating in design and development of data warehouse expansion including operational and warehouse management systems (WMS) data.
  • Developing, modifying and maintaining ETL routine process using established libraries and tools Like SSIS, SSRS, SSAS, Python (Tensorflow, Pandas), JSON, and Azure Analysis Service Modeling like Data Factor, Data Lake, and Data Storage.
  • Showcase knowledge in designing and implementing data warehouse utilizing dimensional modelling approaches and the Kimball methodology, including star schema, dimensions and fact tables, cubes.
  • Writing project documentation, including design specifications, producing test plans.
  • Working closely with other teams to understand their needs and analytical requirements.
  • Discussing complex technical issues with end-users and working with users to prototype applications and agree modification specifications.
  • Collaborating with other software developers, software architects, product owner and project manager to plan, design, develop, test, and maintain databases required for development, testing and production.
  • Monitoring the database environment, identify performance, trends and develop meaningful reporting, metrics and trending documentation to develop action plans.
  • Work with GIS and ETL products for data processing and analysis (FME, ESRI, MapInfo, QGIS, and Alteryx etc.)
  • Developing and optimizing efficient PL/SQL code.
  • Take part in Database Administration tasks such as Creating Database, Backup and Recovery and Performance tuning, Disaster Recovery
  • Monitoring the database environment, identify performance, trends and develop meaningful reporting, metrics and trending documentation to develop action plans.

Qualifications

  • Post-Secondary Degree or Diploma in Computer Science or equivalent
  • 2 to 4 years of experience working as a developer in Data Warehouse, Data modeling, and BI System delivery projects.
  • Must have 2+ years of experience working with Oracle Database.
  • Must have 1+ years of experience with Big Data projects and a strong background in data integration technologies.
  • Must have experience working with ASM and RAC storage systems
  • Experience in working with Microsoft SQL Server, T-SQL, PL/SQL coding and performance tuning is expected
  • Big Data, Hadoop experience will be an asset
  • Experience with ETL tools such as Ab-Initio, Talend, Alteryx, iWay and Informatica are an asset.
  • BI software knowledge is desirable (Tableau, Power BI, WebFocus)
  • Experience working with Microsoft Cloud Environments
  • Ability to work with a team environment and willingness to learn and continuously improve.
  • Strong Communication skills – both written and verbal

Additional Information

We thank all applicants for their interest. However, only those selected for an interview will be contacted. IBI Group is proud to be an Equal Opportunity Employer.

← Back to Job List