Senior Database Engineer (Remote)

In near real time, Cisco Meraki collects massive amounts of data from its devices all over the world. We write nearly 7 million data points each second globally every day. This data, helps power our Dashboard and gives our customers insight into the state of their networks. As a member of the Data Infrastructure team, you will coordinate, scale, secure, and maintain our on-prem relational and non-relational database systems. You will work with all Engineering teams throughout Cisco Meraki guiding them towards best practices to meet the data requirements for their use cases.

What you will do:

• Work alongside our SRE teams to plan, administer, maintain and secure our PostgreSQL infrastructure across our backend
• Perform operational DBA duties: installation, database upgrades, patching, implement backup/recovery and monitoring procedures, capacity planning, and site failover/switchover
• Ensure systems are running at the highest possible performance level by analyzing and tuning queries
• Guide engineers on performance tuning and optimization, query optimization, index tuning, caching, buffer tuning, etc.
• Review database changes requested by engineering teams for impacts to database designs, design standards, data conversions, naming standards, and documentation
• Learn about the data and it’s use to make recommendations for improvements in how it is stored and processed
• Work with Data Engineering team to design, build and maintain ETL pipelines for PG
• Develop procedures and scripts for data migration
• Automate schema management with tools like Liquibase, ActiveRecords, etc.
• Support architectural changes with new database environments in both public and private clouds

About you

• Deep knowledge and experience designing and maintaining PostgreSQL infrastructure On-prem and in cloud
• Experience building and maintaining sophisticated mission-critical production database systems
• Experience analyzing issues holistically, from the application tier through the database, down to the storage
• Proven track record of automating tasks
• Working knowledge of relational database internals (locking, consistency, serialization, recovery paths)
• Systems engineering experience, including Linux performance, memory management, I/O tuning, configuration, security, networking, etc.
• Working knowledge of at least one scripting language (shell, Python, Perl)

Nice to have

• Experience with NoSQL databases, memory stores e.g. Redis
• Experience migrating database from on-prem to cloud and vice versa
• Experience with Timeseries databases
• Experience with messaging queues

We encourage you to drop us a line even if you don’t have all the points above. That’s a lot of different areas of responsibility! We will help you pick them up because we believe that phenomenal engineers come from diverse backgrounds.