Senior Postgres/db2 Dba

Tata Consultancy Services; San Antonio (TX); On-site; USD 95,000 - 110,000; Full time

Job summary

Tata Consultancy Services Limited in San Antonio, TX seeks a Senior Postgres/DB2 DBA to lead administration, performance tuning, and high-availability efforts for PostgreSQL and DB2 databases. The role requires expertise in Linux environments and cloud-hosted deployments (AWS RDS preferred) with strong incident management capabilities.

The position focuses on installation, upgrades, backup/recovery, and ongoing optimization across development, QA, and production environments.

Qualifications

• Experience administering PostgreSQL and DB2 databases on Linux environments.
• Experience with AWS RDS PostgreSQL or cloud-hosted databases.
• Knowledge of backup, recovery, high availability, and disaster recovery.
• Ability to troubleshoot slow queries and optimize performance.
• Familiarity with monitoring tools and incident management processes.

Responsibilities

• Install, configure, upgrade, patch, and administer PostgreSQL and DB2 databases.
• Manage replication, clustering, and high-availability setups.
• Perform capacity planning, growth forecasting, and storage utilization.
• Analyze and optimize SQL queries, indexes, and execution plans.
• Conduct regular DR drills and recovery validation exercises.
• Provide L3 production support and root-cause analysis for incidents.

Skills

PostgreSQL

DB2

Linux

Bash scripting

Git

Jenkins

CI/CD concepts

Tools

Git

Jenkins

CI/CD Concepts

AWS RDS

Shell Scripting

Job description

Job Description

Senior Postgres /DB2 DBA

• PostgreSQL/ DB2
• PostgreSQL Database Administration (v11 and above)
• Installation, configuration, upgrades, and patching
• Performance tuning and query optimization
• Replication, clustering, and high availability
• Backup and recovery strategies
• Database monitoring and health checks
• PostgreSQL security and access management
• PostgreSQL on Linux environments
• Experience with AWS RDS PostgreSQL or cloud-hosted databases
• IBM DB2 Database Administration
• DB2 Performance Monitoring and Tuning
• SQL Optimization and Index Management
• Database Backup and Recovery
• DB2 Security and User Administration
• Database Migration and Upgrade Activities
• Production Support and Incident Management
• Additional Skills
• Linux/Unix Administration
• Shell Scripting (Bash/KSH)
• SQL and Stored Procedure Development
• Monitoring Tools and Alert Management
• Database Migration and Modernization Projects
• Git, Jenkins, CI/CD Concepts
• Cloud platforms (AWS preferred)
• ITSM and Change Management Processes
• Database Administration
• Install, configure, upgrade, patch, and administer PostgreSQL and DB2 databases.
• Manage database capacity planning, growth forecasting, and storage utilization.
• Create and maintain development, QA, UAT, and production database environments.
• Performance Management
• Monitor database performance and availability.
• Analyze and optimize SQL queries, indexes, and execution plans.
• Troubleshoot slow-running queries and application performance bottlenecks.
• Implement proactive monitoring and alerting mechanisms.
• Backup, Recovery & High Availability
• Design and execute database backup and recovery strategies.
• Maintain disaster recovery and business continuity solutions.
• Configure and support replication, failover, and high-availability architectures.
• Conduct regular DR drills and recovery validation exercises.
• Production Support
• Provide L3 database support for critical production environments.
• Perform root cause analysis for incidents and recurring issues.
• Participate in on-call support rotations when required.
• Prepare RCA documents and operational reports.
• Security & Compliance
• Implement database security standards and best practices.
• Manage user accounts, roles, privileges, and auditing.
• Ensure compliance with organizational and regulatory requirements.
• Support vulnerability remediation and security audits.
• Migration & Modernization
• Lead database migration initiatives between environments and platforms.
• Support cloud migration and modernization programs.
• Ensure minimal downtime and data integrity during migrations.
• Collaboration
• Work closely with application teams, architects, cloud engineers, and business stakeholders.
• Provide technical guidance and mentoring to junior DBAs.
• Participate in design reviews and architecture discussions.

Salary Range- $95,000-$110,000 a year

Location

San Antonio, TX

Function

TECHNOLOGY

Role

Technical Lead

ID

433610

Skills

Postgres DBA

Salary Range

$95,000 - $110,000