Database Engineer

Job Title:

Location:

Experience:

Environment:

PostgreSQL Database Engineer

Key Responsibilities

• Install, configure, and maintain PostgreSQL databases in

  Linux/openSUSE environments

  .
• Design, develop, and optimize

  complex SQL queries, stored procedures, and functions

  .
• Implement and manage

  TimescaleDB

  for handling time-series data.
• Perform database

  tuning, indexing, partitioning, and query optimization

  .
• Ensure

  high availability, backup, recovery, and disaster recovery planning

  .
• Monitor database health and troubleshoot performance issues.
• Implement and manage

  replication, clustering, and failover

  mechanisms.
• Collaborate with developers to design efficient

  data models and schemas

  .
• Perform

  database upgrades, migrations, and patch management

  .
• Automate routine DBA tasks using

  scripting (Bash, Python, etc.)

  .

Required Skills & Experience

• 8+ years

  of strong hands-on experience as a PostgreSQL DBA and Developer.
• Expertise in

  PostgreSQL administration, performance tuning, and optimization

  .
• Proficiency in working with

  Linux/openSUSE environments

  .
• Hands-on experience with

  TimescaleDB

  and related toolkits.
• Strong knowledge of

  query planning, indexing strategies, and database internals

  .
• Experience in

  database security (roles, privileges, encryption, auditing)

  .
• Good knowledge of

  replication (logical, streaming, synchronous/asynchronous)

  .
• Familiarity with

  HA tools

  (Patroni, Pacemaker, pgPool-II, etc.).
• Scripting skills in

  Bash, Python, or Perl

  for automation.
• Exposure to

  cloud platforms (AWS RDS/Aurora, Azure Database for PostgreSQL, GCP Cloud SQL)

  is a plus.
• Strong problem-solving and troubleshooting skills.

Preferred Qualifications

• Experience with

  large-scale, high-transactional databases

  .
• Knowledge of

  PostGIS

  or other PostgreSQL extensions.
• Experience with

  CI/CD pipelines

  for database deployments.
• Familiarity with

  monitoring tools (Prometheus, Grafana, pg_stat_statements, pgbadger)

  .