Database Administrator Lead

HealthFirst - Saving Lives•Mukilteo, WA

3h•Hybrid

About The Position

We are seeking an experienced Database Administrator Lead to architect, implement, and maintain MySQL/SQL databases, including performance tuning, and adhering to back-up and archiving schedules. As well, reviewing and approving programmatic changes prior to code deployment. This role requires expertise in database administration, performance optimization, and troubleshooting to ensure the reliability, availability, and security of critical data infrastructure. The ideal candidate will collaborate with developers, system administrators, and business stakeholders to support and optimize database operations.

Requirements

Experience with SQL including high availability configurations.
Strong knowledge of MySQL & SQL database definition, design, and configuration.
Proven expertise in SQL administration, including creating tables, indexes, views, stored procedures, and other database objects.
Experience using performance monitoring and diagnostic tools.
Basic understanding of Windows OS environments and network structure.
Experience with deployment of code.
Excellent problem-solving and communication skills with the ability to work collaboratively across multiple teams.
Experience with data processing flowcharting techniques and technical documentation.
Strong track record in Azure Post environments.
Strong expertise in Azure Cloud services and related infrastructure.
Management and mentoring of a resource focused on reporting.
10+ years of experience in IT, including database administration, system administration, or application development.

Nice To Haves

Bachelor’s degree in Computer Science, Engineering, or a related field.

Responsibilities

Database Management: Maintain, configure, and implement MySQL/SQL databases to ensure optimal performance and reliability.
Managed access control and data security through Azure Active Directory integration and role-based access.
Archiving and Purging: Execute and manage database archiving and purging as per requirements across multiple databases and systems.
Backup & Recovery: Execute and manage database backups, restores, and disaster recovery strategies.
Monitoring & Alerts: Review alerts, analyze performance issues, and generate reports for proactive database management.
MSSQL server and MySQL Administration: Assist in component installations, including database, Analysis Services, Reporting Services, in standalone and clustered environments.
Documentation: Create and maintain documentation of processes, DBA tasks, and business application workflows.
Performance Optimization: Assist developers in identifying and resolving performance bottlenecks, including query optimization and index tuning.
Stored Procedures & Scripting: Write, troubleshoot, and optimize complex stored procedures to support application development.
Working with the business to define and then own the MDM (Master Data Model). Collaborate with the team and cross-functional areas to architect and establish a new Data Lake.
Research & Recommendations: Conduct research and provide recommendations on database products, services, protocols, and standards.
Migrated on-premises SQL Server databases to Azure using Data Migration Assistant (DMA) and Azure Database Migration Service (DMS).
User Training & Support: Develop guidelines and routines for the best database practices and assist business users with reporting needs.
Report Development: Generate reports based on business requirements using Server Reporting Services (SSRS) or other reporting tools.
Maintain up-to-date knowledge of modern technologies, tools, and methodologies related to integration development.
Create ad-hoc queries to support business decision-making.
Other duties as assigned.