Advanced Engineer, Database Development and Automation

Knoxville, TN - USA

Monthly Salary: Not Disclosed

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Department:

Information Technology (IT)

Job Summary

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.

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

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

Remote Work :

Employment Type :

Full-time

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 hardwareCore Roles & Responsibilities related to cloud databases on AWSDatabase Architecture & Design:...

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.

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

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

Remote Work :

Employment Type :

Full-time

Key Skills

Continuous Integration
APIs
Automotive software
Test Cases
Electrical Engineering
Junit
Distributed Control Systems
Testng
Java
Test Automation
Programmable Logic Controllers
Selenium

Apply Now

About Company

Pilot Company

Are you passionate about team building, customer service, and meeting new people? Pilot Company offers a dynamic environment where no two days are the same. Team members have the opportunity to build an inclusive atmosphere with their co-workers and make a better day for every type of ... View more

View Profile View Profile

AI AutoApply

Apply to 100+ jobs with one click