SQL Database Administrator

5 days ago


Toronto, Canada Jolera Inc. Full time

**Who We Are**:
Jolera offers MSPs & IT solution providers next-generation managed services, enabling them to create world-class experiences for their clients. Your clients receive award-winning solutions built on over 20 years of experience servicing businesses worldwide. We’ve helped transform hundreds of MSPs & solution providers worldwide With our collection of tenured experts, we provide an elevated managed service experience for a variety of clients. At Jolera, we treat each MSP partner with specialized care and uniquely organize our products for your individual business needs.

**Who You Are**:
**What You’ll Do**:
You will demonstrate in your day-to-day activities:

- Technical Expertise: Knowledge of SQL Server architecture and the Microsoft Windows operating system.
- Attention to Detail: Precision in implementing changes, updates, and maintaining database security.
- Analytical Skills: Ability to analyze performance metrics and logs to troubleshoot issues and optimize database performance.
- Problem-Solving Skills: Capability to efficiently resolve complex database issues.
- Communication and Collaboration Skills: Effective communication with team members, stakeholders, and management is crucial, especially when explaining technical details in understandable terms. Effectively works well with others to achieve shared objectives.:

- Installation, Configuration, and Upgrading: MS SQL DBAs are responsible for installing and configuring new SQL Server instances according to best practices. This includes setting up database. systems, configuring hardware, and upgrading SQL Server instances to newer versions.
- Performance Tuning and Optimization (PTO): One primary responsibility is ensuring that SQL Server instances run efficiently. This involves monitoring system performance, tuning SQL queries, indexing, and implementing best practices to optimize database and query performance.
- Database Design and Implementation: Although often seen as more of a development role, DBAs may also be involved in database design. This includes designing database schemas, creating tables, indexes, and other database objects, and ensuring the structural integrity of the database.
- Security Management: Ensuring the security of SQL Server databases is paramount. This involves setting up access controls, implementing encryption, managing user permissions, and protecting sensitive data against unauthorized access.
- Backup and Disaster Recovery: DBAs implement robust backup strategies and disaster recovery plans. This includes regularly backing up databases, testing backups, and ensuring that disaster recovery procedures are effective in case of data loss or corruption.
- Database Maintenance: Routine maintenance tasks such as updating statistics, rebuilding indexes, and checking database integrity are essential for the smooth operation of SQL Server databases. DBAs schedule and automate these tasks to ensure database health.
- Troubleshooting and Support: DBAs must quickly diagnose and resolve issues related to SQL Server, such as performance bottlenecks, connectivity issues, and data corruption. Providing support to development teams and end-users is also part of the role.
- Capacity Planning: A critical responsibility is to anticipate future database growth and planning for infrastructure needs. This involves monitoring data growth trends and ensuring the database system can scale to meet future demands.
- High Availability and Disaster Recovery Setup: Implementing solutions like Always On Availability Groups, Database Mirroring, Log Shipping, or Replication to ensure high availability and disaster recovery readiness.

**Qualifications**:

- Preferably experience related to migrations especially OCI Migrations (Oracle Cloud
- Infrastructure)
- Degree in Computer Science or equivalent work experience.
- 4 plus years’ relevant
- Technical Expertise: Knowledge of SQL Server architecture and the Microsoft Windows operating system.
- Attention to Detail: Precision in implementing changes, updates, and maintaining database security.
- Analytical Skills: Ability to analyze performance metrics and logs to troubleshoot issues and optimize database performance.
- Problem-Solving Skills: Capability to efficiently resolve complex database issues.
- Communication and Collaboration Skills: Effective communication with team members, stakeholders, and management is crucial, especially when explaining technical details in understandable terms. Effectively works well with others to achieve shared.

**What We Offer**:

- Remote work
- Competitive compensation & benefits package
- Company Perks
- Company events, recognitions, and celebrations
- Career development and growth opportunities



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


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


  • Toronto, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologies Proficiency with SQL and experience writing SQL scripts Experience designing data architecture for new databases Experience in monitoring and enforcing da


  • Toronto, Ontario, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologies Proficiency with SQL and experience writing SQL scripts Experience designing data architecture for new databases Experience in monitoring and enforcing da


  • Toronto, Ontario, Canada CGI Full time

    SQL Database Administrator:Category: Database AdministrationMain location: Canada, Ontario, TorontoPosition ID:JEmployment Type: Full TimePosition Description: SQL DBA DB2 nice to have- "SQL Server DBA duties and responsibilities We are looking for a Logical/T2 database administrator, with programming experience Manage SQL Server databases Configure and...


  • Toronto, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a seasoned SQL DBA - this is a hybrid contract assignment based in Toronto Project: Reporting to the DBA Manager/Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. As a member of the database administrati


  • Toronto, Ontario, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a seasoned SQL DBA - this is a hybrid contract assignment based in Toronto Project: Reporting to the DBA Manager/Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. As a member of the database administrati


  • Toronto, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologiesProficiency with SQL and experience writing SQL scriptsExperience designing data architecture for new databasesExperience in monitoring and enforcing database rulesExperience cleaning, transforming and joining...


  • Toronto, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologiesProficiency with SQL and experience writing SQL scriptsExperience designing data architecture for new databasesExperience in monitoring and enforcing database rulesExperience cleaning, transforming and joining...


  • Toronto, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologies Proficiency with SQL and experience writing SQL scripts Experience designing data architecture for new databases Experience in monitoring and enforcing database rules Experience cleaning, transforming and joining...


  • Toronto, Ontario, Canada Net2Source Inc. Full time

    Job Title: SQL AdministratorLocation; Toronto, ONDuration: 12 monthsDatabase Skills: Experience with one or more database technologies Proficiency with SQL and experience writing SQL scripts Experience designing data architecture for new databases Experience in monitoring and enforcing database rules Experience cleaning, transforming and joining data...


  • Toronto, ON, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologiesProficiency with SQL and experience writing SQL scriptsExperience designing data architecture for new databasesExperience in monitoring and enforcing database rulesExperience cleaning, transforming and joining...


  • Toronto, ON, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologiesProficiency with SQL and experience writing SQL scriptsExperience designing data architecture for new databasesExperience in monitoring and enforcing database rulesExperience cleaning, transforming and joining...


  • Toronto, ON, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologiesProficiency with SQL and experience writing SQL scriptsExperience designing data architecture for new databasesExperience in monitoring and enforcing database rulesExperience cleaning, transforming and joining...


  • Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of **SQL Database...


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


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


  • Toronto, Ontario, Canada Travelzoo Full time

    Do you feel Capable of managing the SQL Server databases through multiple product lifecycle environments, from development to missioncritical 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 highperformance...


  • Toronto, Ontario, Canada Jolera Inc. Full time

    Who We Are:Jolera offers MSPs & IT solution providers next-generation managed services, enabling them to create world-class experiences for their clients. Your clients receive award-winning solutions built on over 20 years of experience servicing businesses worldwide. We've helped transform hundreds of MSPs & solution providers worldwide With our collection...


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