Senior Database Engineer

About this role

For more than 20 years, Payscale has combined trusted market data with AI-powered technology to deliver actionable insights that turn pay from a cost into a catalyst for growth. The Payscale Intelligence Cloud portfolio of solutions — Ascent, JobNav, and Paycycle — empower top companies and businesses like Cintas, Leidos, Chipotle, Ohio State University, and TJX Companies.Create confidence in your compensation. Payscale.To learn more, visit www.payscale.com.Job SummaryThe 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.What You'll DoCollaborate 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 We're Looking ForMinimum 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 HaveExperience 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.LocationPayscale has an employee centric remote-first model that provides you the flexibility to do your best work in a space that supports you, while also finding time to collaborate in person for the moments that matter. In our remote-first model, employees can work from the location that works best for them. We do not have centralized corporate offices. Employees can choose to work from home, in company-paid co-working spaces, or any combination of the two that best suits their unique needs.If you work from home, we recommend ensuring that you can meet the following technology, equipment and workspace requirements:High-Speed Internet - A stable broadband or fiber connection (satellite is highly discouraged) with a minimum speed of 100 Mbps in a dedicated workspace that has a reliable Wi-Fi signal.Device for Multifactor Authentication (MFA/2FA) - smartphone, tablet, etc.When it matters (usually no more than a few times a year) we take the time to gather for in-person events.Payscale has employees across the US, Canada, UK, The Philippines and Romania however we are currently unable to hire in the Quebec Province, Northern Ireland, and Hawaii.Benefits and PerksAll around awesome culture where together we strive to live our 5 values:Data informed decision making.Customer first. Always.Succeed together.Relentless about results. Obsessed with excellence.Lead the change. Shape the standard.An open and inclusive environment where you’ll learn and grow through programs and resources like:Monthly company All Hands meetingsRegular opportunities for executive leadership exposure through things like AMAsAccess to continued learning & development opportunitiesOur commitment to a continuous feedback culture which allows us to drive performance and career growthA growing network of Employee Resource GroupsCompany sponsored volunteer hoursAnd more!Our more standard benefitsFlexible paid time off, giving you the opportunity to rest, relax and recharge away from work14 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 PayscaleUnlimited infertility coverage benefits through our medical plansAdditional supplemental health benefits offered to you and your family401(k) retirement program with a fully vested immediate company match16 weeks of paid parental leave for birthing and non-birthing parentsHealth Savings Account (HSA) options and company contributions each pay periodFlexible Spending Account (FSA) options for pre-tax employee allocationsAnnual remote work stipend to be used on wellness or home office equipmentEqual Opportunity Employer:We embrace equal employment opportunity. Payscale is committed to a policy of equal employment opportunity for all applicants and employees. It is our policy that employees will not be subjected to unlawful discrimination on the basis of race, color, religion, sex, age, national origin, or ancestry, physical or mental disability, veteran or military status, marital status, sexual orientation, political ideology, and any other basis protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including but not limited to: recruitment, hiring, transfers, promotions, training, discipline, termination, compensation and benefits, performance appraisals, education, and social and recreational programs.We know the confidence gap and imposter syndrome can get in the way of meeting spectacular candidates, so please don’t hesitate to apply — we’d love to hear from you.If you have a disability or impairment and need assistance with the application process, please email recruiting@payscale.com for support.Fraud Alert:Payscale values security and privacy.

What this role is, and what else it is called

Employers in the UK advertise this kind of work as Database Administrator, Database Developer, Senior Database Administrator and Database Engineer too, so it is worth searching more than one wording. It is a senior Database Administration role in the UK, advertised as fully remote, so it is open to candidates working from home.

About hiring at Payscale

Payscale has 3 other live technology roles on its careers page, across Database Administration, Software Engineering and Technology Product & Delivery. Of those, 50% are advertised as fully remote and 50% as hybrid. Elsewhere in its adverts Payscale asks for JavaScript, TypeScript, Scrum, C# and Angular. See all Payscale roles, salaries and stack.

How this role compares to the market

1,453 live UK roles list AWS right now, from 502 employers. The median advertised salary is £80,000; 28% are advertised as remote. Browse AWS roles.

1,143 live UK roles list Azure right now, from 445 employers. The median advertised salary is £55,000; 28% are advertised as remote. Browse Azure roles.

Senior roles make up 1,626 of the live UK IT market and advertise a median of £80,000.

Market figures are today's snapshot of live UK roles on employer careers pages; see hiring trends.

Technologies mentioned

Detected on Payscale's careers page. ProdReady Recruitment lists this vacancy as an aggregator and is not the employer; applications go to the employer's own site.