Database Administrator

3 weeks ago

Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

The Alcohol & Gaming Commission of Ontario (AGCO) is responsible for regulating the alcohol, gaming, horse racing and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.

The Information & Information Technology Branch requires an experienced Database Administrator, who will be reporting to the Senior Manager of IT Infrastructure and Operations. The responsibilities of the Database Administrator include, but not limited to, the following:

- Act as a senior specialist in leading the implementation of new database and analytics services as it relates to AGCO projects.
- Design, build, and support the database and analytics services in a hybrid-cloud environment.
- Automate code deployment, configuration, and monitoring processes.
- Monitor and proactively optimize the availability and performance of database instances and related jobs.
- Monitor and proactively manage database connections, locks, and performance trends.
- Maintain data access, uptime, and performance. Respond to and resolve issues.
- Implement, maintain, and audit data access, performance, and security.
- Create and maintain backup and recovery strategy, and regular testing to ensure usability.
- Create and maintain documentation which includes build books, operating and maintenance procedures.
- Administer, configure, and manage database backup and restore.
- Maintain alert, notification, and job schedule.
- Develop, maintain, and support data related change management and testing processes.
- Develop and maintain DevOps CI/CD processes.
- Interact professionally with all levels of staff with excellent communication and interpersonal skills.
- Provide guidance and knowledge to team members, and promote efficiency, productivity, innovations, and knowledge-sharing across multi-functional teams.
- Provide 3rd level support, liaise with vendors and other IT personnel for problem resolution.
- Participate in on-call, maintenance work, and incident response outside of normal business hours on an as needed basis.

**How do I qualify?**:

- 5+ years of traditional Microsoft SQL Database Administrator experience with 3+ years of Azure database and analytics services experience.
- Expert knowledge of Microsoft SQL Server (i.e. SQL, SSAS, SSIS, SSRS) and Azure database and analytics services (i.e. Azure SQL, Azure Synapse, Azure Data Factory, Azure Data Lake, Power Apps, Power BI).
- Expert knowledge in performance tuning, query optimization, and scalable database design.
- Experience in data preparation for advanced analytics and complex reports development on an Azure platform is an asset.
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
- Experience in migration of database and analytics services to Azure would be a definite asset.
- Oracle experience would be a definite asset.
- Demonstrated experience on Azure DevOps or similar tools.
- Strong technical documentation skills.
- Solid understanding of product management, agile principles, and development methodologies.
- Fundamental knowledge in cybersecurity.
- Excellent communications and interpersonal skills and the ability to interact professionally with all levels of staff.
- Flexible self-starter with the ability to effectively prioritize and execute tasks in a team-oriented agile environment.
- Creative thinker with strong troubleshooting skills and sense of urgency for resolving issues.
- Ability to provide support on a flexible schedule when needed.
- Current certification in related technologies would be a definite asset.

**The AGCO is an inclusive and equal opportunity employer.**:
**_Disability related accommodation during the recruitment process is available upon request._**

**Additional Information**:
**Address**:

- 1 Permanent, 90 Sheppard Ave E, Toronto, Toronto Region, Criminal Record Check

**Compensation Group**:

- Excluded- Understanding the job ad - definitions**Schedule**:

- N/A**Category**:

- Information Technology**Posted on**:

- Monday, February 13, 2023**Note**:
Required security screening checks along with your written consent, will be sent to the Transition and Security Office (TSO), Corporate Talent Programs Branch, Talent and Leadership Division to evaluate the results. If applicable, the TSO, with your written consent, will request and obtain any additional employment screening checks that were not obtained directly by you.

A record under the Criminal Code and/or other federal offence record(s) does not automatically mean you will be ineligible for the position. The employment screening check(s) will only be reviewed and evaluated by the TSO for the purpose of making a security clearance decision. The details of an individual's employment screening check(s) will be considered in specific relation to the duties and responsibilities of the position being filled. Employment screening check records will be maintained by the TSO and k

  • Database Administrator

    1 month ago

    Toronto, Canada iPartner Staffing Full time

    3 days per week in the office Expert Oracle and Microsoft SQL Database administration experience Demonstrated experience with DACPAC Experience with Azure build automation using Ansible, Terraform, Packer and VSTS Description The Services and Deliverables to be provided by the Vendor will include the following: - Participate in the review of...

  • Database Administrator

    5 days ago

    Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...

  • Database Administrator

    5 days ago

    Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...

  • Database Administrator

    5 days ago

    Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...

  • Database Administrator

    1 month ago

    Toronto, Canada Institutional Shareholder Services Full time

    Let's be Brilliant Together! - Advance your career with the leading provider of corporate governance and responsible investment solutions. Institutional Shareholder Services (ISS) empowers investors and companies to build sustainable financial and social value by providing high quality data, analytics, and insight. Our clients rely on ISS’ expertise and...

  • Database Administrator

    5 days ago

    Toronto, Canada Systematix Full time

    We are Systematix and we are looking for 4 experienced Sybase Database Administrators for our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension. The work can be done 100% remotely. Position Details: Title: Sybase...

  • Database Administrator

    5 days ago

    Toronto, Canada Systematix Full time

    We are Systematix and we are looking for 4 experienced Sybase Database Administrators for our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension. The work can be done 100% remotely. Position Details: Title: Sybase...

  • Database Administrator

    1 month ago

    Toronto, Canada Information Services Corporation Full time

    Company Name: Information Services Corporation Location: Toronto, Ontario Requisition ID: JR0000349 Status: Full-time Permanent Job Close Date: November 30, 2023 We are ESC, an experienced provider that delivers solutions uniting public records data, customer authentication, corporate services, collateral management, asset recovery, and accounts...

  • Database Administrator

    5 days ago

    Toronto, Canada Systematix Full time

    We are Systematix and we are looking for4 experienced Sybase Database Administratorsfor our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension.The work can be done 100% remotely.Position Details: Title:Sybase...

  • Database Administrator

    1 month ago

    Toronto, Canada Canadian Institute for Health Information Full time

    **Category** - Data Governance **City** - Toronto, Ottawa, Ontario, Canada - Database Administrator - Who we are - We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we...

  • Database Administrator

    7 days ago

    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...

  • Database Administrator

    1 week ago

    Toronto, Canada CareRx Full time

    Job Details Description CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We...

  • Database Administrator

    3 hours ago

    Toronto, Canada Drake International Full time

    Title: Database AdministratorLocation: Toronto, ON, Canada (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client’s next Database Administrator and sit at the center of projects that drives decisions. You’ll help one of Canada's most trusted government organizations work on the latest project, and be rewarded with...

  • Database Administrator

    4 days ago

    Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience wit

  • Database Administrator

    1 month ago

    Toronto, Canada Interac Corp. Full time

    Database Administrator At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like...

  • Database Administrator

    5 days ago

    Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ HybridCandidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...

  • Database Administrator

    1 week ago

    Toronto, Canada Ombudsman Ontario Full time

    The Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that reports to the Ministry of the Attorney General. The AGCO is responsible for regulating the alcohol, gaming, horseracing, and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.The Cybersecurity and...

  • Database Administrator

    6 days ago

    Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...

  • Database Administrator

    6 days ago

    Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...

  • Database Administrator

    5 days ago

    Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions...