Position: Database Administrator

Location: Remote canada

Duration: Long Term contract

Job description:

At least 8 years of experience as database administrator with at least 4 years on SQL Server.

This database admin position must have deep knowledge and past work experience in the following

· SQL server upgrade from 2012 and 2019

· Data in transit encryption via TLS 1.2

· Data at rest encryption via SQL 2019 native TDE

· Performance monitoring & tuning

The candidate must also have:

· Strong? Foundational knowledge in database structure, configuration, installation and practices

· Extensive experience administering Microsoft SQL Server among other major relational database languages and applications

· Keen attention to detail, a strong customer service orientation and the ability to work as part of a team

· Ability to manage, monitor and maintain enterprise level databases making requested changes, updates and modifications to database structure and data

· Capability to enforce database security, integrity, stability and system availability; maintaining database backup and recovery infrastructure

Job Type: Fixed term to Friday

Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.

We are currently seeking competent individuals to fulfill the role of Database Administrator to join our dynamic team for our client

Contract Duration: 6 months
Extension: Yes
FTE: Yes

Position Summary-

• Monitor the system, and act upon system and application automated alerts
• Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues

(ex. correcting installation, configuration, or data problems)

• Plan and perform software installation, configuration, upgrade and patching
• Plan and perform database configuration, maintenance, upgrade and patching
• Perform and manage system and database backups
• Perform manual switch to redundant system / database components, in case of system failure

Job Responsibilities:
Provide on-site database and system support
Monitor, collect statistical information, and provide reporting on capacity and system performance Based on statistics, make recommendations to maintain and improve capacity and system performance
Monitor the system, and act upon system and application automated alerts
Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
Plan and perform software installation, configuration, upgrade and patching
Plan and perform database configuration, maintenance, upgrade and patching
Perform and manage system and database backups
Perform manual switch to redundant system / database components, in case of system failure

Must Have Skills/Requirements:

• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
• 5+ years Database Administration experience
• Experience in providing technical support, covering database administration and

operations to include monitoring maintenance capacity, performance
monitoring/planning and incident/problem troubleshooting and resolution

• Experience with MSSQL 2019/2017/2016/2014/2012
• Experience with Windows server 2012/2016/2019.
• Experience with Windows 10/8/7 client operating systems.
• Experience with SQL Always-On, mirroring, clustering and data replication.
• Experience with MSSQL services (SSRS/SSAS/SSIS/Fulltext/Polybase/R) and OLAP.
• Experience with application side tuning versus server-side tuning.
• Experience with VB, C#, Power shell, Azure Cloud would be an asset to the role.

Job Type: $60.00-$80.00 per hour

Job Summary

Nova DBA is a data management company that offers a variety of services to help organizations protect, manage, and leverage their data and infrastructure. Nova DBA helps organizations protect their data through data protection measures, compliance with data regulations, and ensuring data availability. We also offers services to help organizations manage and optimize their data, such as data architecture, database management, performance tuning, leverage their data through data visualization and insights, as well as monetization opportunities.

We’re currently looking for a PostgreSQL and MySQL Database Administrator (DBA) to join our operations team. The candidate must be present in Canada and authorized to work.

Qualifications

You are responsible to support client's database environment for the implementation, configuration, and maintenance to ensure the availability and consistent performance of the PostgreSQL and MySQL database environments.

• 10+ years of DBA experience with PostgreSQL and MySQL databases.
• Strong Experience with Cloud solutions (Google Cloud Platform Services, AWS, and Azure).
• Experience in performance tuning and query optimization.
• Technical and troubleshooting skills with PostgreSQL and MySQL databases.
• Experience operating a large-scale production database environment.
• Experience with backups, recoveries and HA/DR for MySQL and PostgreSQL.
• Experience with database security concepts, including access, auditing, and encryption.

Responsibilities

• Install, configure, and upgrade MySQL and PostgreSQL database systems.
• Monitor and respond to database incidents and alerts within SLA.
• Perform regular performance tuning and optimize queries to improve database performance.
• Perform database monitoring, maintenance, reorganizations. and resource management.
• Configure database replication, clustering, and high availability solutions.
• Collaborate with IT and development teams to ensure seamless integration of database systems with applications.
• Implement security measures, manage user’s access and authentication to protect data integrity and privacy.
• Develop and maintain database documentation and standards.
• Communicate effectively with clients to gather requirements and provide updates on database-related incidents/service requests.

