Vertica Database Administrator

6 days ago

New York, New York, United States Tekgence Inc Full time
Job Summary

We are seeking a highly skilled Vertica L3 Database Administrator to join our team at Tekgence Inc. The ideal candidate will be responsible for the advanced management, optimization, and support of Vertica databases in a production environment.

Key Responsibilities
  • Database Management: Administer, configure, and manage Vertica databases in multi-node cluster environments, ensuring high availability and optimal performance.
  • Performance Tuning: Monitor and optimize database performance through advanced tuning techniques, including query optimization, resource management, and workload balancing.
  • Backup and Recovery: Implement and maintain robust backup and disaster recovery solutions to ensure data integrity and system availability.
  • Security Management: Manage database security, including user roles, permissions, encryption, and adherence to compliance requirements.
  • Incident and Problem Management: Provide advanced troubleshooting and root cause analysis for critical production issues, ensuring minimal downtime and quick recovery.
  • Capacity Planning: Analyze system growth trends and plan for future capacity needs, including storage, memory, and compute resources.
  • Automation: Develop and maintain automation scripts to streamline routine database administration tasks such as monitoring, backups, and maintenance.
  • Cluster Management: Manage Vertica database clusters, including node additions, removals, and configuration tuning for large-scale deployments.
  • Consultation: Collaborate with developers, architects, and other IT teams to design scalable and efficient database solutions.
  • Documentation: Maintain detailed documentation on database architecture, configurations, operational procedures, and incident reports.
Required Qualifications
  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 5+ years of relevant experience managing Vertica databases in a production environment.
  • Extensive experience with Vertica architecture, including K-safety, projections, partitions, and resource pools.
  • Expertise in performance tuning, query optimization, and workload balancing for Vertica.
  • Strong knowledge of backup and recovery strategies, including snapshot-based backups and DR.
  • Hands-on experience with Linux systems administration as it relates to Vertica environments.
  • Proficiency in writing SQL and Python/Shell scripts for database automation and monitoring.
  • Familiarity with monitoring tools such as Vertica Management Console and third-party solutions.
Preferred Skills
  • Excellent problem-solving and analytical skills for resolving complex database issues.
  • Ability to work under pressure and manage multiple high-priority tasks.
  • Strong collaboration and communication skills for cross-functional teamwork.
  • Experience with cloud deployments (AWS, GCP, or Azure) for Vertica clusters.
Certifications

