PostgreSQL Database Administrator (Consultant)- 10785315

Tasks

• Analyze workloads and identify bottlenecks
• Automate maintenance and health checks
• Collaborate on database design and schema review
• Design implement backup recovery strategies
• Develop and maintain monitoring backup automation scripts
• Document and test disaster recovery procedures
• Implement database security best practices
• Implement high availability and failover
• Install configure upgrade maintain PostgreSQL environments
• Investigate incidents and resolve database issues
• Maintain operational documentation and support procedures
• Manage database security roles and permissions
• Manage development testing production database instances
• Monitor access and security events
• Monitor database health and address issues
• Monitor performance and resource utilization
• Optimize SQL queries indexes configurations
• Perform patching version upgrades maintenance
• Perform root cause analysis for production problems
• Support deployments and database releases
• Tune database for performance and scalability
• Validate backups and perform recovery testing

Perks/Benefits

• N/A

Skills/Tech-stack

Access Control | Automation | Backup and Recovery | Database Statistics | Database monitoring | Database performance | Database performance tuning | Disaster Recovery | Execution Plans | Failover | High Availability | Indexing | Linux | Performance Tuning | PostgreSQL | Query Optimization | Replication | Resource Management | Role-Based Access | Role-Based Access Control | SQL | Security Management | Shell Scripting