Progress DBA & Release Management Professional

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):

• Manage

  SQL Server

  instances using

  SQL Server Management Studio

  (SSMS).
• Perform regular

  backup and restore

  operations for SQL Server databases.

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

  .