Payscale

Database Architect

Source: Lensa

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 Database Architect 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
  • 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
  • Experience with designing and implementing large scale database systems at enterprise and/or Internet scale
  • Own our data systems roadmap and collaborate with stakeholders from across the organization to set priorities driving toward implementation of the roadmap
  • 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 of MongoDB and prior use
  • Experience working in a microservice architecture with separate datasources per microservice
  • Experience configuration and administration 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
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.
  • Recruiter Screen
  • Hiring Manager Phone Interview
  • Phone interviews with the team, including technical assessment
  • 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.

2 days ago

Seattle, Wa

Payscale

Full Time

Apply at Uzoes
By registering, you are giving consent for uzoes to inform you of jobs by email according to your search. I declare that I have read and accept the Terms of Service , Privacy Policy and Cookies Policy of beBee Affinity Social Network SL

Related Jobs

  • https://dktn8eak9qti5.cloudfront.net/img/letters/P.png

    Database Architect

    Company Description As the industry leader in compensation data and technology, PayScale helps organizations #getpayright. PayScale is the only technology solution for managing

    Payscale - Seattle, Wa - Lensa

  • https://dktn8eak9qti5.cloudfront.net/img/letters/A.png

    Database Consultant

    Are you an experienced commercial or open source database platform specialist? Are you an Oracle or SQL Server Platform Specialist? Have you worked on Open source Database platforms like PostgreSQL, M

    Amazon Corporate LLC - Seattle, Wa - Lensa

  • https://dktn8eak9qti5.cloudfront.net/img/letters/W.png

    Database Developer

    At Wizards of the Coast, we connect people around the world through play and imagination. From our genre defining games like Magic: The Gathering® and Dungeons & Dragons® to our growing multiverse, we

    Wizards of the Coast - Renton, Wa - Lensa

  • https://dktn8eak9qti5.cloudfront.net/img/letters/S.png

    Senior Database Engineer - Database Automation/Database Developer-GovCloud

    To get the best candidate experience, please consider applying for a maximum of 3 roles within 12 months to ensure you are not duplicating efforts.Job CategoryProducts and TechnologyJob DetailsAre you

    SALESFORCECOM INC - Bellevue, Wa - Lensa