What are the responsibilities and job description for the Database Administrator position at Simplot?
The J.R. Simplot Company is a diverse, privately held global food and agriculture company headquartered in Boise, Idaho. We are a true farm-to-table company with an integrated portfolio including food processing and food brands, phosphate mining, fertilizer manufacturing, farming, ranching and cattle production, and other enterprises related to agriculture.
Summary
The Data Platform Administration Team is seeking an accomplished PostgreSQL and SQL Server Database Administrator to join our talented group in Boise, Idaho. In this position, you will contribute to maintaining the platforms of a complete value chain from source systems to modern analytics platforms. We are looking for an administrator to establish standards and develop automation to care for a variety of database platforms while sharing knowledge with teammates and peer teams. With a large on-premises environment, we are seeking an innovative and driven administrator interested in providing outstanding support and furthering our data-driven culture as we manage our current environments and grow into our Cloud architecture.
Key Responsibilities
- Administer and support SQL Server RDBMS environments (Windows)
- Administer and support PostgreSQL RDBMS environments (Windows / Linux)
- Administer and support Db2 RDBMS environments (Windows / IBMi)
- Build, and maintain standards-based, reliable data platform solutions for the global enterprise.
- Establish patching and version update plans to comply with (and provide input into) security, change management, and other applicable policies.
- Collaborate with other Simplot Technology teams on their data-related needs including advanced support of application databases
- Work with vendors and managed-service providers to enable their data-related needs/services and ensure their compliance with Simplot standards and policies
- Monitor for DB server health, database performance, and other indicators of potential issues and attempt to address them preemptively
- Refresh lower environments, perform database restores, and conduct regular disaster recovery simulations
- Utilize Azure DevOps for work item management, knowledge management (wiki), CI/CD automation, and source control
- Strengthen team capabilities into Azure-deployed RDBMS platforms
- Coordinate and prioritize the shared work item backlog with global DBA partners
- Participate in architectural/code reviews, produce documentation, and contribute to company-wide standards
- Cultivate cross-functional, collaborative relationships with Data Owners/Stewards and IT Professionals
- Communicate technical and business topics to key Business Stakeholders
- Manage and prioritize time across project, support, and enhancement initiatives
- Participate in L3 production support and incident response for our team’s globally deployed, 7x24 environments
Typical Education
- Bachelor's Degree (B.A. or B.S.) from 4 year college or university
Relevant Experience
- 5-8 years related experience and/or training with PostgreSQL
- 5-8 years related experience and/or training with SQL Server
-
Subject matter expertise in PostgreSQL on Linux
- Administration, maintenance, and performance (LCM, configuration, security, backup and recovery, tuning, etc.)
- Advanced experience with Microsoft SQL Server administration, LCM, maintenance, performance, and high availability
- Experience with PowerShell is strongly desired
- Experience with RDBMS platforms in Azure is desired
- Experience with PostgreSQL High Availability is desired
- Experience with PostgreSQL on Windows is desired
- Experience with IBM Db2 on Windows is desired
- Experience with PowerBI is a plus
- Experience with other open source RDBMS platforms is a plus
- Experience with Microsoft SSAS, SSIS, SSRS is a plus
- Experience with IBM Db2 on IBMi is a plus
- A collaborative, team focus and a passion for people
- The inclination to continuously learn and to evolve your technical skills
- The willingness to teach and to mentor
- The desire to work on truly challenging, global-scale problems and standardization
- #LI-MH1
Job Requisition ID: 20634
Travel Required: Less than 10%
Location(s): Simplot Headquarters - Boise
Country: United States
**The J.R. Simplot Company is proud to be an Equal Opportunity Employer and will consider all qualified applicants for employment without regard to race, color, religion, national origin, ancestry, age, sex, gender, gender identity, gender expression, genetic information, physical or mental disability, medical condition, sexual orientation, military or veteran status, marital status, or any other protected status. **
