Talent.com
Database Performance Consultant - PostgreSQL

Database Performance Consultant - PostgreSQL

PerconaDurham, North Carolina
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Who is Percona?Percona is a respected thought leader in the open source community. We provide services and software for MySQL, MongoDB, PostgreSQL and Maria DB to open source users globally.Percona is remote-first and globally dispersed; we have 320 people in almost 50 countries. We offer a collaborative, highly-engaged culture where your ideas are welcome and your voice is heard. The growth and development of our staff is a top priority; we provide funding for training, certifications, conferences and more. Discover what it means to work with some of the smartest people in the industry, who also know how to have fun and are always willing to lend a helping hand. We offer flexible hours, the ability to work remotely and the amazing experience of working with a multinational team of experts.The Percona Support Team…Percona Support is a global, elite team of engineers who love getting to the bottom of weird and interesting database behaviour. We understand our customers’ business needs and the nuances of their technical environments. This allows us to help our customers see the big picture and identify opportunities to improve their overall database infrastructures. What you’ll be doing…You’ll be teaming with some of the most well-known database experts in the industry who are even better teammates, friends and mentors. You’ll have the opportunity to develop your own skills and become more powerful than you can possibly imagine…. with databases.This is not a boring, entry-level role where you’ll just be triaging the boring and monotonous.Your main responsibility will be helping our customers’ DBA teams when they need expert assistance. You’ll do that by gathering relevant data and investigating issues to provide a detailed analysis of your findings in a digestible format by email, instant message or voice. For more serious and production-impacting issues, you’ll perform screen-sharing sessions to help them quickly navigate and resolve issues.When you’re not fixing things, you’ll be authoring new blog posts on interesting topics for our open-source community to digest, answering questions on our forum, creating new articles in our customer-facing knowledge base for more frequently seen issues, and hosting webinars amongst other things.This is a remote role, so you can be located anywhere in the world. All you need is a decent, stable internet connection.

You’ll stand out if you have the following :

  • Good hands-on knowledge of PostgreSQL, PostgreSQL Provided tools and Contribution modules
  • Be a skilled with some of the PostgreSQL ecosystem of tools and technologies
  • Knowledgeable about performance tuning, query optimization, & index tuning
  • Know-how of backup solutions such as pg base backup, pgBackRest and WAL-G, etc, and also the Point-in-Time-Recovery
  • Some experience with high availability solutions (replication, routers, proxies, etc)
  • Exposure and practice with zero-downtime procedures
  • Good understanding of monitoring requirements
  • Demonstrable experience of administering Linux based systems
  • Ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues
  • Self-taught and enthused to grow your skill set with new technologies as the industry continues to evolve
  • Availability to travel for the occasional team meeting, conference or customer visit
  • Experience working with customers in English
  • Very desirable to have related Kubernetes knowledge

