Advanced Engineer, Database Development and Automation

Company Description

Pilot Company is an industry-leading network of travel centers with more than 30,000 team members and over 750 retail and fueling locations in 44 states and six Canadian provinces. Our energy and logistics division serves as a top supplier of fuel, employing one of the largest tanker fleets and providing critical services to oil operations in our nation's busiest basins. Pilot Company supports a growing portfolio of brands with expertise in supply chain and retail operations, logistics and transportation, technology and digital innovation, construction, maintenance, human resources, finance, sales and marketing.

Founded in 1958 by Jim A. Haslam II and currently led by CEO Adam Wright, our founding values, people-first culture and commitment to giving back remains true to us today. Whether we are serving guests, a fellow team member, or a trucking company, we are dedicated to fueling people and keeping North America moving.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status or any other characteristic protected under applicable federal, state, or local law.

Military encouraged to apply.

Job Description

Database Engineer is responsible for designing, implementing, and managing data storage solutions on the Amazon Web Services platform and traditional DBAs activities of managing databases on physical hardware

Core Roles & Responsibilities related to cloud databases on AWS

1. Database Architecture & Design: Define and implement scalable, resilient data architectures. This includes selecting the right engine for the workload, such as Amazon RDS, Postgres, Aurora, DynamoDB, or Redshift.
2. Automation & IaC: Use tools like AWS CloudFormation, Terraform, or CDK to automate database provisioning, configuration, and scaling.
3. Performance Tuning: Monitor system health using Amazon CloudWatch and RDS Performance Insights. Tasks include query optimization, index tuning, and rightsizing instance types.
4. Security & Compliance: Implement least-privilege access using AWS IAM, manage encryption with KMS, and ensure compliance with standards like SOC 2 or HIPAA using AWS Config and Audit Manager.
5. Data Migration: Plan and execute migrations from on-premises environments to the cloud using tools like AWS DMS (Database Migration Service) and the Schema Conversion Tool (SCT).
6. Backup & Disaster Recovery: Design and test high-availability (Multi-AZ) and disaster recovery (Cross-Region) strategies using AWS Backup and snapshots.
7. DevOps Integration: Collaborate with developers to integrate databases into CI/CD pipelines using tools like AWS CodePipeline or Jenkins.

Qualifications

1. High Availability & Disaster Recovery (HA/DR)

• Always On Availability Groups: Architecting and maintaining Multi-AZ deployments. On RDS, this is automated; on EC2, you must manually configure Windows Failover Clustering and AGs.
• Backup Management: On RDS, managing automated snapshots and point-in-time recovery. On EC2, scheduling native .bak backups to Amazon S3 and managing transaction log truncation.
• DR Drills: Periodically testing cross-region failover and restoration to ensure compliance with Recovery Time Objectives (RTO). 

1. Performance Tuning & Monitoring

• Query Optimization: Using SQL Server Management Studio (SSMS), Execution Plans, and Extended Events to identify and fix slow-running queries.
• Index & Statistics Maintenance: Scheduling jobs to rebuild/reorganize indexes and update statistics to prevent performance degradation.
• Cloud-Specific Tuning: Monitoring Provisioned IOPS (PIOPS) and storage throughput to ensure the underlying AWS EBS volumes are not bottlenecking the database. 

2. Security & Compliance

• Identity Management: Integrating SQL Server logins with AWS Managed Microsoft AD (Active Directory) for Windows Authentication.
• Encryption: Implementing Transparent Data Encryption (TDE) and managing encryption keys via AWS KMS.
• Auditing: Configuring SQL Server Audit specifications to track sensitive data access, with logs offloaded to Amazon CloudWatch Logs. 

3. Migration & Upgrades

• Schema Conversion: Using the AWS Schema Conversion Tool (SCT) for heterogeneous migrations or migrating from on-premises to AWS.
• Patch Management: Testing and applying Cumulative Updates (CUs) and Service Packs. On RDS, you define maintenance windows for AWS to apply these; on EC2, you handle the full installation. 

4. Cost & License Management

• License Optimization: Choosing between License Included (LI) and Bring Your Own License (BYOL) models to minimize costs.
• Consolidation: Using AWS Optimization and Licensing Assessment (OLA) to right-size instances and reduce core-based licensing expenses