Job Description

Deliver applications programming and analysis tasks as part of a system development process as well as provide application support, maintenance and enhancements. An Application Developer applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or with a mix of technologies, but the focus is to ensure a certain business/functional use case is solved with the help of technology.

Your Key Responsibilities:

• Liaise with business units and program areas to ensure solutions meet current and strategic ministry needs.
• Align development team to follow Application Architecture.
• Write code for the most complex Functional and Technical Designs with minimal defects.
• Define non-functional requirements (Performance, Availability, Portability, Recovery / Recoverability etc.).
• Assess technical impacts up front and recommend better ways of designing application to ease the development.
• Produce Technical Design, Database structure and Application Architecture for a new average to high complex application.
• Seek for the best technical design solution that respects budget and timeline. Advocate the re-use of existing components/frameworks.
• Innovate in providing better efficient ways to design application.
• Review Technical Designs from other developers and recommend optimization if necessary.
• Evaluate, with assistance, the quality of the product being delivered, and take action to improve situations.
• Assist/Execute performance/penetration tests and troubleshoot issues at the system level.
• Isolate root cause of issues and provide solution options/recommendations.
• Provide tracking and reporting of time and status on all work, as required.
• Contribute to the creation of the Application Lifecycle Planning.
• Identify and coordinate release schedules.
• Identify service requests and priorities with customers.
• Ensure planned releases remain on schedule.

Job Description

Your Key Responsibilities:

• Design, develop and maintain SSIS integration packages.
• Contribute to the ongoing development of the data warehouse.
• Contribute significantly to the constant improvement of BI practices.
• Interpret extraction specifications into program design.
• Adhere to overall BI/DW architecture standards and principles.

Your Capabilities and Credentials:

• Related post-secondary education and industry certification.
• 5+ years of proven work experience in a similar role.
• Advanced skills in SQL scripting and stored procedures.
• Programming skills is an asset.
• Familiarity with Microsoft Azure technologies and TFS Source Control.
• Excellent interpersonal, verbal, written, and listening communications skills.
• Highly analytical, organized, detail and action oriented.
• Well-developed problem solving and documentation skills.
• Ability to handle multiple projects efficiently and effectively.
• Ability to interpret business requirements and translate these into detailed designs.

Job Description

Your Key Responsibilities:

• Ensure high levels of database performance, availability, and sustainability.
• Manage database access and security.
• Maintain database backup and recovery.
• Minimize database downtime and manage parameters to provide fast query responses.
• Diagnose, troubleshoot, and fix database errors.
• Create automation for repeatable database tasks.
• Develop and maintain DevOps CI/CD processes.
• Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
• Contribute to the ongoing development of the data warehouse.
• Contribute significantly to the constant improvement of BI practices.
• Adhere to overall BI/DW architecture.

Your Capabilities and Credentials:

• Related post-secondary education and industry certification.
• 5+ years of proven work experience in a similar role.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
• Expert knowledge of Microsoft SQL Server and MS Azure technologies.
• PowerShell and Unix shell scripting skills.
• Familiarity with programming languages API.
• MCSE/MCSA certification is an asset.
• Excellent interpersonal, verbal, written and listening communications skills.
• Highly analytical, organized, detail and action-oriented.

Job Description

Your Key Responsibilities:

• Contribute in the ongoing development of the data warehouse.
• Contribute significantly to the constant improvement of BI practices.
• Design, test, monitor and troubleshoot stable and effective SQL scripts and ETL processes.
• Liaise with other members of BI team to improve data flow and establish best practices.
• Support and enhance data models, queries, integrations, and other ongoing production support tasks.
• Support actionable reports and recommendations to support decision-making.
• Work closely with Architect on day to day development activities.
• Adhere to overall BI/DW architecture standards and principles.

Your Capabilities and Credentials:

• Related post-secondary education and industry certification.
• 5+ years of proven work experience in a similar role.
• Advanced skills in SQL scripting and stored procedures.
• Data warehousing and dimensional modelling experience is an asset.
• Familiarity with TFS Source Control.
• Excellent interpersonal, verbal, written, and listening communications skills.
• Highly analytical, organized, detail and action oriented.
• Well-developed problem solving and documentation skills.
• Ability to handle multiple projects efficiently and effectively.
• Ability to interpret business requirements and translate these into detailed designs.

Job Description

SemTegra Solutions is looking for 3 temporary full-time and part-time student positions for 4 months. Students currently enrolled in a management information system, computer science, and or related degree program.We are looking for a dynamic detail-oriented student to be part of our research group and will have opportunity to work on different projects and to enhance your Artificial Intelligence and Data engineering skills.

Responsibilities Include:

• Analyze raw data: assessing quality, cleansing, structuring for downstream processing
• Design accurate and scalable prediction algorithms
• Collaborate with engineering team to bring analytical prototypes to production
• Generate actionable insights for business improvements
• Document project requirements using collaborative tools
• Conduct research for various projects including innovative AI and data engineering solutions

Qualifications:

