SQL Database Administrator

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

  • SQL Database Architect

    2 weeks ago

    Winnipeg, Manitoba, Canada JMT Consultants Full time

    SQL Database AdministratorJMT Consultants Inc. is seeking a skilled SQL Database Administrator to join our team in Winnipeg, Manitoba.This is a full-time, permanent position that requires a strong background in database management and administration.Key Responsibilities:Design and develop database schemas and objectsDevelop stored procedures, functions, and...

  • Database Developer with Expertise in SQL Server

    2 weeks ago

    Winnipeg, Manitoba, Canada Apex Group Full time

    Opportunity OverviewApex Group, a leading global provider of fund administration and middle office solutions, is seeking a highly skilled Database Developer with expertise in SQL Server to join our team. Located in Winnipeg, this role offers a competitive salary range of $80,000 - $120,000 per year.Job DescriptionWe are looking for an experienced Database...

  • Database Developer with Expertise in SQL Server

    2 weeks ago

    Winnipeg, Manitoba, Canada Apex Group Full time

    Company OverviewThe Apex Group is a leading provider of fund administration and middle office solutions, established in Bermuda in 2003. With over 13,000 employees across 112 offices worldwide, our business has grown exponentially, and we are now one of the world's largest service providers.SalaryWe offer a competitive salary, commensurate with skills and...

  • Database Administrator

    4 months ago

    Winnipeg, Canada Manitoba Hydro Full time

    NATIONAL OCCUPATION CODE 21223 EMPLOYER MANITOBA HYDRO POSITION TYPE FULL-TIME Under the general direction of the Software Operations Lead and Senior Database Administrators, will assist in the design, planning, implementation and tuning of corporate database management systems to meet the Corporation's objectives for security, availability and...

  • Database Administrator

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

  • Administrator - Database

    6 months ago

    Winnipeg, Canada Western Financial Group Full time

    **We are one of Canada’s Top Employer, Join Us** **Database Administrator - Junior** **Here is what a typical day looks like** - Writing Structured Query Language (SQL) scripts, investigating issues and supporting - Defining users and enabling data distribution to the right user, in the appropriate format and in a timely manner - Determining...

  • Analyst, Database

    5 months ago

    Winnipeg, Canada Manitoba Government and General Employees' Union Full time

    Durée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 70 hours bi-weekly - Education: - Expérience: **Education**: - College/CEGEP **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Document customers' requirements for projects - Document reporting needs, queries, logic,...

  • Database/student Information System Administrator

    6 months ago

    Winnipeg, Canada River East Transcona School Division Full time

    **Duties and Responsibilities**: - Portal assignments in PowerSchool, manage Access/Roles (SIS) - Identify data requirements and develop queries using standard query languages to extract, load, report, and analyze data. - Administer Microsoft SQL database version upgrades, new installation, maintenance, performance tuning, and security-related tasks -...

  • Database Analyst

    6 months ago

    Winnipeg, Canada Radical Data Science Ltd Full time

    **Key Responsibilities**: - Administer, maintain, and support multiple databases across various platforms to ensure their performance, availability, and security. - Develop and optimize SQL databases in both Windows and Linux environments. - Design and implement data integration solutions to meet business requirements. - Collaborate with teams, partners,...

  • Business Intelligence Database Analyst

    5 months 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 months 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

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

  • OCI Database Administrator

    3 months ago

    Winnipeg, Canada Stantec Full time

    OCI Database Administrator - ( 2400036M ) Description Grow with the best. Join a smart, creative, and inspired team that accomplishes operational excellence. Bringing together individuals with diverse backgrounds, talents, and expertise, our 31,000 team members in over 450 locations worldwide are vi

  • Senior Database Security Specialist

    2 weeks ago

    Winnipeg, Manitoba, Canada Stantec Consulting International Ltd. Full time

    About the RoleWe are seeking a highly skilled Database Administrator to join our team. The ideal candidate will have extensive experience in database security, auditing, and application security with Enterprise Applications.Main ResponsibilitiesApply strong concepts of database security, auditing, and application security with Enterprise Applications to...

  • Development and Database Administrator

    6 months ago

    Winnipeg, Canada Harvest Manitoba Full time

    Harvest Manitoba is an outstanding place with employees that care 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 Fundraising. The...

  • Database Officer

    3 months ago

    Winnipeg, Canada Alzheimer Society of Manitoba Full time

    *** The Database Officer will have the primary role of senior database administration for the Raiser’s Edge (RE) and Luminate Online (LO) databases as well as all things related to such. This role will provide inter-departmental support in relation to the database and its structure across all departments including Finance, Development, Marketing, and...

  • Database Analyst

    6 months ago

    Winnipeg, Canada Fairysun Systems Inc. Full time

    Education: - Expérience: **Education**: - Bachelor's degree **Tasks**: - Data Science - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document data requirements, data collection and administration policy, and data access rules -...

  • Database Coordinator

    3 months ago

    Winnipeg, Canada Alzheimer Society of Manitoba Full time

    *** Under the general direction of the Database Officer, the Admin & Database Coordinator will have the primary role of data entry of volunteer, donor, and gift information in the Raiser’s Edge (RE) and Luminate Online (LO) databases. This role will also be the support position for the front reception, directing calls, accepting donations, and greeting...

  • Analyst, Database

    6 months ago

    Winnipeg, Canada SALMAN IDRIS CHARTERED PROFESSIONAL ACCOUNTANT CORP. Full time

    Education: Other trades certificate or diploma - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Operate database management systems to analyze data - Research and document data requirements, data collection and administration policy, and data access rules - Prepare income tax returns from accounting records -...

  • Enterprise Systems Administrator, Business Solutions

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