payscale - Senior Database Administrator
Upload My Resume
Drop here or click to browse · PDF, DOCX, DOC, RTF, TXT
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). • 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. • 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 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.
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). • On-call duty may be required, responding to critical DB alerts, and escalating if needed.
Benefits
• $139.8K – $174.7K • Offers Bonus • 10% CBP • In the spirit of pay transparency, we are excited to share the base salary range for all positions, exclusive of fringe benefits or potential bonuses. Depending on the position, there is eligibility for an annual corporate bonus percentage. 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 total rewards package. • Upload your resume here to autofill key application fields. • Drop your resume here! • Parsing your resume. Autofilling key fields... • Please note: Payscale's Talent Team set up limits on the number of times candidates can apply. The following limits apply to all roles at Payscale: • Candidates may not apply more than 3 times in 60 days to any job within a similar scope. • Candidates may not reapply to the same role within 90 days if not presented with an offer • Please enter your full legal name. • Please enter your preferred name. • Please enter your personal email address. • Please upload your document (preferably as a PDF file). • or drag and drop here • Please enter the link to your LinkedIn profile. • Please enter your personal phone number. • Please include your legal street address • City that you live in • State or province that you live in • Country that you live in • This includes OPT & H1B visas. • If yes, please enter their name. • Cover Letter, Portfolio, Projects, etc • Is there anything else you’d like us to know about you? • Asian or Asian American • Black or African American • Hispanic or Latine • Indigenous or Native American • Native Hawaiian or Other Pacific Islander • I prefer not to answer • Another Gender Identity • Heterosexual / straight • Person with disability • Refugee or immigrant • None of the above • Yes I am in active military • Yes I am a veteran • No I am neither in active military or a veteran • Payscale may use Artificial Intelligence with this application. Learn more.
Similar Jobs
No credit card. Takes 10 seconds.