Database Administrator

The role

The Database Administrator maintains, secures, monitors and optimizes production databases across on-premises and cloud environments. The role supports business applications, reporting and operational workflows, and works closely with infrastructure, development, DevOps and data analytics teams.

What you will do

• Install, configure, upgrade and patch database software across on-premises and cloud environments
• Monitor database health, analyze slow queries and tune performance
• Configure, monitor and troubleshoot database replication
• Maintain scheduled backups, validate integrity and run periodic recovery tests
• Investigate and resolve database incidents and production issues
• Plan capacity by monitoring growth, storage and resource use
• Perform Linux server administration, patching and troubleshooting
• Manage database accounts, roles and permissions using least-privilege principles
• Develop Bash, Python or similar scripts to automate routine tasks
• Maintain monitoring and alerting, including with Zabbix

Required qualifications

• 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: Microsoft SQL Server, MySQL or MariaDB
• Working knowledge of SQL, query analysis, indexing, execution plans and performance troubleshooting
• Experience with backups, recovery procedures, replication and production database maintenance
• Practical Linux server administration and command-line troubleshooting on CentOS, Ubuntu or similar
• Understanding of database security, user and permission management, encryption and vulnerability remediation
• Experience using monitoring tools to track availability, performance and resource use
• Basic scripting experience with Bash, Python, PowerShell, PHP or a similar language
• Strong troubleshooting, analytical, documentation and communication skills
• Ability to manage tasks independently, prioritize production issues and collaborate across technical teams

Nice to have

• Experience managing databases in on-prem 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 administration
• Familiarity with CI/CD workflows, Git-based version control and schema migration practices
• Experience supporting data integration and analytics platforms, including Fivetran and Databricks
• Understanding of high availability, disaster recovery, backup strategies, RTO and RPO
• Relevant certifications in database administration, cloud platforms or Linux administration
• Java

Benefits

• Annual bonus program
• 100% premiums covered for employee medical, dental and vision (50% for dependents)
• Basic Life and AD&D with option for additional voluntary coverage
• Short and long term disability coverage
• 401k with up to 4% match
• EAP and Spring Health with free therapy and coaching for you and dependents
• Free access to digital wellness platform Wellness Coach for you and family
• Flex Time Off plus Week of Zen between Christmas and New Year's
• Fully paid parental leave of 16 weeks for birthing and non-birthing parents
• Family forming and fertility support through Maven
• Annual Zenni gift card to use toward products

Before you apply

• Zenni uses AI tools to assist recruiting, but every hiring decision is made by a member of the team

About the company

Zenni Optical is an online eyewear retailer founded in 2003 and based in the San Francisco Bay Area, selling prescription glasses, sunglasses and protective eyewear. The company says it has sold more than 70 million frames globally.