Current jobs related to Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server[...] - Old Toronto - S I Systems

  • SQL Server Database Administrator

    4 weeks ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    Job Title: SQL Server Database AdministratorWe are seeking an experienced SQL Server Database Administrator to join our team at Uncharted Talent Inc. 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...

  • SQL Server Database Administrator

    4 weeks ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    Job Title: SQL Server Database AdministratorWe are seeking an experienced SQL Server Database Administrator to join our team at Uncharted Talent Inc. 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...

  • SQL Server Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

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

  • SQL Server Database Administrator

    2 months ago

    Toronto, Canada Uncharted Talent Inc Full time

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

  • Senior Database Administrator

    1 month ago

    Toronto, Ontario, Canada CB Canada Full time

    Senior Database Administrator - SQL Server Job DescriptionCB Canada is seeking a highly skilled Senior Database Administrator - SQL Server to join our team. As a Senior Database Administrator - SQL Server, you will be responsible for designing, implementing, and maintaining databases to ensure data integrity and security.Key Responsibilities:Design and...

  • Senior Database Administrator

    1 month ago

    Toronto, Ontario, Canada CB Canada Full time

    Senior Database Administrator - SQL Server Job DescriptionCB Canada is seeking a highly skilled Senior Database Administrator - SQL Server to join our team. As a Senior Database Administrator - SQL Server, you will be responsible for designing, implementing, and maintaining databases to ensure data integrity and security.Key Responsibilities:Design and...

  • SQL Server and Database Expert

    2 months ago

    Toronto, Ontario, Canada Rogers Communications Full time

    About the RoleRogers Communications is seeking a highly skilled Database Administrator to join our Technology team. As a key member of our team, you will be responsible for designing, building, and administering our database systems, ensuring optimal performance, security, and scalability.Key ResponsibilitiesDatabase Design and Administration: Design and...

  • SQL Server and Database Expert

    2 months ago

    Toronto, Ontario, Canada Rogers Communications Full time

    About the RoleRogers Communications is seeking a highly skilled Database Administrator to join our Technology team. As a key member of our team, you will be responsible for designing, building, and administering our database systems, ensuring optimal performance, security, and scalability.Key ResponsibilitiesDatabase Design and Administration: Design and...

  • SQL Server Database Administrator

    1 month ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    Database Administrator Job DescriptionWe are seeking an experienced 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...

  • SQL Server Database Administrator

    1 month ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    Database Administrator Job DescriptionWe are seeking an experienced 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...

  • SQL Server Database Administrator

    5 months ago

    Toronto, Canada amaris Full time

    Job description We are looking for dynamic consultants to grow our Information Systems & Digital team in Toronto. Your experience, knowledge, and commitment will help us to face our client's challenges. You will be supporting different projects through your expertise as SQL Server Database Administrator. **Your main responsibilities**: Manage and operate...

  • Senior Database Administrator

    2 months ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Title: Senior Database Administrator - SQL ServerCB Canada is seeking a highly skilled Senior Database Administrator - SQL Server to join our team. As a key member of our IT function, you will be responsible for designing, implementing, and maintaining our database systems.Key Responsibilities:Design and implement database solutions to meet business...

  • Senior Database Administrator

    2 months ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Title: Senior Database Administrator - SQL ServerCB Canada is seeking a highly skilled Senior Database Administrator - SQL Server to join our team. As a key member of our IT function, you will be responsible for designing, implementing, and maintaining our database systems.Key Responsibilities:Design and implement database solutions to meet business...

  • SQL Database Administrator

    5 months ago

    Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...

  • SQL Server Database Architect

    3 weeks ago

    Toronto, Ontario, Canada Uncharted Talent Inc Full time

    Database Administrator Job DescriptionWe are seeking an experienced 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...

  • SQL Database Administrator

    5 months ago

    Toronto, Canada Travelzoo Full time

    Do you feel - Capable of managing the SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Manage Always On, Replication, and Azure connectivity - Excited to configure and maintain database servers and processes, including monitoring system health and performance, to ensure...

  • SQL Database Administrator

    5 months ago

    Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...

  • SQL Database Administrator

    5 months ago

    Toronto, Canada Travelzoo Full time

    Do you feel - Capable of managing the SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Manage Always On, Replication, and Azure connectivity - Excited to configure and maintain database servers and processes, including monitoring system health and performance, to ensure...

  • Senior Database Administrator

    2 months ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Title: Senior Database Administrator - SQL ServerCB Canada is seeking a highly skilled Senior Database Administrator - SQL Server to join our team.Job SummaryWe are looking for a seasoned professional with expertise in database setup and management, data cleansing and appending, query analysis, database modeling, segmentation, and profiling. The ideal...

  • Senior Database Administrator

    2 months ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Title: Senior Database Administrator - SQL ServerCB Canada is seeking a highly skilled Senior Database Administrator - SQL Server to join our team.Job SummaryWe are looking for a seasoned professional with expertise in database setup and management, data cleansing and appending, query analysis, database modeling, segmentation, and profiling. The ideal...

Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server[...]

