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 #LI-SP3 #LI-VX1 </div

Requirements

Must-haves

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

Nice-to-haves

 Cloud platforms (AWS preferred)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

postgresawssqlci/cd

Platform: careers-page
Effort: medium