Database Administrator

Koch Ag & Energy Solutions, LLC. (KAES) is seeking a Database Administrator to support our SQL Server and modern databases that serve a variety of KAES users. As a database administrator in KAES, you will work with a team of DBAs to administer SQL Server and other modern databases, ensuring high availability, patching, performance tuning, backup/recovery, and supporting development and production systems across on-prem and cloud platforms.

Our culture is defined by the Principle Based Management ™ philosophy which guides everyday decision making and provides employees with opportunities to contribute and personally benefit from the value they create.

This role is expected to be based at our corporate office in Wichita, Kansas.

What You Will Do

• Troubleshoot access issues, grant least privileged access to databases
• Apply security patches/updates to dev/uat/prod database servers for end users or support to test
• Review database/monitoring logs for troubleshooting performance or application issues
• Assist in planning database upgrades accommodating business requirements
• Add disk space to an Amazon EC2 instance or building a new EC2 database server
• Help an end user with a connectivity issue to a supported database
• Troubleshoot performance issues, identifying problematic queries or indexes and providing solutions for system slowdowns
• Work with your team to troubleshoot a process through multiple systems
• Automate log cleanup to preserve server disk space
• Documenting solutions in the knowledgebase

Who You Are (Basic Qualifications)

• Intermediate experience administering Microsoft SQL Server in production environments
• Scripting for task automation processes
• Hands-on experience with backups and restores (full/diff/log), and demonstrated ability to perform point-in-time restores.
• AWS practical experience: EC2, EBS, IAM, CloudWatch and basic networking for database hosts

What Will Put You Ahead

• Experience with other database technologies, MongoDB, MySQL, Postgres, DynamoDB
• Experience using tools/logs (SQL Server logs, Extended Events, perfmon, CloudWatch or equivalent).
• Database architectural design/planning
• AWS technologies certifications

At Koch companies, we are entrepreneurs. This means we openly challenge the status quo, find new ways to create value and get rewarded for our individual contributions.