What are the responsibilities and job description for the Vertica DB Administrator & Developer :: W2_Contract_Remote position at Softcom Systems Inc?
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.