Job Description
Summary
Tata Consultancy Services (TCS) is seeking an experienced SQL Developer / PostgreSQL Database Specialist in Bangalore to manage, optimize, and maintain enterprise-level PostgreSQL databases. This role is ideal for professionals with 2–14 years of experience in PostgreSQL installation, configuration, performance tuning, backup & recovery, high availability, and security management. Join TCS to work on high-impact database projects, support cross-functional teams, and ensure robust, scalable, and secure database solutions.
Job Details at a Glance
| Title | SQL Developer / PostgreSQL Database Specialist |
|---|---|
| Company | Tata Consultancy Services (TCS) |
| Location | Bangalore, India |
| Experience | 2 – 14 Years |
| Role | Developer |
| Technical Skills | PostgreSQL 9.x–12.x, PGAdmin III/IV, Replication, PGBouncer, PGPOOL, pg_dump/pg_restore, UNIX Shell Scripting, Backup & Recovery, Performance Tuning, High Availability, Security |
| Job Function | Technology |
| Apply By | 31-Dec-2025 |
| Qualification | Bachelor of Computer Applications (BCA) |
Responsibilities
- Plan, install, configure, and maintain PostgreSQL database servers (9.x–12.x).
- Install and configure PostgreSQL tools including PGAdmin III/IV, rep manager, PGPOOL, PGBouncer, and pgbadger.
- Perform database performance tuning and enable configuration parameters for optimal performance.
- Conduct database backup, recovery, and upgrade tasks, including pg_dump, pg_restore, pg_basebackup, and replication setup.
- Implement high availability (HA) solutions and maintain security protocols for PostgreSQL databases.
- Write and manage UNIX Shell Scripts for automation, backup scheduling, and routine tasks.
- Create databases, tables, indexes, users, roles, and assign privileges following business requirements and password policies.
- Conduct Linux administration and support test databases.
- Collaborate with cross-functional teams to resolve database-related issues and provide technical support.
- Monitor load balancing, replication, and database connections to ensure system stability.
Skills & Qualifications
Technical Skills
- Expertise in PostgreSQL administration (installation, configuration, backup, recovery, and upgrades).
- Proficient with PGAdmin III/IV, replication tools, PGBouncer, and PGPOOL.
- Strong UNIX/Linux scripting skills for automation and administrative tasks.
- Knowledge of high availability, security, and performance tuning best practices.
- Experience with database troubleshooting, load balancing, and indexing strategies.
Behavioral Competencies
- Strong problem-solving and analytical skills.
- Effective communication and collaboration abilities.
- Ability to manage multiple tasks and coordinate with different teams.
Education
- Bachelor of Computer Applications (BCA) or equivalent degree in Computer Science, IT, or related fields.
Why Work at TCS Bangalore?
- Work with a global IT leader on enterprise-level PostgreSQL database projects.
- Opportunities for professional growth and exposure to advanced database technologies.
- Collaborate with diverse teams in a dynamic and innovative work environment.
- Contribute to high-impact, secure, and scalable database solutions for clients globally.
Apply Now
Advance your career as a SQL Developer / PostgreSQL Database Specialist in Bangalore with TCS! Apply today via the TCS Careers Official Page and become part of a global IT leader delivering cutting-edge database solutions.