SQL Server Database Administrator

Koch Ag & Energy Solutions, LLC; Wichita (KS); On-site; USD 90,000 - 120,000; Full time

Job summary

Koch Ag & Energy Solutions, LLC. (KAES) is seeking a SQL Server Database Administrator to support our SQL Server and modern databases that serve KAES users across on-prem and cloud platforms.

You will join a team of DBAs to ensure high availability, patching, performance tuning, backup/recovery, and production support. Our culture emphasizes practical, principle-based decision making, with opportunities to contribute and grow within a global KAES technology team.

Qualifications

• Intermediate experience administering Microsoft SQL Server in production environments.
• Scripting for task automation processes.
• Backups and restores (full/diff/log) and point-in-time restores.
• AWS: EC2, EBS, IAM, CloudWatch and basic networking for database hosts.
• Legally authorized to work in the United States.

Responsibilities

• Troubleshoot access issues and grant least-privilege access to databases.
• Apply security patches/updates to dev/uat/prod database servers.
• Review database/monitoring logs for troubleshooting performance issues.
• Assist in planning database upgrades to meet business needs.
• Add disk space to an Amazon EC2 instance or build a new EC2 database server.
• Help end users with connectivity issues to a supported database.
• Troubleshoot performance issues and optimize queries or indexes.
• Automate log cleanup to preserve server disk space.
• Document solutions in the knowledgebase.

Skills

SQL Server administration

Scripting

Backups and restores

AWS basics

Troubleshooting

Performance tuning

Tools

SQL Server

CloudWatch

EC2

IAM

Job description

Your Job

Koch Ag & Energy Solutions, LLC. (KAES) is seeking a SQL Server 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.

Your Job

Koch Ag & Energy Solutions, LLC. (KAES) is seeking a SQL Server 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.

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 systemsAutomate 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
• Legally authorized to work in the United States.

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. Any compensation range provided for a role is an estimate determined by available market data. The actual amount may be higher or lower than the range provided considering each candidate's knowledge, skills, abilities, and geographic location.

Hiring Philosophy

All Koch companies value diversity of thought, perspectives, aptitudes, experiences, and backgrounds. We are Military Ready and Second Chance employers. Learn more about our hiring philosophy here.

Who We Are

As a Koch company, Koch Ag & Energy Solutions (KAES) is a global provider of value-added solutions for the agriculture, turf and ornamental, energy and chemical markets. From agriculture to energy, KAES makes things grow better with plant nutrient and biological technologies. Our team of innovators unleash their potential while developing the technologies that feed and power the world.

At Koch, employees are empowered to do what they do best to make life better. Learn how our business philosophy helps employees unleash their potential while creating value for themselves and the company.

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.

• 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.

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.

Equal Opportunities

Equal Opportunity Employer, including disability and protected veteran status. Except where prohibited by state law, some offers of employment are conditioned upon successfully passing a drug test. This employer uses E-Verify.