Rq04176 Database Administrator Jobs

Five (5) years of experience performing duties related to the above mentioned major responsibilities

Demonstrated experience managing vendor relationships and achieving desired performance outcomes while maintaining a positive working relationship

Demonstrated experience in data warehouse/lake development, disaster recovery, high availability, clustering and virtualization

Our Culture and Qualifications of the Job

Four (4) year University Degree in Computer Information Systems, Computer Engineering, or related discipline

For a full job posting and how to apply, visit: https://barrie.hiringplatform.ca/processes/140605-database-administrator-data-engineer?locale=en

Experience in Oracle RAC, ASM, RMAN, GridControl and Dataguard;

Experience in Avamar backups will be an asset;

Excellent communication skills; ability to communicate technical information to both technical and non-technical groups;

Experience in working in a 24 x 7 environment and being on call; and

Ability to design new or adapt existing systems/applications taking into account design alternatives, business requirements, and cost, recourse and time constraints.

You will have knowledge of:

AWS RDS (2+ yrs experience)

Benefit coverage (Medical, Dental, Vision, etc)

Writing query’s, working on optimization, data retention strategy

Competitive Salary: Up to $130K/year, DOE

Eight years experience within the past 10 years providing database administrator services in a Microsoft SQL environment;

Two years experience within the past 4 years working in a Dell virtualized environment;

CISP or similar security certification would be an asset, but is not strictly required.

will also ensure the secure operation of PGT’s in-house computer systems,

servers, and network connections. This includes checking server and firewall logs,

scrutinizing network traffic, establishing and updating virus scans, and

·Proactive and reactive management of support issues, including liaison with business users and system users.

·Design and Implement database solutions to satisfy application (business and technical) requirements;

Location: Montreal, QC(Hynrid-3 days a week)

·Involved in production/Stage/development environment setup, configuration and support of db2/Sybase/oracle/Sqlserver and other RDBMS;

·Installation, configuration and upgrade of db2/Sybase/oracle/Sqlserver and other RDBMS products;

·Perform database troubleshooting and performance monitoring;

Experience in Incident, Change and Configuration Management procedures

Oracle Enterprise Manager configuration & Management for alerting & reporting

MS SQL Server installation, Configuration, and database management

Experience in database administration at the specified experience level

Experience with managing Oracle 12c/19c ETL/Data warehouse

Experience with UNIX operating system

Technical knowledge and experience with Windows OS platforms from 2008 to 2019.

Manage and operate large-scale critical production database systems efficiently.

Perform root cause analysis and proactively offer recommendations to prevent issues from arising.

Effectively manage monitoring and alerting tools, including PowerShell scripts, Redgate, and logic monitor.

Document technical requirements, justifications, and recommendations to maintain accurate Standard Operating Procedures (SOPs).

7+ years of experience with MS SQL Server versions 2022, 2019, 2017, and 2016.

Plan, consult, design, implement and manage SQL/MP and SQL/MX objects

Install and manage SQL/MX database

Open and manage problem tickets with HP Global Support

Forecast future storage requirements to provide input to the hardware acquisition process

Bachelor’s Degree (preferably in Computer Science or equivalent) from a four-year college or equivalent experience

7+ years demonstrated work experience in a Database Administrator role

Support environments remotely for on-call

Experience with relational databases such as MariaDB, MySQL and SQL

Knowledge of standards and best practices in MySQL

Experience with replication configuration in MySQL

Beneficial to have experience with MySQL proxy tools such as ProxySQL or MariaDB MaxScale

Experience with MySQL backup and monitoring tools

Education, Certifications and Experience Requirements:

•Strong understanding and experience in capacity and performance management

•Recommend, document, and implement database and system standards, management and maintenance policies and standard operational procedures.

•Implement and enhance database and systems monitoring, alerting and event management

•Work closely with the scrum and service management teams to support application release and deployment initiatives

o Database management tools, load balancing, clustering, and replication

Intermediate skills include: Analytical; Facilitation; Interpersonal; Presentation; Problem Solving; Project Management; Time Management; Troubleshooting; Written Communication

Five (5) years of experience performing duties related to the above mentioned major responsibilities

Demonstrated experience managing vendor relationships and achieving desired performance outcomes while maintaining a positive working relationship

Demonstrated experience in data warehouse/lake development, disaster recovery, high availability, clustering and virtualization

Working knowledge of the following principles and standards: Business Intelligence practices, data structure, data modelling, analyzing and reporting techniques

Our Culture and Qualifications of the Job

Related formal database education or DBA certification

Familiar with Change Management and ITIL processes

Comprehensive health benefits including vision, dental, disability, life insurance, and more with immediate coverage

Consistently work to improve your knowledge of Data technologies

Hands-on experience writing and optimizing TSQL

Experience in working with Distributed Always on Availability Groups

In terms of skillset, this is typically what we would look for a Vertica DBA to provide:

• Provide skilled counsel in the technical design of applications.

We place consultants all over Canada.

Job Title: Vertica Database Administration Support

We are currently looking of Vertica Database administration support

• To provide support for the Vertica database technology and its deployment and usage standards.

Strong Linux working knowledge (preferably RedHat/CentOS family)

Experience with NoSQL databases such as MongoDB or Couchbase

Experience supporting development, testing, and production databases

Experience setting up replication, sharding, and other high-availability solutions

Experience working with Kubernetes (or any other orchestration frameworks)

Experience working with Percona Toolkit such as pt-online-schema-change

Minimum of three (3) years Oracle DBA experience required, five (5) years preferred

Oracle Database Administrator certification an asset

Experience with Apex/.NET an asset

Demonstrated experience in PL/SQL programming

Weblogic administration experience, particularly with Oracle Forms and Reports

Experience in a broad range of tools/platforms/applications/systems an asset

Bachelor’s degree in a related field. In some cases, substantial, relevant experience may be substituted for this qualification.

Manage MS-SQL Server databases across multiple environments, from development to mission-critical production systems.

Other duties as assigned by supervisor. Duties and Responsibilities are subject to change based on business needs.

5+ years of Microsoft SQL Server Administration experience required.

Advanced level SQL development and tuning skills (T-SQL and SSIS).

Experience with performance tuning and optimization, using native monitoring and troubleshooting tools.

Assists with designing workflows for image permissions, requests and fulfillment. Assists in creating and maintaining institutional guidelines/knowledge base.

Solid technical, analytical and problem-solving skills, highly organized with a strong attention to detail and accuracy.

Knowledge and understanding of digital images, image resolution, metadata and file formats.

Demonstrated ability to work independently and as part of a team. Excellent communication and writing skills.

Experience with end-user support and training.

Assists with the implementation of DAMS and CMS database systems.

Perform and manage system and database backups

Certification on IBM DB2 is a great Asset

Strong communication skills – written & verbal (will be speaking with various teams)

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