Senior Database Administrator

Nutrien•Deerfield, IL

7d•Onsite

About The Position

Nutrien is a leading provider of crop inputs and services, and our business results make a positive impact on the world. Our purpose, Feeding the Future, is the reason we come to work each day. We’re guided by our culture of care and our core values: We put safety first. We act with integrity. We are stronger together. We deliver with excellence. Through the collective expertise of our nearly 26,000 employees, we operate a world-class network of production, distribution, and ag retail facilities. We efficiently serve growers' needs and strive to provide a more profitable, sustainable, and secure future for all stakeholders. Help us raise the expectation of what an agriculture company can be and grow your career with Nutrien.

Requirements

Bachelor's Degree in IT, Computer Science, or related field; experience may be considered in lieu of education
8+ years of hands-on PostgreSQL database administration, including internals (MVCC, autovacuum, WAL, buffer cache, query planner)
Strong SQL proficiency across PostgreSQL and Redshift
Solid experience with AWS data services: Aurora PostgreSQL, RDS, Redshift, DynamoDB, S3, DMS, Lambda
Proficient with Terraform (HCL) for infrastructure as code
Proficient with Python for automation and tooling
Experience with Liquibase or similar database migration tools
Competent with AWS CLI and AWS security (IAM, KMS, Secrets Manager, VPC networking)
Experience with database monitoring: pg_stat views, Performance Insights, CloudWatch, and Prometheus/Grafana-based observability
Experience with Git-based workflows, code review, and CI/CD (GitHub Actions)
Strong troubleshooting skills for complex database performance and connectivity issues
Enthusiasm for AI-assisted development and willingness to adopt AI tools and workflows

Nice To Haves

AWS Certified Database – Specialty
Experience with PostgreSQL extensions: PostGIS, postgres_fdw, pg_stat_statements, pgAudit
Experience with AWS DMS for migrations and change data capture (CDC)
Familiarity with Data Mesh architecture
Experience with AI coding assistants (Amazon Q, Kiro, Copilot) or building AI agents
Familiarity with Jira, Confluence, and Docker

Responsibilities

Administer Amazon Aurora PostgreSQL, Amazon RDS, and Amazon Redshift across multiple AWS accounts and environments supporting data product teams in a Data Mesh architecture
Provision and manage database infrastructure using Terraform modules (clusters, parameter groups, security groups, KMS, IAM auth, Secrets Manager, automated user/role creation)
Execute Database Change Requests (DBCRs): schema changes, data migrations, user/role management, and ad hoc SQL
Perform PostgreSQL major/minor version upgrades including pre-checks, extension upgrades, post-verification, and statistics regeneration
Manage database security: IAM authentication, roles, service accounts, credential rotation, security groups, VPC networking, and cross-account access
Build and maintain database monitoring using YACE CloudWatch exporter, Amazon Managed Prometheus (AMP), and Grafana dashboards and alerts
Manage schema migrations using Liquibase for both PostgreSQL and Redshift
Develop and maintain Python Lambda functions for database automation
Configure and manage Foreign Data Wrappers (postgres_fdw), AWS DMS, and RDS Proxy; support data migration and integration efforts across systems and platforms
Optimize query performance, indexes, and schema design in collaboration with application developers
Plan and execute backup/recovery strategies, disaster recovery testing, high availability configurations, and capacity planning
Create and maintain documentation, runbooks, and standard operating procedures
Participate in on-call rotation for production database incidents and perform occasional off-hours database upgrades and maintenance as needed