Postgres + SQL DBA
- Tata Consultancy
- 8 - 12 years
- Pune
- 9 days ago
- Email to a friend
- Report this job
Job Description
TCS has been a great pioneer in feeding the fire of young techies like you. We are a global leader in the technology arena and theres nothing that can stop us from growing together.
What we are looking for
Role: Postgres+ SQL DBA
Experience Range: 8 to 12 Years
Location: Pune/Bangalore
Must Have:
- Strong handson experience with PostgreSQL (administration & performance tuning)
- Solid expertise in SQL, complex queries, joins, functions, and indexing
- Experience with replication, failover, and HA solutions
- Knowledge of database internals, vacuuming, bloating, and locking mechanisms
Operating Systems & Platforms
- Strong Linux/Unix administration skills
- Experience with cloud platforms (AWS / Azure / GCP)
- Familiarity with containerized or Kubernetes-based database deployments (nice to have)
Tools & Automation
- Monitoring tools (pg_stat_statements, pgAdmin, Prometheus, Grafana, etc.)
- Backup tools (pg_dump, pg_basebackup, WAL archiving)
- Scripting: Bash / Python / Shell
Good to Have:
- Experience with PostgreSQL migrations from Oracle / MySQL / SQL Server
- Knowledge of DevOps practices, CI/CD pipelines
- Exposure to cloud-native databases and managed PostgreSQL services
- PostgreSQL or cloud certifications
Essential:
- Install, configure, upgrade, and maintain PostgreSQL and SQL database servers
- Ensure high availability, replication, and disaster recovery (Streaming Replication, logical replication, clustering)
- Monitor database performance, health, storage, and capacity planning
- Perform backup, restore, and recovery operations and regularly test DR procedures
- Tune queries, indexes, and database parameters for optimal performance
- Manage schema changes, migrations, and version upgrades with minimal downtime
- Troubleshoot database incidents and conduct root cause analysis
- Implement security best practices (roles, privileges, encryption, auditing)
- Support development teams with database design, SQL optimization, and best practices
- Automate routine DBA tasks using scripting
- Maintain documentation, SOPs, and operational runbooks
- Participate in 247 production support and oncall rotations
Minimum Qualification:
- 15 years of full-time education
- Minimum percentile of 50% in 10th, 12th, UG & PG (if applicable)
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Tata ConsultancyLocation(s): Pune
Keyskills: Database Administration Postgres Database Postgresql Database Administration Mysql Database MySQL Database Administration
Similar positions
Tata Consultancy
ManekTech Solutions Private Limited - MTSPL started its journey in 2011 with the sole objective of serving clients with agile, scalable and resilient digital solutions. Over the years, we have established a flourishing work culture with our robust team of vastly experienced personnel. Thanks to our ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in