SENIOR DATABASE ADMINISTRATOR

Job Description Job Title: Senior Database Administrator Requisition ID: 31841 Location: Calgary, AB, CAN, T2J 7E8
| Saskatoon, SK, CAN, S7K 5R6
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.

• 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

• 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