Database Administrator

• As the Platform Database Administrator (DBA) for Aurora, serve as the architectural and operational anchor for high-scale database environments.
• Bridge the gap between technical data layers and production feature engineering.
• Take full ownership of database performance tuning, optimization strategies, and system reliability across core software suites.
• Sustain consistent system performance and reliability across 400+ database schemas, managing comprehensive schema migrations and tracking client-specific data growth metrics.
• Supervise AWS Aurora-specific environments, orchestrating cluster endpoint routing configurations, managing failover behaviors, executing parameter tuning, and troubleshooting data warehouse / read replica lags.
• Apply deep knowledge of InnoDB core internals to manage lock behaviors, resolve complex lock contentions, adjust buffer pool parameters, and systematically reduce purge lags across write-heavy database clusters.
• Diagnose and optimize heavy database pipelines utilizing INSERT...SELECT queries and computed-table patterns.
• Analyze Aurora instance utilization models against pricing factors to right-size compute resources and minimize I/O waste stemming from unoptimized queries.

Platform Database Administrator, Aurora/MySQL

• Assist in managing AWS RDS instances by monitoring database health, identifying performance issues, and participating in root-cause investigations
• Participate in a rotating on-call schedule to ensure 24/7 database availability and rapid response to production incidents across our global infrastructure
• Execute quarterly patching, monthly index reviews, and backup integrity testing within a live production environment
• Advance your T-SQL knowledge by participating in code reviews and assisting Developer and TechOps teams with query optimization and execution
• Utilize Python, PowerShell, and other scripting languages to build or maintain automation tools (e.g., AWS Lambdas, GitHub Action workflows, etc.)
• Manage user permissions, SOPs, and disaster recovery runbooks while helping ensure regulatory framework compliance (including HIPAA, HITRUST, and SOC2) across all database systems

Junior Database Administrator

• Develop conceptual, logical, and physical data models to support new and existing ODOT applications using DB2, MS SQL Server, Oracle, and other platforms.
• Design secure, efficient data exchange solutions for both batch and real-time processing across cloud and in-house systems.
• Define and enforce policies, procedures, and best practices for data modeling, storage, and governance.
• Conduct profiling, analysis, and performance tuning to maintain high-quality, reliable databases.
• Manage relational databases, metadata repositories, and enterprise schemas while ensuring regulatory compliance and system security.
• Provide input on data sharing, integration, and analytics initiatives, including infrastructure for reporting, AI/ML, and data products.
• Coordinate complex software installations, version upgrades, and migrations across distributed environments.
• Work with IS staff, vendors, and business units to assess needs, solve problems, and align technology with agency goals.
• Develop and execute database backup, recovery, and disaster recovery plans to minimize downtime to system failures, assist users with data issues, and train staff on database tools and best practices.

See all jobs on JobTailor

Platform Database Administrator, Aurora/MySQL

Junior Database Administrator

Senior Database Administrator