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.
- Robust 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)