Progress DBA & Release Management

Fresher

Not Disclosed

Early Applicant

Job Description

Job Description:

Responsibilities:

Database Administration:

Manage and support Production, QA, and Development environments for PostgreSQL and Progress 4GL databases
Monitor and manage database backups and ensure proper data growth management
Refresh Dev, Test, and Preprod environments by syncing them with the Live environment
Tune database performance by analyzing and optimizing query execution, index usage, and general database configurations

Database Operations:

Perform Database Dump and Load operations, including experience with Progress database management
Ensure data integrity and consistency across different environments (Dev, Test, Preprod, and Production)
Troubleshoot database-related issues, especially around code deployments, compilation, and their interaction with the database
Collaborate closely with the Development Team, providing support for database-related queries, optimizations, and issues

Monitoring & Performance Tuning:

Use PROMON and other tools to regularly perform database health checks
Proactively monitor database performance and make adjustments to ensure optimum functionality
Experience in tuning performance issues and implementing changes when necessary
Knowledge of Appserver and Webspeed to optimize the performance of Progress-based applications

SQL Server Support (Optional but helpful):

Release & Deployment Support:

Prepare runbooks for production releases, outlining all steps and procedures for application deployment and database changes
Assist in Release Management by coordinating deployment schedules and ensuring that deployment goes smoothly
Handle deployment issues, ensuring the release process is seamless across all environments

Key Skills Required:

Experience managing both PostgreSQL and Progress 4GL databases
Expertise in database backups, restores, and data refreshes across environments
In-depth experience with database performance tuning (e.g., query optimization, indexing)
Familiarity with Progress 4GL queries, Appserver, and Webspeed
SQL Server management skills (backup, restore, etc.) are a plus
Experience with release management and writing/maintaining runbooks