Search jobs > Toronto, ON > Temporary > Dba

Vertica DBA 9898

Foilcon
Toronto, Ontario, Canada
$40 an hour (estimated)
Temporary

Description :

  • To provide support for the Vertica database technology and its deployment and usage standards.
  • To lead application development and support teams in optimal use of Vertica database technology through creation and communication of standards and walkthrough of critical application components.
  • Ensure that databases are optimally designed, so that applications meet their defined SLA’s, reuse of existing database structures is maximized and operational costs are minimized.
  • 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

  • Create and maintain Vertica database and amp; processing environments for application testing, pre-production verification, and production operation.
  • 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

  • Provide skilled counsel in the technical design of applications.
  • 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.
  • With senior staff, assess the impact of software upgrades and other environmental changes. Communicate, coordinate and implement application modifications as required.
  • Participate in the development and review of standards, guidelines and processes.
  • Seek productivity, quality and efficiency through tools and procedures.

Extensive knowledge of the Vertica database software and its architecture to ensure sound and efficient running of the applications using the platform.

The ability to build and upgrade the Vertica database environments with appropriate knowledge of system and OS settings for optimal SQL performance.

30+ days ago
Related jobs
Foilcon
Toronto, Ontario

To provide support for the Vertica database technology and its deployment and usage standards. To lead application development and support teams in optimal use of Vertica database technology through creation and communication of standards and walkthrough of critical application components. Create an...

Foilcon
Toronto, Ontario

To provide support for the Vertica database technology and its deployment and usage standards. To lead application development and support teams in optimal use of Vertica database technology through creation and communication of standards and walkthrough of critical application components. Create an...

Foilcon
Toronto, Ontario

To provide support for the Vertica database technology and its deployment and usage standards. To lead application development and support teams in optimal use of Vertica database technology through creation and communication of standards and walkthrough of critical application components. Create an...

Promoted
Apex Systems Inc
Toronto, Ontario

Apex Systems is a global IT services provider and our staffing group has an opening for an Database Developer with strong experience with Exadata, PL/SQL, relational databases, and ideally exposure to Capital. ...

Promoted
freelance.ca
Toronto, Ontario

Developer, SAS (Statistical Analysis System), Python, SQL, Pandas, GIT, JIRA, Confluence, Azure, CloudBees, Jenkins, UrbanCode, UC4, AKS Azure Kubernetes Service. Strong SQL skills using relational databases such as Oracle, SQL Server, DB2. Statistical Analysis System (SAS) to Python & SQL. ...

Promoted
Altis Technology
Toronto, Ontario

Senior Data and Systems Administrator (Education Sector). We are looking for a talented Senior Data and Systems Administrator with specialized experience in educational environments, particularly at the primary and elementary levels. Oversee and manage complex database systems, ensuring high perform...

Promoted
Metal Supermarkets
Toronto, Ontario

This role is ideal for someone with strong expertise in Power BI dashboard development, PostgreSQL and MS SQL databases, Integration Services, and VBA programming. You will be responsible for maintaining and enhancing existing dashboards, ensuring seamless integration with databases, and optimizing ...

CEC Entertainment Canada, ULC.
Mississauga, Ontario

Cashiers are the frontline of guest service as they take orders, process payments, help with prizes and more. ...

Scotiabank
Toronto, Ontario

As a Database Developer, you will be responsible for the enhancement, development and maintenance of the corporate ebusiness and banking systems. Design and build database component for growing banking application. Work closely with the development team to provide database components. Have a strong ...

Zurich Insurance Company
Toronto, Ontario

Strong preference will be given to Databricks Certified Data Engineer Associates or Databricks Certified Data Engineer Professionals candidates. The Data Engineer should have extensive experience working with very large data sets from the insurance industry and knowledge of building programs/mapping...