What are the responsibilities and job description for the Development Database Administrator position at IMCS Group?
Role: Vertica DB Developer and Administrator
Duration: 6 - 12 months
Location: Bridgewater, NJ 08807
Skillset:
• Vertica Expertise
• Database Administration
• Security & Compliance
• ETL & Data Integration
• Scripting
• Cloud migration expertise
Job description:
• Design, develop, and maintain Vertica database solutions for high-performance analytics.
• Optimize Vertica database performance, including query tuning, resource management, and workload balancing.
• Implement and enforce security best practices, including user access control, encryption, and compliance with regulatory standards.
• Manage database backup, recovery, and disaster recovery strategies.
• Monitor and troubleshoot database issues, ensuring high availability and reliability.
• Collaborate with application teams to migrate existing applications to cloud environments (AWS, Azure, or GCP).
• Develop and maintain ETL processes for data ingestion and transformation.
• Perform capacity planning and scalability assessments for Vertica clusters.
• Document database architecture, configurations, and operational procedures.
• Stay updated on Vertica features, cloud technologies, and security compliance requirements.