Job Type: Full-time

Pay: $27.19-$77.05 per hour

Benefits:

• Casual dress
• Dental care
• Extended health care
• Paid time off
• Vision care
• Work from home

Schedule:

• Monday to Friday

Application question(s):

• How many years of experience do you have as a PostgreSQL/MySQL DBA?

Education:

• Bachelor's Degree Location: Remote

With its Corporate office in Red Deer, Alberta and its Regional office in London Ontario, Peavey Industries LP is the corporate parent to retail brands Peavey Mart, MainStreet Hardware, and Ace Canada. We are 100% Canadian and employee-owned.

Peavey is an engaging workplace. We are proud to promote from within and provide training to make this possible. We offer flex-time and comprehensive benefits.

We are committed to our customers and the communities and agricultural regions we serve every day.

Location:London, ON or Red Deer, AB. Hybrid work environment required in-office 2 days a week.

Job Overview:The Database Administrator is responsible for directing and/or performing all activities related to maintaining a successful database environment*. *This role ensures Peavey Industries databases, and its related applications operate functionally and efficiently.

Ideal Candidate:We are looking for an analytics-driven individual who is skilled at problem-solving and has effective communication skills. They will have proven abilities in planning, organizing, and working on multiple tasks simultaneously. They will also have familiarity with the following: Azure DevOps, Data Factory, Azure Synapse, Microsoft Azure SecOps, IaaS, PaaS, DBaaS, and IPaaS solutions (Boomi, Informatica, MuleSoft).

Responsibilities

· Manage an environment of SQL Server, Azure SQL DB, AS400 and other databases through multiple product lifecycle environments, from development to mission-critical production systems

· Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

· Refine and automate regular processes, track issues, and document changes

· Manage and ensure compliance with database backup strategies

· Troubleshoot problems as they occur, including weekends, on-call rotation as required

· Complete administration of SQL Server Replication (transactional, peer-to-peer)

· Complete administration of SQL Server Clustering, including Always On; additional knowledge of other HA/DR options as asset

· Creating and deploying Power BI and SSRS dashboards.

· Manage and maintain service pack updates, cumulative updates and security patches

Qualifications

· Bachelor’s Degree in computer science or a related field/equivalent experience

· Microsoft certifications

· 5-8+ years of experience in MS SQL Server production support in a mission-critical environment, Microsoft Azure SQL DBs, and AS400 environment

· Experience in analysis and tuning of T-SQL queries to improve performance, providing baselines and reporting to higher teams on results

· Experience with backup, restore, and recovery models

Employee Perks

· Employee ownership program

· Employee discount

· RRSP matching program

· Competitive group benefits

· Inclusive work culture

· Laid back atmosphere

· Work-life balance

*Only those selected for an interview will be contacted.

Job Types: Full-time, Permanent

Ability to commute/relocate:

• London, ON: reliably commute or plan to relocate before starting work (required)

Education:

• Bachelor's Degree (preferred)

Experience:

• Database administration: 5 years (required)
• MS SQL Server production support: 5 years (preferred)

Licence/Certification:

• Microsoft certification (required)

GlobeStar Systems is a leader in integrated clinical communication. Our cornerstone product, Connexall®, is an award-winning Enterprise grade IoT platform, purpose built for the healthcare industry. Connexall® is a sophisticated and customizable end-to-end integration and communication platform that helps its customers improve clinical workflow, reduce alarm fatigue, and drive better patient and staff outcomes.

Application and Database Administrator

Reporting to the Director of IT, the Application & Database Administrator position is responsible for support of all assigned applications, this position will serve as a subject matter expert on content, processes, and procedures associated with enterprise and in-house developed applications. Is responsible for the availability, integrity, accessibility, and performance of all the database systems by supporting, enhancing, administering, and maintaining the corporate databases.

Primary Responsibilities

• Collaborate with various stakeholders to play an active role, in selecting, configuring, and implementing application systems.
• Interacts with users and evaluates vendor products.
• Leads and participates in efforts to develop and implement processes for application and system monitoring.
• Leads and participates in efforts to implement application updates to include upgrades, patches, and new releases.
• Develops test plans to verify the logic of new or modified programs.
• Maintains systems documentation.
• Provides advice and training to end-users.
• Analyze internal user business requirements and develop, maintain, and modify reports for the ERP platform.
• Develop, and maintain the overall health of the ERP, CRM, Incident Management systems and other third-party applications.
• Configuration planning and installation of mostly MS-SQL and My-SQL databases.
• Conduct database performance analysis, tuning and maintenance.
• Create and maintain reports in SQL server 2016/2019 Reporting Services and Power BI.
• Apply database patches as required to both Production and Test databases.
• Responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Qualifications

