Postgres Database Administrator
Postgres Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Req number:
R5569Employment type:
Full timeWorksite flexibility:
HybridWho we are
CAI is a global technology services firm with over 8500 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 rightwhatever 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 willbefull-time employment and Location Bangalore -Hybrid.
What Youll 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 developmenttesting 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 Youll Need
Educational Qualifications
- Bachelors degree in computer science Information Technology Engineering or a related technical field is required.
- Masters 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 or (888).
Required Experience:
Unclear Seniority
Employment Type
Full-Time
