Hire IT People, LLC Vertica DBA Developer in sour lake, Texas

Vertica DBA Developer

Apply Now

Sign up for similar job alert!

Job ID :

6166

Company :

Internal Postings

Location :

sour lake, TX

Type :

Contract

Duration :

6 months

Rate :

open

Status :

Active

Openings :

1

Posted :

3 years ago

At least 3 + years of experience in administering Vertica, experience

with Teradata would be a plus.

·

Ability to

analyze current environments, design for upgrade and migration, install,

configure, administer, troubleshoot and tune environments

·

Experience

administering Vertica in virtualized and physical environments

·

Experience in

designing Vertica to run a 24x7 enterprise multi-data center environment,

including installation, configuration, backup, recovery and node failures

·

Linux/UNIX

experience, including shell scripting Proven ability to work in global

environments with counterparts in remote offices

·

Experience with

multiple versions, upgrades and performance tuning

·

Excellent

organization and communication skills

·

5+ years’

experience in shell scripts

·

3+ Experience in

SQL

·

Vertica Certification is a plus

·

5-10 years of overall relevant

experience in DBA

·

5+ years of experience data

management, maintaining and optimizing databases

·

5+ years of experience with data interfacing

with BI tools like, Cognos, Business Objects, Tableau etc.

Responsibilities:

You will be involved

in the product engineering for Sabre's analytics products suits that will be

enabled on data in a Vertica database.

Execute on Schema and projection design, Query optimization and support

Upgrades and system expansion. Create, maintain and refresh required Vertica

databases for development, test and production environments.

Monitor security, error log(s), database and log space, user activity and

resource utilization of production environment and Non-Prod Environments. Work

with application programmers for best practices and Policy enforcement.

Monitor system resources of servers to assure production systems meet

performance & availability

Provide expert assistance in database, projects and SQL statement tuning to

improve performance. This includes, but is not limited to, re-writing SQL statements,

creating new and altering existing projections.

Using vertica supplied tools and/or local scripts, monitor performance, space,

database parameters and tune as required.

Monitor disk usage and compute resources, plan acquisition and replacement feedback.

Act as liaison and coordinate with HP OS administrators for application of OS

patches and maintenance required for Vertica servers.

Understand and maintain documentation of dependencies between versions of

application vendor software.

Provide training and support for other resources and staff.

Develop, maintain and document procedures and standards for effective Vertica

usage.

Support a 24x7 mission critical environment.