SQL Server

4 days ago


Toronto, Ontario, Canada Resonaite Full time
Our client in the non-profit sector is seeking a SQL Server Security consultant for a short term project to implement security hardening for their SQL Server instances.

Responsibilities:

- Conduct security assessments of on-prem SQL Server instances to identify vulnerabilities and misconfigurations.
- Harden SQL Server security using best practices and native tools, including Transparent Data Encryption (TDE), Always Encrypted, Row-Level Security, and Dynamic Data Masking.
- Configure role-based access control (RBAC), least privilege access, and Active Directory (AD) integration for authentication and authorization.
- Secure SQL Server network configurations, including firewall rules, encryption (SSL/TLS), and TCP port hardening.
- Implement and optimize SQL Server Audit and Extended Events for logging security-related activities.
- Restrict SQL Server Agent Jobs and ad-hoc query execution to prevent unauthorized actions.
- Apply security hardening techniques for SQL backups, data encryption, and compliance auditing.
- Monitor and detect anomalous activity using SQL Server security logs and SIEM tools.
- Provide remediation plans and documentation for ongoing SQL security maintenance.
- Train internal teams on SQL Server security best practices and compliance requirements.

Requirements:

- 7+ years of SQL Server administration and security experience in enterprise environments.
- Expertise in SQL Server security features, including TDE, Always Encrypted, SQL Audit, RBAC, and Policy-Based Management.
- Strong knowledge of Active Directory authentication, Kerberos, and Group Managed Service Accounts (gMSA).
- Experience with firewall configurations, port hardening, and SSL/TLS encryption for SQL Server.
- Hands-on experience with PowerShell scripting for SQL security automation.
- Familiarity with CIS benchmarks, GDPR, HIPAA, SOC 2, and PCI-DSS compliance.
- Knowledge of SQL Server High Availability (HA) and Disaster Recovery (DR) security best practices.
- Experience with SIEM tools (Splunk, Azure Sentinel, or similar) for SQL Server security monitoring.
- Excellent communication skills for documenting security measures and training internal teams.
- Certifications: Microsoft Certified: Azure Database Administrator Associate, CISSP, or Security+ preferred.
- Knowledge of cloud-based SQL security (Azure SQL, AWS RDS for SQL Server) is a plus.
  • SQL Server, ETL

    7 days ago


    Toronto, Ontario, Canada Cloudious LLC Full time

    1.Job title : GEOSPATIAL SR.ANALYST MAP 2.Job summary : We are looking for a GeoSpatial Sr. Analyst MAP with 6 to 8 years of experience to join our team. The ideal candidate will have expertise in SQL Server, ETL, Microsoft SSIS, and MS SQL Server. This hybrid role requires a strong analytical mindset and the ability to work collaboratively in a dynamic...


  • Toronto, Ontario, Canada Resonaite Full time

    Job Summary:We are seeking a seasoned SQL Server Security Consultant to join our team. As a key member of our security team, you will be responsible for implementing robust security measures for our SQL Server instances.Key Responsibilities:- Conduct comprehensive security assessments of on-prem SQL Server instances to identify vulnerabilities and...


  • Toronto, Ontario, Canada Resonaite Full time

    Job DescriptionWe are seeking a skilled SQL Server Security Consultant to join our team at Resonaite. As a key member of our security team, you will be responsible for ensuring the security and integrity of our SQL Server instances.Your primary focus will be on implementing and maintaining robust security measures to prevent unauthorized access and data...


  • Toronto, Ontario, Canada Creative Solutions Services, LLC Full time

    OverviewCreative Solutions Services, LLC is a leading provider of innovative solutions for businesses. We are currently seeking a skilled MS SQL Server Specialist to join our team.About the JobThis is an excellent opportunity for a talented individual with expertise in MS SQL servers to work on planning and deploying cloud and on-premise servers. The ideal...


  • Toronto, Ontario, Canada Dacaro Services Full time

    Responsibilities and Requirements- Consult, engineer, design, build, test, and deploy high-quality database solutions involving Oracle and SQL Server that meet project objectives and client requirements.- Administer Oracle/SQL database infrastructure full life cycle design to production support, ensuring system availability, efficiency, integrity, security,...


  • Toronto, Ontario, Canada Creative Solutions Services, LLC Full time

    **Job Overview:**Creative Solutions Services, LLC is a leading provider of innovative solutions, and we are currently seeking a highly skilled MS SQL Server Specialist to join our team.**Key Responsibilities:**Deploy and manage MS SQL servers on cloud and on-premise environments.Ensure optimal server performance through regular monitoring and...


  • Toronto, Ontario, Canada Dacaro Services Full time

    About UsDacaro Services is a leading provider of specialized support, engineered solutions, and dedicated technology environments for businesses. Our team manages a diverse environment by ensuring compliance in Base Support and Governance requirements for servers, including Backup remediation, HPSA remediation, Monitoring Server performance, Patch...


  • Toronto, Ontario, Canada Dacaro Services Full time

    Department Overview: Client provides specialized support, engineered solutions, and a dedicated technology environment that enables new technologies and the agility to meet the unique needs of the Client and its partners. Given the diverse set of software, infrastructure designs, and facilities that these businesses rely on, the client team manages a...


  • Toronto, Ontario, Canada Graebel Companies, Inc. Full time

    **About the Role:**We are seeking a talented Application Support Engineer to join our team. The successful candidate will have a strong background in Windows Server administration, SQL Server knowledge, and experience with automation scripting. They will also possess excellent problem-solving skills, be able to work effectively with cross-functional teams,...


  • Toronto, Ontario, Canada RBC - Royal Bank Full time

    RBC is looking for an experienced SQL server DBA specialist with minimum of 10+ years of working experience. We are looking for someone provide application DBA support and services but also lead initiatives across the group. This is an exciting position working with SQL server as leading initiatives in the group as well working with the databases in cloud.We...


  • Toronto, Ontario, Canada Creative Solutions Services, LLC Full time

    Job Overview:We are a leading provider of innovative solutions in the IT industry, and we are seeking a talented Database Administrator to join our team. In this role, you will be responsible for designing, implementing, and maintaining MS SQL servers to meet the evolving needs of our clients.Responsibilities:• Plan and deploy MS SQL servers on cloud and...


  • Toronto, Ontario, Canada Alithya Full time

    Please note that this is a hybrid position.Do you want to experience the essence of a large organization in a company with a personal touch? Come and work with us We are looking for creative, innovative, and collaborative people like you to join our team.Take your ambitions to the next levelAs a senior infrastructure engineer, with a focus on building and...


  • Toronto, Ontario, Canada Dacaro Services Full time

    Job Overview:Dacaro Services is seeking a skilled SQL Infrastructure Specialist to join our team. As a key member of our team, you will be responsible for designing, building, and administering database solutions that meet the evolving needs of our clients. This includes consulting with stakeholders to understand their requirements, developing robust...


  • Toronto, Ontario, Canada Creative Solutions Services, LLC Full time

    Job DescriptionCreative Solutions Services, LLC is seeking a highly skilled Database Administrator to join our team. In this role, you will be responsible for planning and deploying MS SQL servers on cloud and on-premise servers. Your expertise in general health and capacity monitoring, as well as load balancing of servers, will ensure the smooth operation...


  • Toronto, Ontario, Canada Dacaro Services Full time

    Department Overview: Client provides specialized support, engineered solutions, and a dedicated technology environment that enables new technologies and the agility to meet the unique needs of the Client and its partners. Given the diverse set of software, infrastructure designs, and facilities that these businesses rely on, the client team manages a...


  • Toronto, Ontario, Canada CloudVital Full time

    We are looking for an experienced Azure SQL Database Administrator to join our team As a SQL Server Database Administrator you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systemsJob Title: Azure SQL Database AdministratorJob Type: Full Time/ ContractJob Location:...


  • Toronto, Ontario, Canada CloudVital Full time

    We are looking for an experienced Azure SQL Database Administrator to join our team As a SQL Server Database Administrator you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systemsJob Title: Azure SQL Database AdministratorJob Type: Full Time/ ContractJob Location:...


  • Toronto, Ontario, Canada GFT TECHNOLOGIES SE Full time

    GFT Technologies SE is a leading global digital transformation company with over 12,000 solution-oriented technology professionals across 22 countries. We deliver cutting-edge software solutions to elevate our clients' productivity with intelligent software.We are hiring an experienced SQL Database Engineer to join our team. In this role, you will design,...


  • Toronto, Ontario, Canada GFT TECHNOLOGIES SE Full time

    We are looking for a highly skilled Data Modeler and SQL Specialist to join our team at GFT Technologies SE. In this role, you will be responsible for designing, developing, and maintaining SQL databases to support business applications, ensuring data security, integrity, and high availability.The ideal candidate will have a strong understanding of data...


  • Toronto, Ontario, Canada Computershare Full time

    Job DescriptionDevelop robust programs using Perl, Quadient Inspire, and interacting with SQL ServerReview solution design, architecture, and code to maintain quality and standardsFacilitate training and knowledge transfer between team membersIdentify and support business innovation initiatives