Progress / QAD Database Administrator

Key Responsibilities

• Administer and maintain Progress OpenEdge/QAD databases across development, test, and production environments.
• Perform database refreshes, migrations, and environment cloning activities.
• Monitor and optimize database performance, including table, index, and query tuning.
• Manage backup, recovery, and Disaster Recovery (DR) processes to ensure high availability.
• Handle database growth through extent additions and storage planning.
• Implement database security, access controls, and compliance standards.
• Troubleshoot and resolve database-related issues promptly.
• Collaborate with application, infrastructure, and functional teams to support QAD ERP operations.
• Prepare and maintain DBA documentation, SOPs, and audit artifacts.

Required Skills

• 5+ years of hands-on experience as a Progress/QAD Database Administrator.
• Strong experience supporting:
• QAD Enterprise Edition (EE)
• QAD Standard Edition
• Progress OpenEdge databases
• Strong understanding of Progress OpenEdge RDBMS architecture and DBA activities.
• Experience with Unix/Linux environments.
• Hands-on expertise in:
• Database installation and configuration
• Database setup and upgrades
• Backup & Recovery
• Disaster Recovery (DR) and Replication
• Extent management
• Storage planning
• Schema additions
• Dump & Load activities
• Experience generating and analyzing:
• Database reports
• Table reports
• Index reports
• Performance reports
• Ability to maintain secure, reliable, and high-performing production databases.

Domain

• Manufacturing
• ERP (QAD ERP supporting Manufacturing, Supply Chain, and Finance)