Lead Database Engineer
Company Description
As the industry leader in compensation data and technology, PayScale helps organizations #getpayright. PayScale is the only technology solution for managing compensation that provides multiple streams of fresh, transparently curated and validated salary data. Combined with modeling engines that learn continuously and generate recommendations and insight, PayScale empowers HR to price jobs and adjust compensation to reflect real-time changes in the market — all on one trusted data platform. With PayScale’s Adaptive Compensation Advantage, teams operate with efficiency, focused on outcomes rather than manual data management. To learn how companies like The Washington Post, Perry Ellis International, United Healthcare and The New York Times rely on PayScale to attract and retain top talent, motivate and engage employees and plan their future workforce, visit payscale.com.
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 the 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 in order 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 and escalate if needed
Qualifications
Requirements/Skills:
- Experience with designing and implementing large scale database systems at enterprise and/or Internet scale
- Support and encourage data engineering practices supporting a multi-source data ecosystem
- Solid understanding of data analytics and reporting solution concepts and strategies
- 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
- Curiosity to explore new ideas and passion to make them happen
- 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
- Ability to collaborate with SQL developers and solve problems
- 5+ years of developing and scaling MS SQL Server SaaS applications.
- Experience with SQL Server 2012 and above
- Experience with PostgreSQL v9 and above
- Solid understanding and experience with NoSQL dbs
- Experience working in a microservice architecture with separate datasources per microservice
- Solid understanding of Event Streaming Platforms such as Apache Kafka
- Experience with design and administration of data pipelines involving multiple data storage technologies (Relational DBs, NoSQL DBs, Data warehouses, Data Lakes, Event Streaming Platforms)
- 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 (preferably Azure)
- Familiarity with one or more industry standard source control solutions (Git preferred - experience with DACPAC a plus)
- Agile experience
- Boston or Seattle area based - No sponsorship or relocation available at this time
- Bachelors in Computer Science, Engineering, Information Technology, other relevant degree, or comparable work experience
Pluses:
- Experience designing and building Distributed Database ecosystems
- Solid understanding of Spark, Cassandra, Snowflake
- SSAS a strong plus
- SSIS and SSRS
- AWS/Azure/Azure SQL
- Elasticsearch
- Data visualization and analytic software tools such as Tableau
- Ability to develop/debug C# .Net code
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
Additional Information
Hiring Process: “Change is the only constant in life (and Payscale)” – Heraclitus (okay, so we paraphrased a bit). The hiring process outlined below is a rough overview, and is subject to change based on business priority, interviewer availability, etc.
1. Recruiter Screen
2. Hiring Manager Phone Interview
3. Phone interviews with the team, including technical assessment
4. Hiring decision
Benefits & Perks – The Highlights:
All around awesome culture where together we strive to:
- Pursue excellence every day
Create customer value
Compete to win (and lose!) as a team
As part of our culture of transparency and commitment to employee engagement, we have several programs and resources such as:
Regular virtual company meetings
Coffee chats
Table for 4 Executive conversation
Spirit Week
Pulsing tools for continuous conversations to drive performance and career growth
Strengths based tools designed to help employees engage with peers and managers, supported through a program called StandOut
Access to top notch learning courses for all employees through LinkedIn Learning
As well as constant re-evaluation of what our employees need to be successful at work!
Our more standard benefits include:
Flexible Paid Time Off program – most employees average around 3 weeks per year
14 paid holidays including Independence Week, Juneteenth and World Mental Health Day
3 comprehensive health plans to fit your unique needs; plans have up to 100% company-paid premium coverage for employee Medical, Dental and Vision
Access to Premera’s Healthcare Services including an Employee Assistance Program (EAP), 24-hour Nurse Hotline, Telehealth (Doctor on Demand), Talkspace, and other virtual care options
Flexible Spending Account (FSA) options for pre-tax employee allocations towards: Medical, Dependent Care, Parking, and Transit
Company Paid Short Term Disability, Long Term Disability, and Life Insurance
Comprehensive Paid Parental / Adoption Leave program
401k program with fully vested, immediate company match
PayScale provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. PayScale complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.