Senior Postgres/DB2 DBA — Tata Consultancy Services, San Antonio, TX

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