Lead Database Engineer United States
Job title: Lead Database Engineer United States in Seattle, WA at Payscale
Company: Payscale
Job description: The Lead Database Engineer will work directly with Software Architecture, development, and product teams to design and implement product and process solutions and improve application performance and
stability.Role and Responsibilities:
Collaborate with stakeholders from across the organization to set priorities and drive toward implementation
Partner with our Architecture team in the design, build, and creation of our data platform
Ensure database systems meet all requirements of performance, availability, scalability, quality and security to produce world class products
Lead by example, delivering high-quality work products; champion quality standards, performance and scalability
Research new technologies and stay ahead of industry
Design and implement resilient and performant database processes and solutions
Develop custom stored procedures, views, or user-defined functions
Participate in database design and data access strategies
Collaborate with cross-functional teams
Debug and tune/optimize SQL code either directly or indirectly from application
Support Tier2 development team with database requests as needed (including bug fixes, production data manipulation and feature testing)
Coach, develop and mentor the database engineers in technical tools and techniques to maximize their individual contribution and professional growth to ensure they are successful
Debug and tune/optimize SQL code either directly or indirectly from application
On-call duty may be required, responding to critical DB alerts andescalate if needed
Requirements/Skills:
Experience with designing and implementing large-scale database systems at enterprise and/or Internet scale
Minimum of 10+ years of experience in administering and managing SQL Server.
Minimum of 3+ years of experience in SQL Server 2019 and above.
Minimum of 5+ years of experience in administering either MySQL, MariaDB or PostgreSQL.
Hands-on experience with SQL Server Always On, Failover Clustering, and Log Shipping. • Familiarity with PowerShell & python scripting and automation frameworks.
Ability to lead and influence others in a highly flexible and fast-moving environment
Intrinsic self-starter and problem solver
Good communication skills
Desire to work in a fast paced, evolving, growing, and dynamic environment
Experience with performance tuning and a broad knowledge base of indexing strategies, In-Memory OLTP technologies and best practice SQL standards
Ability to collaborate with SQL developers and solve problems
5+ years of developing and scaling MS SQL Server SaaS applications.
Solid understanding and experience with NoSQL dbs
Experience with administration and configuration of sharded, multi- tenant databases
Experience with Database Encryption Strategies (Encryption per Client, PIP encryption)
Experience with scaling databases on Cloud platforms (preferablyAzure)
Familiarity with one or more industry standard source control solutions (Git preferred - experience with DACPAC a plus)
Familiarity with monitoring tools like SolarWinds DPA or Datadog.
Agile experience
Bachelor’s in computer science, Engineering, Information Technology, other relevant degrees, or comparable work experience
Pluses:
Experience designing and building Distributed Database ecosystems
Solid understanding of Spark, Cassandra, Snowflake SSIS and SSRS
AWS/Azure/Azure SQL
Elasticsearch
Data visualization and analytic software tools such as Tableau
CompensationIn the spirit of pay transparency, we are excited to share the base salary range for this position is $158,400 - $237,600, exclusive of fringe benefits or potential bonuses. This position is also eligible for an annual corporate bonus of 12%. If you are hired at Payscale, your final base salary compensation will be determined based on factors such as skills, education, and/or experience. In addition to those factors – we believe in the importance of pay equity and consider any internal equity of our current team members as a part of any final offer. Please keep in mind that the range mentioned above is the full base salary range for the role. Hiring at the maximum of the range would not be typical in order to allow for future & continued salary growth. We also offer a generous compensation and benefits package (more information on benefits listed below).Company DescriptionPayscale gives employers and employees confidence to know the what and why behind pay. With our leading data, technology, and experience we make it easier for you to connect compensation to goals.As the industry leader in compensation management, Payscale is on a mission to help job seekers, employees, and businesses get pay right and to make sustainable fair pay a reality. Empowering more than 50 percent of the Fortune 500 in 198 countries, Payscale provides a combination of diverse and dynamic data sources, experienced compensation services, and scalable software to enable organizations such as Angel City Football Club, Target, United Healthcare, Gainsight, eBay, and The Washington Post to make fair and appropriate pay decisions. To learn more, visitLocationPayscale 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, and the UK, 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:
Respect every individual, work as a team
Be Customer first, customer centric
Have a Bias towards action
Commit to excellence (we give our best everyday)
Make Data driven decisions
An open and inclusive environment where you’ll learn and grow through programs and resources like:
Monthly company All Hands meetings
Regular opportunities for executive leadership exposure through things like AMAs
Access to continued learning & development opportunities
Our commitment to a continuous feedback culture which allows us to drive performance and career growth
A growing network of Employee Resource Groups
Company sponsored volunteer hours
And more!
Our more standard benefits
Flex Paid Time Off, giving you flexibility to rest, relax and recharge away from work
14 Paid Company Holidays, including 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 or non-birthing parents
Health Savings Account (HSA) options and company contribution 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
We know the and can get in the way of meeting spectacular candidates, so please don’t hesitate to apply — we’d love to hear from you.Equal 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.Fraud Alert:Payscale values security and privacy. During your job application and interview process, we will never ask for your personal banking or financial information, social security number, or other sensitive information, if you are unsure if a message is from Payscale, please email
Expected salary:
Location: Seattle, WA
Apply for the job now!
Apply Now
Company: Payscale
Job description: The Lead Database Engineer will work directly with Software Architecture, development, and product teams to design and implement product and process solutions and improve application performance and
stability.Role and Responsibilities:
Collaborate with stakeholders from across the organization to set priorities and drive toward implementation
Partner with our Architecture team in the design, build, and creation of our data platform
Ensure database systems meet all requirements of performance, availability, scalability, quality and security to produce world class products
Lead by example, delivering high-quality work products; champion quality standards, performance and scalability
Research new technologies and stay ahead of industry
Design and implement resilient and performant database processes and solutions
Develop custom stored procedures, views, or user-defined functions
Participate in database design and data access strategies
Collaborate with cross-functional teams
Debug and tune/optimize SQL code either directly or indirectly from application
Support Tier2 development team with database requests as needed (including bug fixes, production data manipulation and feature testing)
Coach, develop and mentor the database engineers in technical tools and techniques to maximize their individual contribution and professional growth to ensure they are successful
Debug and tune/optimize SQL code either directly or indirectly from application
On-call duty may be required, responding to critical DB alerts andescalate if needed
Requirements/Skills:
Experience with designing and implementing large-scale database systems at enterprise and/or Internet scale
Minimum of 10+ years of experience in administering and managing SQL Server.
Minimum of 3+ years of experience in SQL Server 2019 and above.
Minimum of 5+ years of experience in administering either MySQL, MariaDB or PostgreSQL.
Hands-on experience with SQL Server Always On, Failover Clustering, and Log Shipping. • Familiarity with PowerShell & python scripting and automation frameworks.
Ability to lead and influence others in a highly flexible and fast-moving environment
Intrinsic self-starter and problem solver
Good communication skills
Desire to work in a fast paced, evolving, growing, and dynamic environment
Experience with performance tuning and a broad knowledge base of indexing strategies, In-Memory OLTP technologies and best practice SQL standards
Ability to collaborate with SQL developers and solve problems
5+ years of developing and scaling MS SQL Server SaaS applications.
Solid understanding and experience with NoSQL dbs
Experience with administration and configuration of sharded, multi- tenant databases
Experience with Database Encryption Strategies (Encryption per Client, PIP encryption)
Experience with scaling databases on Cloud platforms (preferablyAzure)
Familiarity with one or more industry standard source control solutions (Git preferred - experience with DACPAC a plus)
Familiarity with monitoring tools like SolarWinds DPA or Datadog.
Agile experience
Bachelor’s in computer science, Engineering, Information Technology, other relevant degrees, or comparable work experience
Pluses:
Experience designing and building Distributed Database ecosystems
Solid understanding of Spark, Cassandra, Snowflake SSIS and SSRS
AWS/Azure/Azure SQL
Elasticsearch
Data visualization and analytic software tools such as Tableau
CompensationIn the spirit of pay transparency, we are excited to share the base salary range for this position is $158,400 - $237,600, exclusive of fringe benefits or potential bonuses. This position is also eligible for an annual corporate bonus of 12%. If you are hired at Payscale, your final base salary compensation will be determined based on factors such as skills, education, and/or experience. In addition to those factors – we believe in the importance of pay equity and consider any internal equity of our current team members as a part of any final offer. Please keep in mind that the range mentioned above is the full base salary range for the role. Hiring at the maximum of the range would not be typical in order to allow for future & continued salary growth. We also offer a generous compensation and benefits package (more information on benefits listed below).Company DescriptionPayscale gives employers and employees confidence to know the what and why behind pay. With our leading data, technology, and experience we make it easier for you to connect compensation to goals.As the industry leader in compensation management, Payscale is on a mission to help job seekers, employees, and businesses get pay right and to make sustainable fair pay a reality. Empowering more than 50 percent of the Fortune 500 in 198 countries, Payscale provides a combination of diverse and dynamic data sources, experienced compensation services, and scalable software to enable organizations such as Angel City Football Club, Target, United Healthcare, Gainsight, eBay, and The Washington Post to make fair and appropriate pay decisions. To learn more, visitLocationPayscale 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, and the UK, 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:
Respect every individual, work as a team
Be Customer first, customer centric
Have a Bias towards action
Commit to excellence (we give our best everyday)
Make Data driven decisions
An open and inclusive environment where you’ll learn and grow through programs and resources like:
Monthly company All Hands meetings
Regular opportunities for executive leadership exposure through things like AMAs
Access to continued learning & development opportunities
Our commitment to a continuous feedback culture which allows us to drive performance and career growth
A growing network of Employee Resource Groups
Company sponsored volunteer hours
And more!
Our more standard benefits
Flex Paid Time Off, giving you flexibility to rest, relax and recharge away from work
14 Paid Company Holidays, including 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 or non-birthing parents
Health Savings Account (HSA) options and company contribution 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
We know the and can get in the way of meeting spectacular candidates, so please don’t hesitate to apply — we’d love to hear from you.Equal 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.Fraud Alert:Payscale values security and privacy. During your job application and interview process, we will never ask for your personal banking or financial information, social security number, or other sensitive information, if you are unsure if a message is from Payscale, please email
Expected salary:
Location: Seattle, WA
Apply for the job now!
Apply Now