SQL Database Administrator

1 week ago

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

  • SQL Database Administrator

    1 week ago

    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

  • SQL Database Administrator

    1 week ago

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

  • SQL Database Administrator

    1 week ago

    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

  • SQL Database Administrator

    1 week ago

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

  • SQL Database Administrator

    1 week ago

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

  • SQL Server Database Administrator

    1 week ago

    Toronto, Ontario, Canada amaris Full time

    Job descriptionWe 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 medium and...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Job DescriptionThis is an excellent opportunity for a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join a dynamic team and contribute to the success of our cloud-based data initiatives. If you meet the above qualifications and are passionate about database...

  • SQL Database Solutions Architect

    1 week ago

    Toronto, Ontario, Canada Equest Full time

    Your Career at Moneris - Exciting OpportunityThe role of SQL Database Solutions Architect at Moneris involves providing technical leadership and guidance on both on-premise and cloud-based database systems. The main focus is on ensuring scalability, reliability, security, and operational efficiency to meet the company's needs.About the Company: Moneris is a...

  • Senior SQL Database Analyst

    1 week ago

    Toronto, Ontario, Canada Procom Full time

    Senior SQL Database Analyst - AzureOn behalf of our client in the Banking Sector, PROCOM is looking for a Senior SQL Database Analyst - Azure.Senior SQL Database Analyst - Azure - Job DescriptionTaking ownership of and leading technical resolutions for production incidentsCommunicating clearly complex technical issues to stakeholders and Lines of Business...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Capleo Global Full time

    Position: Database Administrator IntermediateLocation: Toronto, ON (Hybrid) Duration: 240 Business Days + Possible Extension Job Description: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...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada IBI Group Full time

    Company DescriptionWe are a global architecture, engineering, planning, and technology firm defining the cities of tomorrow.By connecting design and technology, we change how people experience their built environment. We work across disciplines to create the intelligent systems, sustainable buildings, and efficient infrastructure that shapes the way people...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Canadian Institute for Health Information Full time

    Category Data GovernanceCity Toronto, Ottawa, Ontario, Canada Database Administrator Who we are We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, notforprofit organization and together with our partners we provide essential...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade:Participate in the review of project and maintenance release artefacts Use Case, System Requirement Specification, etc.; Prepare and implement database changes according to design; Promote database changes through Development, Integration Testing,...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada AGCO Full time

    Term: Permanent, Full-TimeDivision/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity BranchApplication Deadline: May 24, 2024Level: Level 10Salary Range: Min: $92,902 to Max: $116,123Work Location: Head Office, Toronto, ON; HybridThe Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Alcohol and Gaming Commission of Ontario Full time

    The Alcohol & Gaming Commission of Ontario (AGCO) is responsible for regulating the alcohol, gaming, horse racing and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.The Information & Information Technology Branch requires an experienced Database Administrator, who will be...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Drake International Full time

    Title: Database AdministratorLocation: Toronto, ON, Canada (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client's next Database Administrator and sit at the center of projects that drives decisions. You'll help one of Canada's most trusted government organizations work on the latest project, and be rewarded with great...

  • Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada Flywheel Digital Full time

    OpportunityAs a Database Administrator on our team you will be responsible for maintaining Flywheel's data ingestion, transformation, transactional and data warehousing needs. This role is essential to help support Flywheel's exponential growth. Responsiveness and willingness to solution new ideas is a key to the success of this position. Willingness to own...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Yamin Data Compliance Inc. Full time

    Education: Bachelor's degree Experience: 3 years to less than 5 yearsTasks: Design and develop database Design, construct, modify, implement and test data models and database management systems Operate database management systems to analyze data Develop and implement data administration policy, standards and models Research and document data requirements,...

  • Database Administrator

    1 month ago

    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...

  • Database Administrator

    3 weeks ago

    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...