3 months ago

Old Toronto, Canada S I Systems Full time
Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server Database for a Fin-Tech Client

Our Fin-Tech Client is in need of a Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server Database

In response to the rapidly changing payments landscape and the multiyear Payments Canada modernization initiative. Our clients resources are in year two of a multi-year project to move to a payments as a service model with their vendor. They are also intent upon streamlining the payments functions between the three Centrals. The goal is to ensure prairie credit unions are competitive in payments and have access to efficient, cost-effective, modernized payments processing infrastructure.

Must Have:

  • 6+ years experience as a SQL Server Database Administrator (DBA) managing relational databases in a production environment
  • database design , installation, configuration , and maintenance
  • database performance tuning and optimization techniques.
  • 4+ years experience writing complex SQL queries , stored procedures, triggers, and functions, etc.
  • 1+ years experience with high availability and disaster recovery solutions
  • database mirroring, log shipping, and clustering.
  • SQL Server Administration Certificate

Nice to Haves:

Key Responsibilities

The SQL DBA will be responsible for the design, development and sustainment of the SQL Server Environment, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. Provide expertise with enterprise application for database usage for OLTP type environment and associated database tools.

  • Manage and monitor SQL Server databases to ensure optimal performance, availability, and security.
  • Implement and maintain database backup and recovery strategies to minimize data loss and downtime.
  • Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning.
  • Proactively identify and resolve database performance issues and bottlenecks.
  • Collaborate with developers, system administrators, and other stakeholders to ensure efficient and effective use of database resources.
  • Develop and implement database security policies and procedures to protect sensitive data.
  • Monitor and analyze database performance metrics and provide recommendations for improvement.
  • Plan and execute database migration and upgrade projects.
  • Troubleshoot and resolve database-related problems in a timely manner.
  • DBA on-call support
  • Daily checks and action on monitoring alerts
  • Apply SQL Server patches
  • Set up and maintain SQL database backups
  • Retrieve backups for application users
  • Restoration of databases if required
  • Provide user permission support as per client request
  • Major incident service calls
  • Engagement on performance issues
  • Provide suggestions and solutions as part of RCA or design remediations
  • Perform scheduled maintenance and supporting release deployment activities after hours (ex. ensure SQL services are up and running after server maintenance)
  • DR test
  • Database migration to different server
  • Database upgrade (to newer version or different edition)
  • Install new SQL Server instances
  • SQL Server instances unreachable (Send SMS alert to on-call person)
  • Low disk space usage (Send SMS to on-call person if usage over 90%)
  • Tagging but not alerting: Database backup failures, Overdue database backups, Blocking sessions, High CPU usage.
  • Top queries, server CPU and memory usages, types of wait
#J-18808-Ljbffr