• Currently enrolled in a management information system, computer science, or related degree program
• At least 1 - 2 years' of experience in quantitative analytics or data modeling
• Deep understanding of predictive modeling, machine-learning, clustering and classification techniques, and algorithms
• Experience with programming languages and relational databases such as SQL, C, C++, JAVA
• Ability to analyze and visualize data using R or Python
• Ability to work in a fast-paced environment
• Demonstrated ability to conduct research and analysis with proven attention to detail
• Effective verbal and written communication skills and ability to maintain strong working relationships
• Demonstrated knowledge of marketing and social media practices and principles is an asset

Eligibility:

• Please attach an unofficial transcript, or an enrollment verification letter (indicating the program you are currently attending)
• Between 18 and 35 years of age at the start of the employment
• be a Canadian citizen, permanent resident
• Priority will be given to applications from candidates who self-identify as being part of underrepresented groups or as having additional barriers to entering or staying in the labour market such as New immigrant / Indigenous youth , Visible minorities, Women in science, technology, engineering and mathematics.

Note: This position may be partially funded by combination of different Grants.

Hours of Work: 20-40 hours per week, Monday - Friday Salary Range: $20 - $30 (Hourly)

Your Key Responsibilities:

• Builds, designs, and maintains all websites and software applications.
• Regulates exposure to business stakeholders and executive management and to other authorities.
• Editing, writing, or designing website content, and directing team members.
• Present design specs and work with graphics and other designers.
• Conferring with teams to resolve conflicts, prioritize needs, develop content criteria, or choose solutions.
• Directing or performing Website updates routinely.
• Executes assignments with the use of web applications, scripts, and programming languages such as HTML, CSS, JavaScript and other coding languages.
• Developing or validating test routines and schedules to ensure that test cases mimic external interfaces and address all browser and device types.
• Maintaining an understanding of the latest Web applications and programming practices through education, study, and participation in conferences, workshops, and groups.
• Gather & refine specifications and requirements based on technical needs.
• Create and maintain software documentation.
• Back up files from Web sites to local directories for recovery.
• Integrating data from various back-end services and databases.
• Identifying problems uncovered by customer feedback and testing, and correcting or referring problems to appropriate personnel for correction.
• Evaluating code to ensure it meets industry’s standards, is valid, is properly structured, and is compatible with browsers, devices, or operating systems.
• Communicates with colleagues, managers, and stakeholders daily.
• Determining user needs by analyzing technical requirements.
• Troubleshoot website problems.

Your Key Responsibilities:

• Plan, organize, direct, control and evaluate the operations of information systems and electronic data processing (EDP) departments and companies.
• Develop and implement policies and procedures for electronic data processing and computer systems development and operations.
• Meet with clients to discuss system requirements, specifications, costs and timelines.
• Assemble and manage teams of information systems personnel to design, develop, implement, operate and administer computer and telecommunications software, networks and information systems.
• Control the budget and expenditures of the department, company or project.
• Recruit and supervise computer analysts, engineers, programmers, technicians and other personnel and oversee their professional development and training.

Your Key Responsibilities:

• Develop policies and administer programs to promote industrial and commercial business investment in urban and rural areas.
• Design market research questionnaires.
• Conduct social or economic surveys on local, regional or national areas to assess development potential and future trends.
• Plan development projects and co-ordinate activities with representatives of a wide variety of industrial and commercial enterprises, community and business associations and government agencies.
• Assess business opportunities and develop strategies to attract venture capital.
• Respond to enquiries from members of the business community and general public concerning development opportunities.
• Review and evaluate commercial or industrial development proposals and provide advice on procedures and requirements for government approval.
• Conduct surveys and analyze data on the buying habits and preferences of wholesale or retail consumers.
• Evaluate customer service and store environments.

Job Description

We are currently seeking a talented Database Administrator (DBA) to join our team and take a lead role in managing and optimizing our database infrastructure.

Your Key Responsibilities:

As a Database Administrator at SemTegra Solutions you will be responsible for:

• Installing, configuring, and maintaining database management systems (DBMS) to ensure optimal performance, security, and availability.
• Managing and optimizing database configurations for various applications, focusing on efficiency and scalability.
• Managing Very Large Databases (VLDB), ensuring performance maintenance, and troubleshooting using SQL native and third-party tool
• Implementing and maintaining database security protocols to safeguard sensitive data and ensure compliance with industry standards.
• Performing regular database backups and recovery procedures to minimize data loss in the event of system failures or disasters.
• Collaborating with development teams to design and implement efficient database schemas, queries, and stored procedures.
• Monitoring and tuning database performance using diagnostic tools and analyzing query execution plans.
• Planning and implementing database upgrades and patches in coordination with the development and infrastructure teams.
• Providing on-call support for database-related issues and participating in disaster recovery planning and execution.
• Evaluating and recommending new database technologies and solutions to enhance overall system performance.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Administrator, managing and optimizing relational database management systems (RDBMS), such as SQL Server, Oracle, or MySQL.
• In-depth knowledge of database security, backup and recovery procedures, and performance tuning.
• Strong understanding of database design principles and experience working closely with development teams.
• Proficiency in scripting languages for automation (e.g., SQL, PowerShell, Python).
• Excellent problem-solving and troubleshooting skills with a keen attention to detail.
• Effective communication skills with the ability to collaborate across teams and convey technical information to non-technical stakeholders.

SemTegra Solutions is an equal-opportunity employer. We encourage applications from candidates of all backgrounds and experiences.