PostgreSQL Developer

Job Title: PostgreSQL Developer with DBA Expertise

Work Location: Cincinnati, Ohio

Job Details:

• We are seeking a highly skilled and experienced PostgreSQL Developer with strong Database Administration (DBA) capabilities to join our team.
• The ideal candidate will possess a deep understanding of PostgreSQL internals, excellent SQL query writing and debugging skills, and practical experience in managing and optimizing PostgreSQL databases.
• This role requires a proactive individual who can troubleshoot complex performance issues, ensure data integrity, and contribute to the overall efficiency and scalability of our database systems.

Responsibilities:

• Develop, optimize, and debug complex SQL queries, stored procedures, and functions in PostgreSQL.
• Analyze and resolve database performance bottlenecks, including query tuning, indexing strategies, and database configuration adjustments.
• Perform routine database administration tasks such as backup and recovery, replication setup, and security management.
• Design and implement database schemas, ensuring optimal performance and data integrity.
• Manage and maintain partitioned tables, including understanding indexing implications and performing partition maintenance.
• Utilize advanced SQL features like Common Table Expressions (CTEs) and understand the nuances of different SQL constructs (e.g., NOT IN vs. NOT EXISTS).
• Monitor database health, performance, and resource utilization, implementing proactive measures to prevent issues.
• Collaborate with development teams to ensure database best practices are followed throughout the application lifecycle.
• Document database designs, configurations, and operational procedures.

Required Skills & Qualifications:

• 5+ years of hands-on experience as a PostgreSQL Developer and/or DBA.
• Expert-level proficiency in SQL with a proven track record of writing complex, efficient, and debugged queries.
• Deep understanding of PostgreSQL architecture and internal mechanisms.
• Extensive experience with database performance tuning and optimization.
• Solid understanding of database backup and recovery strategies, including Point-In-Time Recovery (PITR).
• Experience with partitioned tables, including their design, indexing, and maintenance.
• Proficiency in using and understanding Common Table Expressions (CTEs).
• Clear understanding of the differences and appropriate use cases for SQL constructs like NOT IN vs. NOT EXISTS.
• Knowledge of PostgreSQL vacuuming processes (e.g., autovacuum) and their configuration.
• Familiarity with replication technologies (e.g., streaming replication, logical replication) is a plus.
• Experience with database monitoring tools and best practices.
• Strong problem-solving and analytical skills.
• Excellent communication and teamwork abilities.