Onsite DBA – SQL Server & PostgreSQL (1st Shift)

Koch Foods; Peoria (IL); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

401(k) plan

Health, dental, and vision insurance

Short-term and long-term disability

Life insurance policy

Weekly pay

On-the-job training

Promotional career opportunities

PPE provided

Team events and cook-outs

Job summary

Koch Foods is seeking a Database Administrator for the 1st shift onsite team in a typical office environment. You will manage SQL Server and PostgreSQL across development, test, and production, with a focus on performance, security, and reliability.

You will partner with developers and infrastructure teams, implement DR and HA solutions, automate tasks with PowerShell, Bash, and Python, and contribute to data governance and compliance efforts.

Qualifications

• Bachelor's degree or equivalent professional experience.
• 3+ years in SQL Server and/or PostgreSQL administration in production.
• Certifications are a plus.
• Familiarity with AI tools for query tuning, documentation, or troubleshooting is preferred.
• Strong expertise in installation, configuration, and performance optimization of SQL Server and PostgreSQL.
• Excellent problem-solving skills and ability to resolve complex DB issues quickly.
• Meticulous data integrity, security settings, and documentation discipline.
• Ability to explain technical concepts to both technical and non-technical audiences.
• Knowledge of data security, encryption, and compliance frameworks.
• Proficiency in PowerShell, Bash, or Python for automation.
• Experience with SSIS and SSRS.
• Strong collaboration across teams and adaptability across DB platforms.
• Ownership mindset and reliability, including on-call responsiveness.
• Commitment to continuous learning and staying current with DB features.

Responsibilities

• Install, configure, upgrade, and support SQL Server and PostgreSQL in development, test, and production.
• Monitor performance, tune queries/indexes/configs to improve throughput.
• Design and validate backup, recovery, and DR strategies.
• Manage database security, permissions, encryption, and auditing.
• Plan migrations, upgrades, and patching with minimal disruption.
• Collaborate with developers on schema design, data modeling, and integration best practices.
• Implement high-availability and replication (Always On, PostgreSQL streaming).
• Create and maintain documentation for DB architecture and DR plans.
• Enforce data governance standards and retention policies.
• Respond to and resolve incidents, including off-hours support.
• Automate routine admin tasks with PowerShell, Bash, and Python.
• Capacity planning for storage/memory/compute; scalability recommendations.
• Stay informed on new DB technologies and vendor patches.
• Support audits with documentation and evidence of controls.

Skills

SQL Server Admin

PostgreSQL Admin

Scripting (PowerShell)

Scripting (Python)

Scripting (Bash)

Data security

Encryption

On-call support

Communication

Performance tuning

Collaboration

Education

Bachelor's degree in Computer Science/Information Systems or related field

Tools

SSIS

SSRS

SQL Server Management Studio (SSMS)

Always On Availability Groups

PostgreSQL replication tools

Job description

Koch Foods is seeking a Database Administrator for the 1st shift onsite team in a typical office environment. You will manage SQL Server and PostgreSQL across development, test, and production, with a focus on performance, security, and reliability.

You will partner with developers and infrastructure teams, implement DR and HA solutions, automate tasks with PowerShell, Bash, and Python, and contribute to data governance and compliance efforts.