Database Administrator
Zennioptical · Novato, California, United States
About this role
**Database Administrator (DBA) — Zenni Optical** **Who We Are** Zenni pioneered the online eyewear industry in 2003 with a mission to make eyewear affordable and accessible. Based in the San Francisco Bay Area, Zenni offers prescription glasses, sunglasses, protective eyewear, and non-prescription frames—curated with fashion, function, and style in mind. **Position Overview** The Database Administrator (DBA) is responsible for maintaining, securing, monitoring, and optimizing Zenni’s databases across on-premises and cloud environments. This role ensures the availability, performance, integrity, and security of production databases supporting critical business applications, reporting, and operational workflows. **Onsite Schedule** - **Hybrid (Novato, CA):** 2 days in office (Monday & Wednesday), 3 days remote **On-Call Responsibilities** - On-call rotation every other week, supporting onsite servers - Ad-hoc support for the team as needed --- ## Key Responsibilities **1) Database Administration & Performance Optimization** - Install, configure, upgrade, and patch database software (on-prem & cloud) - Monitor database health; analyze slow queries and execution plans; tune performance - Configure and troubleshoot replication and high availability - Maintain scheduled backups; validate backup integrity; perform recovery tests - Investigate and resolve production incidents (connectivity, performance, replication) - Perform capacity planning (growth, storage, CPU/memory, resource metrics) **2) Database & Linux System Administration** - Perform Linux server administration (monitoring, patching, log analysis, disk management) - Manage database access (accounts, roles, permissions) using least-privilege - Apply security hardening for database and OS configurations - Perform routine maintenance (index optimization, statistics updates, log/storage cleanup) **3) Automation & Operational Monitoring** - Automate repetitive tasks using **Bash**, **Python**, or similar tools - Configure monitoring/alerting (e.g., **Zabbix**) for availability, performance, replication, backups, storage, and service health - Analyze monitoring data to prevent recurring incidents - Improve operational efficiency by reducing manual work **4) Cloud Database & DevOps Support** - Support database deployment, migration, monitoring, and maintenance in **AWS** and **GCP** - Assist with cloud-native database services and instances on cloud VMs - Collaborate with data engineering/analytics to troubleshoot connectivity, access, performance, and data availability (e.g., **Fivetran**, **Databricks**) - Support schema changes, deployments, and version-controlled database updates **5) Database Security & Change Management** - Implement encryption, authentication, access controls, and secure configurations - Conduct access reviews; remove unnecessary access; investigate suspicious activity - Track vulnerabilities and coordinate timely remediation - Follow change-management procedures for upgrades/config changes/maintenance - Prepare rollback and recovery steps before production-impacting changes **6) Documentation & Cross-Functional Collaboration** - Maintain database inventories, architecture diagrams, SOPs, troubleshooting and recovery guides - Document recurring issues and resolutions - Collaborate with infrastructure, security, application, development, and business teams - Participate in migrations, platform upgrades, monitoring initiatives, and IT projects - Provide tim
Listing freshness
CronJobs last confirmed this listing 4h ago. If its source stops confirming the opening for seven days, this page is removed from active inventory.