Sql Database Engineer Jobs

Migration of database objects from development through production following documented standards, policies, and procedures (Change Management Process)

On prem and cloud database migration and management expertise on either Azure or Aws.

Please note this role can be remote based (Halifax/Toronto area)***

2+ years of SQL Server database administration experience handling medium to large database.

2+ years of experience and support with Cloud technologies and database workload

Manage medium to large projects and participate in a variety of projects through the entire project lifecycle (if applicable)

Produce Integration Recommendations: Recommendations for integrating the extracted business rules into the new workflow management system, ensuring alignment with solution design.

Utilize your PL/SQL skills to assess, understand, document existing business rules in the current workflow system.

5+ years experience in Oracle administration and development, including managing standard database security utilizing user accounts, privileges, profiles and role-based security.

Produce Technical Analysis Report: A detailed report describing the technical analysis conducted on the existing system, highlighting insights and logic intricacies.

Contract duration: 6 months with extension option

Location: Hybrid - downtown Toronto

-Candidate should have 10 to 15 years of experience on MS SQL DB experience.

-Should have experience on database Migration project from My SQL to MS SQL DB.

-Should be able to evaluates existing database design to determine necessary updates, performance tuning, and integration requirements.

-Collaborates with users to design, code, test, debug, and deploy databases that meet requirements and organizational needs.

-Should be able writes complex queries, stored procedures and functions for database development.

-Can Monitors databases' performance, scalability, and security and modifies procedures to optimize database designs

Database security management, e.g. Design & implement Security framework, incl. database roles.

Synapse Dedicated SQL Pool Workload Management.

5 + years MS SQL Server database administration experience.

Experience with the provisioning/administration/operations of Azure Synapse Analytics/Dedicated SQL Pools.

Experience with Performance Analysis, query optimization & troubleshooting.

Experience working with users to resolve issues.

3+ years of professional experience as a Database Engineer or equivalent

ETL experience and experience with SSRS/SSIS

100% Database engineering and administration

Expertise and experience monitoring Azure workspaces, VM's, VM drives, Memory etc.

Expertise and experience creating MS Visio diagrams as they relate to MS SQL and database design.

Responsible for maintaining existing databases with high-availability solutions, replication, backup, restore, encryption, and disaster recovery solutions.

Configure & Monitor Performance/Storage/Memory alerts on all Production Azure Servers to ensure high availability of data

Ensuring all hardware and software are updated.

Assist to define data retention policies and automation.

Communicate issues, risks, and concerns proactively to management.

Self-sufficient and good communication skills

Must be skilled with MS Office applications.

Data Warehousing experience is preferred.

Strong MS SQL Database Developer.

Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness.

5+ years' experience in Database Management, with demonstrated expert skillsets in both SQL and PowerBI, and strong data analysis skills

Business analysis & consulting ability - Experience at writing business & user requirements

Database Manager - PowerBI & SQL w Python – Mandatory Skills

Database Manager - PowerBI & SQL w Python – Preferred Skills

Collaborate with IT team to develop/maintain/manage SQL Server database Global Operational Risk entities.

Fix any data discrepancies or schema changes as per the business requirement

Hands on experience with query engine internals, transactional storage engines and indexing techniques.

Excellent programming skills in C, C++ or Rust is a must. Familiarity with other languages is an asset.

Experience with data integration from various sources in data lakes.

Work with a small team of highly motivated engineers and researchers.

Participate the design and implementation of analytical database engines.

Validate, evaluate and troubleshoot system designs issues.

7-10 years relevant engineering experience, including experience with the following required:

Experience with Java/JMS, .NET, C/C++, REST

Scripting experience in JIL, Shell, Salt

Salesforce experience is a plus

What experience will you need?

Understanding of Databases (e.g. Oracle, Azure SQL)

Exceptional abilities and knowledge of relational databases – SQL Server knowledge a plus

Work with business stakeholders to understand and iterate over software and business requirements

Excellent organization, critical-thinking and personal leadership skills

Experience with building large scale SaaS software

Knowledge with scripting languages such as Python

Develop solutions by producing clean, efficient, production-ready code

Hands on experience with PolyBase and External Tables, Loading data into Synapse.

Strong communications skills – Excellent spoken and written English communication skills

Azure Synapse Analytics components such as Dedicated pool, serverless, Synapse Studio and its associated components etc.

Network connectivity (Network +, CCNA preferred), Firewalls, VNet, Private Endpoints, Connection policies, Point-to-site, Site-to-Site, Express Route, security (TLS/SSL versions)

Alerts, Auditing (storage, Log Analytics), Security (Threat detection, Vulnerability Assessment)

SQL Server Data Warehouse / Azure Synapse or RDMS or equivalent MPP cloud-based databases

Knowledge on Azure SQL Managed Instance

Deep Knowledge in Database (Mongo DB, MS SQL, No SQL)

Experience in one or more of these areas desirable:

Experience supporting Azure or other cloud-based solutions.

Microsoft certifications in data platform or Azure technologies

Expert level understanding of Azure Data factory, Azure Synapse, Azure SQL Services

Knowledge on Azure SQL Managed Instance

Minimum 5+ of experience is required in Technical Support Roles

Must have knowledge of basics of Azure and SQL

Hand on experience in production support with Database experience

Experience supporting or maintaining complex mission critical database solutions, RDMS technologies, and/or SQL language.

Manage all customer communication with the appropriate level of etiquette, timeliness, and professionalism, whilst working towards achieving the KPI targets.

Demonstrate strong interpersonal and communication skills, while working with diverse audiences including highly technical IT professionals, developers, architects, and executive management

on-prem experience, and strong communication skills

Manage crisis situations that may involve technically challenging issues and diverse audiences

Maintain strong working knowledge of released products, take ownership for product improvement, and participate in pre-release activities and BETA programs

Lead triage meetings to share knowledge with other engineers and develop customer solutions efficiently

Second interview – 45 mins-1 hour with hiring manager

Demonstrate strong interpersonal and communication skills, while working with diverse audiences including highly technical IT professionals, developers, architects, and executive management

on-prem experience, and strong communication skills

Manage crisis situations that may involve technically challenging issues and diverse audiences

Maintain strong working knowledge of released products, take ownership for product improvement, and participate in pre-release activities and BETA programs

Lead triage meetings to share knowledge with other engineers and develop customer solutions efficiently

Second interview – 45 mins-1 hour with hiring manager

Experience working remotely with a fully distributed team, with the communication and adaptability it requires.

Prior hands-on experience in MongoDB database installation, deployment and upgrade procedures

Data modeling, performance tuning and experience in writing efficient SQL.

Scripting knowledge – proficiency with Python, Go, Java, JS or similar languages

Strong presentation, verbal and written communication skills

Experience mentoring and training junior team members

Enhance database and systems monitoring, alerting, and event management capabilities.

Provide operational support and contribute to the architecture, deployment, and management of databases, systems, and services in a dynamic, distributed environment.

Proficiency in capacity and performance management.

Database management tools, load balancing, clustering, and replication

8+ years of relevant work experience in a large-scale environment.

Experience in managing and supporting critical databases, servers, and clusters.

5+ years of hands-on experience with Microsoft SQL and a strong knowledge of database management software

Modify existing databases and database management systems or direct programmers and analysts to make changes.

Excellent verbal and written communication skills and problem-solving skills

Ability to work independently and manage one’s time

Basic mentoring skills necessary to provide support and constructive performance feedback

Test programs or databases, correct errors and make necessary modifications.