SQL Server Database Administrator

Koch•Wichita, KS

1d•Onsite

About The Position

Koch Ag & Energy Solutions, LLC. (KAES) is seeking a SQL Server Database Administrator to support SQL Server and other modern databases used across the company. The role is part of the Platform Engineering team, which supports, designs, and maintains technologies on premises and in the cloud. The DBA provides end-to-end database support, including implementation and architectural planning, and daily support of development and production systems. The position is expected to be based at KAES’s corporate office in Wichita, Kansas, and is not eligible for visa sponsorship. The administrator works with a team of DBAs to ensure database availability, apply patches, tune performance, manage backups and recovery, and troubleshoot database issues. KAES describes its culture as guided by its Principle Based Management philosophy, which informs everyday decision-making and gives employees opportunities to contribute and benefit from the value they create.

Requirements

Intermediate experience administering Microsoft SQL Server in production environments.
Scripting experience for task automation processes.
Hands-on experience with full, differential, and log backups and restores, including demonstrated ability to perform point-in-time restores.
Practical AWS experience with EC2, EBS, IAM, CloudWatch, and basic networking for database hosts.
Legally authorized to work in the United States.

Nice To Haves

Experience with other database technologies, including MongoDB, MySQL, Postgres, or DynamoDB.
Experience using tools and logs such as SQL Server logs, Extended Events, PerfMon, CloudWatch, or equivalent.
Database architectural design and planning experience.
AWS technology certifications.

Responsibilities

Troubleshoot database access issues and grant least-privileged access.
Apply security patches and updates to development, UAT, and production database servers, or support testing of those updates.
Review database and monitoring logs to troubleshoot performance or application issues.
Assist in planning database upgrades to accommodate business requirements.
Add disk space to Amazon EC2 instances or build new EC2 database servers.
Help end users resolve connectivity issues to supported databases.
Troubleshoot performance problems by identifying problematic queries or indexes and recommending solutions for system slowdowns.
Work with the DBA team to troubleshoot processes spanning multiple systems.
Automate log cleanup to preserve server disk space.
Document solutions in the knowledgebase.
Administer SQL Server and other modern databases across on-premises and cloud platforms, supporting development and production environments.