Advanced Engineer, Database Development and Automation

Pilot Company • Knoxville, TN

3h

About The Position

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
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.
Automation & IaC: Use tools like AWS CloudFormation, Terraform, or CDK to automate database provisioning, configuration, and scaling.
Performance Tuning: Monitor system health using Amazon CloudWatch and RDS Performance Insights. Tasks include query optimization, index tuning, and rightsizing instance types.
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.
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).
Backup & Disaster Recovery: Design and test high-availability (Multi-AZ) and disaster recovery (Cross-Region) strategies using AWS Backup and snapshots.
DevOps Integration: Collaborate with developers to integrate databases into CI/CD pipelines using tools like AWS CodePipeline or Jenkins.

Requirements

• 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).
• 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.
• 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.
• 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.
• 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

Responsibilities

• 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.
• Automation & IaC: Use tools like AWS CloudFormation, Terraform, or CDK to automate database provisioning, configuration, and scaling.
• Performance Tuning: Monitor system health using Amazon CloudWatch and RDS Performance Insights. Tasks include query optimization, index tuning, and rightsizing instance types.
• 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.
• 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).
• Backup & Disaster Recovery: Design and test high-availability (Multi-AZ) and disaster recovery (Cross-Region) strategies using AWS Backup and snapshots.
• DevOps Integration: Collaborate with developers to integrate databases into CI/CD pipelines using tools like AWS CodePipeline or Jenkins.
• High Availability & Disaster Recovery (HA/DR)
• Performance Tuning & Monitoring
• Security & Compliance
• Migration & Upgrades
• Cost & License Management

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed