Database Administrator

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. We are keenly aware that the technology diversity in the marketplace and its impact in business are ever increasing. KAES IT continues to understand, synthesize, and recommend technologies that will enhance the value KAES can create for our customers. The KAES DBA is an IT Professional who will have the ability to troubleshoot and diagnose database issues. In this role, 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.

Koch Ag & Energy Solutions (KAES) is a leading innovator in value-added solutions for the agriculture, energy, and chemical markets. Our Platform Engineering team provides advanced support, design, and maintenance for technologies both on premises and in the cloud. As a Database Administrator on this team you will provide beginning to end support of our databases including implementation/architectural planning, and daily support.

This role is not eligible for Visa Sponsorship

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