Database Administrator



DETAILS

Location: Toronto, ON, M9W7K6
Employee Type: full time
Experience: 2 - 5 years
Education: Bachelor degree
Travel Required: none

DESCRIPTION

Aecon Group Inc. is Canada’s largest publicly traded construction and infrastructure development company. Aecon and its subsidiaries provide services to private and public sector clients throughout Canada and on a selected basis internationally. Aecon is pleased to be recognized as one of the Best Employers in Canada.
Aecon’s Corporate division provides a support system which extends throughout all branches of the company and includes IT services, communications, finance and human resources, among others.
Position Overview:
Reporting to the Manager, Infrastructure and based at the Carlson Cour office, the position is responsible for the day to day management of the many databases currently operating at Aecon. The incumbent would be responsible for the operations backup and reporting of all database activities including Microsoft SQL Server and DB2.
Key responsibilities:
  • Provide DBA support for installing, upgrading and maintaining Aecon’s MS SQLServer environments
  • Plan, recommend and implement system upgrades to address capacity and growth
  • Adhere to established service level agreements for SQL Server systems
  • Analyze and resolve database and application issues affecting SQLServer environments
  • Test and implement new releases of SQLServer-related software
  • Recommend and patch Microsoft SQL Server as required
  • Support the migrations of databases to new servers as required
  • Participate in the support of applications through the One-Click ticketing system
  • Deploy database changes to production using change management/release management policies and procedures
  • Escalate critical issues to manager in a timely manner
  • Provide recommendations for improvements for unplanned activities
  • Ability to work weekends and after hours as required
  • Participation in an on call rotation requiring 24x7 availability for one-week periods is required
  • Maintain Aecon product roadmap for SQL Server 2008 R2, SQL Server 2012 migrate or upgrade SQL Server instances no longer under Microsoft mainstream support
  • Ability to troubleshoot SQL Server performance issues and perform root cause analysis
  • Ability to implement Database optimizations
  • Ability to administer SQL Server 2012 through SAP Database Administration transaction codes
  • Ability to configure SQL Server 2012 availability groups
  • Ability to implement SQL Server jobs through SQL Agent and be able to implement basic SSIS packages for maintenance routines
  • Knowledge of Informatica PowerCenter and Informatica Data Quality is an asset
  • Ability to query and understand OLTP and OLAP data models is an asset
  • Experience with data conversions is an asset
  • Coordinate with onsite third party vendors and technicians as required
  • Participate in data conversion activities and architecture reviews of database environments as needed
Qualifications:
  • Experience with administrating SQL environment with 100+ SQL instances
  • Work experience with SAP (ERP) required
  • Minimum 5 years experience working with Microsoft SQL 2005 and above
  • Microsoft certificate in SQL Server
  • Experience working in a team environment
  • Excellent analytical, troubleshooting and communication skills
  • Basic Keyboarding skills
  • Intermediate and senior level of Database administration
  • Strong analytical and structured problem solving skills.
  • SQL Server 2008/2012 instance installation and configuration
  • Transact-SQL for database management and general querying
  • Experience working with large, highly available, and/or high-transaction databases
  • Understanding of N+1 high availability clustering architecture
Interested candidates may submit an application directly online at www.aecon.com.



REQUIREMENTS



THIS JOB IS EXPIRED

COMPANY

Aecon Group Inc.
20 Carlson Court, Suite 800

Toronto, M9W 7K6
CANADA