Job Summary :

We are looking for a PostgreSQL & Amazon Redshift Performance Engineer to optimize database performance, improve query efficiency, and ensure high availability of enterprise data platforms.

The ideal candidate should have deep expertise in PostgreSQL administration, Amazon Redshift optimization, database tuning, and performance diagnostics.

Key Responsibilities :

- Monitor and optimize PostgreSQL and Amazon Redshift database performance.
- Analyze complex SQL queries and improve execution efficiency.
- Perform database indexing, partitioning, and schema optimization.
- Configure database parameters for optimal workload performance.
- Identify bottlenecks using execution plans and monitoring tools.
- Manage database backup, recovery, replication, and failover strategies.
- Support capacity planning and infrastructure scaling.
- Implement database security, access control, and auditing.
- Automate routine database administration tasks.
- Collaborate with development teams to improve application database performance.





Required Skills:

- Robust experience in PostgreSQL database administration.
- Extensive expertise in Amazon Redshift architecture and performance tuning.
- Advanced SQL query optimization skills.
- Experience with VACUUM, ANALYZE, indexing, partitioning, and query planning.
- Knowledge of replication, clustering, and high availability.
- Experience with Linux administration.
- Hands-on experience with monitoring tools such as CloudWatch, pgAdmin, Prometheus, or Grafana.
- Familiarity with ETL workloads and data warehousing concepts.
- Scripting experience using Python, Shell, or Bash.

Preferred Skills :

- AWS Database Specialty or PostgreSQL certification.
- Experience with data migration projects.
- Knowledge of Redshift Spectrum, AWS Glue, and S3 integration.
- Exposure to large-scale analytical data platforms and cloud-native database architectures.

📌 PostgreSQL & Amazon Redshift Performance Engineer (India)
🏢 Compunnel Technology India Private
📍 India