Vertica DBA 9898

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.