SQL Database Administrator

9 hours ago

Winnipeg, Canada JMT Consultants Full time

**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**:

- ** 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
- **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
- 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., PowerShell) 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**:

  • Database Administrator

    1 week ago

    Winnipeg, Canada Kaplan Agency Full time

    We are seeking to hire a technically skilled database administrator that is capable of holding positions of great responsibility. In this role, you'll be the first respondent to database problems that arise and carry out periodic maintenance and troubleshooting. To ensure success as a database administrator, you should be an excellent problem-solver and...

  • Business Intelligence Database Analyst

    5 days ago

    Winnipeg, Canada Workers Compensation Board of Manitoba Full time

    The Business Intelligence, Database Analyst (BI DBA) is responsible for transforming WCB operational data into information that is stored and managed utilizing WCB data warehouses. The incumbent maintains the foundation technology and data for all advanced analysis and research for WCB to improve programs, develop new methods and gain understanding of the...

  • Business Intelligence Database Analyst

    5 days ago

    Winnipeg, Canada Worker's Compensation Board of Manitoba Full time

    The Business Intelligence, Database Analyst (BI DBA) is responsible for transforming WCB operational data into information that is stored and managed utilizing WCB data warehouses. The incumbent maintains the foundation technology and data for all advanced analysis and research for WCB to improve programs, develop new methods and gain understanding of the...

  • Business Intelligence Database Analyst

    2 days ago

    Winnipeg, Canada Workers Compensation Board of Manitoba WCB Manitoba Full time

    **Job Summary**: The Business Intelligence, Database Analyst (BI DBA) is responsible for transforming WCB operational data into information that is stored and managed utilizing WCB data warehouses. The incumbent maintains the foundation technology and data for all advanced analysis and research for WCB to improve programs, develop new methods and gain...

  • Business Intelligence Database Analyst

    3 days ago

    Winnipeg, Canada WCB Manitoba Full time

    **Job Summary**: The Business Intelligence, Database Analyst (BI DBA) is responsible for transforming WCB operational data into information that is stored and managed utilizing WCB data warehouses. The incumbent maintains the foundation technology and data for all advanced analysis and research for WCB to improve programs, develop new methods and gain...

  • Tds Delivery

    2 days ago

    Winnipeg, Canada G3 Canada Limited Full time

    G3 Canada Limited is a progressive and continuously growing company. As part of our commitment of building a smarter path from Farmer’s fields to the global market, we are establishing a highly efficient coast to coast Canadian Grain enterprise designed to provide a unique competitive alternative to farmers and superior service to customers and...

  • Development & Database Administrator

    1 week ago

    Winnipeg, Canada Harvest Manitoba Full time

    **Harvest Manitoba is an outstanding place with employees that care greatly about the work that we do and the people that we work with and serve. We are seeking a **Development and Database Administrator** **that will work well with our development team. **Reporting to the Senior Manager of Development and works with the CEO and Director for Food and...

  • Business Intelligence Database Analyst

    6 days ago

    Winnipeg, Canada Buzzclan Full time

    **Title: Senior Business Intelligence Database Analyst** **Location: 333 or 363 Broadway in Winnipeg.** **Type: Onsite** **Description of Services** a) Lead the data warehouse solution design, development, and implementation including Enterprise Data Warehouse (EDW) BI Semantic Models, Extract/Transform/Load (ETL), and OLAP development; b) Contribute to...

  • Enterprise Systems Administrator, Business Solutions

    4 days ago

    Winnipeg, Canada University of Winnipeg Full time

    The Business Solutions team at The University of Winnipeg works closely with clients to identify ways in which the adoption of technology can streamline processes, enhance the student experience, and further the mission of the University. The team determines the business requirements and creates the functional design for new software and enhancements to...

  • Enterprise Systems Administrator

    3 days ago

    Winnipeg, Canada University of Winnipeg Full time

    The Business Solutions team at The University of Winnipeg works closely with clients to identify ways in which the adoption of technology can streamline processes, enhance the student experience, and further the mission of the University. The team determines the business requirements and creates the functional design for new software and enhancements to...

  • Data Migration Analyst/ms SQL

    5 days ago

    Winnipeg, Canada Buzzclan Full time

    **Job Title: -** Data Migration Analyst **Responsibilities: -** - Engage on multiple data migration/transformation client initiatives - Design test strategy, including data reconciliation strategy and perform data validation post migration to ensure successful transfer - Collaborate with IT and business stakeholders on a regular basis to understand...

  • IT Database System Support and Trainer

    2 days ago

    Winnipeg, Canada End Homelessness Winnipeg Full time

    IT Database System Support and Trainer - "HIFIS Stakeholder Relations and Support" Under the guidance and direction of and in consultation and collaboration with the Senior Director Housing Supports and the Manager, HIFIS (Manager), the Homeless Individuals and Families Information System (HIFIS) Stakeholder Relations and Support is responsible for...

  • Application Support Specialist

    9 hours ago

    Winnipeg, Canada PRICE INDUSTRIES LIMITED Full time

    **What We Offer**: Health and Dental - Employees and their families enjoy flexible benefits options covering an extensive list of medical and dental expenses and services. Life and Disability - You will be provided with life insurance in a multiple of your salary with an option to purchase additional coverage. Employee and Family Assistance Program (EFAP)...

  • Manager of IT Operations and Network Infrastructure

    7 days ago

    Winnipeg, Canada WINNIPEG SCHOOL DIVISION Full time

    **WINNIPEG SCHOOL DIVISION** Winnipeg School Division (WSD) nurtures a welcoming and inclusive culture of people committed to working together to inspire students to reach goals and achieve academic success. WSD is the largest school division in the Province of Manitoba with over 33,000 students and 6,000 employees. To ensure WSD’s continued success as a...

  • Administrative Assistant

    4 days ago

    Winnipeg, Canada The Dream Factory Full time

    As an **Administrative Assistant** at The Dream Factory, your exceptional attention to detail and strong organizational skills will play a vital role in supporting our day-to-day operations. You will ensure the smooth functioning of our office while prioritizing tasks related to donation processing, administration, and data entry into QuickBooks. Your...

  • Administrative Assistant

    4 days ago

    Winnipeg, Canada Southern First Nations Network of Care Full time

    **Summary**: **Key Responsibilities**: **Service Support Administration** - Analyses, prioritizes, organizes, and enters Intakes and other correspondences on electronic database (CRM). - Maintains paper filing of correspondence. - Gathers, analyses, and reports on yearly statistical data. - Processes, prints, and distributes letters. - Assists with questions...

  • Administrative Assistant

    6 days ago

    Winnipeg, Canada Industrial Metals Full time

    Industrial Metals (2011) is looking for an Administrative Assistant to join our team at the Messier office, working Monday to Friday from 8:00 AM to 4:30 PM. Based in Winnipeg, the Administrative Assistant ensures all incoming calls to the switchboard are answered promptly, maintaining a strong customer service commitment and a clean and prepared office...

  • Senior IT Support Specialist

    7 hours ago

    Winnipeg, Canada Floform Full time

    Required immediately, our Winnipeg Branch is seeking aFULL-TIME SENIOR IT SUPPORT SPECIALIST to provide desktop support, technical support and network administration services to users working in Canada and the US. With 16 branches and 5 manufacturing facilities located in Western Canada and the Pacific Northwest, FLOFORM Countertops manufactures, sells and...

  • Forms Administrator

    6 days ago

    Winnipeg, Canada Arctic Glacier Full time

    **Junior Forms Adminstrator** Location: Winnipeg - Bringing More to the Party!_ - At Arctic Glacier we create value with quality products and great service experiences._ - Sure,we have exciting job opportunities, but there’s also the great pay, rewarding work, and clear vision of doing the right thing - by our customers and associates. Our team goes the...

  • Administrator

    7 days ago

    Winnipeg, Canada Sincerus Capital Full time

    **Sincerus Capital - Administrator** Sincerus Capital Ltd. is seeking a self-motivated innovator with a proven record of success in troubleshooting, problem resolution and work independently when necessary. Our goal is to provide outstanding service and support to investors so strong communication skills are a must. This role requires organization, the...