• A Bachelor’s degree in Information Technology or related field required.
• Minimum 3 years of experience in Application Management and Database Administrator
• Microsoft SQL Certification is required.
• Knowledge in Power BI is an asset.
• System application administration experience related to ERP, Microsoft-based products, master data management, middleware services, and digital platforms.
• Ability to select new enterprise-level software packages and optimize existing processes.
• Experience with installing, administering, and supporting applications in a multi-platform environment.
• Strong understanding of database structures, theories, principles, and practices.
• General Database Administration, Performance and Health/capacity monitoring (SQL Server 2016/2019).
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of databases.
• Extensive knowledge of T-SQL (Ad-hoc maintenance scripts, stored procedures, views).
• Experience integrating SQL Server and Power Bi.
• Expert knowledge of design and maintenance of SQL Server 2016/2019 Reporting Services reports.
• Expert knowledge of applications management.

Job Type: Full-time

Benefits:

• Dental care
• Disability insurance
• Extended health care
• Flextime
• Life insurance
• Paid time off
• RRSP match
• Tuition reimbursement
• Work from home

Schedule:

• 8 hour shift

Supplemental pay types:

• Bonus pay

Ability to commute/relocate:

• Toronto, ON: reliably commute or plan to relocate before starting work (required)

Education:

• Bachelor's Degree (required)

Experience:

• Database administration: 3 years 2 years (required)

As a member of the development team, you will be primarily responsible for designing and developing high quality solutions within our suite of products (Omni CMS, Digarc, Destiny One, Lumens), as well implementing integrations with external systems, such as LMS systems, Banner, Colleague, etc.
You will work with team members to implement efficient, reusable database schemas and queries as well as optimize existing schemas and queries to improve performance. You will also work with the team to implement integrations with external systems through the maintenance and implementation of stored procedures to interact with external schemas and API's.
We are looking for the type of person that loves to have their hands in everything and someone who can take on the challenge of working within a growing team with a great deal of responsibility. In this role, you will be given the opportunity to actively contribute to all phases of the development cycle that will take your skills and experience to the next level.
How you'll make an impact:

• Act a as subject matter expert across product lines, for the modification and creation of database schemas and queries
• Analyze database usage patterns to optimize performance for indexes and queries
• Participate in all phases of the software development lifecycle – requirements, architecture, design, development, testing, deployment.
• Participate in the project planning process including estimating and process improvements in an Agile environment.
• Developing new features, enhancing existing features, fixing bugs and upgrading software to maintain tech health
• Deliver solutions that are highly usable, efficient, secure and scalable.
• Strive at all times to do work using best practices – through experience or experimentation.

What you'll need to succeed:

• The education and experience. You have either a diploma or a degree in Computer Sciences, IT, or related field and/or 5+ years work experience in a development environment.
• 5+ years of professional experience working with MS SQL Server and Oracle
• The ability to trouble shoot and optimize database performance issues
• Knowledge of best practices for database schema and query creation
• The tech exposure. You have experience with most of the following technologies and infrastructures:
• MS SQL Server
• MS SQL Reporting Services
• Java (JavaEE experience preferred)
• Coldfusion
• Tomcat, Apache
• AWS, Azure and/or Digital Ocean
• Familiarity with the following systems is an advantage but not necessary:
• Ellucian Banner
• Ellucian Colleague
• Oracle's PeopleSoft
• Familiarity with project management tools such as Jira and Git
• A perfectionist streak. You want to be part of a team dedicated to creating and delivering quality software. You define and follow best practices for web design and usability principles.
• Outstanding communication. You will split your time between heads-down work and team collaboration and innovation. We support each other out loud, working out solutions.
• Pride. You enjoy your work and getting a job done well. You want to be part of a team that promotes their accomplishments and sees the difference they make.
• Ownership. You can be counted on to deliver the best solution in collaboration with your team. You take ownership for your work, your tasks, your timelines.
• Driven. You want to be challenged and you are constantly seeking new opportunities to learn, gain and apply new skills and knowledge.

