Senior Postgres/DB2 DBA

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