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

6 days ago
Related jobs
CB Canada
Toronto, Ontario

Senior Database Administrator - SQL Server. On behalf of our client in the Banking Sector, PROCOM is looking for a Senior Database Administrator - SQL Server. Senior Database Administrator - SQL Server – Job Description. Responsible for database setup and management, data cleansing and appending, qu...

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

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

Randstad Canada
Toronto, Ontario

Title: Database Administrator_ Senior. At least 10 years of relevant experience as a Database Administrator. Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support. Experience...

BMO
Toronto, Ontario

Applies expertise to transform from on-premise databases to cloud data services and leverages cloud database technologies available (e. Manages and maintains enterprise databases, adhering to data governance and management policies. Designs databases that follow standards for data integrity, structu...

Scriptbox
Mississauga, Ontario

Operate database management systems to analyze data. Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models. ...

Acosta
Mississauga, Ontario

The SQL Server DBA plays an important role that is responsible for managing, maintaining, monitoring and troubleshooting our database infrastructure both On-Premises and in the Cloud. The primary responsibility of the DBA is to manage the daily operations for MS SQL Server database technologies in m...

Randstad Canada
Toronto, Ontario

Title: Database Administrator_ Senior. At least 10 years of relevant experience as a Database Administrator. Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support. Experience...

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

AGMD GROUP
Mississauga, Ontario

Operate database management systems to analyze data. ...