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
