Senior Database Administrator

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.

Requirements

• Minimum of 7+ years of experience in administering MySQL, MariaDB, and PostgreSQL.
• Support and encourage data engineering practices supporting a multi-source data ecosystem.
• Extensive knowledge of Pgpool-II for query load balancing, failover management, and connection routing between primary and standby nodes.
• Automate database deployment and maintenance tasks using shell scripts and infrastructure automation tools.
• Develop operational runbooks for replication setup, failover recovery and pooler troubleshooting.
• Intrinsic self-starter and problem solver.
• Experience with performance tuning and a broad knowledge base of indexing strategies, In-Memory OLTP technologies, and best practice SQL standards.
• Hands on experience with replication, performance tuning and maintenance plans.
• Hands on experience building processes for OLTP and OLAP processing.
• 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).
• Agile experience.
• Excellent communication skills.
• Desire to work in a fast paced, evolving, growing, and dynamic environment.
• Curiosity to explore innovative ideas and passion to make them happen.
• Bachelors in computer science, Engineering, Information Technology, other relevant degree, or comparable work experience
• Experience with designing and implementing large scale database systems at enterprise and/or Internet scale.
• Experience designing and building Distributed Database ecosystems.
• Understanding of data analytics and reporting solution concepts and strategies.
• Experience with SQL Server 2012 and above.
• Experience with PostgreSQL v9 and above.
• Understanding and experience with NoSQL databases.
• Understanding of 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 with scaling databases on Cloud platforms (preferably Azure).
• AWS/Azure/Azure SQL.
• Elasticsearch.
• Data visualization and analytic software tools such as Tableau.
• Location
• Payscale 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

Benefits

Additional Information

About Payscale Payscale is the original compensation innovator for organizations who want to scale their business with pay and transform their largest investment into their greatest advantage. With decades of innovation in sourcing reputable data and developing AI-powered tools, Payscale delivers actionable insights that turn pay from a cost to a catalyst. Its suite of solutions - Payfactors, Marketpay, and Paycycle - empower top companies in the U.S. and businesses like Cintas, Leidos, Chipotle, Brookdale Senior Living, Ohio State University, American Airlines, and TJX Companies. Create confidence in your compensation. Payscale. To learn more, visit www.payscale.com . Job Summary The Senior Database Engineer 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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at payscale? Share your experience