About PDI
PDI helps convenience retailers and petroleum wholesalers thrive through digital transformation and enterprise software that enables them to grow topline revenue, optimize operations and unify their business across the entire value chain.
Over 1,500 customers in more than 200,000 locations worldwide count on our leading ERP, logistics, fuel pricing and marketing cloud solutions to provide insights that increase volume, margin, and customer loyalty. For more than 35 years, our comprehensive suite of solutions and unmatched expertise have helped customers reimagine their enterprise and deliver exceptional customer experiences. Backed by the investment of TA Associates, Genstar, and Insight Partners, PDI is embarking upon an aggressive expansion strategy through internal investment in development as well as intensive M&A activity. In the past five (5) years PDI has completed over 20 acquisitions to build a far broader, more powerful, global company that more fully serves the needs of our customers across their entire supply chain.
The Opportunity
The Data Engineer II will assist in the architecture, maintenance, monitoring, advancement, tuning, business continuity planning, backup and recovery testing of the company’s development, staging and production Databases. The candidate’s job activities will include database development, definition, structure, documentation, maintenance, long-range planning, and operational guidelines and data security. The candidate will also help with development and adapting frameworks and industry best practices, executing unit and performance testing.
Primary Responsibilities
• Rewrite and review complex stored procedures when necessary following advanced SQL best practices.
• Provide recommendations and participate in design sessions with engineering teams for data restructuring and performing complex maintenance.
• Design and implement processes and solutions for data distribution and data archiving.
• Plan work to meet project deadlines, accommodate demands by development teams, set priorities, and escalate issues appropriately.
• Provide recommendations to development teams for data restructuring.
• Assist development and dev ops teams on SQL queries and tuning.
• Understand replication technologies. Transactional Replication, AlwaysOn availability groups and Log-Shipping.
Qualifications
• Experience in SQL Database Administrator (SQL DBA)
• Working experience with using ADO as ticket management tool
• Retail and wholesale petroleum industry knowledge & experience is good to have
• Experience in Powershell Automation in automating SQL Server related tasks
• Expertise in MS-BI – Development and Administration (ETL Jobs, SSIS, SSRS)
• Expertise in import and export activity
• Expertise in MS SQL Server
• Expertise in SQL Programming skills
• Design and implementation of Data Partitioning
• Optimization of hardware configuration to SQL configuration
• Ability to participate in multiple projects concurrently
• Excellent communication skills (verbal, written and presentation), customer service-oriented
• Strong problem-solving skill set, and the ability to understand new technologies quickly are essential
• Working knowledge of Agile/Scrum and participates in all Agile/Scrum ceremonies
• Highly motivated self-starter with a desire to help others and take action
• Strong written and verbal communication & can translate technical concepts into non-technical terms
• Ability to independently work as a contributing member in a high-paced and focused team
• Ability to multi-task and prioritize tasks with competing deadlines
• Strong problem-solving and analytical skills with the ability to work under pressure
• Ability to socialize ideas and influence decisions without direct authority
• Considers ‘best-practice’ standards, as well as departmental policies and procedures.
Top Skills
What We Do
PDI is a fast-paced company that promotes strong values and a high-performance culture. We are proactive, detail-oriented, and committed to maximizing our efforts to drive results for our customers, the company and each other. Our company aspires to create an “awesome” team by attracting, developing and growing our talent. We value hard work and foster a fun and collaborative atmosphere that encourages sharing knowledge and building skill sets.
PDI helps convenience retailers and petroleum wholesalers thrive through digital transformation and enterprise software that enables them to grow topline revenue, optimize operations and unify their business across the entire value chain. Over 1,500 customers in more than 200,000 locations worldwide count on our leading ERP, logistics, fuel pricing and marketing cloud solutions to provide insights that increase volume, margin and customer loyalty. PDI owns and operates the Fuel Rewards® loyalty program that is consistently ranked as a top-performing fuel savings program year after year. For more than 35 years, our comprehensive suite of solutions and unmatched expertise have helped customers of any size reimagine their enterprise and deliver exceptional customer experiences.
Our Solutions:
Fuel Pricing: From B2B to fuel retailers, PDI offers fuel pricing solutions to optimize profitability while streamlining the pricing process in a volatile fuel market.
Marketing Cloud: PDI offers marketing cloud solutions to help retailers gain a competitive advantage, attract and retain more loyal customers and drive the greatest financial success.
ERP: Reimagine your operations and empower your back office with ERP solutions that unify and transform the industry’s fastest-growing convenience retailers and petroleum marketers.
Logistics: PDI offers comprehensive petroleum logistics solutions that help you maximize productivity and profits while increasing visibility and control from the rack to the pump.
.jpeg){kind=icon}
.JPG)
