Date Posted
Category
Salary
Job type
Work model
Level
Location
Unfortunately, this job posting is expired.
Company

PanoptoSee more

addressAddressSeattle, WA
type Form of workFull-Time
CategoryInformation Technology

Job description

Job Description

Panopto is looking for a Senior Database Architect to join our Data team. The team owns the database infrastructure that powers the Panopto system, which is used by the 10+ million end users of Panopto. We are looking for someone with excellent technical skills, great learning ability, and who goes the extra mile to deliver high quality work in a collaborative environment.

About the Role
Our Senior Database Architect role is a combination of DB Engineering and DBA.  As the Senior Database Architect, you will own the architecture and administration of the MS SQL Server databases that power all of Panopto’s experiences.  You will be responsible for the database modeling & design and collaborate closely with the engineering team to ensure development activities are aligned to the vision. You will also be responsible for maintaining the integrity, availability and performance of the company databases on a AWS-based platform to create a smooth operational customer experience for our clients.

About You
Below are some of the skills and experiences we think are important for this role:

Required technical skills:

  • Extensive hands-on experience with MS SQL Server and T-SQL is required
  • Hands-on expertise on database modeling and architecture at scale
  • Strong understanding of database infrastructure, maintenance, and administration preferably within an AWS-based platform
  • Ability to write SQL code, stored procs, triggers, views and identify, analyze and solve database and SQL code issues related to  performance issues, blocking, deadlocks, security, etc.
  • Preferred performance tuning expertise in a high-volume OLTP environment utilizing execution plans and various optimization techniques
  • Experience as DBA working on all aspects of database administration such as backups/restores,  SQL Server High Availability (HA) solutions (AGs, Window Server Failover Cluster, mirroring, log shipping), monitoring, alerts, security, permissions, patches, etc.
  • Strong troubleshooting skills are essential
  • Software & database debugging and diagnostic skills: SQL Server Profiler, instrumenting code with logging and metrics, reviewing logging and metrics to diagnose bugs and operational issues.
  • Support the Site Reliability Engineering team with troubleshooting, release deployments, and scheduled maintenance
  • Software engineering skills: well-defined normalized schema design, code reuse and refactoring, automated testing, debugging, and coding/designing for fault tolerance
  • Assists and mentors developers with T-SQL best practices and complex query tuning.
  • Ensure all T-SQL code meets Panopto’s defined coding standards.
  • Experience working on complex projects in a professional environment
  • The candidate’s attention to detail is critical.
  • Excellent written and verbal communication skills are required.

How you work / what motivates you:

  • Pride of craft in your work
  • Customer focus and a love for solving customer problems
  • Ability to rapidly prototype ideas and code for production
  • Effective communication and collaboration with others to build something with lasting impact.
  • A love for learning, near-insatiable technical curiosity, a desire to grow and to help improve the team around you.

Extra credit areas of knowledge:

  • Basic coding skills in C#, Powershell, and Python
  • Experience with Microsoft SSIS and SSRS
  • Experience with Microsoft Active Directory
  • Experience with AWS, including EC2 & Cloudwatch

Total Rewards
In the spirit of pay transparency, Panopto is excited to share the salary range for this position which is $145,000- $165,000 USD per year. This salary range may include multiple levels. Your level is based on our assessment of your interview performance, skills, experience, and/or location. Salary is just one component of Panopto’s total compensation package for employees. Your total rewards package at Panopto will include 100% employer-paid health benefits for you and your dependents, 401k match, unlimited PTO, and more. All employees participate in our annual bonus program. A full list of our total reward offerings can be found here. 

Panopto is committed to pay equity and transparency. We explicitly do not negotiate salary outside of the defined range to ensure that we aren’t introducing bias that could lead to pay inequities within the team between candidates who have different negotiation tactics.

About Panopto
We believe that video can have a transformative effect on learning. So we built a video platform that helps businesses and universities improve the way that they train, teach, and share knowledge. Since 2007, we have been a pioneer in video capture software, video management, and inside-video-search technology. Panopto has been adopted by more than 1,500 companies and universities worldwide with over ten million end users. Today, Panopto’s video management system is the largest repository of expert learning videos in the world. Headquartered in Seattle, with offices in Pittsburgh, London, Hong Kong, Singapore, and Sydney, Panopto has received industry recognition for its innovation, rapid growth, and company culture.

Panopto’s mission is to help anyone share knowledge using video. Our user base is as diverse as the world’s universities and businesses. To fulfill our mission with the best products and services, we eagerly seek individuals who bring diversity of background, experience, and thought to create an engaging work environment, foster innovation and better understand and meet the needs of our users. We encourage people from underrepresented and/or marginalized backgrounds, including BIPOC, LatinX, LGBTQ+, women, and people with disabilities, to apply.

Panopto is an Equal Opportunity Employer.

Panopto is committed to the full inclusion of all qualified individuals. If you require accommodation for interviewing or otherwise participating in the employee selection process, please provide more detail on how we can further support you utilizing this form.

Candidates looking for flexible or remote-friendly positions are encouraged to apply. Employees in this position are eligible to work remotely on a permanent basis, but have the option to work out of our Seattle or Pittsburgh office. Panopto's Seattle office is located in Smith Tower in the heart of the Pioneer Square neighborhood or at our Pittsburgh office which is on the north side of Pittsburgh along the Three Rivers Heritage Trail with quick access to downtown. 

Powered by JazzHR

Hq11MIkNsc

Refer code: 2328810. Panopto - The previous day - 2023-02-03 13:35

Panopto

Seattle, WA
Popular Senior Database Architect jobs in top cities
Jobs feed

Customer Service Representative

Upscale

Casselberry, FL

$600 - $900 a week

Human Resources Analyst

City Of Santa Fe

Santa Fe, NM

$23.75 - $35.62 an hour

Part Time Afternoon Receptionist

Coursey Blvd Animal Hospital

Baton Rouge, LA

$13 - $16 an hour

Kids Instructor

Life Time, Inc.

Oak Brook, IL

Hoffman Estates AP Computer Science Principles Tutor

Varsity Tutors

Evanston, IL

7am Hangers

Marshalls

Apopka, FL

Senior Human Resources Analyst

City Of Poway, Ca

Poway, CA

$84,943.25 - $103,247.46 a year

Accounting Clerk I

Marion County Sheriff's Office

Ocala, FL

Experienced Tax, Bookkeeeping & Payroll Professional

Kingdom Financial

Missouri, United States

$40,000 - $80,000 a year

Benefits Representative

Amba

Hammond, LA

From $100,000 a year

Share jobs with friends