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
As a Database Engineer, you will partner with a team of software engineers in the design, development, and maintenance of our database system for new and existing PDI solutions. The system will be used internally by the engineering teams, and externally by our customers for production applications.
You will assist in the data design, reporting and export development, SQL writing for data definition and querying, DB monitoring, advanced SQL tuning, backup, deployment packaging for lower environments, staging and production SQL Server databases. You will be responsible for supporting the database needs of a fast-growing business and therefore must be comfortable regularly interacting with business and engineering teams. You will spend most of your time on design, definition, SQL writing, documentation, maintenance, and long-range planning. You will also help with development and adapting frameworks and industry best practices, executing unit and performance testing.
Key Responsibilities
* Plan work to meet project deadlines, accommodate demands by development teams, set priorities and escalate issues appropriately.
* Monitor database management systems as well as evaluating database performance to maximize efficiency.
* Work in an environment that practices strict change management.
* Provide recommendations and participate in design sessions with engineering teams for data restructuring and performing complex maintenance.
* Deploy and manage changes in lower environments, staging, and production.
* Perform scheduled maintenance.
* Strong on T-SQL methods for optimization of existing complex stored procedures for performance improvements and contention resolution.
* Rewrite stored procedures when necessary.
* Manage database install, configure, monitor and upgrade towards production and non-production environments.
* Perform and propose archiving, partitioning.
* Implement technical support for enterprise monitoring, backup, alerting, and security compliance for SQL instances.
* Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues.
* Actively seek to optimize and simplify our architecture.
* Assist engineers and product owners on SQL queries and tuning.
Qualifications/Experience/Skills
* Highly motivated 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 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.
* 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.
* 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 skills sets, and the ability to understand new technologies quickly are essential.
* Working knowledge of Agile/Scrum and participates in all Agile/Scrum ceremonies.
Behavioral Competencies
* Ensure accountability.
* Manages Complexity.
* Optimizes work processes.
* Communicate effectively.
* Collaborates.
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 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.
#J-18808-Ljbffr