About this role
Already a Kwik Trip Coworker? Follow this link to apply: myapps.kwiktrip.com
Location: Department 759
Shift: Daytime
Experience: 3-5 years
Full Pay Range: $85,633.60 to $128,450.14
Actual pay will be based on various factors, such as a candidate’s qualifications, skills, competencies, proficiency for the role, and internal equity. In addition to base pay, Kwik Trip gives 40% of pre-tax profits back to our coworkers with bonuses ranging from 8-12% of each coworker’s gross annual wage depending on company profitability and offers a comprehensive benefits package, including health insurance, 401k, paid time off, and more.
Database Administrator 3
Kwik Trip’s Network Services Department is seeking a Database Administrator 3 .
What you’ll be doing…
As a Database Administrator 3, you will be an experienced technical member of the DBA team responsible for supporting, securing, and improving Kwik Trip’s database environment, primarily Microsoft SQL Server, both on-prem and Azure.
Responsibilities include:
- Maintain, support, and continually improve Kwik Trip’s SQL Server and database environments.
- Serve as a technical escalation resource for complex database incidents, performance issues, production problems, and high-risk changes.
- Install, configure, upgrade, patch, migrate, and maintain database platforms while supporting lifecycle and capacity planning.
- Monitor and optimize database performance using Query Store, execution plans, indexing, statistics, monitoring tools, and other diagnostic techniques.
- Design, support, and test backup, recovery, High Availability, and Disaster Recovery solutions, including Always On Availability Groups and log shipping.
- Work with Security and other IT teams to maintain database security, encryption, certificate, privileged access, and data protection standards.
- Help create and maintain Database Administration standards, procedures, documentation, and the DBA technology roadmap.
- Partner with application teams, business areas, infrastructure teams, and vendors to design, implement, and troubleshoot database solutions.
- Identify opportunities to automate recurring DBA activities and improve standardized database deployments through PowerShell, T-SQL, Flyway, CI/CD, and other automation technologies.
- Provide technical guidance and mentoring to other Database Administrators while promoting cross-training and knowledge sharing.
- Participate in project planning and provide technical input related to database architecture, performance, security, availability, and recoverability.
- Participate in an on-call rotation and provide after-hours support for critical production database systems as needed.
You’ll need to have:
- Associate degree in Information Systems, Network Administration, Computer Science, or an equivalent combination of education and relevant database administration experience.
- Strong hands-on experience administering Microsoft SQL Server in enterprise production environments.
- Experience with SQL Server installation, configuration, upgrades, migrations, patching, performance tuning, backup, and recovery.
- Strong knowledge of SQL Server High Availability and Disaster Recovery technologies.
- Experience troubleshooting complex database, application, performance, and availability issues.
- Working knowledge of database security, permissions, encryption, certificates, and least-privilege access.
- Strong T-SQL skills and experience using database diagnostic and performance tools.
- Ability to independently prioritize and manage production support, project, maintenance, and strategic responsibilities.
- Strong analytical, problem-solving, communication, and documentation skills.
- Strong attention to detail and the ability to make sound technical decisions in business-critical environments.
Even better if you have:
- PowerShell and database administration automation experience.
- Experience with Redgate SQL Monitor, Flyway, database source control, or CI/CD pipelines.
- Experience with Microsoft Azure database technologies.
- Experience supporting MySQL, PostgreSQL, or other database platforms.
- Experience with SSRS and SSIS.
- Experience with enterprise certificate management, TLS, or database encryption.
- Familiarity with Jira, ServiceNow, Agile, and Scrum methodologies.
Work Schedule
Monday through Friday, primarily daytime hours. Weekend and after-hours work may be required for maintenance, production changes, migrations, or critical incidents. This position participates in the DBA on-call rotation.
Kwik Trip, Inc. is a family-owned, Midwest company, in operation since 1965. We are dedicated to serving our guests and coworkers while treating everyone like family. Along with our award-winning culture, we are proud to be an Equal Opportunity Employer. Learn more about Kwik Trip and our culture.
Learn more about.... (https://jobs.kwiktrip.com/us/en/about-us)