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