Database Administrator

3 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



  • 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...


  • Toronto, Canada Rang Healthcare Full time

    Job Title: Database Administrator Duration: 04 Month Contract Location: 125 Sir William Hearst, Toronto, ON M3M 0B5 (Position is 3 days onsite in a week) Must haves: Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database Experience with database development, e.g., stored procedure, PL/SQL,...


  • 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,...


  • Toronto, Ontario, 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, Integration Testing,...

  • Database Administrator

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


  • 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...


  • 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...


  • 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...


  • 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...


  • Toronto, Canada Sunwing Travel Group Full time

    **Join us in making vacation dreams come true** **!** Are you searching for a fun, passionate, travel loving team? -Sunwing has the EPIC work culture you have been searching for. We are currently looking for a **Database Administrator** to join us in making vacation dreams come true. As the Database Administrator, you are responsible for the installation,...


  • 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...


  • Toronto, Ontario, Canada IBI Group Full time

    Company DescriptionWe are a global architecture, engineering, planning, and technology firm defining the cities of tomorrow.By connecting design and technology, we change how people experience their built environment. We work across disciplines to create the intelligent systems, sustainable buildings, and efficient infrastructure that shapes the way people...


  • Toronto, Canada Raise Full time

    Database Administrator (Financial Industry) Location: Toronto, ON- Hybrid – ( In office every Tuesday for the time being) Contract Length: 6 Months with possibility of extension. We at Raise are hiring a Database Administrator (Financial Industry) for one of our top clients. After establishing th

  • Database Administrator

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


  • Toronto, Ontario, Canada Momentum Financial Services Group_new 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...


  • 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...


  • Toronto, Ontario, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School:The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada's first independent Ashoka Changemaker...


  • Toronto, Ontario, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.We are currently seeking competent individuals to fulfill the role of DBA to join our...


  • Toronto, Canada Raise Full time

    Database Administrator (Financial Industry)Location: Toronto, ON- Hybrid – ( In office every Tuesday for the time being)Contract Length: 6 Months with possibility of extension.We at Raise are hiring a Database Administrator (Financial Industry) for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their...


  • Toronto, Ontario, Canada AGCO Full time

    Term: Permanent, Full-TimeDivision/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity BranchApplication Deadline: May 24, 2024Level: Level 10Salary Range: Min: $92,902 to Max: $116,123Work Location: Head Office, Toronto, ON; HybridThe Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that...