Database Administrator

Zenni Optical

Novato (CA)

Hybrid

USD 120,000 - 160,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Hybrid work arrangement

Job summary

Zenni Optical is seeking a Database Administrator to maintain, secure, monitor, and optimize production databases across on-premises and cloud environments. The role covers performance tuning, replication, backups, and Linux systems management, with hybrid in-office and remote work options depending on location.

The DBA will support cloud services (AWS, GCP), data pipelines, and DevOps collaboration, ensuring data integrity and availability for critical business applications.

Qualifications

  • Experience administering production databases across on-premises and cloud.
  • Ability to monitor performance and tune queries and execution plans.
  • Experience with Linux server administration and security hardening.
  • Proficient scripting for automation (Bash, Python).
  • Familiarity with cloud services (AWS, GCP) and data pipelines.
  • Strong incident response and change management.

Responsibilities

  • Administer databases and optimize performance.
  • Install, configure, upgrade, and patch DB software across on-premises and cloud environments.
  • Configure replication and high availability.
  • Maintain backups and perform recovery testing.
  • Provide production support for incidents.
  • Monitor capacity and resource usage.
  • Perform Linux system administration.
  • Manage database access and security.
  • Automate tasks and monitor with alerts.
  • Support cloud databases and data pipelines.

Skills

Database Administration
Performance Tuning
Linux Administration
Cloud Databases
Automation & Scripting
Monitoring & Alerts
Security Hardening
Backup & Recovery
DevOps Collaboration
Incident Response

Education

Bachelor's in CS or related field
DBA Certification

Tools

Zabbix
AWS
GCP
Databricks
Fivetran

Job description

Who We Are

Zenni pioneered the online eyewear industry in 2003 with a mission to make eyewear affordable and accessible for everyone. With complete prescription pairs starting under $10, Zenni offers adults and children the freedom to see clearly and express themselves through a wide selection of high-quality prescription glasses, sunglasses, protective eyewear, and non-prescription frames - curated with fashion, function, and style in mind.

Who We Are

Zenni pioneered the online eyewear industry in 2003 with a mission to make eyewear affordable and accessible for everyone. With complete prescription pairs starting under $10, Zenni offers adults and children the freedom to see clearly and express themselves through a wide selection of high-quality prescription glasses, sunglasses, protective eyewear, and non-prescription frames - curated with fashion, function, and style in mind.

Based in the San Francisco Bay Area, Zenni has redefined the traditional retail model, emerging as the premier destination for online eyewear in the United States while surpassing 70 million frames sold globally.

Zenni is proud to be the Official Eyewear of the San Francisco 49ers, Columbus Crew, Monster Jam, WWE, Team Liquid, and more. Zenni has collaborated with designers and tastemakers on exclusive collections, including Chase Stokes and George and Claire Kittle. For more information, visit zenni.com.

Position Overview

The Database Administrator (DBA) at Zenni Optical is responsible for maintaining, securing, monitoring, and optimizing the company's databases across on-premises and cloud environments. This role ensures the availability, performance, integrity, and security of production databases that support critical business applications, reporting, and operational workflows.

This position is an onsite role and you must be located either in the California Bay Area or the greater Columbus Ohio area.
Onsite Schedule if located in the following:
  • Hybrid (Novato, CA): 2 days in office (Monday and Wednesday), 3 days remote
  • Hybrid (Obetz, Ohio): 4 days in office, 1 day remote
On-Call Responsibilities
  • On-call rotation every other week, supporting onsite servers
  • Ad-hoc support for the team as needed
