Senior Database Administrator

at Nutrien Ag Solutions, Inc in Deerfield, Illinois, United States

Job Description

Job Description

Job Title: 
 
 Senior Database Administrator

Requisition ID: 
 
 31834

Location: 
 
 Deerfield, IL, USA, 60015

Workplace Type: 
 
 On-Site

Experience Level: 
 
 Associate

Job Type: 
 
 Full Time

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.

What You'll Do:

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

What You'll Bring:

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
Preferred Technical Experience:
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

Compensation & Benefits:
The salary range for this role, in Deerfield, IL, is between $110,400 - $173,470. While we provide this range as general guidance, several factors are taken into consideration when making compensation decisions including, but not limited to, candidate skill set, experience and training, licensure and certifications, work location, and other business and organizational needs. Actual salary and benefits may differ based upon... For full info follow application link.

The company is an equal opportunity employer that is committed to creating an inclusive workplace.  We evaluate qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, genetic information, national origin, disability, veteran status, and other legally protected characteristics