Hi ,
Hope you are doing well.
I came across your resume, and I believe you are great match for below opportunity we have with one of our clients, If you or anyone you know are interested and available for this exciting role, Please share your resume along with the best time and phone number to reach you so, I can call with more details.
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.
Looking forward to work with you !!
Riya | Manager – Talent Acquisition
United IT Solutions Inc | Contact: 469-598-1195| Email: riya@uniteditinc.com
LinkedIn: https://www.linkedin.com/in/rajeshwari-r-riya-81848921a/
www.uniteditinc.com | 1212 Corporate Dr, Suite 555, Irving, TX – 75038
*United IT Solutions, Inc. is Celebrating 16 years in the IT Industry *
To unsubscribe from future emails or to update your email preferences click here
