Senior Database Engineer

Posted 28ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior Database Engineer working with database and software architecture teams at Payscale. Designing and implementing resilient database solutions while collaborating with cross-functional stakeholders.

Responsibilities:

  • Collaborate with stakeholders from across the organization to set priorities and drive toward implementation
  • Ensure database systems meet all requirements of performance, availability, scalability, quality, and security to produce world class products
  • Delivering high-quality work-products; champion quality standards, performance, and scalability
  • Research innovative technologies and stay ahead of the industry
  • Design and implement resilient and performant database processes and solutions
  • Develop custom stored procedures, views, or user-defined functions
  • Collaborate with cross-functional teams
  • Debug and tune/optimize SQL code either directly or indirectly from the application
  • Support Tier2 development team with database requests as needed (including bug fixes, production data manipulation and feature testing)
  • On-call duty may be required, responding to critical DB alerts, and escalating if needed

Requirements:

  • Minimum of 7+ years of experience in administering MySQL, MariaDB, and PostgreSQL
  • Support and encourage data engineering practices supporting a multi-source data ecosystem
  • Extensive knowledge of Pgpool-II for query load balancing, failover management, and connection routing between primary and standby nodes
  • Automate database deployment and maintenance tasks using shell scripts and infrastructure automation tools
  • Develop operational runbooks for replication setup, failover recovery and pooler troubleshooting
  • Intrinsic self-starter and problem solver
  • Experience with performance tuning and a broad knowledge base of indexing strategies, In-Memory OLTP technologies, and best practice SQL standards
  • Hands on experience with replication, performance tuning and maintenance plans
  • Hands on experience building processes for OLTP and OLAP processing
  • Ability to collaborate with SQL developers and solve problems
  • Experience working in a microservice architecture with separate data sources per microservice
  • Familiarity with one or more industry standard source control solutions (Git preferred - experience with DACPAC a plus)
  • Agile experience
  • Excellent communication skills
  • Desire to work in a fast paced, evolving, growing, and dynamic environment
  • Bachelors in computer science, Engineering, Information Technology, other relevant degree, or comparable work experience

Benefits:

  • Flexible paid time off, giving you the opportunity to rest, relax and recharge away from work
  • 14 Paid Company Holidays, includes 2 floating holidays (you choose!)
  • A comprehensive benefits plan including medical, dental, life, vision, disability, and life insurance covered up to 100% by Payscale
  • Unlimited infertility coverage benefits through our medical plans
  • Additional supplemental health benefits offered to you and your family
  • 401(k) retirement program with a fully vested immediate company match
  • 16 weeks of paid parental leave for birthing and non-birthing parents
  • Health Savings Account (HSA) options and company contributions each pay period
  • Flexible Spending Account (FSA) options for pre-tax employee allocations
  • Annual remote work stipend to be used on wellness or home office equipment