Job Summary

We are seeking a highly experienced Senior Database Administrator (DBA) to manage, monitor, optimize, and evolve our PostgreSQL database environments. This role is responsible for supporting high-load on-premises PostgreSQL systems as well as AWS RDS PostgreSQL deployments.

The ideal candidate will bring deep expertise in query performance tuning, database version upgrades, and cloud database operations, with a proven ability to plan, test, and execute PostgreSQL upgrades and migrations while ensuring application compatibility, data integrity, and system stability.

---

Key Responsibilities

PostgreSQL Administration (On-Premise & Cloud)

· Monitor, analyze, and tune heavy and long-running SQL queries across PostgreSQL environments

· Identify and resolve performance bottlenecks using PostgreSQL statistics, logs, and system metrics

· Optimize database performance through:

o Index design and optimization

o Query analysis and rewriting

o PostgreSQL configuration tuning (memory, vacuum, autovacuum, checkpoints)

o Detect and propose data archival mechanism for unused data

· Ensure database availability, reliability, and data integrity

· Manage backup, restore, and disaster recovery strategies

---

Database Version Upgrades & Compatibility Testing

· Lead and execute PostgreSQL database version upgrades in on-premises and AWS RDS environments

· Perform pre-upgrade assessments to identify:

o Deprecated features and breaking changes

o Extension, stored procedure, and function compatibility issues

o Query behavior and performance changes between versions

· Design and execute comprehensive upgrade testing plans to ensure:

o Stored procedures, functions, triggers, and views remain compatible

o Existing SQL queries execute correctly and efficiently

o Applications function as expected on the upgraded database version

· Validate data integrity, performance, and stability post-upgrade

---

AWS RDS PostgreSQL & Cloud Operations

· Design, provision, and manage AWS RDS PostgreSQL instances

· Spin up and configure RDS environments following best practices for:

o Security and access control

o Performance tuning and scalability

o High availability, backups, and snapshots

· Monitor RDS performance using AWS and PostgreSQL monitoring tools

· Partner with DevOps and infrastructure teams on cloud database architecture

---

Database Migration & Modernization

· Lead and support database migrations between on-premises PostgreSQL and AWS RDS

· Plan and execute migrations with minimal downtime and risk

· Perform data validation and performance testing after migration

· Provide strategic recommendations for PostgreSQL modernization, architecture improvements, and version adoption

---

DevOps & Automation

· Apply DevOps principles to database operations

· Automate database provisioning, configuration, monitoring, and maintenance

· Support CI/CD pipelines involving database schema and data changes

· Use scripting and infrastructure-as-code approaches to improve operational efficiency

---

Required Qualifications

· Minimum 7 years of experience as a Database Administrator, with strong focus on PostgreSQL

· Deep hands-on knowledge of PostgreSQL internals, performance tuning, and query optimization

· Proven experience planning and executing PostgreSQL version upgrades, including:

o Compatibility testing of stored procedures, functions, and SQL queries

o Managing risks, rollback plans, and production cutovers

· Strong experience managing AWS RDS PostgreSQL environments

· Solid understanding of Linux/Unix operating systems

· Experience working with DevOps tools, automation, and modern infrastructure practices

· Excellent troubleshooting, analytical, and problem-solving skills

· Experience supporting large-scale or high-traffic PostgreSQL environments

· Strong communication and technical documentation skills

· Ability to work independently and take ownership of complex database platforms

· Comfortable collaborating with application, DevOps, and infrastructure teams

· Proactive, improvement-driven mindset focused on performance, stability, and scalability

· Familiarity with PostgreSQL monitoring and diagnostic tools

· Knowledge of high-availability, replication, and failover strategies

· Experience with AWS services such as VPC, IAM, EC2, and S3

· Scripting skills (Bash, Python, or similar)

Job Summary

We are seeking a highly experienced Senior Database Administrator (DBA) to manage, monitor, optimize, and evolve our PostgreSQL database environments. This role is responsible for supporting high-load on-premises PostgreSQL systems as well as AWS RDS PostgreSQL deployments.

The ideal candidate will bring deep expertise in query performance tuning, database version upgrades, and cloud database operations, with a proven ability to plan, test, and execute PostgreSQL upgrades and migrations while ensuring application compatibility, data integrity, and system stability.

---

Key Responsibilities

PostgreSQL Administration (On-Premise & Cloud)

· Monitor, analyze, and tune heavy and long-running SQL queries across PostgreSQL environments

· Identify and resolve performance bottlenecks using PostgreSQL statistics, logs, and system metrics

· Optimize database performance through:

o Index design and optimization

o Query analysis and rewriting

o PostgreSQL configuration tuning (memory, vacuum, autovacuum, checkpoints)

o Detect and propose data archival mechanism for unused data

· Ensure database availability, reliability, and data integrity

· Manage backup, restore, and disaster recovery strategies

---

Database Version Upgrades & Compatibility Testing

· Lead and execute PostgreSQL database version upgrades in on-premises and AWS RDS environments

· Perform pre-upgrade assessments to identify:

o Deprecated features and breaking changes

o Extension, stored procedure, and function compatibility issues

o Query behavior and performance changes between versions

· Design and execute comprehensive upgrade testing plans to ensure:

o Stored procedures, functions, triggers, and views remain compatible

o Existing SQL queries execute correctly and efficiently

o Applications function as expected on the upgraded database version

· Validate data integrity, performance, and stability post-upgrade

---

AWS RDS PostgreSQL & Cloud Operations

· Design, provision, and manage AWS RDS PostgreSQL instances

· Spin up and configure RDS environments following best practices for:

o Security and access control

o Performance tuning and scalability

o High availability, backups, and snapshots

· Monitor RDS performance using AWS and PostgreSQL monitoring tools

· Partner with DevOps and infrastructure teams on cloud database architecture

---

Database Migration & Modernization

· Lead and support database migrations between on-premises PostgreSQL and AWS RDS

· Plan and execute migrations with minimal downtime and risk

· Perform data validation and performance testing after migration

· Provide strategic recommendations for PostgreSQL modernization, architecture improvements, and version adoption

---

DevOps & Automation

· Apply DevOps principles to database operations

· Automate database provisioning, configuration, monitoring, and maintenance

· Support CI/CD pipelines involving database schema and data changes

· Use scripting and infrastructure-as-code approaches to improve operational efficiency

---

Required Qualifications

· Minimum 7 years of experience as a Database Administrator, with strong focus on PostgreSQL

· Deep hands-on knowledge of PostgreSQL internals, performance tuning, and query optimization

· Proven experience planning and executing PostgreSQL version upgrades, including:

o Compatibility testing of stored procedures, functions, and SQL queries

o Managing risks, rollback plans, and production cutovers

· Strong experience managing AWS RDS PostgreSQL environments

· Solid understanding of Linux/Unix operating systems

· Experience working with DevOps tools, automation, and modern infrastructure practices

· Excellent troubleshooting, analytical, and problem-solving skills

· Experience supporting large-scale or high-traffic PostgreSQL environments

· Strong communication and technical documentation skills

· Ability to work independently and take ownership of complex database platforms

· Comfortable collaborating with application, DevOps, and infrastructure teams

· Proactive, improvement-driven mindset focused on performance, stability, and scalability

· Familiarity with PostgreSQL monitoring and diagnostic tools

· Knowledge of high-availability, replication, and failover strategies

· Experience with AWS services such as VPC, IAM, EC2, and S3

· Scripting skills (Bash, Python, or similar)