Senior Database Administrator

AutoTec LLC; Birmingham, Northern (AL, KY); Hybrid; USD 100,000 - 140,000; Full time

Job summary

AutoTec LLC is seeking a dedicated Senior Database Administrator to own health, performance, security, and recoverability of on-premises SQL Server and AWS RDS Aurora PostgreSQL, plus an AWS data lake/analytics stack (S3, Glue, Athena, QuickSight). You will mentor the data team and drive upgrades, monitoring, and automation.

You will manage backups, HA/DR, security, and performance improvements across platforms, with runbooks and incident response responsibilities as a core duty.

Qualifications

• Bachelor's degree or equivalent in CS/Engineering
• 5+ years of hands-on production DBA experience
• Deep production experience with SQL Server (2016+) HA/DR, backup/recovery, and tuning
• Production experience administering PostgreSQL including vacuum/bloat management
• AWS experience: RDS/Aurora, S3, Glue, Athena, CloudWatch
• Scripting proficiency in PowerShell, Bash, or Python
• Strong written communication and ability to document runbooks
• Ability to work independently and in a team environment

Responsibilities

• Own installation, configuration, patching, and upgrade planning for all on-premises SQL Server instances
• Administer SQL Server high availability and disaster recovery (Always On Availability Groups / FCI), including failover testing and DR runbooks
• Own AWS RDS Aurora Serverless v2 cluster configuration
• Design, implement, and routinely test backup and recovery on both platforms against documented RTO/RPO targets
• Tune performance on both platforms via wait statistics, execution plans, Query Store, and index/statistics strategy
• Monitor databases and manage alerting via Extended Events, DMVs, Performance Insights, CloudWatch
• Own the connection management strategy (RDS Proxy) for serverless scaling
• Plan and execute engine version upgrades with Blue/Green deployments for Aurora
• Administer database security – least-privilege, encryption, auditing, IAM, Secrets Manager
• Administer the S3 data lake - partitioning, lifecycle policies, formats like JSON/Parquet
• Manage AWS Glue crawlers and the Glue Data Catalog to keep data lake schemas current
• Support analysis/visualization in QuickSight – datasets from Athena and Postgres
• Govern Aurora costs and explain cost anomalies to leadership
• Create/runbooks for safe DBA operations by non-experts
• Automate recurring tasks with PowerShell, Bash, or Python
• Assist development teams with schema review and data migrations
• Own incident response for outages and post-incident reviews
• Perform capacity planning for storage/memory/compute

Skills

Analytical mindset

Detail oriented

Self-motivated

Team collaboration

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

SQL Server

PostgreSQL

AWS (RDS, Aurora)

S3, Glue, Athena, QuickSight

CloudWatch, IAM, Secrets Manager

PowerShell

Bash

Python

Terraform

DMS, Babelfish

Job description

Job Details

Job Location: Headquarters - Birmingham, AL 35209Position Type: Full Time

A dedicated senior Database Administrator who serves as the organization’s database expert, owning the health, performance, security, and recoverability of our on-premises Microsoft SQL Server and AWS RDS Aurora Serverless v2 (PostgreSQL) platforms, along with our AWS data lake and analytics stack (S3, Glue, Athena, and QuickSight). Working alongside others on the data team who handle routine maintenance and first-line troubleshooting, own the deep work - upgrades, high-availability, recovery, security, and performance - build the runbooks, monitoring, and automation that keep the database estate safe, and mentor the team to take on more over time.

Qualifications

• Own installation, configuration, patching, and upgrade planning for all on-premises SQL Server instances
• Administer SQL Server high availability and disaster recovery (Always On Availability Groups / Failover Cluster Instances), including failover testing and DR runbooks
• Own AWS RDS Aurora Serverless v2 (PostgreSQL) cluster configuration - ACU min/max capacity, parameter groups, reader instances, and failover priorities
• Design, implement, and routinely test backup and recovery on both platforms against documented RTO/RPO targets, including point-in-time recovery drills
• Tune performance on both platforms - wait statistics, execution plans, Query Store, index and statistics strategy, and pg_stat_statements analysis
• Manage PostgreSQL internals - autovacuum tuning, bloat remediation, and transaction ID wraparound prevention
• Monitor databases and manage alerting via Extended Events, DMVs, Performance Insights, Enhanced Monitoring, and CloudWatch
• Own the connection management strategy (RDS Proxy or equivalent pooling) appropriate to serverless scaling behavior
• Plan and execute engine version upgrades on both platforms, including Blue/Green deployments for Aurora major versions
• Administer database security - least-privilege access, encryption, auditing, IAM authentication, and Secrets Manager rotation
• Administer the S3 data lake - transactional and semi-structured data stored in JSON and Parquet, including storage layout, partitioning strategy, and lifecycle policies
• Manage AWS Glue crawlers and the Glue Data Catalog to keep data lake schemas current and queryable, and tune Athena query performance and cost (partitioning, file formats, workgroups)
• Support data analysis and visualization in Amazon QuickSight - administer datasets sourced from Athena and Postgres, including connectivity, permissions, and refresh performance
• Govern Aurora costs - monitor ACU consumption, right-size capacity settings, and explain cost anomalies to leadership
• Author and maintain runbooks that allow non-experts to safely perform routine database operations
• Automate recurring database work using PowerShell, Bash, or Python
• Support development teams with schema review, query optimization guidance, and data migrations across both platforms
• Own incident response for database outages, including escalations to AWS support as needed, and conduct post-incident reviews
• Perform capacity planning for database storage, memory, and compute
• Gather an expert understanding of the AutoTec products

• Bachelor's degree in Computer Science, Engineering, or related field. Experience may be considered in lieu of the degree
• 5+ years of hands-on production DBA experience, including significant time as a primary or sole DBA
• Deep production experience with SQL Server (2016 or later): HA/DR, backup/recovery, and performance tuning at the wait-statistics and execution-plan level
• Production experience administering PostgreSQL, including vacuum/bloat management and query tuning
• Professional experience in AWS, specifically: RDS/Aurora, S3, Glue, Athena, CloudWatch, IAM, Secrets Manager
• Demonstrated history of performing (not just configuring) restores and failovers
• Scripting proficiency in at least one of PowerShell, Bash, or Python
• Strong written communication - this role produces documentation others depend on
• Able to be self-motivated and directed
• Detail oriented, analytic mindset with strong technical & problem-solving skills
• Able to work independently and in a team-orientated, collaborative environment
• Able to prioritize, multitask, and handle shifting priorities
• Able to build and maintain relationships
• Adaptable and resilient through a changing environment

• Aurora experience, particularly Aurora Serverless v2
• Experience supporting data lake and analytics workloads - columnar formats (Parquet), partitioning strategies, and query engines such as Athena or Presto/Trino
• Microsoft SQL or AWS certifications
• Experience with infrastructure-as-code (Terraform preferred)
• Experience migrating workloads between SQL Server and PostgreSQL (AWS DMS, Babelfish)
• Experience operating in a regulated or audited environment
• Knowledge of Agile Methodologies
• Experience estimating AWS pricing and system costs