Database Administrator

4 weeks ago

Toronto, Canada Alcohol and Gaming Commission of 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 Digital Platforms Branch is looking for an experienced **Database Administrator** to join their team. Reporting to the Senior Manager of IT Infrastructure and Operations, the Database Administrator will act as a senior specialist in leading the implementation of new database and analytics services as it relates to AGCO projects. Also, the position will design, build and support such services in a hybrid-cloud environment to ensure availability, performance and integrity and security of business data.

**Work Location: Head Office, Toronto, ON; Hybrid**

**OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

Visit the **OPS Anti-Racism Policy** and the **OPS Diversity and Inclusion Blueprint** pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's **Human Rights Code**. Refer to the "How to apply" section if you require a disability-related accommodation.
- Automate code deployment, configuration, and monitoring processes.
- Monitor and proactively optimize the availability and performance of database instances and related jobs.
- Maintain data access, uptime, and performance. Respond to and resolve issues.
- Implement, maintain, and audit data access, performance, and security.
- Create and maintain database backup strategy, and regular testing to ensure usability.
- Create and maintain documentation which includes build books, operating and maintenance procedures.
- 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?**:

- A minimum of 5 years of Oracle Database Administrator experience.
- A minimum of 3 years of traditional Microsoft SQL Database Administrator ((i.e. SQL, SSAS, SSIS, SSRS) experience with 3 years of Azure database and analytics services ((i.e. Azure SQL, Azure Synapse, Azure Data Factory, Azure Data Lake, Power Apps, Power BI) experience; demonstrated experience on Azure DevOps or similar tools.
- 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.
- 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.
- Disability related accommodation during the recruitment process is available upon request._

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

- 1 English 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**:

- Friday, May 10, 2024**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

  • Database Administrator

    2 months 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

    4 days ago

    Toronto, Canada Red Label Vacations Full time

    **Reports to**:Director, IT **Department**:IT **Location**:Hybrid**: - **Head Office, Toronto, ON/ Canada & work from home **Summary**: As DBA you'll be the first respondent to database problems that arise and carry out periodic maintenance and troubleshooting. To ensure success as a database administrator, you should be an excellent problem-solver and...

  • Database Administrator

    3 weeks 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

    3 weeks 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

    3 weeks 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

    2 months 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

    1 hour ago

    Toronto, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...

  • Database Administrator

    1 month ago

    Toronto, Canada iPartner Staffing Full time

    Must haves: - Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x; UNIX OS (Operating System) and Linux OS, utilities, shell scripting - **Expert level knowledge of Oracle 12c/19c database administration**, maintenance, security implementation include:, upgrade and...

  • Database Administrator

    4 days ago

    Toronto, Canada iPartner Staffing Full time

    Role: Database Administrator - Senior Location: Toronto, ON Contract **Must-haves**: - More than 10 yrs Oracle DBA experience - Approved experience of Oracle 12c AND 19c using multi-tenant architecture - Oracle 12c and 19c RAC - Grid infrastructure/ASM - RMAN backup and Restore - Data Encryption using ASO/TDE - Oracle Dataguard Physical/Logical...

  • Database Administrator

    3 weeks 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

    3 weeks 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

    2 months 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

    3 days ago

    Toronto, Canada AGCO Full time

    **Term**: Permanent, Full-Time **Division/Branch**: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch **Application Deadline**: May 24, 2024 **Level**: Level 10 **Salary Range**: Min: $92,902 to Max: $116,123 **Work Location**: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario...

  • Database Administrator

    3 weeks 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

    5 days ago

    Toronto, Canada Momentum Financial Services Group Full time

    Job DescriptionThis is an excellent opportunity for a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join a dynamic team and contribute to the success of our cloud-based data initiatives. If you meet the above qualifications and are passionate about database...

  • Database Administrator

    1 month ago

    Toronto, Canada Cloudvital Technologies Full time

    We are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...

  • Database Administrator

    2 months 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

    3 weeks 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

    5 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

    3 weeks 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...