Sql product owner

Job Summary:

The IT Operations Application Maintenance Product Owner is responsible for understanding application capabilities and how they support business needs. This critical role will focus on database integration and management of our client's Pro2SQL database replication application. The Product Owner collaborates with the IT Manager and business sponsor to develop the product roadmap and documents business rules, interface requirements, and product user stories. A key initiative includes implementing and managing Pro2 database integrations and ensuring data integrity and consistency.

The Product Owner is continuously involved in the product's lifecycle, from conception to post-production phases, ensuring the Pro2 database replication application aligns with business goals and delivers high value.

location: Telecommute

job type: Contract

salary: $65 - 90 per hour

work hours: 9am to 5pm

education: Bachelors

Responsibilities:

Responsibilities:

Ideation Phase

• Coordinate with stakeholders to understand database integrations and replication needs and requirements.
• Document integration and replication requirements, and implementation plan.
• Engage with database and application development teams for replication and data consistency requirements.
• Work with support teams to improve data synchronization and replication efficiency.
• Own and refine product requirements and user stories.
• Evaluate and prioritize the backlog of features.
• Determine product capability roadmap with the IT Operations team and business sponsor.
• Assess the need for changes or enhancements in database replication, working with stakeholders.
  
  

Project Delivery Phase

• Manage the product backlog for Pro2SQL replication features and issues.
• Ensure the design and implementation of database replication is complete and valid.
• Document business requirements, user stories, and configuration changes.
• Maintain JIRA board for database related projects, creating appropriate stories and features.
• Engage business stakeholders for user acceptance testing.
• Produce Release Notes focusing on database replication updates.
• Ensure team adherence to timelines and quality standards.
• Maintain continuous engagement with stakeholders, ensuring solutions align with Pro2SLQ integration and replication needs.
  
  

Pilot / Rollout / Post-Production Phases

• Facilitate communication between stakeholders for database replication-related work.
• Manage product backlog aligned with database replication outcomes and customer value.
• Gather and analyze user feedback during rollout phases and make necessary adjustments to the strategy.
• Ensure the quality of integrated systems meets predetermined standards.
• Assist in QA of implementations when necessary.
• Plan and oversee integrations' release, ensuring a smooth transition from development to production environments.
• Ensure effective communication with all stakeholders regarding schedules and changes.
  
  

Requirements/Qualifications:

Progress OpenEdge Platform :

Deep understanding of OpenEdge database architecture, including Change Data Capture (CDC) and trigger-based replication.

Familiarity with OpenEdge ABL (Advanced Business Language) and schema design.

Pro2 Architecture :

Knowledge of Pro2 replication flow: ReplQueue, CDC threads, multi-threaded replication, and bulk loading. Understanding of Pro2's UX dashboard, Replication Wizard, and job runner features.

SQL Server & Oracle:

Strong grasp of Microsoft SQL Server and Oracle database structures, performance tuning, and replication targets.

Experience with Azure SQL Server (VM-hosted preferred over serverless due to performance limitations).

Database Design & Optimization - Ability to design normalized and denormalized schemas, optimize indexes, and manage large datasets for performance and scalability.

Troubleshooting & Root Cause Analysis - Skilled in diagnosing data sync issues, latency problems, and system errors across Pro2SQL, and SQL environments.

SQL Server Proficiency - Strong command of SQL Server, including writing complex queries, stored procedures, views, and performance tuning.

Data Integration & ETL Knowledge- Experience with data extraction, transformation, and loading (ETL) processes between external systems using Pro2SQL or similar tools.

Education/Experience Requirements:

• Bachelor's Degree in Computer Science, Project Management, or related field.
• Minimum of 3-5 years of professional experience.
• Ideal candidate will have experience analyzing and supporting Progress OpenEdge database system integration and replication processes.
• Candidate should have excellent written and verbal communication skills and be comfortable communicating with all levels of the organization.
• Candidate should operate autonomously requiring little direction from the manager on daily tasks.
  
  

Qualifications:

Requirements/Qualifications:

Progress OpenEdge Platform:

Deep understanding of OpenEdge database architecture, including Change Data Capture (CDC) and trigger-based replication.

Familiarity with OpenEdge ABL (Advanced Business Language) and schema design.

Pro2 Architecture:

Knowledge of Pro2 replication flow: ReplQueue, CDC threads, multi-threaded replication, and bulk loading. Understanding of Pro2's UX dashboard, Replication Wizard, and job runner features.

SQL Server & Oracle:

Strong grasp of Microsoft SQL Server and Oracle database structures, performance tuning, and replication targets.

Experience with Azure SQL Server (VM-hosted preferred over serverless due to performance limitations).

Database Design & Optimization- Ability to design normalized and denormalized schemas, optimize indexes, and manage large datasets for performance and scalability.

Troubleshooting & Root Cause Analysis- Skilled in diagnosing data sync issues, latency problems, and system errors across Pro2SQL, and SQL environments.

SQL Server Proficiency- Strong command of SQL Server, including writing complex queries, stored procedures, views, and performance tuning.

Data Integration & ETL Knowledge- Experience with data extraction, transformation, and loading (ETL) processes between external systems using Pro2SQL or similar tools.

Education/Experience Requirements:

• Bachelor's Degree in Computer Science, Project Management, or related field.
• Minimum of 3-5 years of professional experience.
• Ideal candidate will have experience analyzing and supporting Progress OpenEdge database system integration and replication processes.
• Candidate should have excellent written and verbal communication skills and be comfortable communicating with all levels of the organization.
• Candidate should operate autonomously requiring little direction from the manager on daily tasks.
  
  

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.