Key Responsibilities
  • Database Administration and Performance Optimization
  • Database Installation and Maintenance: Install, configure, upgrade, and patch database software across on-premises and cloud environments while minimizing service interruptions.
  • Performance Monitoring and Tuning: Monitor database health, analyze slow queries and execution plans, identify resource bottlenecks, and implement performance improvements.
  • Replication and High Availability: Configure, monitor, and troubleshoot database replication to maintain data consistency and support business continuity.
  • Backup and Recovery: Maintain scheduled backups, validate backup integrity, and perform periodic recovery tests to ensure databases can be restored when needed.
  • Production Support: Investigate and resolve database incidents, connectivity issues, performance degradation, and replication failures in a timely manner.
  • Capacity Planning: Monitor database growth, storage utilization, CPU, memory, and other resource metrics to identify potential capacity issues before they affect production services.
  • Database and Linux System Administration
  • Linux Administration: Perform routine Linux server administration, including system monitoring, patching, log analysis, disk management, and basic troubleshooting.
  • Database Access Management: Create and manage database accounts, roles, and permissions in accordance with least-privilege principles.
  • Security Hardening: Apply database and operating system security best practices, maintain secure configurations, and address identified vulnerabilities.
  • Routine Maintenance: Perform database maintenance tasks, including index optimization, statistics updates, log management, and storage cleanup, as appropriate for each database platform.
  • Automation and Operational Monitoring
  • Task Automation: Develop and maintain scripts using Bash, Python, or similar tools to automate repetitive database administration and maintenance tasks.
  • Monitoring and Alerting: Configure and maintain monitoring for database availability, performance, replication status, backup completion, storage capacity, and critical service health using tools such as Zabbix.
  • Incident Prevention: Analyze monitoring data and recurring incidents to identify root causes and recommend corrective or preventive actions.
  • Operational Efficiency: Identify opportunities to reduce manual work, improve consistency, and streamline routine database operations through automation.
  • Cloud Database and DevOps Support
  • Cloud Database Operations: Support the deployment, migration, monitoring, and maintenance of databases in cloud environments, particularly AWS and GCP.
  • Cloud Database Services: Assist with managing cloud-native database services and database instances hosted on cloud virtual machines.
  • Data Pipeline Support: Collaborate with data engineering and analytics teams to troubleshoot database connectivity, access, performance, and data availability issues affecting Fivetran, Databricks, and related data workflows.
  • Development and Deployment Support: Work with application development and DevOps teams to support database schema changes, deployment activities, and version-controlled database updates.
  • Database Security and Change Management
  • Data Protection: Implement and maintain appropriate encryption, authentication, access controls, and secure database configurations.
  • Access Reviews: Conduct periodic reviews of database accounts and privileges, remove unnecessary access, and investigate suspicious or unauthorized activity.
  • Patch and Vulnerability Management: Track database and operating system vulnerabilities and coordinate timely remediation in accordance with company security requirements.
  • Change Control: Follow established change-management procedures for database upgrades, configuration changes, maintenance, and production deployments.
  • Risk Mitigation: Prepare and validate implementation steps, rollback procedures, and recovery plans before performing changes that could affect production systems.
  • Documentation and Cross-Functional Collaboration
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator
Database Administrator

Zenni Optical • Obetz (OH)

On-site
USD 110,000 - 150,000
Database Administrator
Database Administrator

zennioptical • Novato (CA)

Hybrid
USD 120,000 - 170,000
Onsite Database Administrator: Cloud, Security & Automation
Onsite Database Administrator: Cloud, Security & Automation

Zenni Optical • Obetz (OH)

On-site
USD 110,000 - 150,000
Hybrid Cloud & On-Prem Database Administrator
Hybrid Cloud & On-Prem Database Administrator

zennioptical • Novato (CA)

Hybrid
USD 120,000 - 170,000
Logistics Associate II
Logistics Associate II

Zenni Optical • Novato (CA)

On-site
USD 28,000 - 36,000
Annual Bonus Program
Healthcare premiums paid
401k matching
+2
Database Administrator (DBA)
Database Administrator (DBA)

TechDigital Group • Phoenix (AZ)

On-site
USD 85,000 - 115,000
Database Administrator
Database Administrator

Revel IT • Columbus (OH)

Hybrid
USD 85,000 - 110,000
Database Operations Manager
Database Operations Manager

Crane Worldwide Logistics • Houston (TX)

On-site
USD 120,000 - 180,000
Database Administrator
Database Administrator

Diverse Lynx, LLC • Phoenix (AZ)

On-site
USD 90,000 - 120,000
Enterprise Technology Database Administrator
Enterprise Technology Database Administrator

NEPHRON SC, LLC • West Columbia (SC)

On-site
USD 90,000 - 120,000