Natobotics - PostgreSQL Administrator - Database Performance Tuning

PostgreSQL Administrator (AWS & Java)

Experience : 5-10 Years

Employment Type : Full-time

Job Overview :

We are seeking a highly skilled and experienced PostgreSQL Administrator with a strong background in managing databases on AWS and supporting applications developed in Java. You will be responsible for the installation, configuration, monitoring, maintenance, and performance tuning of our PostgreSQL database instances, ensuring high availability, security, and optimal performance for critical business applications. This role requires expertise in both on-premise and cloud-based PostgreSQL environments, with a focus on seamless integration with Java applications and AWS services.

Key Responsibilities :

- Perform end-to-end administration of PostgreSQL databases, including installation, configuration, patching, upgrades, and migration across various environments.

- Manage and maintain PostgreSQL instances on AWS, specifically leveraging services like Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL, including parameter group configuration, security group management, and automated backups.

- Monitor database performance metrics, identify bottlenecks, and perform advanced query optimization and performance tuning using tools like pg_stat_statements, pgBadger, and manual query analysis.

- Design, implement, and maintain robust backup, recovery, and disaster recovery strategies for PostgreSQL databases, ensuring data integrity and minimal recovery time objectives (RTO).

- Configure and manage high availability and replication solutions (streaming replication, logical replication) for PostgreSQL clusters.

- Collaborate closely with Java application development teams to understand application data access patterns, optimize queries, design efficient database schemas, and troubleshoot database-related application issues.

- Implement and manage database security, including user and role management, access controls, encryption (at rest and in transit via SSL), and auditing.

- Monitor database logs, events, and streams (via AWS CloudWatch, CloudTrail) to proactively detect and resolve operational issues.

- Participate in database capacity planning, forecasting growth, and making recommendations for scaling and infrastructure improvements.

- Provide expert-level T2/T3 support for production PostgreSQL databases, including on-call rotation as required.

- Create and maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.

Required Qualifications :

- 5-10 years of hands-on experience as a PostgreSQL Database Administrator.

- Strong expertise in PostgreSQL database administration, including installation, configuration, performance tuning, backup & recovery, and replication.

- Proven experience managing PostgreSQL databases in AWS cloud environments, specifically with Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL.

- Experience with Java-based applications and a clear understanding of how Java applications interact with PostgreSQL databases, including JDBC and connection pooling.

- Proficient in SQL, including advanced query writing, analysis, and optimization.

- Strong knowledge of database architecture, data modeling, and schema design.

- Experience with database monitoring tools and setting up alerts.

- Familiarity with Linux operating systems for database server management.

- Solid understanding of high availability, disaster recovery, and replication solutions.

- Excellent problem-solving, debugging, and analytical skills.

- Strong verbal and written communication skills, with the ability to collaborate effectively with development teams and other stakeholders.