Senior Postgres/DB2 DBA

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

Job summary

Tata Consultancy Services in San Antonio, TX is seeking a Senior PostgreSQL/DB2 DBA to manage PostgreSQL and DB2 databases, including installation, upgrades, replication, and high availability.

The role emphasizes performance tuning, backup strategies, security, and production support, with cloud experience (AWS RDS) preferred and collaboration with application teams.

Qualifications

• Experience with PostgreSQL/DB2 database administration.
• Proficient in performance tuning and query optimization.
• Experience with AWS RDS PostgreSQL or cloud-hosted databases.
• Strong Linux/Unix administration and shell scripting.

Responsibilities

• Install, configure, upgrade, patch PostgreSQL and DB2 databases.
• Monitor and optimize SQL queries and indexes.
• Design and implement backup, recovery, and HA strategies.
• Provide L3 production support and incident management.
• Collaborate with application teams and cloud engineers.
• Lead migration and modernization projects.

Skills

PostgreSQL

DB2

Linux

Shell scripting

SQL optimization

Tools

AWS

Jenkins

Git

CI/CD

DB2 Monitoring

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