Vertica Certified Professional or similar Vertica-related certifications are highly preferred.

  • Database Administrator

    1 month ago

    New York, New York, United States Michael Page Full time

    Full time opportunity offering competitive base and discretionary bonus.Join an established law firm About Our Client The client is an established law firm. Job DescriptionInstall and upgrade database servers and application tools, and plan system storage requirements.Enroll users, maintain system security, and control user access to the database.Monitor and...

  • SQL Database Administrator

    3 days ago

    New York, New York, United States CGS Full time

    About the RoleWe are seeking a highly skilled SQL Database Administrator to join our team at CGS. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key ResponsibilitiesDesign and implement database systems to meet business...

  • Senior Oracle Database Administrator

    3 days ago

    New York, New York, United States Donnelly & Moore Corporation Full time

    Job Description**Job Title:** Senior Oracle Database Administrator**Company:** Donnelly & Moore Corporation**Job Type:** Contract**Duration:** 12+ monthsWe are seeking a highly experienced Senior Oracle Database Administrator to join our team in Downtown NYC. As a Senior Oracle DBA, you will be responsible for administering and maintaining our Oracle...

  • Oracle Database Administrator

    3 months ago

    New York, New York, United States TEKsystems Full time

    ***6 month+ contract******W2***Must be fully covid vaccinated, even for remote rolesDescription:Our healthcare client is looking for a Sr. Oracle DBA on a 6 month contract for a migration to Exadata (OCI). The primary responsibility of the Oracle DBA will be to plan, design, and execute complex database migrations from one environment to another, such as...

  • System Database Administrator-Oracle DB

    3 months ago

    New York, New York, United States Atechstar Full time

    JOB DESCRIPTIONYour Role and ResponsibilitiesAdminister maintain tune and troubleshoot Oracle databases to provide high availability and reliability to the databases and applications running on them. Administer databases running on RAC in Exadata environments. Work with application teams product teams and onshore DBA team to design provision maintain and...

  • Azure Database Architect

    5 days ago

    New York, New York, United States Apexon Full time

    About the RoleWe are seeking a highly skilled Azure Database Administrator to join our team at Apexon. As a key member of our database team, you will be responsible for designing, implementing, and maintaining scalable and secure database solutions on Azure.Key ResponsibilitiesDesign and implement database architectures on Azure SQL Database, Cosmos DB, and...

  • Lead Database Architect

    2 days ago

    New York, New York, United States Diligent Tec, Inc Full time

    Job Title: Lead DBA (IBM DB2)Location: HybridType: Contract to HireKey Skills:We are seeking an experienced DB2 LUW Subject Matter Expert to join our IT department at Diligent Tec, Inc. The ideal candidate will be responsible for the design, implementation, and maintenance of DB2 LUW database systems on Linux, Unix, and Windows...

  • AWS Cloud Database Architect

    2 days ago

    New York, New York, United States HireTalent Full time

    Job DescriptionJob Title: AWS Cloud Database AdministratorJob Summary:HireTalent is seeking a highly skilled AWS Cloud Database Administrator to join our team. As a key member of our IT department, you will be responsible for delivering high-quality database administration services to our App/Dev Teams.Key Responsibilities:Provision, configure, maintain, and...

  • Yardi Database Administrator/HelpDesk Specialist

    1 day ago

    New York, New York, United States Douglas Elliman Property Management Full time

    Job Summary:We are seeking a highly skilled Yardi Database Administrator/Helpdesk Coordinator to ensure the seamless operation of our Yardi system and provide exceptional technical support to our users. This role involves managing user settings, security permissions, and menu sets, as well as troubleshooting technical issues and coordinating training...

  • Metrics and Analytics Specialist

    1 week ago

    New York, New York, United States THE BANK OF NEW YORK MELLON CORPORATION Full time

    Position: Specialist, Metrics and AnalyticsCompany: The Bank of New York MellonLocation: New York, NYOverview: The Bank of New York Mellon is on the lookout for a Specialist in Metrics and Analytics to establish, develop, and sustain a comprehensive set of performance indicators while analyzing business intelligence data to guide strategic business and...

  • Metrics and Analytics Specialist

    1 week ago

    New York, New York, United States THE BANK OF NEW YORK MELLON CORPORATION Full time

    Position: Specialist, Metrics and AnalyticsCompany: The Bank of New York MellonLocation: New York, NYOverview: The Bank of New York Mellon is on the lookout for a Specialist in Metrics and Analytics to establish, develop, and sustain a comprehensive set of performance indicators while analyzing business intelligence data to guide strategic business and...

  • Metrics and Analytics Specialist

    2 weeks ago

    New York, New York, United States THE BANK OF NEW YORK MELLON CORPORATION Full time

    Position: Specialist, Metrics and AnalyticsCompany: The Bank of New York MellonLocation: New York, NYOverview: The Bank of New York Mellon is on the lookout for a Specialist in Metrics and Analytics to establish, develop, and uphold a significant array of metrics while analyzing business intelligence data to guide strategic business and product decisions....

  • Administrative Coordinator

    1 week ago

    New York, New York, United States Hunter College Full time

    Job Title: Administrative Coordinator**Job Summary:**We are seeking an experienced Administrative Coordinator to join our team at Hunter College. The successful candidate will provide administrative support to the Director of Athletics and Recreation and the overall athletic department.Key Responsibilities:Provide administrative support to the Director of...

  • Administrative Coordinator

    1 week ago

    New York, New York, United States Blade Tech Tools Full time

    Job SummaryBlade Tech Tools is seeking a highly organized and detail-oriented Administrative Coordinator to provide exceptional support to our senior management team. As an Administrative Coordinator, you will be responsible for coordinating daily calendars, planning appointments and events, and acting as the point of contact between executives and...

  • Administrative Coordinator

    1 week ago

    New York, New York, United States Blade Tech Tools Full time

    Job SummaryBlade Tech Tools is seeking a highly organized and detail-oriented Administrative Coordinator to provide exceptional support to our senior management team. As an Executive Support Specialist, you will be responsible for coordinating daily calendars, planning appointments and events, and acting as the primary point of contact between executives and...

  • Tessitura Systems Administrator

    1 week ago

    New York, New York, United States Intrepid Museum Full time

    Job OverviewThe Intrepid Museum, a distinguished private non-profit institution, plays a vital role in the cultural fabric of New York City. Established in 1982 with the acquisition of the historic WWII aircraft carrier Intrepid, a National Historic Landmark, the Museum attracts over one million visitors each year from across the globe. Its mission is to...

  • Tessitura Systems Administrator

    1 week ago

    New York, New York, United States Intrepid Museum Full time

    Job OverviewThe Intrepid Museum, a distinguished non-profit institution, plays a vital role in the cultural fabric of New York City. Established in 1982 with the acquisition of the historic WWII aircraft carrier Intrepid, a National Historic Landmark, the Museum attracts over one million visitors each year from across the globe. Its mission is to enhance...

  • Administrative Coordinator

    3 days ago

    New York, New York, United States Sanctuary For Families Full time

    Job SummaryThe Administrative Associate plays a vital role in supporting the Anti-Trafficking Initiative (ATI) at Sanctuary for Families. This position is responsible for providing programmatic support, ensuring compliance, and collecting and analyzing data to drive informed decision-making.Key ResponsibilitiesAdministrative Support: Provide administrative...

  • Tessitura Systems Administrator

    2 weeks ago

    New York, New York, United States Intrepid Museum Full time

    Job OverviewThe Intrepid Museum, a distinguished non-profit institution, plays a vital role in the cultural fabric of New York City. Established in 1982 with the acquisition of the iconic WWII aircraft carrier Intrepid—a National Historic Landmark and the centerpiece of its collection—the Museum attracts over one million visitors each year from around...

  • Administrative Coordinator

    2 weeks ago

    New York, New York, United States CCM Wellness center Full time

    CCM Wellness Center is seeking a dedicated administrative coordinator to provide essential support to our leadership team. You will be responsible for managing various business-related tasks, including preparing reports, organizing travel arrangements, and documenting meeting minutes, along with other organizational responsibilities. To excel in this role,...