Jobs via Dice
Join to apply for the
PostgreSQL Developer
role at
Jobs via Dice Continue with Google Continue with Google 2 days ago Be among the first 25 applicants Join to apply for the
PostgreSQL Developer
role at
Jobs via Dice Get AI-powered advice on this job and more exclusive features. Sign in to access AI-powered advices
Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Dice is the leading career destination for tech experts at every stage of their careers. Our client, United IT Solutions, is seeking the following. Apply via Dice today!
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.
Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Get notified about new Developer jobs in
Cincinnati, OH . We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
PostgreSQL Developer
role at
Jobs via Dice Continue with Google Continue with Google 2 days ago Be among the first 25 applicants Join to apply for the
PostgreSQL Developer
role at
Jobs via Dice Get AI-powered advice on this job and more exclusive features. Sign in to access AI-powered advices
Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Continue with Google Dice is the leading career destination for tech experts at every stage of their careers. Our client, United IT Solutions, is seeking the following. Apply via Dice today!
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.
Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Get notified about new Developer jobs in
Cincinnati, OH . We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr