Database Administrator

Sira Consulting, an Inc 5000 company
Ontario, Canada
Full-time

Role : DBA (Dev / core MS SQL / MYSQL / Maria DB)

Location Remote

Primary Job Responsibility

  • Create table design based on RDBMS principle
  • Creating and maintaining triggers / procedures / functions - knowledge should be
  • Tune queries for performance, determine right indexes and advise on technique performance for local installs and Azure MySQL / Azure SQL
  • Install / maintain DEV and QA database for MySQL, MariaDB, MSSQL (On-prem a
  • Good to have backup / restore database and export / import database skills.
  • Database migration on-premises to cloud or cloud to on-premises.
  • Assist customers for technical support
  • Work with cross-border and cross-functional team

Experience / Skill Level - Required :

  • 7+ years of experience
  • Database : MSSQL / MySQL / MariaDB
  • Languages : SQL, T-SQL, Scripting using PowerShell, Azure CLI, etc
  • Tools : SQLyog, SSMS, etc

Good to have :

  • ADO, Jira, Cofluence
  • MSSQL / MYSQL DBA and other related certification
  • Java
  • PowerShell

Education :

  • Degree in Computer Science or equivalent.
  • 8 hours ago
Related jobs
BMO Financial Group
Scarborough, Ontario

Understands data in terms of its business and technical lifecycle (Create, Release, Update, and Delete), technical underpinnings of database theories (e. Assists in creation, implementation/installation, configuration, change, and support of data models, databases, data marts, data warehouses. Proac...

Telesat
Ottawa, Ontario

This setup fosters brainstorming, problem-solving, and trusted relationships and allows our employees to come together three days a week to collaborate, innovate and thrive!Reporting to the Manager of Platform Engineering, the candidate will work as an integral part of the Platform Engineering team ...

Stantec
Kanata, Ontario

Database Administrator - Security - ( 2400036L ). This role embodies reviewing the security of the database and the applications that the database administration team supports. Utilize Audit Vault and Database Firewall to effectively monitor databases. Working with the teams to implement database ba...

EMCO Corporation
London, Ontario

EMCO Corporation is seeking a highly skilled Database Administrator (DBA) with a strong background in C# and SQL. Manage, monitor and maintain databases, ensuring optimal performance, security, and availability. Engage in troubleshooting and resolving database-related issues. Develop and optimize co...

Extreme Networks
Toronto, Ontario

Position: Cloud Database Administrator - CanadaLocation: Toronto, Canada - HybridJob Scope:There has never been a better time to join Extreme, after several acquisitions extending our portfolio and go-to-market strategy, we have seen enormous opportunity and growth within the regions. You will be re...

Stantec
Toronto, Ontario

OCI Database Administrator - ( 2400036M ). Minimum of 5 years' experience working as in Database Administrator role support in a LINUX/UNIX environment. As an Oracle Cloud Administrator on our Advanced Technology team, this position will have a primarily technical focus while also holding some manag...

Alltech Consulting Services
Toronto, Ontario

Expert level knowledge of Oracle 19c database administration, maintenance, security implementation, upgrade and patching, database performance tuning, sizing and capacity planning, database backup and recovery using RMAN. ...

Maarut Inc
Toronto, Ontario

Assistingwith the transformation/cleaning of data from a legacy databaseinto a new datawarehouse. Developmapping and transformation rules to align the twodatabases. Developconnections with multiple other government databases and developsystem to maintain the connection so that it does not go out ofd...

JDRF Canada
Remote, CA
Remote

National Database Administrator. National Database Administrator. Breakthrough T1D if growing our IT team and we’re searching for a new team member who is experienced with CRM databases, for the role of. Develop and deliver reusable user-friendly queries for recurring or ad hoc dashboard views...

Renaud Consulting IM/IT Solutions
Ottawa, Ontario

Informationmust include Organization, contactname,contact telephone number, e-mail address, adescriptionof the projects and the date and duration of thecontract.MUST CURRENTLY HOLD A VALID SECRET GOVERNEMNTCLEARENCE....