Search

PostgreSQL DBA

PublishedPublished: 6/14/2022
Technology
|

Job Description

Only considering candidates who live nearby and can commute to the client’s location three days a week

\n


\n

PostgreSQL DBA

\n


\n

Location: Phoenix, AZ - day 1 onsite – min 3 days in the office.

\n

Duration: 12 months

\n


\n

Key Responsibilities

\n

    \n
  • Administer database platforms, including installation, configuration, upgrades, patching, monitoring, troubleshooting, backup and recovery, replication, and high availability.
  • \n

  • Monitor database health, availability, capacity, and performance; identify risks early and implement proactive improvements to reduce incidents.
  • \n

  • Manage and resolve production incidents using established Incident Management processes.
  • \n

  • Perform root cause analysis and drive long-term remediation through Problem Management practices.
  • \n

  • Plan, validate, and implement database changes in alignment with Change Management processes.
  • \n

  • Partner with application, infrastructure, cloud, security, data engineering, and vendor teams to troubleshoot issues and improve platform stability.
  • \n

  • Contribute to the architecture, design, engineering, and optimization of enterprise-scale data platforms.
  • \n

  • Develop automation, observability, and self-healing capabilities to improve reliability, reduce manual effort, and increase operational efficiency.
  • \n

  • Leverage AI-enabled tools and automation frameworks to identify improvement opportunities and accelerate operational outcomes.
  • \n

\n


\n

Required Qualifications

\n

    \n
  • 8+ years of hands-on DBA experience supporting PostgreSQL, YugabyteDB, SQL Server, and cloud-native databases such as Amazon Aurora PostgreSQL, Amazon Aurora MySQL, Google Cloud SQL, and Google Cloud Spanner.
  • \n

  • Strong experience with database administration activities, including installation, configuration, upgrades, patching, monitoring, troubleshooting, backup and recovery, replication, and high availability.
  • \n

  • Deep technical knowledge of PostgreSQL, SQL Server, YugabyteDB, and cloud-native database platforms.
  • \n

  • Proven ability to troubleshoot complex production issues related to performance, query optimization, workload management, capacity planning, latency, availability, and reliability.
  • \n

  • Experience with automation and DevOps tools such as Python, Unix shell scripting, Ansible, Terraform, GitHub, and CI/CD pipelines.
  • \n

  • Hands-on experience with AWS and/or GCP database services, Infrastructure as Code, monitoring, and observability tools such as Grafana and DMC.
  • \n

  • Understanding of data engineering concepts, including data ingestion, ETL/ELT, data pipelines, data integration, and support for high-volume data workloads.
  • \n

  • Knowledge of ITIL processes, including Incident, Problem, and Change Management, along with Disaster Recovery and root cause analysis.
  • \n

  • Strong troubleshooting, communication, ownership, and collaboration skills in a 24x7 production support environment.
  • \n

  • Solid understanding of database setup, configuration, administration, and replication.
  • \n

  • Ability to learn quickly, work independently, and take ownership of assigned responsibilities.
  • \n

  • Willingness to provide rotational weekend and off-hours support as needed.
  • \n

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...