Z

Zenni Optical

Online prescription eyeglasses retailer

Database Administrator

Database AdministrationConfirmed live in the last 24 hours
Full-timeNovato, CA, USA$77k - $121k

About the Job

Requirements

  • 3–5 years of experience in database administration, database operations, or a related IT role.
  • Hands-on experience administering at least one major relational database platform, such as Microsoft SQL Server, MySQL, or MariaDB.
  • Working knowledge of SQL, query analysis, indexing, execution plans, and database performance troubleshooting.
  • Experience with database backups, recovery procedures, replication, and production database maintenance.
  • Practical experience with Linux server administration and command-line troubleshooting on CentOS, Ubuntu, or other related Linux distributions.
  • Understanding of database security, user and permission management, encryption, and vulnerability remediation.
  • Experience using monitoring tools to track database availability, performance, and resource utilization.
  • Basic scripting experience with Bash, Python, PowerShell, PHP, or a similar language.
  • Strong troubleshooting, analytical, documentation, and communication skills.
  • Ability to manage assigned tasks independently, prioritize production issues, and collaborate effectively across technical teams.

Responsibilities

  • Install, configure, upgrade, and patch database software across on-premises and cloud environments while minimizing service interruptions.
  • Monitor database health, analyze slow queries and execution plans, identify resource bottlenecks, and implement performance improvements.
  • Configure, monitor, and troubleshoot database replication to maintain data consistency and support business continuity.
  • Maintain scheduled backups, validate backup integrity, and perform periodic recovery tests to ensure databases can be restored when needed.
  • Investigate and resolve database incidents, connectivity issues, performance degradation, and replication failures in a timely manner.
  • Monitor database growth, storage utilization, CPU, memory, and other resource metrics to identify potential capacity issues before they affect production services.
  • Perform routine Linux server administration, including system monitoring, patching, log analysis, disk management, and basic troubleshooting.
  • Create and manage database accounts, roles, and permissions in accordance with least-privilege principles.
  • Apply database and operating system security best practices, maintain secure configurations, and address identified vulnerabilities.
  • Perform database maintenance tasks, including index optimization, statistics updates, log management, and storage cleanup, as appropriate for each database platform.
  • Develop and maintain scripts using Bash, Python, or similar tools to automate repetitive database administration and maintenance tasks.
  • Configure and maintain monitoring for database availability, performance, replication status, backup completion, storage capacity, and critical service health using tools such as Zabbix.
  • Analyze monitoring data and recurring incidents to identify root causes and recommend corrective or preventive actions.
  • Identify opportunities to reduce manual work, improve consistency, and streamline routine database operations through automation.
  • Support the deployment, migration, monitoring, and maintenance of databases in cloud environments, particularly AWS and GCP.
  • Assist with managing cloud-native database services and database instances hosted on cloud virtual machines.
  • Collaborate with data engineering and analytics teams to troubleshoot database connectivity, access, performance, and data availability issues affecting Fivetran, Databricks, and related data workflows.
  • Work with application development and DevOps teams to support database schema changes, deployment activities, and version-controlled database updates.
  • Implement and maintain appropriate encryption, authentication, access controls, and secure database configurations.
  • Conduct periodic reviews of database accounts and privileges, remove unnecessary access, and investigate suspicious or unauthorized activity.
  • Track database and operating system vulnerabilities and coordinate timely remediation in accordance with company security requirements.
  • Follow established change-management procedures for database upgrades, configuration changes, maintenance, and production deployments.
  • Prepare and validate implementation steps, rollback procedures, and recovery plans before performing changes that could affect production systems.
  • Create and maintain database inventories, architecture diagrams, configuration records, standard operating procedures, troubleshooting guides, and recovery procedures.
  • Document recurring issues and resolutions to improve team knowledge and operational consistency.
  • Collaborate with infrastructure, security, application, development, and business teams to resolve database-related issues and support business requirements.
  • Contribute to database migrations, platform upgrades, infrastructure improvements, monitoring initiatives, and other IT projects.
  • Provide timely updates on incidents, maintenance activities, project progress, and identified risks.
  • Participate in an on-call rotation every other week to support onsite servers and provide ad hoc team support as needed.

Desired Qualifications

  • Experience managing and supporting databases in on-premises and cloud environments, particularly AWS or GCP.
  • Hands-on experience with database monitoring and alerting tools, such as Zabbix.
  • Familiarity with Pervasive PSQL, MySQL, or MariaDB database administration and maintenance.
  • Familiarity with CI/CD workflows, Git-based version control, and database schema migration practices.
  • Experience supporting data integration and analytics platforms, including Fivetran and Databricks.
  • Understanding of high availability, disaster recovery planning, backup strategies, recovery time objectives (RTO), and recovery point objectives (RPO).
  • Relevant certifications in database administration, cloud platforms, Linux system administration, or related technologies are a plus.
  • Java.

About the Company

Zenni Optical

Online prescription eyeglasses retailer

Zenni Optical sells prescription and protective eyewear online, offering a wide range of frames for men, women, and children to make eyewear affordable and accessible. Customers design their glasses by selecting frames and lens options, provide their prescription, and place orders online; the lenses are manufactured to fit the prescription and shipped to the customer. The company differentiates itself through its long-running direct-to-consumer model (since 2003), high volume and global reach, and partnerships with sports teams and public figures, which together help it offer low prices and a broad selection. Zenni’s goal is to help people See Better And Live Better by making quality eyewear affordable and easy to obtain for everyone.

Company size
201-500
Company stage
Not listed
Total funding
Not listed
Headquarters
Novato, CA
Founded
2003

Recently Posted Jobs

Explore more opportunities at Zenni Optical

See more jobs