Senior Developer - Data Systems

Location: Seattle, WA
Type: Full Time
Department: Software Engineering
Status: Open
Required Experience: Experienced

Job Description

At Panopto we have created a one-of-a-kind platform that makes video searchable, and enables anyone to share their expert knowledge with video.  As a Senior Developer, you will play a pivotal role in extending our products and services to reach new markets and new customers. You will own major portions of Panopto’s data layer, which is a critical resource in every facility of Panopto’s services.  You will be responsible for designing, implementing, and sustaining the core SQL-based data storage layer of the Panopto software platform. You will have a major role in the planning and execution of Panopto’s development roadmap especially with regard to scalability of our cloud-hosted systems and implementation of new core functionality.

Responsibilities, both individual and as part of the team include:

Team participation:

  • Work closely with your fellow Data Team developers and collaborate with developers from all other teams to implement complex cross-team optimizations and new features.
  • With other engineers, help design, spec, plan, and execute Panopto’s technology roadmap. Produce high-quality software components using software engineering best practices.  Deliver ship-quality code, scripts, and components on schedule.
  • Assist other engineers with ramp-up on Panopto technologies, help with design reviews and other quality control practices, and work towards expanding the capabilities of the engineering team as a whole.  Drive implementation of SQL-specific best practices across the dev team. Function as a mentor for others on the team.
  • Communicate clearly and concisely with the dev team and executive stakeholders. Make strong, thoughtful cases for major changes when required, handle pushback gracefully but don’t give up (unless specifically asked by your management team to ‘disagree and commit’).
  • When appropriate, engage directly with the support team or customers to solve SQL issues in customer-deployed environments or to write one-off SQL queries to solve specific customer problems.
  • Participate positively in the development of Panopto’s vision, culture, and image.

Data layer conversion to SQL stored procedures:

  • Work closely with the rest of the data team to deeply understand the product scenarios and the C# code that sits within the data layer, but above the database.  Collaborate to solve problems that cross the SQL<->application code layers.
  • Take the lead role in converting our existing Linq-to-SQL C# code to SQL stored procedures.  Help prioritize the order in which we do this conversion to optimize for both system performance, team efficiency, and bang-for-the-buck.  Use great care in defining the C# code-level interfaces in front of your stored procedures to capture the required nuance of the existing code and encode that into the API.
  • Build new data layer interfaces to enable new functionality, reaching from the lowest levels of database schema design and optimization, all the way up to the web API layer.
  • Ensure the SQL code you write is unit tested, working with members of our QA and Dev-Infrastructure team to build the missing pieces in our tool chain that make auto-testing of SQL difficult today.

Database operations:

  • As a member of the Data Team, share ownership of the performance, scalability, monitoring and operations of our SQL Servers. Ensure our SQL Servers are configured and maintained according to best practices.  Work with the rest of the Data Team to improve our metrics & monitoring for SQL Server health. Ensure we stay ahead of the scale wave by identify looming problems with enough time to react.
  • Pitch in and wear the ‘DBA Hat’, when required, to offload work from Adam and Chris and to help cover when they are unavailable.  Pull diagnostic information out of SQL to understand when and where problems exist. Build reports and dashboards to aid in diagnosis.  Consult with Chris and other data team members to publish metrics to our ops dashboards to help catch operational problems before they become customer-visible.

About You

You have a strong track record designing and shipping customer-facing software services. Your technical designs and code performs well, is maintainable over the long run, and has proven easy for other developers to use.

  • You excel at written and verbal communication.
  • You have a history of working closely with developers and engineering leaders to deliver complex multi-stage projects.
  • You naturally take ownership when you encounter a problem.
  • You thrive in an environment with ambiguity - asking the right questions to bring order out of chaos and spread that order to your peers.
  • You aren’t afraid to think big when establishing vision, but you know how to develop a plan in steps that delivers incremental value without boiling the ocean.
  • You are highly motivated to move quickly, but you insist on high standards and delivering great results. You are thoughtfully and positively critical of your own work and your team’s work, always looking for ways to improve.
  • You have a 4-year degree in computer science or a related field and 5+ years of industry experience.

About Us

At 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 our founding in 2007, we’ve been a pioneer in video capture software, video content management systems, and inside-video search technology. We’ve been recognized by Deloitte as one of the fastest growing technology companies in North America, and by Gartner as a Leader in video content management. Today, more than 5 million end users depend on our software, and we have over 100 employees spread across our offices in Seattle, Pittsburgh, London, Hong Kong, Beijing, and Sydney.

If you are interested in working with other down-to-earth, smart people who love to roll up their sleeves and get stuff done in the face of big, exciting challenges, then we want to talk.

We expect a lot and so should you:

  • Opportunity to learn and stretch your capabilities
  • Market-competitive total compensation
  • Employee stock options
  • Employer-paid health benefits
  • Paid time-off and holidays
  • An award-winning work environment

Application

* Required fields
First name*
Last name*
Email address*
Location
Phone number*
Resume*

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file

How did you hear about this job?*
Are you authorized to work lawfully in the United States for Panopto?*
Will you now or in the future require visa sponsorship for employment
at Panopto?*
The following questions are entirely optional.
To comply with government Equal Employment Opportunity / Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race/Ethnicity

Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status
I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE
I AM NOT A PROTECTED VETERAN
I DON’T WISH TO ANSWER

Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 1/31/2020
Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities.i To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • HIV/AIDS
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Please check one of the boxes below:

YES, I HAVE A DISABILITY (or previously had a disability)
NO, I DON’T HAVE A DISABILITY
I DON’T WISH TO ANSWER

Your Name Today's Date
Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.


iSection 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.


PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Human Check*