Search jobs > Toronto, ON > Temporary > Database administrator

Database Administrator

freelance.ca
Toronto, Canada
Full-time

We are hiring for the position of " Database Administrator with MS SQL DBA" and are looking for talented individuals who are passionate about this field.

If you have experience, we would love to hear from you. Job Title : Database Administrator with MS SQL DBA Duration : Contract Location : Hybrid in Toronto, ON Job Description :

Configuration planning & deploying MS SQL servers on cloud and on-premise servers.

Performance and general health / capacity monitoring. Tuning and load balancing of servers.

Do routine maintenance including database rebuilds / re-indexing / expansion and archiving.

Trouble-shoot MS SQL server problems, and assist in the resolution of application problems.

Server upgrades / migrations.

Assist in database code promotions & data fixes.

Disaster Recovery / High Availability (DR / HA), backup & recovery of local and remote replicated databases.

Provide DBA support to development / implementation projects as assigned, doing installations, database loading, migrations, testing, etc.

Practical working knowledge of : MS SQL Server 2019 / 2017 / 2016 / 2014 / 2012, Windows Servers, versions 2012 and up, Windows Client, Azure IaaS, MI and DBaaS database deployment and tools, Firewall IP / Port, domain trust / authentication

Database Device Configuration / Installation

Stored Procedures, Setup SQL Always-On & Database Replication

Data Encryption & Masking Database Re-build / De-fragment techniques

Logical & Physical Backup / Recovery techniques

MS SQL Services (SSRS / SSAS / SSIS / Poly Base, R Service) OLAP, Power BI Application side tuning vs. server-side tuning

Competencies : Microsoft SQL Server 2019, Database Administration (DBMS)

Key Words : MS SQL DBA

30+ days ago
Related jobs
FRDJ Carrières
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...

Macropus Global
Canada

Administer the SAP database with Database Administrator (plan and perform database upgrades, apply database maintenance, design and maintain physical database layout, perform database reorganizations, design and implement backup and restore strategy, maintain database security, administer database p...

PeopleToGo
Markham, Ontario

Database Administrator/Architect. Our client is currently seeking an experienced Database Administrator/Architect to work out of their Toronto office. Coordinates changes to the database, including the deletion of records, changes to the existing records and additions to the database;. A minimum of ...

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

Macropus Global
Canada

Oracle Database Administrator/Team Leader. Our client has an immediate need for an Oracle Database Administrator. The Oracle Database Administrator works closely with all data centre professionals and the successful incumbent will be a member of the data center DBA team. Oracle Database Administrato...

PET VALU
Markham, Ontario

This role involves working with other database service team members, cross-functional IT and business team members to ensure high security, high availability, high performance Pet Valu databases, including but not limited to on-prime and cloud-based SQL server, Oracle, and other databases. A hands-o...

BMO Financial Group
Etobicoke, 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...

Interac Corp.
Toronto, Ontario

Experience with performance tuning of Oracle databases, highly available payment and transactional systems, data replication, and database clusters. You’ll be responsible for the implementation and technical support of the company's production databases and associated technologies. You’ll perform ta...

Broadridge
Toronto, Ontario

Database Administrators participate in the design, build, run, and modernization of our databases. You will perform all database administration tasks and should be well versed with database features, utilities, and recovery procedures. They are part of a senior technical team to ensure that our data...

Yoush Consulting
Toronto, Ontario

Maintain, administrate, tune performance ofdatabases, , IMS, DB2, Oracle, Microsoft Azure SQL database andSynapse database;. Expert Database administration experience, ,IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database. Database Administrator - Senior - 1 Year Contract - Hybrid Wor...