Home
Jobs

PostgreSQL Database Administrator

5 years

0 Lacs

Posted:4 days ago| Platform: Linkedin logo

Apply

Work Mode

Remote

Job Type

Full Time

Job Description

This is a remote position.

Job Summary:

PostgreSQL Database Administrator

Key Responsibilities:

  • Monitor and maintain PostgreSQL database systems, ensuring high availability and performance.

  • Manage database backup, restore, archiving, and disaster recovery procedures.

  • Perform database upgrades, patching, and version control with thorough testing.

  • Design and implement database architecture, schema, indexing strategies, and replication setups.

  • Develop and maintain stored procedures, functions, and performance-optimized SQL queries.

  • Identify and resolve performance bottlenecks, including query tuning and system-level optimizations.

  • Support developers with database integration, schema changes, and data migrations.

  • Define and enforce database security, access control, and compliance best practices.

  • Participate in On-Call rotations for critical support and incident resolution.

  • Collaborate with DevOps and infrastructure teams for automation and monitoring solutions.

Requirements:

  • 5 years of experience

  • In-depth knowledge of PostgreSQL internals, configuration, performance tuning, and replication (e.g., logical, streaming).

  • Strong experience with backup and recovery tools (e.g., pgBackRest, WAL-G) and high availability configurations.

  • Proven skills in SQL and PL/pgSQL development, including stored procedures and triggers.

  • Familiarity with monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana).

  • Experience with Linux/Unix systems administration as it pertains to PostgreSQL.

  • Ability to work independently, prioritize tasks, and “own” technical challenges and solutions.

  • Strong analytical, problem-solving, and communication skills.

  • Knowledge of cloud-based PostgreSQL services (e.g., AWS RDS, Azure Database for PostgreSQL) is a plus.

  • MySQL DBA Experience is a Big plus.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Numentica
Numentica

Information Technology

San Francisco

RecommendedJobs for You