PostgreSQL DBA Professional
Job Description
• Manage and maintain PostgreSQL database environments to ensure high availability and performance.
• Perform database administration tasks including physical and logical backups, database restore, and access control management.
• Handle PostgreSQL major and minor version upgrades with minimal downtime.
• Monitor database performance and implement tuning strategies for optimized system efficiency.
• Manage user roles, permissions, and database security configurations.
• Support and execute data migration activities across database environments.
• Write and optimize complex SQL queries for performance and reporting requirements.
• Utilize AppDynamics tools for performance monitoring and issue identification.
• Troubleshoot database-related issues and provide effective resolution to maintain business continuity.
• Collaborate with application and infrastructure teams to ensure seamless database operations.
• Analyze system performance trends and recommend improvements for scalability and reliability.
• Maintain database documentation and follow best practices for database administration and monitoring.
