Senior Database Engineer, Cisco Meraki

• 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)

Desirable

• 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
• 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