Vertica Dba

**Role: Vertica DBA**

**Location: Toronto, ON**

**Duration: Long Term Contract**

In terms of skillset, this is typically what we would look for a Vertica DBA to provide:
High-level
- To provide support for the Vertica database technology and its deployment and usage standards.
- To ensure that all database and environmental changes are appropriately tested and implemented in such a manner that there is no impact to RBC systems and clients.
- To provide database related technical support for development and production environment including required level of 7X24 on call support.

Primary Responsibilities:
1. Maintenance Services
- Provide technical support for database processing, data access, performance tuning, and database recovery.
- Perform analysis required to resolve complex technical issues/problems.

2. Design Services
- Ensure optimum use of software facilities and features; walk through critical components.
- With senior staff, make decisions on data placement and strategic/tactical software, addressing business-specific objectives in the context of RBC technology strategies.
- Transform logical data models into physical database structures via standard processes. Provide data modelling assistance, as required.
- Participate in the architecture review process for development projects. Be accountable for adherence to standards and policies; escalate non-conformance.
- Serve as the technical lead for projects of short duration.

3. Infrastructure Services
- Research, analyze and make recommendations on software/utility usage.
- Participate in the development and review of standards, guidelines and processes.
- Seek productivity, quality and efficiency through tools and procedures.

**Job Type**: Fixed term contract
Contract length: 12 months

**Salary**: $55.00-$65.00 per hour

Schedule:

- Monday to Friday

Ability to commute/relocate:

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

**Experience**:

- Vertica Database: 6 years (preferred)