Job Description
Postgres Database Administrator
Req number:
R5569
Employment type:
Full time
Worksite flexibility:
Hybrid
Who we areCAI 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 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 will be full-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 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
- 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 ap***********************s@***.io or (888) 824 8111.
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time
Contact Details:
Company: CAI
Location(s): Bengaluru
Keyskills:
replication
continuous integration
cd
python
indexing
performance tuning
configuration
methods
query
strategy execution
microsoft azure
ci/cd
database administration
ansible
sql
performance
postgresql
appdynamics
troubleshooting
bash
pgadmin
aws
postgresql administration