Search jobs > Toronto, ON > Database administrator

SQL Server Database Administrator

Uncharted Talent Inc
Toronto, ON, Canada
Full-time
Quick Apply

We are seeking an experienced SQL Server Database Administrator to manage and maintain our production SQL Server Platform as a Service (PaaS) databases.

The ideal candidate will have a proven track record of optimizing database performance in a high-concurrency transaction environment and will play a critical role in ensuring the reliability and efficiency of our database systems.

Key Responsibilities :

  • Maintain and support production SQL Server PaaS databases, ensuring high availability and performance.
  • Implement and manage database partitioning strategies for large tables in live environments.
  • Optimize and reduce the number of indexes on high I / O tables based on usage analysis.
  • Work with and optimize .NET Entity Framework queries to enhance application performance.
  • Perform query plan analysis and maintenance to ensure efficient execution of database queries.
  • Utilize Azure portal features for database maintenance, monitoring, and automation.
  • Conduct index maintenance, analyze disk fragmentation, and monitor database size for optimal performance.
  • Collaborate with developers, DevOps, and technical leads to effectively implement, test, and deploy database updates.

Qualifications :

  • Minimum of 7 years of experience in maintaining production SQL Server databases.
  • Advanced knowledge of SQL Server PaaS management and performance tuning techniques.
  • Proven experience with database partitioning, index optimization, and query performance tuning.
  • Familiarity with Azure portal features related to database management.
  • Strong analytical skills with experience in query plan analysis and database performance monitoring.
  • Excellent communication skills, with the ability to work collaboratively across teams.
  • Experience managing Production databases in a similar high-concurrency environment.

Nice to Have :

  • Knowledge of data warehousing concepts and best practices.
  • 19 hours ago
Related jobs
Uncharted Talent Inc
Toronto, Ontario

We are seeking an experienced SQL Server Database Administrator to manage and maintain our production SQL Server Platform as a Service (PaaS) databases. Maintain and support production SQL Server PaaS databases, ensuring high availability and performance. Minimum of 7 years of experience in maintain...

Extreme Reach
Toronto, Ontario

The Database Administrator will be responsible for maintaining Extreme Reach's core databases and applications. Manage SQL Server databases on AWS. Configure and maintain database servers and processes. Manage High Availability (HA) and Disaster Recovery (DR) options for SQL Server. ...

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. Senior Database Administrator - SQL Server – Mandatory Skills. ...

Tundra Talent Community
Mississauga, Ontario

Role: Global SQL Database Administrator . The Global SQL Database Administrator will support both operational and project related activities and maintain defined IT standards at all global locations. Monitor and maintain database server and database health. Install database software and configure da...

Bell
Toronto, Ontario

Le DBA Oracle sera responsable de l’environnement de la base de données utilisé pour la création des campagnes et travaillera en étroite collaboration avec l’équipe de données des campagnes et l’équipe de projet afin de livrer une nouvelle solution et d’améliorer les processus actuels. Installation,...

Canadian Systems Inc.
Toronto, 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. ...

CI Financial
Toronto, Ontario

We are seeking a highly skilled and motivated individual to join our Infrastructure team as a Database Engineer. Provide day-to-day operational and emergency support of core Database DB infrastructure systems including SAN, OS and associated platforms and hosting solutions (On-Prem, Cloud and Hybrid...

CLIO
Toronto, Ontario

Staff Software Developer, Back End Infrastructure and Databases. The Staff Software Developer will be responsible for discovering, triaging, and solving difficult performance and scalability problems in Clio's core applications and databases. Youll be responsible for preparing Clios database infrast...

Pearl Technologies LTD.
Toronto, Ontario

Test data models and database management systems. Operate database management systems to analyze data. Liaise with staff on data requirements, collection and availability. ...

pt Health
Toronto, Ontario

Senior Database Administrator / Developer. You are a database geek with many years of professional work experience and know how to code T-SQL as well as troubleshoot long running queries and other database performance tweaks. Manage and optimize databases hosted on Azure SQL Database, Azure SQL Mana...