Senior Database Engineer

Payscale•,

3d•$139,800 - $174,700•Remote

About The Position

The Senior Database Engineer II will work directly with the database, software architecture, development, and product teams to design and implement product, process solutions, and improve application performance and stability. This role reports to our Manager, Database Engineering.

Requirements

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.

Nice To Haves

Experience with designing and implementing large scale database systems at enterprise and/or Internet scale.
Experience designing and building Distributed Database ecosystems.
Understanding data analytics and reporting solution concepts and strategies.
Experience with SQL Server 2012 and above.
PostgreSQL v9 and above (advanced versions).
Understanding and experience with NoSQL databases.
Understanding Event Streaming Platforms such as Apache Kafka.
Experience with administration and configuration of sharded, multi-tenant databases.
Experience with Database Encryption Strategies (Encryption per Client, PIP encryption).
Experience scaling databases on Cloud platforms (preferably Azure).
AWS/Azure/Azure SQL.
Elasticsearch.
Data visualization and analytic software tools such as Tableau.

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).
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.

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