Vertica Database Administrator (DBA)

Apex Informatics, a leading technology consulting firm, is seeking a skilled and experienced Database Administrator (DBA) to join our team. As a Database Administrator at Apex Informatics, you will be responsible for the performance, integrity, and security of all databases in our organization.

The ideal candidate will have a solid understanding of database management systems, strong analytical skills, and the ability to troubleshoot and optimize database performance. You will work closely with software developers, data analysts, and system administrators to ensure that our databases are running smoothly and efficiently.

Responsibilities

• Design, implement, and maintain database systems in accordance with company standards and best practices
• Monitor database performance and identify opportunities for improvement
• Perform database upgrades and migrations
• Create and maintain database backups and disaster recovery plans
• Troubleshoot and resolve database issues and outages
• Collaborate with software developers to optimize database queries and performance
• Ensure data security and compliance with data protection regulations
• Develop and maintain database documentation, including data models and schema

Requirements

• Minimum 5+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud.
• Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon.
• Expertise in installing/upgrade and maintaining 50+ Vertica environments.
• 5+ year experience in Performance Tuning and Optimization in Vertica which includes projections, partitions
• Maintain Vertica databases and assist with regular OS patching.
• Troubleshoot and resolve Vertica issues for aggressive SLA needs in production environment.
• Maintain database services, database monitoring and performance tuning and resource management
• Enhance and add more tools for automation of manual tasks for DBA activities - bash and python
• Experience in working mission critical production environment.
• Experience in working with database backup and recovery, and resolving production database incidents.