Back to jobs
New

Database Administrator (Obetz, OH)

Obetz, OH

Who We Are

Zenni Optical, the world's leading online eyewear retailer, pioneered the industry in 2003 with a mission to make prescription eyewear affordable and accessible to everyone. Based in the San Francisco Bay Area, Zenni offers adults and children the freedom to express their personal style through high-quality prescription and protective eyewear curated with a sense for fashion and an incredible selection. With over 55 million frames sold worldwide, the company has brought massive price disruption to the traditional retail model. 

Zenni is proud to be the Official Eyewear of the San Francisco 49ers, the Boston Celtics, Chicago Bulls, USA Volleyball, Columbus Crew, Ghost Gaming, TSM and more. Zenni has worked with designers and tastemakers on curations and collections, including Keke Palmer, Iris Apfel, Chase Stokes and George and Claire Kittle. 

With our recent EyeQLenz and VR Prescription Lenses for Meta Quest 3, we continue to innovate and serve our mission to help the world see better and live better.

Check out our Press Room for more information.

Candidate safety is important to us. Please note that all official communication will only be sent from @zennioptical.com addresses.

Position Overview

The Database Administrator (DBA) role at Zennioptical will be pivotal in managing, optimizing, and securing enterprise data across on-premise and cloud environments. Bring innovation into our data management practices; this role requires a strong focus on automation, DevOps integration, and adherence to contemporary IT security standards.

Primary Responsibilities

  • Database Management & Performance Optimization
    • Installation & Upgrades: Install, configure, and upgrade database servers and applications on-premise and in the cloud.
    • Replication and Data Consistency:  Maintain and manage database replication to ensure data consistency across systems
    • Performance Tuning: Monitor and optimize database performance using modern analytics and automated tuning tools to enhance efficiency.
    • Backup & Recovery: Develop and execute robust backup and disaster recovery procedures and policies.
  • System Administration & Maintenance
    • Setup & Configuration: Install and configure Linux OS and services
    • User & Access Management: Create and manage users, groups, and permissions.  
    • Monitoring & Maintenance: Monitor system performance and logs. 
    • Automation: Automate tasks using cron jobs and shell scripts
  • Cloud & Hybrid Environment Expertise
    • Cloud Integration: Migrate, integrate, and manage cloud-based databases across platforms such as AWS, Azure, and Google Cloud.
    • Scalability & High Availability: Design and implement solutions that ensure scalability and high availability (HA) with automated failover and load balancing.
  • Automation & DevOps Collaboration
    • CI/CD Pipelines: Collaborate with development teams to integrate database changes into CI/CD pipelines.
    • Infrastructure as Code: Utilize automated tools (e.g., Terraform, Ansible) to manage database infrastructure.
    • Monitoring & Analytics: Implement proactive monitoring tools for automated issue detection and resolution.
  • Security & Compliance
    • Data Security: Enforce best practices in data encryption, access controls, and compliance with regulatory standards (e.g., GDPR, HIPAA).
    • Vulnerability Management: Conduct regular security audits and implement vulnerability management protocols.
    • Change Management: Ensure that all database changes maintain proper version control and undergo a thorough risk assessment.
  • Data Integration & Management
    • Data Governance: Collaborate with cross-functional teams to establish and maintain data governance and quality standards.
    • Big Data & Analytics: Engage with data analysts and engineers to support analytical environments, including NoSQL and distributed systems.
  • Documentation & Collaboration
    • Policy Documentation: Maintain comprehensive documentation for configuration, processes, and disaster recovery protocols.
    • Stakeholder Communication: Serve as the primary point of contact for database-related issues and collaborate closely with IT, developers, and business users.

Basic Qualification

Educational Background:

  • Bachelor’s degree in Computer Science, Information Technology, or equivalent job experience.

Experience:

  • 5+ years of experience in a DBA role in a dynamic, modern data environment.

  • Proven expertise with relational databases (e.g., PostgreSQL, MySQL, SQL Server) and NoSQL databases (e.g., MongoDB, Cassandra).

  • 3+ years of Linux system administration experience (Ubuntu, CentOS, RHEL).

  • Strong programming skills with a focus on PHP, Python, or Perl for backend development and automation.

Technical Skills:

  • Proficiency in cloud database platforms such as AWS RDS, Azure SQL, and Google Cloud SQL.

  • Experience with automation and orchestration tools (e.g., Terraform, Ansible, Jenkins).

  • Expertise in performance database tuning, replication, and disaster recovery.

  • Proficiency in both relational and sequential database systems, with hands-on experience in at least one: MySQL, PostgreSQL, or Microsoft SQL Server; familiarity with SQLite or Berkeley DB.

  • Demonstrated experience managing a complete LAMP stack.

  • Proficiency in T-SQL stored procedures, complex queries, and scripting in PHP, PowerShell, or Perl.

  • Hands-on experience with installation, configuration, patching, database upgrade/migration, including high availability (HA) and disaster recovery (DR) implementations.

Security & Compliance Knowledge:

  • Deep understanding of security best practices, encryption and hashing methodologies, and regulatory compliance frameworks.

Soft Skills:

  • Strong analytical and problem-solving abilities.

  • Excellent communication and collaboration skills.

  • Adaptability to rapidly evolving technologies and environments

Preferred Qualifications

  • Knowledge of SSRS, SSIS, and SSAS.

  • Certifications such as AWS Certified Database – Specialty, Microsoft Certified: Azure Database Administrator Associate, or similar.

Benefits

  • Employee Paid - Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401K & matching)
  • Life Insurance (Basic, Voluntary & AD&D)
  • Paid Time Off (Vacation, Public Holidays)
  • Training & Development
  • Dental insurance
  • Employee assistance program
  • Flexible spending account
  • Health savings account
  • Vision insurance
  • Free Lunch Daily
  • Referral program

In addition to other forms of compensation like perks and benefits, the estimated range for this role is $86,600 - 108,500 USD. The final offer will be determined based on permissible, non-discriminatory factors such as skill set, experience, geographical location, market conditions, and other organizational needs. The Company reserves the right to change, modify, or revisit the salary range for various reasons including business needs

As a condition of employment for this role, you will be required to undergo pre-employment drug testing in accordance with our company policies and applicable law.

We look forward to hearing from you!

We strive to build a diverse team of individuals with a broad range of experience and perspectives. We encourage you to apply even if you don’t feel you meet all the qualifications.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Zenni Optical’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.