Senior Postgres/DB2 DBA

Senior Postgres/DB2 DBAPostgreSQL/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.Location: San Antonio, TXSalary Range: $95,000-$110,000 a year