Job Specifications
Role- Progress DB SME
Location- London, UK (Hybrid)
Employment type- Contract
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,
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 maintainained 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.
About the Company
We provide Software Development, Maintenance and Other Related IT Services, across spectrum, depending on individual client’s needs and dependability on us. Being a young and vibrant software solution company, we believe in harnessing the talent and experience of each member of our team to provide a unique flavor to our offerings within practical considerations and as per need and flexibility as expressed by our clients.
We believe in working as a true partner and demonstrate transparency in all our dealings and conduct wi...
Know more