Canada Job Openings
JMT Consultants
SQL Database Administrator
Winnipeg
FULL TIME
October 26, 2024
JMT Consultants Inc. – Winnipeg, Manitoba
Full-Time, Permanent
Are you ready to dive into the world of cutting-edge data management? As a SQL Database Administrator (DBA) at JMT, you won't just be maintaining databases—you’ll be at the helm of ensuring that massive amounts of data are optimized for performance, security, and accessibility. You'll play a key role in shaping the database architecture and contributing to innovative designs.
You'll have the opportunity to work with a variety of powerful database systems. Your expertise will be crucial in every day work bringing forward new puzzles to solve, as you’ll work to enhance performance and keep the lifeblood of modern businesses—our data—flowing smoothly and efficiently.
If you're passionate about working behind the scenes to make sure data powers every critical decision, this is the role for you!
What you'll do:
What Makes you Stand out:
Must Haves:
Leap into Action:
Ready to join the JMT family? Apply with gusto! Click the link to submit your Cover Letter and Resume, showcasing your journey as a SQL Database Administrator.
We appreciate the time all candidates take to apply, but we’ll only reach out to those who make the shortlist for an interview.
Full-Time, Permanent
Are you ready to dive into the world of cutting-edge data management? As a SQL Database Administrator (DBA) at JMT, you won't just be maintaining databases—you’ll be at the helm of ensuring that massive amounts of data are optimized for performance, security, and accessibility. You'll play a key role in shaping the database architecture and contributing to innovative designs.
You'll have the opportunity to work with a variety of powerful database systems. Your expertise will be crucial in every day work bringing forward new puzzles to solve, as you’ll work to enhance performance and keep the lifeblood of modern businesses—our data—flowing smoothly and efficiently.
If you're passionate about working behind the scenes to make sure data powers every critical decision, this is the role for you!
What you'll do:
-
Database Design and Development:
- Create and optimize database schemas and objects
- Develop stored procedures, functions, and complex queries
- Design and generate complex SQL reports based on business requirements
-
Data Mining and Integration:
- Perform complex data mining to extract valuable insights
- Integrate data from various sources into databases
- Ensure data consistency, integrity, and quality across different datasets
- Develop and maintain ETL (Extract, Transform, Load) processes
-
Collaboration and Solution Tailoring:
- Coordinate with internal teams to analyze and assess business needs
- Tailor database solutions to meet unique business requirements
-
Database Management and Maintenance:
- Oversee comprehensive database management tasks
- Implement backup and recovery strategies
- Secure database access and ensure data integrity
- Optimize physical data storage design
-
Security Management:
- Implement and maintain database security best practices
- Manage user access and authentication
- Ensure compliance with security policies and data protection regulations
-
Performance Optimization:
- Continuously monitor database performance and resource utilization
- Identify bottlenecks and optimize queries and indexes
- Maintain peak database performance through proactive measures
-
Troubleshooting and Debugging:
- Conduct root cause analysis for database issues
- Resolve performance issues and errors promptly
- Collaborate with development teams to fix application-related database problems
-
Scalability and Improvement:
- Develop scalable database solutions to accommodate growing data volumes
- Implement strategies for database scaling and partitioning
- Stay updated with the latest database technologies and best practices
-
Integration and Connectivity:
- Enable and manage connectivity via RESTful APIs
- Work with custom-developed applications to ensure seamless data flow
- Collaborate with software developers to integrate database solutions
What Makes you Stand out:
-
Education:
- Bachelor’s degree in computer science, Information Technology, or a related field
-
Experience:
- Minimum of 3-5 years of experience as an SQL Developer and/or DBA
- Proven experience with Azure SQL Database services
- Strong background in database schema design and optimization
- Experience in writing complex stored procedures and SQL queries
- Extensive experience in data mining and data integration from various sources
- Experience in coordinating with cross-functional teams to develop tailored database solutions
-
Technical Skills:
- Proficiency in SQL Server and T-SQL programming
- Knowledge of database security best-practices
- Experience with performance tuning and optimization techniques
- Familiarity with performance monitoring tools and techniques
- Understanding of RESTful APIs and web services
- Experience with cloud platforms, specifically Microsoft Azure
- Proficiency in ETL tools and processes (e.g., SSIS, Informatica)
- Knowledge of data integration methodologies and tools
- Familiarity with scripting languages (e.g., Power Shell) is desirable
- Experience with data warehousing and business intelligence tools is a plus
-
Soft Skills:
- Strong analytical and problem-solving skills
- Excellent communication and teamwork abilities
- Ability to work independently and manage multiple tasks
- Attention to detail and commitment to quality
Must Haves:
-
Security Consciousness:
- Must prioritize security in all database activities
- Experience with data encryption and secure data transmission methods
-
Continuous Improvement:
- Proactive in suggesting and implementing improvements
- Willingness to learn and adopt new technologies
-
Leadership and Guidance:
- Ability to provide expert advice on database management systems
- Experience in guiding teams on best practices and effective solutions
-
Certification:
- Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate are a plus
- Canadian Citizenship/Legally able to work in Canada
Leap into Action:
Ready to join the JMT family? Apply with gusto! Click the link to submit your Cover Letter and Resume, showcasing your journey as a SQL Database Administrator.
We appreciate the time all candidates take to apply, but we’ll only reach out to those who make the shortlist for an interview.
New Job Alerts
Sister Sophie Ltd.
English Instructor - K12
Markham
FULL TIME & PART TIME
November 26, 2024
View Job DescriptionLynx Design
Technicien(ne) en ébénisterie / ébéniste – Fabrication de cabinets pour véhicules récréatifs
FULL TIME
November 26, 2024
View Job Description
Career Connections Canada Inc.
Electrical Assembly Technician / Electrical Wiring Technician (Non-Engineering)
Milton
FULL TIME
November 26, 2024
View Job Description
Eassons Transportation Group
Truck Driver (AZ Class Experience Required + Cross Border)
Brampton
FULL TIME
November 26, 2024
View Job Description
OSL Direct Services
Associé aux Ventes Sans-Fil
FULL TIME & PART TIME
November 26, 2024
View Job Description
CANADA CARTAGE
Coordonnateur des Opérations - Jour
Bois-des-Filion
November 26, 2024
View Job DescriptionLooking for similar job?
Explorer Group Canada Ltd.
Database administrator (DBA)
Edmonton
FULL TIME
October 20, 2024
View Job Description
Canadian Nuclear Laboratories
Senior Database Administrator (2YR Term)
August 28, 2024
View Job DescriptionMaverick Innogarage Inc
Analyst, database
Bowmanville
FULL TIME
October 10, 2024
View Job DescriptionMaverick Innogarage Inc
Analyst, database
Bowmanville
FULL TIME
October 25, 2024
View Job DescriptionBNA O&M General Partnership
Database & System Administrator
Windsor
FULL TIME
October 26, 2024
View Job DescriptionNew Job Alerts
Sister Sophie Ltd.
English Instructor - K12
Markham
FULL TIME & PART TIME
November 26, 2024
View Job DescriptionLynx Design
Technicien(ne) en ébénisterie / ébéniste – Fabrication de cabinets pour véhicules récréatifs
FULL TIME
November 26, 2024
View Job Description
Career Connections Canada Inc.
Electrical Assembly Technician / Electrical Wiring Technician (Non-Engineering)
Milton
FULL TIME
November 26, 2024
View Job Description
Eassons Transportation Group
Truck Driver (AZ Class Experience Required + Cross Border)
Brampton
FULL TIME
November 26, 2024
View Job Description
OSL Direct Services
Associé aux Ventes Sans-Fil
FULL TIME & PART TIME
November 26, 2024
View Job Description
CANADA CARTAGE
Coordonnateur des Opérations - Jour
Bois-des-Filion
November 26, 2024
View Job Description