Postgres Database Administrator

Postgres Database Administrator

Req number:

R5569

Employment type:

Full time

Worksite flexibility:

Hybrid

Who we are

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

We are looking for a motivated Postgres SQL Database Administrator ready to take us to the next level! If you understand in PostgreSQL administration, configuration, tuning, and troubleshooting and are looking forward to your next career move, apply now.

Postgres SQL Database Administrator

What You’ll Do

• We are seeking an experienced PostgreSQL DBA to join our team with 5-7 years of experience the ideal candidate will be responsible for the maintenance and performance tuning of PostgreSQL databases in high-availability environments you will work closely with development, DevOps, and infrastructure teams to ensure data integrity, security, and scalability.
• Administer, maintain, tune, and troubleshoot PostgreSQL databases across development, testing, and production environments.
• Plan and implement database backup and recovery strategies.
• Monitor database performance, implement changes, and apply new patches and versions when required.
• Design and implement high-availability and disaster recovery strategies (e.g., replication, clustering, failover).
• Ensure database security and compliance with internal and external standards.
• Automate routine tasks using scripting (e.g., Bash, Python, Ansible).
• Work closely with software developers to optimize SQL queries and database schema design.
• Perform data migrations, upgrades, and capacity planning.
• Support CI/CD processes related to database deployments.

What You'll Need

Educational Qualifications

• Bachelor’s degree in computer science, Information Technology, Engineering, or a related technical field is required.
• Master’s degree or relevant Postgraduate qualification is a plus.
• Industry certifications (preferred but not mandatory)- PostgreSQL Certified Professional ,Linux Administration Certifications (e.g., RHCE), Cloud Cloud certifications (i.e. Azure, AWS).

Technical Expertise

• Expert-level experience in PostgreSQL administration, configuration, tuning, and troubleshooting.
• In-depth knowledge of PostgreSQL internals, query planner, execution strategies, and indexing techniques.
• Strong experience in replication methods (streaming replication, logical replication) and clustering/failover solutions.
• Familiarity with tools like pgAdmin, psql, pgBackRest, , and Patroni, AppDynamics.
• Backup and recovery planning, implementation, and testing in business-critical environments.
• Experience in PostgreSQL version upgrades, migrations, and capacity planning.

Physical Demands

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor.

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.