Progress DBA & Release Management

As a Database Administrator, you will be responsible for managing and supporting Production, QA, and Development environments for PostgreSQL and Progress 4GL databases. Your key responsibilities include: - Monitor and manage database backups to ensure data integrity and proper data growth management. - Refresh Dev, Test, and Preprod environments by syncing them with the Live environment. - Analyze and optimize query execution, index usage, and general database configurations to tune database performance. - Perform Database Dump and Load operations, including experience with Progress database management. - Troubleshoot database-related issues, especially around code deployments, compilation, and their interaction with the database. - Collaborate closely with the Development Team to provide support for database-related queries, optimizations, and issues. Additionally, you will be involved in: - Using PROMON and other tools to regularly perform database health checks. - Proactively monitoring database performance and making adjustments to ensure optimum functionality. - Implementing changes for tuning performance issues and optimizing the performance of Progress-based applications using Appserver and Webspeed. - Optionally, managing SQL Server instances using SQL Server Management Studio (SSMS) and performing regular backup and restore operations for SQL Server databases. Furthermore, you will play a vital role in: - Preparing runbooks for production releases to outline all steps and procedures for application deployment and database changes. - Assisting in Release Management by coordinating deployment schedules and ensuring a seamless release process across all environments. - Handling deployment issues effectively to ensure a smooth release process. Key Skills Required: - Experience in managing both PostgreSQL and Progress 4GL databases. - Expertise in database backups, restores, and data refreshes across environments. - In-depth experience with database performance tuning, including query optimization and indexing. - Familiarity with Progress 4GL queries, Appserver, and Webspeed. - SQL Server management skills (backup, restore, etc.) are advantageous. - Experience with release management and writing/maintaining runbooks.,