Sysco LABS Sri Lanka

THE BIG PICTURE

Sysco LABS is the captive innovation center for Sysco Corporation (NYSE:SYY), a Fortune 100 company and the world’s largest foodservice provider with 71,000+ associates, 330+ distribution centers and over 725,000 customers in 90 countries. For fiscal 2023 that ended July 1, 2023, Sysco generated over $76 billion in sales.

Sysco LABS powers Sysco’s farm-to-fork operations and our technology is present in the sourcing of food products, merchandising, storage and warehouse operations, order placement and pricing algorithms, the delivery of food and supplies to Sysco’s global network, the in-restaurant dining experience of the end-customer and much more.

Our technology ecosystem spans 600+ applications, monitoring and incident management across 10,000+ servers, multi-cloud – multi-platform event streaming and microservices architecture, and enterprise-grade systems that power a catalog of over 1.4 million products, 330+ distribution centers and a fleet of 14,000 IoT-enabled delivery trucks, and more.

Everything we do at Sysco LABS supports Sysco’s Purpose of ‘Connecting the world to share food and care for one another’, and our technology directly impacts millions of food consumers in a trillion-dollar, global industry.

THE OPPORTUNITY

We are seeking a skilled Database Administrator with experience in data engineering to join our team. The ideal candidate will have 3 to 5 years of relevant experience and will be responsible for managing and maintaining our AWS Redshift data warehouse and AWS Aurora PostgreSQL databases. This role will play a key part in ensuring the availability, performance, security, and scalability of our data infrastructure.

RESPONSIBILITIES

Manage and maintain AWS Redshift data warehouse and AWS Aurora PostgreSQL databases, including installation, configuration, monitoring, performance tuning, backup, recovery, and security.
Collaborate with data engineering and analytics teams to gather and analyze data requirements, design data models, and implement data solutions to support business operations and applications.
Design, develop, and maintain ETL processes to extract, transform, and load data into AWS Redshift and AWS Aurora PostgreSQL databases from various sources.
Analyze and identify inefficient SQL queries by reviewing query execution plans, identifying long-running queries, and profiling query performance using query monitoring tools.
Develop and implement SQL query optimization techniques such as rewriting queries, optimizing joins, and reducing data movement to minimize query execution time and resource consumption.
Evaluate and optimize indexing strategies by identifying appropriate columns for indexing, creating and maintaining indexes, and periodically reviewing index usage and effectiveness.
Optimize data distribution and partitioning strategies based on workload patterns, query access patterns, and data distribution skew to minimize data movement during query execution and improve parallel processing performance.
Collaborate with data engineering and analytics teams to review and optimize ETL processes, including data extraction, transformation, and loading operations, to minimize data processing latency and maximize throughput.
Implement best practices and performance optimization techniques recommended by AWS documentation, whitepapers, and community forums to ensure efficient use of resources and maximize query performance across both AWS Redshift and AWS Aurora PostgreSQL environments.
Continuously monitor the health and performance of the database systems
Implementing proactive monitoring strategies to detect and address potential issues, such as hardware failures, resource contention, or configuration errors, before they impact system availability or performance.
Establishing and enforcing data validation checks, constraints, and referential integrity rules to maintain the accuracy and consistency of the data stored in the databases.
Monitoring the execution of ETL jobs, tracking job status, duration, success/failure rates, and data quality metrics, and implementing automated alerting mechanisms to notify relevant stakeholders of any anomalies or failures.
Defining performance SLAs for database systems and ETL processes based on business requirements and user expectations, and regularly monitoring performance metrics to ensure they meet or exceed predefined targets.
Conducting regular reviews and analysis of performance trends and historical data, identifying opportunities for optimization and improvement to enhance system efficiency and meet evolving business needs.
Implement and enforce database security policies and procedures, including access controls, encryption, and compliance with regulatory requirements.
Automate routine database administration and ETL tasks using scripting languages and automation tools.
Document database configurations, ETL processes, data flows, and best practices.

REQUIREMENTS

Bachelor’s degree in Computer Science, Information Technology, or related field.
3 to 5 years of experience as a Database Administrator or similar role, with experience in data engineering.
Experience managing and maintaining AWS Redshift and/or AWS Aurora PostgreSQL databases in a production environment.
Proficiency in SQL programming and performance tuning.
Experience designing, developing, and maintaining ETL processes.
Strong problem-solving skills, attention to detail, and ability to work independently as well as part of a team.
Excellent communication and interpersonal skills.
AWS certification(s) in Database specialty, Analytics specialty, or Data Engineering is a plus.

BENEFITS

US dollar-linked compensation
Performance-based annual bonus
Performance rewards and recognition
Agile Benefits - special allowances for Health, Wellness & Academic purposes
Paid birthday leave
Team engagement allowance
Comprehensive Health & Life Insurance Cover - extendable to parents and in-laws
Overseas travel opportunities and exposure to client environments 
Hybrid work arrangement

Sysco LABS is an Equal Opportunity Employer.