Tata Consultancy Services · 1 day ago
PostgreSQL DBA
Framingham, MA
Full-time
Onsite
Mid, Senior Level
$90K/yr - $120K/yrTata Consultancy Services is seeking a PostgreSQL DBA to design, maintain, and optimize complex PostgreSQL database schemas. The role involves extensive hands-on experience with PostgreSQL installation, configuration, high availability setup, backup strategies, and performance tuning.
Business Information SystemsConsultingInformation TechnologyIT Management
Responsibilities
Extensive hands-on experience with PostgreSQL (v11 and above)
Database installation, configuration, and upgrades on Linux/Unix platforms
High Availability (HA) setup using streaming replication, Patroni, repmgr, etc
Backup and recovery strategies using tools like pgBackRest, Barman
Performance tuning and query optimization
Strong knowledge of PL/pgSQL scripting and automation
Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana)
Security hardening and compliance (role-based access control, SSL, encryption at rest/in-transit)
Disaster Recovery planning and execution
Capacity planning and data growth forecasting
Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL)
Good communication skills with both technical and management teams
Database Architecture & Design: Design and maintain complex PostgreSQL database schemas
Performance Tuning & Optimization: Advanced query tuning and index optimization. Analyze and resolve slow queries using EXPLAIN, ANALYZE, and pg_stat views
Backup and Recovery: Implement and manage high-availability backup strategies. Test and document disaster recovery procedures
Replication and High Availability: Set up and maintain replication (physical/logical). Experience with HA tools like Patroni, repmgr, or Pgpool-II
Security Management: Implement role-based access controls, SSL/TLS, and audit logging. Monitor for vulnerabilities and apply patches
Monitoring & Maintenance: Perform routine health checks and maintenance tasks (VACUUM, REINDEX, ANALYZE)
Upgrades & Migrations: Plan and execute PostgreSQL version upgrades with minimal downtime. Experience migrating from on-prem to cloud (AWS RDS/Aurora, Azure Database for PostgreSQL, or GCP)
Qualification
Required
Extensive hands-on experience with PostgreSQL (v11 and above)
Database installation, configuration, and upgrades on Linux/Unix platforms
High Availability (HA) setup using streaming replication, Patroni, repmgr, etc
Backup and recovery strategies using tools like pgBackRest, Barman
Performance tuning and query optimization
Strong knowledge of PL/pgSQL scripting and automation
Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana)
Security hardening and compliance (role-based access control, SSL, encryption at rest/in-transit)
Disaster Recovery planning and execution
Capacity planning and data growth forecasting
Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL)
Good communication skills with both technical and management teams
Preferred
Experience with other databases (Oracle, MySQL, or NoSQL like MongoDB)
Experience with Kubernetes & PostgreSQL operators (e.g., Zalando, Crunchy)
Knowledge of Infrastructure as Code (Terraform, Ansible)
Experience with CI/CD pipelines for database changes
Experience with Databases (Oracle, DB2 & SQL server)
Exposure to PostgreSQL clustering and sharding
Understanding of logical replication and change data capture (CDC)
Knowledge of network monitoring and tools
Excellent stakeholder management and cross-functional collaboration
Certifications (Optional but Preferred): AWS Certified Database – Specialty
Benefits
Disc retionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Ma ternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commute r Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
Founded in 1968
10001+ employees
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
Trak.in - Indian Business of Tech, Mobile & Startups
2026-01-06
Business News Americas
2026-01-06
Company data provided by crunchbase