Database Engineer III

At PDI Technologies, we empower some of the world's leading convenience retail and petroleum brands with cutting-edge technology solutions that drive growth and operational efficiency.

By “Connecting Convenience” across the globe, we empower businesses to increase productivity, make more informed decisions, and engage faster with customers through loyalty programs, shopper insights, and unmatched real-time market intelligence via mobile applications, such as GasBuddy. We’re a global team committed to excellence, collaboration, and driving real impact. Explore our opportunities and become part of a company that values diversity, integrity, and growth.

Role Overview

Responsible for the planning, development, and administration of database systems to ensure high performance, security, and reliability. The position involves working closely with software developers, data teams, and other stakeholders to support the organization's data needs. Core duties include optimizing database performance, troubleshooting issues, managing data integration processes, and ensuring robust backup and recovery protocols. Strong background in SQL, data modeling, ETL, and database performance tuning, along with a good understanding of best practices for database security. 

Key Responsibilities

• Provide recommendations and participate in design session with engineering teams for data restructuring and performing complex maintenance 
• Monitor database management systems as well as evaluating database performance to maximize efficiency 
• Perform and propose archiving, partitioning 
• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues. 
• Actively seek to optimize and simplify our architecture 
• Actively track database resource cost usage and look for ways to minimize costs while maximizing resource usage. 
• Expert in Infrastructure as Code in relation to Databases(Terraform/Terr grunt/AWS RDS CLI/Jenkins files) 
• Ability to design, document, test and deliver solutions that may involve data manipulation and/or data migration (inbound/outbound). An emphasis on accuracy, efficiency and execution time is critical. 
• Would be nice: Sanitizing and transferring data between environments
• Ability to design, document, test and deliver solutions to accurately and rapidly setup database environments for special projects, developer/qa teams or for support of application bug/maintenance projects.
• Would be nice: Creating versions of the databases that could run locally 

Qualifications

• Expert in MySQL, proficient with DynamoDB 
• Solid experience working with the services found in the AWS cloud. Other cloud provider experience is also a plus. 
• Experience with AWS Glue, Airflow, Athena 
• Working experience with using Jira as ticket management tool and Bitbucket repositories. 
• Highly motivated and proactive self-starter with a desire to help others and take action 
• Requires strong written and verbal communication skills with the ability to translate technical concepts into non-technical terms 
• Ability to socialize ideas and influence decisions without direct authority 
• Collaborative in nature with a strong desire to dig in and learn independently as well as through asking questions 
• Considers ‘best-practice’ standards, as well as departmental policies and procedures 
• Security awareness required. Knowledge of data and user access principles and concepts. 
• Solid scripting skills (Bash/Jenkins file/Python) in one, or many, languages or tools would be extremely helpful. Automation of daily/routine tasks would be desirable so that more energy can be directed toward higher priority tasks. 
• Expertise in import and export activity 
• Design and implementation of Data Partitioning 
• Ability to participate in multiple projects concurrently 
• 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 

Behavioral Competencies

• Ensures Accountability
• Manages Complexity
• Communicates Effectively
• Balances Stakeholders
• Collaborates Effectively 

PDI is committed to offering a well-rounded benefits program, designed to support and care for you, and your family throughout your life and career. This includes a competitive salary, market-competitive benefits, and a quarterly perks program. We encourage a good work-life balance with ample time off [time away] and, where appropriate, hybrid working arrangements. Employees have access to continuous learning, professional certifications, and leadership development opportunities. Our global culture fosters diversity, inclusion, and values authenticity, trust, curiosity, and diversity of thought, ensuring a supportive environment for all.