PostgreSQL Developer (ONSITE – Louisville, KY)

[Adarsh mallik]

Senior PostgreSQL Developer (ONSITE – Louisville, KY | 8+ YEARS EXPERIENCE)

Job Description

We are seeking a highly experienced Senior PostgreSQL Developer to join our team in Louisville, KY (100% onsite). The ideal candidate will have strong expertise in database development, performance tuning, and managing enterprise-scale PostgreSQL environments.

Key Responsibilities:

• Design, develop, and maintain PostgreSQL databases, schemas, and data models
• Write and optimize complex SQL queries, stored procedures, and functions (PL/pgSQL)
• Perform database performance tuning, query optimization, and indexing strategies
• Implement data partitioning, replication, and high availability solutions
• Ensure data integrity, security, and compliance standards
• Manage database migrations, upgrades, and patching activities
• Monitor database performance and troubleshoot production issues
• Collaborate with application developers, data engineers, and business teams
• Implement backup, recovery, and disaster recovery strategies

Required Skills:

• 10+ years of database development experience
• Strong hands-on experience with PostgreSQL
• Advanced knowledge of SQL and PL/pgSQL
• Expertise in query optimization and performance tuning
• Experience with database design, normalization, and data modeling
• Strong understanding of indexing, partitioning, and replication
• Experience working in Linux/Unix environments

Preferred Skills:

• Experience with cloud platforms (AWS, Azure, or GCP)
• Knowledge of ETL pipelines and data warehousing
• Familiarity with NoSQL databases (MongoDB, Cassandra, etc.)
• Experience with DevOps tools and CI/CD pipelines