Logo
CAI

Postgres Database Administrator

CAI, Indiana, Pennsylvania, us, 15705

Save Job

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. Job Description We are looking for a

Postgres SQL

Database Administrator

.

This position will

be

full-time employment

and Location

Bangalore -Hybrid. What You’ll Do We are seeking an experienced PostgreSQL DBA to join our team with 5-7 years of experience theideal candidate will be responsible for the maintenance and performance tuning of PostgreSQLdatabases in high-availability environments you will work closely with development, DevOps, andinfrastructure 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 versionswhen 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 schemadesign.

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.

#J-18808-Ljbffr