Intermediate Database Administrator

4 weeks ago


Toronto, Canada IBI Group Full time

Company Description

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 liveable, sustainable, and advanced urban environments.

Arcadis has officially purchased IBI Group and with this transaction now complete, IBI will now be known as Arcadis IBI Group moving forward. Please refer to our website for more information.

**Job Description**:
The Arcadis IBI Group Data Services team delivers complex solutions and pushes the limits of technology. We use technology, Database Administration, Data warehouse and business intelligence tools to manage Toll System, Traffic Management, transportation corridors, transit systems, building infrastructure, energy and utilities.

Arcadis IBI Group’s Toronto’s office is looking for a full-time position for Database Administrator with 4+ years of experience to join our growing team. The role involves planning, development, expansion, and protection of the database program, performance tuning, troubleshooting issues and ensuring the database supports

Are you looking for a challenge where you can manage terabytes of data in a high-volume environment? You’ll call on a diverse set of database management skills; we are looking for someone that has both Oracle and SQL Server Database experience to work in our mission critical Revenue System

**Most of the Things You’ll Work On**:

- Create and maintain all the Oracle and SQLServer databases required for development, testing and production
- Active experience in supporting Oracle, SQLServer, MySQL and PostgreSQL environments
- Monitor the database environment, identify performance, trends and develop meaningful reporting, metrics and trending documentation to develop action plans
- Establish the needs of users and monitoring user access and security
- Monitor performance and manage parameters in order to provide fast responses to front-end users
- Responsible for managing the database environment by ensuring that storage, archiving backup and recovery procedures are functional
- Developing and utilizing database utilities to help the maintenance process
- Utilize expert understanding of schema implementation to interpret and tune queries
- Developing, managing, implementing and testing database upgrade, migration, etc
- Perform the capacity planning required to create and maintain the databases
- Basic knowledge and work experience in Oracle Database Cloud Services
- Responding to and resolving database access and performance issues
- Basic knowledge in Data Warehouse, ETL and Business Intelligence
- Writing project documentation, including design specifications, producing test plans
- Working experience in Agile/Kanban
- Collaborate with other software developers, software architects, product owner and project manager to plan, design, develop, test, and maintain databases required for administration, testing and production
- Monitor the database environment, identify performance, trends and develop meaningful reporting, metrics and trending documentation to develop action plans
- Developing and optimizing efficient Procedures, PL/SQL code

**Qualifications**:
**You'll Need To Have**:

- Degree or Diploma in Computer Science or equivalent
- 4+ years of experience in providing Oracle Database Administration: installation/configuration, security, backup/recovery, capacity planning, performance tuning, and troubleshooting
- 2+ years of experience in working Oracle HA solution like RAC and DRS
- 2+ years of experience with Microsoft SQL Server Database Administration, T-SQL, Replication, Always on availability Group DRS solution, Performance tuning
- 3+ years of experience in working in both Linux and Window Platform
- 1+ years of experience in Oracle Database Cloud Services technologies
- +1 years of experience in Oracle and/or Microsoft Cloud Technologies is an asset
- +2 years of experience in Oracle PL/SQL coding
- Knowledge and/or experience in Big Data and a strong background in data integration technologies is an asset
- Ability to work with a team environment and willingness to learn and continuously improve

Additional Information

Located at 55 St. Clair Ave West, this office is steps away from St. Clair station and is easily accessible by bike, TTC and car. Occupying 7 floors, with over 700 employees, it is the largest office at Arcadis IBI Group. The floors are open concept and represent our collaborative approach to projects. You’ll have direct access to management while benefitting from our enthusiastic and helpful organizational resources team. As a global architecture, engineering and technology design firm, Arcadis IBI Group also has offices across the country, continent and world. Currently, Arcadis IBI Group offers flexibility of remote work, in-office or hybrid.

Arcadis IBI Group provides a competitive benefit package and pays association dues and licensing fees.

We request appl



  • Toronto, Canada Capleo Global Full time

    Position: Database Administrator IntermediateLocation: Toronto, ON (Hybrid) Duration: 240 Business Days + Possible Extension Job Description: Experience with one or more database technologies. Proficiency with SQL and experience writing SQL scripts. Experience designing data architecture for new databases. Experience in monitoring and enforcing database...


  • Toronto, Canada Global Pharma Tek Full time

    Position: Database Administrator – Intermediate Location: Toronto, ON (Hybrid) Duration: Business Days + Possible Extension Job Description: Experience with one or more database technologies. Proficiency with SQL and experience writing SQL scripts. Experience designing data architecture for new databases. Experience in monitoring and...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated of **Database Administrator - Intermediate** one of our client. **Position: Database Administrator - Intermediate** **Location: Toronto, Ontario (Hybrid)** **Hybrid - 3 days on site and 2 remote** **Duration: Long Term Contract** **Must Haves**: - Experience with one or more database...


  • Toronto, Canada Tri-global Full time

    **INTERMEDIATE DATABASE ADMINISTRATOR** **Requisition #**:R24-3089 (RQ# 06249) **Location**:Hybrid (Toronto, ON - 3 days onsite/2 days remote per week) **Engagement Type**: Contract **Number of Resources required**: 1 **Term**: 2024-06-10 to 2025-03-31 with extension available **Rate (Per Day)**:Up to $500 per diem (equivalent to $68.97/hour) /...


  • Toronto, Canada AppTad Technologies Pvt Ltd Full time

    **Job Title**: Database Administrator - Intermediate **Job Duration**:Long-Term - Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with client groups to assess current data analytics and reporting capabilities, gather future-state...


  • Toronto, 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 **Database...


  • Toronto, Canada NR Consulting Full time

    Position Title :: Intermediate Database Administrator Work Location :: Toronto, ON ( Hybrid) Position Type :: Contract Duration :: + Month Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with client groups to assess current data...


  • Toronto, Canada IBI Group Full time

    Company Description We 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...


  • Toronto, Canada Total Systems Solutions Consulting Inc. Full time

    **Intermediate Database Adminstrator - Oracle and Microsoft SQL** **THE OPPORTUNITY** The **consultant is expected to start date is ASAP **and the **contract length is 2 years.** **Project Context** **Service Required** The scope of activities will include the following tasks: - Provide database design and implementation services - Provide database...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Intermediate** **Location: Toronto, Ontario** **Duration: Long Term Contract** **Must Haves**: - Experience with one or more database technologies - Experience designing data architecture for new databases - Experience in monitoring and enforcing database rules - Experience in developing documentation on data...


  • Toronto, Canada IBI Group Full time

    Company Description 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 liveable, sustainable, and advanced urban environments. Arcadis has officially purchased IBI Group and with this transaction now complete, IBI will now be known...


  • Toronto, Canada LBC IT Solutions, Inc. Full time

    **Join Our Team**: At LBC IT Solutions, Inc. we're a little bit different and we like it that way! We're not a traditional brick & mortar business. We live and work in the cloud to keep our experience current, keep costs down, and to be environmentally friendly. Working in the cloud ensures that we can offer the highest level of reliability, and also allows...


  • Toronto, Canada Computer Consultants International, Inc. Full time

    HYBRID position at Toronto, OntarioMust haves:Database Skills Experience with one or more database technologiesProficiency with SQL and experience writing SQL scriptsExperience designing data architecture for new databasesExperience in monitoring and enforcing database rulesExperience cleaning, transforming and joining dataExperience is creating and...


  • Toronto, Canada Maarut Inc Full time

    Description ·         Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights.·         Work closely with client groups to assess current data analytics and reporting capabilities, gather future-state requirements and identify further...

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


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


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


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