What you’ll gain:

• Competitive compensation
• Employee benefits including health, dental and vision insurance among others
• Learning and development opportunities
• You will make a difference every day for universities trying to grow, and students trying to learn.

Only qualified candidates selected for an interview will be contacted.
Company Overview:
Modern Campus is obsessed with empowering its 1,800+ higher education customers to thrive when radical transformation is required to respond to lower student enrollments and revenue, rising costs, crushing student debt and administrative complexity.
The Modern Campus engagement platform powers solutions for non-traditional student management, web content management, catalog and curriculum management, student engagement and development, conversational text messaging, career pathways, and campus maps and virtual tours. The result: innovative institutions can create a learner-to-earner lifecycle that engages modern learners for life, while providing modern administrators with the tools needed to streamline workflows and drive high efficiency.
Learn how Modern Campus is leading the modern learner engagement movement at [website] and follow us on LinkedIn.
Modern Campus is committed to fair and accessible employment practices and are committed to providing accommodations for persons with disabilities. We will work with all applicants to determine appropriate accommodation for individual accessibility needs.

• Toronto, ON, Canada
• Full Type: Full-time

Job Title: Database Administrator - Intermediate
Job Location: 315 Front St, 15th Floor, Toronto, Ontario (Hybrid-Candidate must be able to work 3 days onsite and 2 days remote)
Job Duration:Long-Term Job Description:

• Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with client groups to assess current data analytics and reporting capabilities, gather future-state requirements and identify further opportunities for improvement. Facilitate decision-making and manage client expectations. Own the execution of analytics initiatives including end-to-end reporting and data set delivery. Participate in documentation, development, testing
• Work with functional area experts, Data Architects and ETL Developers and stakeholders to understand complex business issues and develop appropriate Business Intelligence solutions. Design methods to capture, structure, transform and process data to be used to generate models. Build data models that provide information which is accurate, easy to understand and unbiased. Communicate complex quantitative analysis in a clear and precise manner, providing useful visuals and summaries. Provide interpretation, advice, and expertise to client groups and other stakeholders, including direction on how to transform analytics into actionable information and proactive insights that support decision making.

General Skills

• Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and teamwork skills
• Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
• Adept at communicating to both technical and non-technical audiences
• Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level
• Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
• Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
• Experience designing high quality interfaces to present information in a meaningful way to end users
• Broad understanding of data management, financial and business analysis, database architecture, and information visualization
• Proficiency in query languages and experience constructing complex query statements
• Experience in one or more programming or scripting languages
• Strong investigative and logic skills. Proficiency in mathematics and statistics
• Awareness of emerging Business Intelligence trends and directions
• Experience with analytical software such as R,
• Proficiency with desktop analysis software including Microsoft Excel, Access, VBA, Power BI

The general scope of work for the Database Administrator involves:

• Assisting with the transformation/cleaning of data from a legacy database into a new data warehouse
• Determine appropriate data structure for remaining relevant legacy data
• Develop mapping and transformation rules to align the two databases
• Create data dictionary for new data
• Develop connections with multiple other government databases and develop system to maintain the connection so that it does not go out of date
• Supporting Power BI visualization and report building
• Develop and test any automated data validation tools deemed necessary

*

Experience and Skill Set Requirements

• Database Skills - 70%
• Experience with one or more database technologies
• Proficiency with SQL and experience writing SQL scripts
• Experience designing data architecture for new databases
• Experience in monitoring and enforcing database rules
• Experience cleaning, transforming and joining data
• Experience is creating and applying data standards
• Experience with dimensional data models
• Subject matter expert in database design of data warehouse or data marts.

Communication Skills - 25%

• Experience in developing documentation on data standardization and requirements
• Demonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
• Strong verbal and written communication skills; with both technical and non-technical audiences
• A demonstrated team player with a track record for meeting deadlines

OPS Experience - 5%

• Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service."

MUST HAVES:

• Experience with one or more database technologies
• Experience designing data architecture for new databases
• Experience in monitoring and enforcing database rules
• Experience is creating and applying data standards
• Experience in developing documentation on data standardization and requirements"

Job Type: Full-time

Pay: $65.00-$70.00 per hour

Benefits:

• Dental care
• Extended health care
• Paid time off

Schedule:

• Day shift
• Evening shift
• Monday to Friday
• Night shift

Experience:

• Database Administrator: 6 years 4 years (required)