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