Senior Vertica DBA

Artech Information System LLC; Hanover Township (NJ); On-site; USD 100,000 - 130,000; Full time

Job summary

A staffing solutions firm in Hanover Township is looking for a Senior Vertica DBA with over 5 years of experience. The role involves supporting data center migrations and overseeing database environments. Candidates must have extensive experience with Vertica and RHEL, excellent troubleshooting skills, and ability to produce technical documentation. This position requires onsite work during normal business hours, with some evening or weekend hours for migration-related tasks.

Qualifications

• 5+ years of experience as a Vertica DBA.
• Experience in virtualized and physical environments.
• Ability to work in global environments with remote counterparts.

Responsibilities

• Install and configure Vertica in multiple node environments.
• Execute Vertica version upgrades.
• Monitor server and database process health.

Skills

Vertica administration

Performance tuning

Shell scripting

Linux/UNIX experience

Data center migration

Education

Bachelor's degree

Tools

RHEL 6.x

Vertica

Job description

At the forefront of the staffing industry, Artech is a minority and women-owned business enterprise (MWBE) committed to maximizing global workforce solutions on behalf of its clients. Artech's deep heritage, proven expertise and insightful market intelligence has secured long-term partnerships with Fortune 500 and government clients seeking world-class professional resources.

Job Description

Title: Senior Vertica DBA
Location: Rancho Cordova, CA
Duration: 6 months
Job Description:
Seeking a senior level Vertica DBA with 5+ years of experience to support the data center migration of four Vertica Clusters. Responsibilities include analysis of current environments, design for upgrade and migration, install, configure, administer, troubleshoot and tune environments running on RHEL 6.x. The candidate should have experience with multiple versions, upgrades and performance tuning. Candidate should possess excellent organization and communication skills and be able to own communications with multiple stakeholders including Product, IT and Data Center support staff. The candidate will be functioning as an individual contributor, as well as, produce various technical documents such as conversion procedures, backup and recovery instructions.

Primary Responsibilities:

• Install and configure Vertica in multiple 12+ node environments running on RHEL 6.x supporting 15 TB+ databases
• Execute Vertica version upgrades from 5 to 6
• Query and partition performance tuning
• Proactively monitor server and database process health to ensure availability and performance
• Create shell scripts
• Produce technical documentation, status reports and ensure issues are escalated in a timely manner
• Mentor and guide team members

Education: Bachelor degree

Qualifications

Experience:

• Proven experience administering Vertica in virtualized and physical environments running on RHEL 6.x across various storage solutions including SAN, internal drives and SSD storage.
• Proven experience designing Vertica to run a 24 x 7 enterprise multi-data center environment, including installation, configuration, backup, recovery and node failures.
• Proven experience planning and executing Vertica version upgrades.
• Proven experience with data center migrations.
• Proven Linux/UNIX experience, including shell scripting.
• Proven ability to work in global environments with counterparts in remote offices.
• Resourceful, responsible, flexible, able to work unsupervised and dedicated to quality of work.

Working Conditions:
Onsite during normal business hours in San Francisco or Sacramento.
Some evening or weekend work required during migration, migration testing or production down issues.

Additional Information

All your information will be kept confidential according to EEO guidelines.
If you believe you're qualified for this position and are currently in the job market or interested in making a change, please give me a call as soon as possible at [phone]