Database Administrator

Your Job 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 ™ 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 headquarters in Wichita, Kansas. Our Team Koch Ag & Energy Solutions (KAES) is a leading innovator in value-added solutions for the agriculture, energy, and chemical markets. Our Team 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 Our Benefits Our goal is for each employee, and their families, to live fulfilling and healthy lives. We provide essential resources and support to build and maintain physical, financial, and emotional strength - focusing on overall wellbeing so you can focus on what matters most. Our benefits plan includes - medical, dental, vision, flexible spending and health savings accounts, life insurance, ADD, disability, retirement, paid vacation/time off, educational assistance, and may also include infertility assistance, paid parental leave and adoption assistance. Specific eligibility criteria is set by the applicable Summary Plan Description, policy or guideline and benefits may vary by geographic region. If you have questions on what benefits apply to you, please speak to your recruiter. Additionally, everyone has individual work and personal needs. We seek to enable the best work environment that helps you and the business work together to produce superior results. #J-18808-Ljbffr