Database Engineer III
Chennai
Engineering – Product Development /
On-site
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
Do you love optimizing database systems to unlock peak performance, integrity, and enable customers to experience innovative, data-driven solutions? Do you insist on the highest standards for the database activities performed by your team? Are you an advocate of fast database release cycle times, continuous delivery, and measurable quality? If this is you, then join an energetic team of Database Engineers building the next generation applications for PDI!
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.
As a Database Engineer, you will assist in the data design, reporting and export development, SQL writing for data definition and querying, DB monitoring, advanced MySQL tuning, backup, deployment packaging for lower environments, staging and production MySQL 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, 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 session with engineering teams for data restructuring and performing complex maintenance
- Deploy and manage changes in lower environments, staging and production
- Assist engineers and product owners on SQL queries and tuning
- Perform scheduled maintenance
- 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
- 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/Terragrunt/AWS RDS CLI/Jenkinsfiles)
- Schema changes / Migrations (Perform routinely scheduled database deployments that support the various Application/API enhancements being delivered into a live production environment.)
- 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 and administering MySQL databases
- Solid experience working with the services found in the AWS cloud. Other cloud provider experience is also a plus.
- 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 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
- Security awareness required. Knowledge of data and user access principles and concepts.
- Solid scripting skills (Bash/Jenkinsfile/Python,etc) 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
- Strong written and verbal communication & can translate technical concepts into non-technical terms.
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.