Job Specifications
Role: Progress DB SME
Location: London
Exp: 20-25yrs
Job Type: Contract - Hybrid
Job Description:
Overall 25 years of IT Experience with last 5 years handling mission critical progress databases
Conduct regular, in-depth analysis of database performance, growth trends, and architecture to anticipate future needs and prevent potential issues before they arise.
Develop and present data-driven recommendations for performance tuning, capacity planning, and architecture modernization to senior leadership.
Should have Architected and designed robust, scalable, and high-availability solutions for the Progress OpenEdge environment, including disaster recovery and replication strategies.
Implement and manage advanced monitoring tools (like ProTop) to track database health and performance metrics in real-time.
Experienced in analyzing Virtual System Tables (VSTs), query execution plans, and application code (ABL) interactions to identify and resolve performance bottlenecks.
Fine-tune database parameters, indexing strategies, and storage area layouts to ensure optimal performance and resource utilization.
Should have Designed, implemented, and rigorously done enterprise-wide backup and restore in progress environment
Own the DR plan for all Progress databases, conducting periodic drills to ensure business continuity.
Implement and enforce database security policies, manage user access, and work with security teams to ensure data is protected and compliant with industry standards.
Hands on experience in performing essential maintenance tasks including schema updates, index rebuilds, data dumps/loads, and storage management.
Should have developed and maintained scripts (Shell, Python, etc.) to automate routine DBA tasks, reducing manual effort and risk.
Deep knowledge of Progress OpenEdge database architecture version 12.x.
Proven expertise in designing and managing backup, restore, and disaster recovery solutions using PROBKUP, PROREST, and RFUTIL.
Extensive experience in performance tuning, using VSTs, DBTOOL, and other analysis techniques.
Proficiency with Progress DBA utilities and the Proenv shell.
Strong scripting skills in Shell (bash/ksh), Perl, or Python for automation.
Solid understanding of the underlying Linux/Unix operating systems.
Excellent verbal and written communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.