Tag: database

Company: Cisco Systems

Location: Toronto, ON

Expected salary: $115900 – 160400 per year

Job date: Thu, 23 Jan 2025 23:51:18 GMT

Job description: Please apply here to be considered for the role:Applications are accepted until further noticeAt Cisco Meraki, we know that technology can connect, empower, and drive us. Our mission is to simplify technology so our customers can focus on what’s most important to them: their students, patients, customers, and businesses. We’re making networking easier, faster, and intelligent with technology that simply works.The modern world runs on the internet, and the internet cannot exist without its underlying infrastructure. Meraki makes setting up, leading, and maintaining that infrastructure easier than it has ever been before. Meraki enables connectivity everywhere from neighborhood cafes to education institutions to global hospitality groups operating thousands of sites!About the roleIn 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 .Life at Cisco MerakiWe are passionate about building real products that . We are confident you will love it here.As a Cisco Meraki employee you can expect:

• An encouraging and lively environment and a team that values your contributions. The Backend Group is called the Exploding Whales. Interested to learn why? Just message us.
• A lot of opportunities for professional and personal growth via employee-led groups. Check out one of our groups – Women of Meraki on

and . * Actionable and candid feedback on a periodic basis following
. * Delicious catered meals every day and fully-stocked kitchens and all you can eat snacks.

• Paid time off to volunteer, and much more.

Cisco is an Affirmative Action and Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, national origin, genetic information, age, disability, veteran status, or any other legally protected basis. Cisco will consider for employment, on a case by case basis, qualified applicants with arrest and conviction records.At Cisco Meraki, we’re challenging the status quo with the power of diversity, inclusion, and collaboration. When we connect different perspectives, we can imagine new possibilities, encourage innovation, and release the full potential of our people. We’re building an employee experience that includes appreciation, belonging, growth, and purpose for everyone.Please apply here to be considered for the role:Message to applicants applying to work in the U.S. and/or Canada:When available, the salary range posted for this position reflects the projected hiring range for new hire, full-time salaries in U.S. and/or Canada locations, not including equity or benefits. For non-sales roles the hiring ranges reflect base salary only; employees are also eligible to receive annual bonuses. Hiring ranges for sales positions include base and incentive compensation target. Individual pay is determined by the candidate’s hiring location and additional factors, including but not limited to skillset, experience, and relevant education, certifications, or training. Applicants may not be eligible for the full salary range based on their U.S. or Canada hiring location. The recruiter can share more details about compensation for the role in your location during the hiring process.U.S. employees have to quality medical, dental and vision insurance, a 401(k) plan with a Cisco matching contribution, short and long-term disability coverage, basic life insurance and numerous wellbeing offerings.Employees receive up to twelve paid holidays per calendar year, which includes one floating holiday (for non-exempt employees), plus a day off for their birthday. Non-Exempt new hires accrue up to 16 days of vacation time off each year, at a rate of 4.92 hours per pay period. Exempt new hires participate in Cisco’s flexible Vacation Time Off policy, which does not place a defined limit on how much vacation time eligible employees may use, but is subject to availability and some business limitations. All new hires are eligible for Sick Time Off subject to Cisco’s Sick Time Off Policy and will have eighty (80) hours of sick time off provided on their hire date and on January 1st of each year thereafter. Up to 80 hours of unused sick time will be carried forward from one calendar year to the next such that the maximum number of sick time hours an employee may have available is 160 hours. Employees in Illinois have a unique time off program designed specifically with local requirements in mind. All employees also have access to paid time away to deal with critical or emergency issues. We offer additional paid time to volunteer and give back to the community.Employees on sales plans earn performance-based incentive pay on top of their base salary, which is split between quota and non-quota components. For quota-based incentive pay, Cisco typically pays as follows:.75% of incentive target for each 1% of revenue attainment up to 50% of quota;1.5% of incentive target for each 1% of attainment between 50% and 75%;1% of incentive target for each 1% of attainment between 75% and 100%; and once performance exceeds 100% attainment, incentive rates are at or above 1% for each 1% of attainment with no cap on incentive compensation.For non-quota-based sales performance elements such as strategic sales objectives, Cisco may pay up to 125% of target. Cisco sales plans do not have a minimum threshold of performance for sales incentive compensation to be paid.