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

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

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

Promoted
NexGen Tech Solutions
Mississauga, Ontario

We are seeking a skilled and detail-oriented Database Developer to help design, develop, and maintain our database systems. Proven experience as a Database Developer, Database Administrator, or similar role. The Database Developer will collaborate with cross-functional teams to ensure that our data ...

Promoted
Synechron
Mississauga, Ontario

We are looking for a Database Developer who will be responsible for creating, administering and troubleshooting computer databases that can process large amounts of information and keep it secure. Design, develop, and optimize complex SQL scripts, stored procedures, packages, and functions. Extensiv...

Promoted
Centrilogic
Canada

We are looking for a Senior Oracle Apps/EBS DBA with Oracle Cloud Infrastructure Experience. Knowledge and experience with Oracle Database 19c and Oracle EBS. Must be able to obtain and maintain Oracle Certifications pertaining to Oracle Database and Oracle Cloud Infrastructure. ...

Promoted
Tata Consultancy Services
Markham, Ontario

Oracle DBA Oracle Database Administration Oracle Enterprise Monitoring AWS Database specialist. Production support experience as Oracle DBA. Cloning Oracle Database from Production environment to non-prod environments. ...

Promoted
Teckhorizon Inc
Toronto, Ontario

Resolve and troubleshoot technical issues during the software operation lifecycle. Collaborate with IT professionals throughout the Software Development Life Cycle (SDLC). Expertise in CRM software and knowledge of upcoming releases. Knowledge of middleware, gateways, and specific CRM software devel...

Promoted
Coforge
Markham, Ontario

Proven experience as a Database Administrator with a focus on Oracle Databases (12c and 19c). Job Title: Database Administrator. We at Coforge are hiring for a Database Administrator with the following skills:. We are seeking a highly skilled and experienced Database Administrator (DBA) to join our ...