Senior Database Administrator (PRE-ID)

As a Senior Database Administrator, you will be responsible for the daily operation of our database
deployments around the world. This senior position requires a knowledge of technology that is both
broad and deep. You will install, configure, maintain, and monitor several different types of database
systems such as Microsoft SQL Server, MySQL, and PostgreSQL. You will also be responsible for
performance tuning through collaboration with global development groups and third-party support
organizations, data migration and lifecycle management, and disaster recovery and high available
designs to meet Lineages' internal availability targets. Lineage has a cloud first model so much of this
work will be done using AWS RDS and EC2 database technologies. As a successful Senior Database
Administrator, you will ensure our systems are secure, efficient, scalable, available, durable, and
maintainable.
At Lineage, the aim is not to build the largest IT group; instead, we are creating a small, highly-skilled
team that focuses on having right mix of talents, skills, and the capacity to learn in areas that define
our core differentiation. We then leverage cloud services, best-of-breed technologies, and external
teams to augment our capabilities with sufficient capacity. This means that in addition to being a great
architect, an ideal candidate will need to be able to review and collaborate with others - both internal
and external - to ensure that we are collectively able to deliver.
As a company, Lineage builds state-of-the-art systems to make our employees productive, to meet and
exceed our customers' expectations, to assist in our growth, and to create an operating platform that
enables Lineage to achieve its vision of transforming the food supply chain. This is one of the most
critical roles in that journey, and it will require someone who has a true passion for technology.

Primary Responsibilities

Responsible for the design, implementation, and maintenance of Lineage Logistics global database infrastructure.

Manages monitoring and alerting for performance and service availability.

Leads performance tuning activities

Responsible for data movement including backups, refreshes, and migrations, point-in-time restores, read replicas, Amazon S3 Bucket and Amazon Database Migration Services.

Manages Change Tracking and CDC configurations used for Data Lake population.

Pursues innovation and continuous improvement that enhances security, efficiency, scalability, availability, durability, and maintainability.

Collaborates with others to solve complex problems and resolve technological disagreement with informed, rational, practical solutions.

Mentors and provides guidance to other technical resources.

Job Requirements

Education and Work Experience

University degree in computer science, software engineering, or IT management and/or >10 years of relevant work experience.

10+ years of experience and expert level knowledge of Microsoft SQL Server.

AWS Cloud Practitioner certificate or 5+ years of experience with cloud platforms such as Amazon Web Services

3+ years of experience with at least one other database platform (Oracle, Postgres, MySQL).

Required Knowledge, Skills, and Abilities

Experience with SQL Always On Clusters and other Database High Availability Technologies

Experience with systems monitoring tools like Query Store, Extended Events, CloudWatch and those like Datadog or Solarwinds Orion

Ability to execute multi-system deployments simultaneously through scripting and SQL Registered Servers

Deep understanding of performance-based configurations tuned for ad-hoc query use, parallelism, and SQL memory allocation

Extensive focus on performance tuning with the ability to identify and resolve lock waits, blocking locks, lock chains, missing indexes, and top N queries

Familiarity with SQL Agent jobs, operators, and alerts for database maintenance and monitoring

Familiarity with networking and storage concepts and how they related to database platforms.

Strong scripting skills and experience with Infrastructure as Code: PowerShell, SQLCMD, T-SQL, AWS CLI.

Strong problem solving and troubleshooting skills.

Handle multiple assignments/projects simultaneously.

Possess a willingness to be coached and proactively seek feedback.

Ask for help and provide it to others.

Maintain personal accountability for getting things done on time and with quality results.

Demonstrate excellent verbal and written communication skills including the ability to explain technical concepts to business leaders.

Willingness to travel up to 20% of the time as required

Why Lineage?

This is an excellent position to begin your career path within Lineage! Success in this role enables greater responsibilities and promotions! A career at Lineage starts with learning about our business and how each team member plays a part each and every day to satisfy our customers' requirements. Beyond that, you'll help us grow and learn on our journey to be the very best employer in our industry. We'll ask you for your opinion and ensure we do our part to keep you developing and engaged as we grow our business. Working at Lineage is energizing and enjoyable. We value respect and care about our team members.

Lineage is an Equal Employment Opportunity Employer and is committed to compliance with all federal, state, and local laws that prohibit workplace discrimination and unlawful harassment and retaliation. Lineage will not discriminate against any applicant on the basis of race, color, age, national origin, religion, physical or mental disability or any other protected status under federal, state and local law.

Benefits

Lineage provides safe, stable, reliable work environments, medical, dental, and basic life and disability insurance benefits, 401k retirement plan, paid time off, annual bonus eligibility, and a minimum of 7 holidays throughout the calendar year.