Database Administrator

• Administer and maintain MS SQL Server across production and development environments.
• Recommend, design, and build out of new database systems cluster and high availability groups.
• Design and implement database solutions integrated with modern data lake storage and analytics platform.
• Automate routine administrative tasks using scripting languages (PowerShell/Python).
• Identify tools and resources to monitor SQL Server activity and provide key statistics and performance measures.
• Analyzes and troubleshoots problems related to SQL Server Environment.
• Maintains SQL Server plans for DR planning and business continuity including backup verification and restore testing.
• Designs and documents database architecture and standards.
• Perform capacity planning and forecasting to meet growing business and data demands.
• Design, recommend and implement appropriate storage to ensure optimum performance and availability of all database servers.
• Provide 24/7 support for critical situations.
• Develops security measures and policies for SQL Server to prevent unauthorized access.
• Protect personal health information (PHI) while fulfilling the above duties and responsibilities.

Senior 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

Database Administrator jobs in Montana

See all jobs on JobTailor

Senior Database Administrator

Platform Database Administrator, Aurora/MySQL

Junior Database Administrator