What Will Make you Stand Out :

  • MySQL knowledge
  • Experience working in SLA-bound operations
  • OpenSource Community contributions (could be a blog)
  • Good practice with working over screen-sharing / phone
  • Patroni / Repmgr / Stolon
  • Cloud Services such as AWS and RDS, Azure, GCP
  • Percona Monitoring & Management (PMM) and other monitoring tools
  • Configuration management solutions such as Ansible, Puppet or Chef
  • Good grasp of ANSI SQL 92 to 2016 and ability to write / rewrite SQL statements involving Window functions and recursive CTEs
  • Indexing methods including Full-Text Indexing
  • Contrib Modules of PostgreSQL
  • Most popular extensions - pg_repack, pg_partman, pg_audit etc
  • Foreign Data Wrappers of PostgreSQL (postgres_fdw, oracle_fdw, tde_fdw, file_fdw etc)
  • Advanced Linux troubleshooting tools (gdb, perf, strace, bpftrace, tcpdump, etc)
  • Experience programming in C
  • Percona is a respected thought leader in the open-source community. We provide services and software for MySQL, MongoDB, PostgreSQL and MariaDB to open-source users globally. Percona is remote-first and globally dispersed; we have colleagues in more than 50 countries. We offer a collaborative, highly-engaged culture where your ideas are welcome and your voice is heard. The growth and development of our staff is a top priority; we provide funding for training, certifications, conferences and more. Discover what it means to work with some of the smartest people in the industry, who also know how to have fun and are always willing to lend a helping hand. We offer flexible hours, the ability to work remotely and the amazing experience of working with a multinational team of experts. Percona's Lifestyle :

  • Enjoy the freedom to work remotely from anywhere in the world!
  • With top talent sourced globally, you will enjoy an international and culturally diverse team
  • Flexibility in your working hours means you can prioritize your personal life, pursue hobbies, volunteer, and stay active
  • Our internal programs include groups like :
  • The Percona Adventure Team : This team embarks on unforgettable journeys to breathtaking locations around the world for activities such as mountain climbing, hiking, white water rafting and more.
  • Women Transforming Technology is a grassroots program committed to building a supportive community of women in technology. Their goals are to connect, empower and inspire women in all areas and levels of the organization.
  • Flow days : Fridays at Percona are for focusing on finding your workflow. Meetings and distractions are limited on Fridays so you can focus on getting things done.
  • FryDays :    With Percona being so globally dispersed there are not many holidays that overlap for everyone. FryDays are four Fridays each year where everyone at Percona can unplug and enjoy the same 3-day weekend.Percona is remote-only and globally dispersed – we have colleagues in more than 50 countries! We offer a collaborative, highly-engaged culture where your ideas are welcome and your voice is heard.Our staff receives generous benefits including flexible work hours and paid time off, all your equipment for your remote office, funds for career development (external training, certifications, conferences) and the opportunity to participate in an equity incentive plan.Connect with us and stay up to date on our latest news and developments by following us on LinkedIn and Twitter. We look forward to connecting with you!Location : Remote, work-from-home position anywhere. 5-day work week including weekendParticipation with the on-call team schedule. You will need to be able to travel to company events, conferences, etc. as safety permits.
  • serp_jobs.job_alerts.create_a_job

    Database Performance • Durham, North Carolina

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Cloud Solutions Architect - Alliances

    Cloud Solutions Architect - Alliances

    CanonicalRaleigh, NC, United States
    serp_jobs.job_card.full_time
    Cloud Solutions Architect - Alliances.Be among the first 25 applicants.Cloud Solutions Architect - Alliances.Canonical is a leading provider of open source software and operating systems to the glo...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    SQL Administrator

    SQL Administrator

    Sunrise SystemsRaleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Experience in troubleshooting and resolving database problems; Experience with following : .Backups restores and High Availability (Always on),. Installation and configuration of SQL 2014, 2016 and 20...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    MO-3-12-AWS Cloud Architect and Advisory (759545)

    MO-3-12-AWS Cloud Architect and Advisory (759545)

    Focused HR SolutionsRaleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    This job is 100% remote for now.If it changes All work must be completed on site at the client's discretion.Do you accept this requirement?. Our client has an opening for a AWS Cloud Architect and A...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Enterprise Cloud Architect and Advisory

    Enterprise Cloud Architect and Advisory

    Sunrise SystemsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Enterprise Cloud Architect and Advisory.Duration : 05 Months On Contract.Responsibilities include but are not limited to : . Evaluate projects from an Enterprise perspective, ensuring alignment with bu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Cloud IAM Solutions Architect

    Cloud IAM Solutions Architect

    Public Consulting GroupRaleigh, NC, United States
    serp_jobs.job_card.full_time
    Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve li...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Solutions Consultant

    Solutions Consultant

    KERRIDGE COMMERCIAL SYSTEMS CORPCary, NC, US
    serp_jobs.job_card.full_time
    This approach promotes a balanced work environment that combines office collaboration with the comfort and convenience of remote work. Klipboard provides specialist software, services and support to...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Data Solutions Architect

    Data Solutions Architect

    ZipRecruiterRaleigh, NC, United States
    serp_jobs.job_card.full_time
    Job DescriptionJob Description.Responsible for the overall design and governance of the enterprise data platform.Defines Azure resource architecture, metadata strategy, data integration patterns,.A...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    O&M Reports Developer

    O&M Reports Developer

    Sunrise SystemsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title : O&M Reports Developer.Duration : 12 Months On Contract.CLIENT requires the services of a senior ETL and report developer to provide business and systems analysis, modeling, design, an...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    MO 24410 - 761423 - SQL Database Administrator

    MO 24410 - 761423 - SQL Database Administrator

    Focused HR SolutionsCary, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Candidate will work 100% on-site in Raleigh, NC.In-person Interview on 1st Round Required.Our direct client has an opening for a SQL Database Administrator position # 76125.This position is for 6+ ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    SQL Server Administrator

    SQL Server Administrator

    Sunrise SystemsRaleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title : SQL Server Administrator.Backups restores and High Availability (Always on),.Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise. Configuration of SSIS and S...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    PostgreSQL Database Administrator

    PostgreSQL Database Administrator

    EnvestnetRaleigh, NC, US
    serp_jobs.job_card.full_time
    PostgreSQL Database Administrator.This is a hybrid role, with in-office work required at our Berwyn, PA office location.Envestnet is transforming the way financial advice is delivered through its c...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Databricks Architect - Remote

    Databricks Architect - Remote

    CognizantRaleigh, NC, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Job Title - Databricks Architect.Databricks Architect with expertise in building scalable data solutions on AWS.Supply Chain, Consumer Goods / Retail domain knowledge required.Experience in moderni...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Cloud Solutions Architect

    Cloud Solutions Architect

    CopelandRaleigh, NC, United States
    serp_jobs.job_card.full_time
    We are a global climate technologies company engineered for sustainability.We create sustainable and efficient residential, commercial and industrial spaces through HVACR technologies.We protect te...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Power BI Dashboard Developer

    Power BI Dashboard Developer

    Sunrise SystemsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title : PowerBI Dashboard Developer.Job Location : Durham, NC 27709.NC FAST requires the services of a Power BI Dashboard developer to provide business and systems analysis, modeling, design, and...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    PostgreSQL DBA

    PostgreSQL DBA

    Omm IT SolutionsRaleigh, NC, us
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Candidate must be located within commuting distance or willing to relocate to Raleigh, NC.Candidate must be available to work on a rotating shift schedule to provide 24 / 7 support, including early m...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Principal Consultant, Cloud DFIR, Reactive Services (Unit 42) - Remote

    Principal Consultant, Cloud DFIR, Reactive Services (Unit 42) - Remote

    Palo Alto NetworksRaleigh, NC, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Principal Consultant, Cloud DFIR, Reactive Services (Unit 42) - Remote.Be among the first 25 applicants.At Palo Alto Networks everything starts and ends with our mission : .Being the cybersecurity pa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Database Engineer(Elastic / Mongo / Hadoop)

    Senior Database Engineer(Elastic / Mongo / Hadoop)

    CatchProbe Intelligence TechnologiesRaleigh, NC, United States
    serp_jobs.job_card.full_time
    Senior Database Engineer(Elastic / Mongo / Hadoop).Senior Database Engineer(Elastic / Mongo / Hadoop).Must have experience with MongoDB installations, upgrades, support on MongoDB.Responsible for administr...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Enterprise Data Consultant - Senior Collibra Lineage Developer

    Enterprise Data Consultant - Senior Collibra Lineage Developer

    First Citizens BankRaleigh, NC, US
    serp_jobs.job_card.full_time
    This is a remote role that may be hired in several markets across the United States.The Enterprise Data Consultant (Senior Collibra Lineage Developer) is responsible for designing and implementing ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Sr. Cloud Consultant- Remote

    Sr. Cloud Consultant- Remote

    IBM ComputingRaleigh, NC, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Joining the IBM Technology Expert Labs teams means you'll have a career delivering world-class services for our clients.As the ultimate expert in IBM products, you'll bring together all the necessa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    MO - 4 / 10 - 761423 - SQL Database Administrator

    MO - 4 / 10 - 761423 - SQL Database Administrator

    FHRMorrisville, NC, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Candidate will work 100% on-site in Raleigh, NC.In-person Interview on 1st Round Required.Our direct client has an opening for a SQL Database Administrator position # 76125.This position is for 6+ ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30