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
#LI-SP3
#LI-VX1
More Information
Application Details
- Organization DetailsTCS / Tata Consultancy Services
Recommended Comments
There are no comments to display.
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.