Skip to main content
Payscale

Senior Database Engineer

RemoteUnited States only
Published
Role
Data Engineering
Experience
Senior
Employment
Full-time
$139.8k–$174.7k/yr
Check eligibility

Open to US only. Set where you work from to check your eligibility.

No BS summary

Senior Database Engineer II with 7+ years hands-on PostgreSQL administration, advanced MariaDB, and Pgpool-II. Must handle replication, performance tuning, and automation. US-based remote role.

Core skills

PostgreSQLMariaDBPgpool-II

Required skills

SQLGitshell scripts

Optional skills

SQL ServerNoSQLApache KafkaAzureAWSElasticsearchTableauDACPAC

What you'll do

  • 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).
  • Debug and tune/optimize SQL code either directly or indirectly from the application.
  • On-call duty may be required, responding to critical DB alerts, and escalating if needed.

What they require

  • Minimum of 7+ years of hands-on experience administering PostgreSQL databases.
  • Advanced experience with MariaDB administration and optimization.
  • Extensive knowledge of Pgpool-II for query load balancing, failover management, and connection routing between primary and standby nodes.
  • Hands-on experience with PostgreSQL replication, performance tuning, and maintenance operations.
  • Develop and maintain operational runbooks for PostgreSQL replication setup, failover recovery, and pooler troubleshooting.
  • Automate database deployment and maintenance tasks using shell scripts and infrastructure automation tools.
  • Experience with performance tuning and a broad knowledge base of indexing strategies, In-Memory OLTP technologies, and best practice SQL standards.
  • Hands-on experience building processes for OLTP and OLAP processing.
  • Support and encourage data engineering practices supporting a multi-source data ecosystem.
  • 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).
  • Intrinsic self-starter and problem solver.
  • Agile experience.

Benefits

  • Flexible paid time off
  • 14 Paid Company Holidays, includes 2 floating holidays
  • 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

American compensation software and data company

Compensation IntelligenceEnterprisepayscale.com
$139.8k–$174.7k/yr