Hire IT People, LLC Vertica DBA Developer in sour lake, Texas
Vertica DBA Developer
Sign up for similar job alert!
Job ID :
sour lake, TX
2 years ago
At least 3 + years of experience in administering Vertica, experience
with Teradata would be a plus.
analyze current environments, design for upgrade and migration, install,
configure, administer, troubleshoot and tune environments
administering Vertica in virtualized and physical environments
designing Vertica to run a 24x7 enterprise multi-data center environment,
including installation, configuration, backup, recovery and node failures
experience, including shell scripting Proven ability to work in global
environments with counterparts in remote offices
multiple versions, upgrades and performance tuning
organization and communication skills
experience in shell scripts
3+ Experience in
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.
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
Support a 24x7 mission critical environment.