Sr. Database Administrator

At Traction Ag, we're not just redefining farm management; we're revolutionizing it through our all-encompassing, cloud-based software solutions. With an innovative and forward-thinking approach that seamlessly integrates farm accounting, payroll, and a suite of agronomic tools and empowers progressive farmers to unlock true operational efficiency and profitability, we're setting new standards in the industry. Our commitment lies in providing unparalleled insights into the cost of production, inventory tracking, and detailed profitability analysis, all designed to elevate the modern agricultural enterprise. Traction Ag is actively seeking a senior database Administrator with expertise in Postgres to join our growing Engineering team. You will manage, maintain, optimize, and secure our infrastructure's 27 Postgres database instances. You should be well-versed in the AWS ecosystem, including cost management. Finally, you should understand data warehousing well with experience working with and supporting products like Redshift. What You'll Do Database Optimization : Tune and optimize Postgres database performance using advanced techniques to support high transaction volume and complex query workloads. Maintenance & Upgrades : Perform regular database maintenance tasks, including backups, restoration, and upgrades, ensuring no downtime for clients. Security : Establish and maintain robust database security practices, including but not limited to role-based access controls, encryption, and vulnerability assessments. Problem-Solving : Quickly address database-related incidents and provide long-term solutions to prevent recurrence. Capacity Planning : Analyze and predict future database capacity requirements and proactively plan for scalable solutions. Collaboration : Work closely with cross-functional teams to understand data needs and deliver infrastructure that supports enterprise applications. Innovation : Continuously explore and integrate emerging database technologies and methodologies to enhance Traction Ag's data offerings. How You'll Qualify Minimum of 10 years of experience in database administration with at least 3 years of deep technical expertise in PostgreSQL. Proficiency and knowledge working with and in AWS and their varying services focused on securing and delivering data solutions. Proven experience in managing large-scale databases, particularly serving cloud-based SaaS products. Expert understanding of SQL, query analysis, and performance tuning in Postgres. Strong grasp of database principles, backup and recovery techniques, and replication strategies. Expertise in PostgreSQL database management, tuning, backup, and recovery. Competency in SQL and PL/pgSQL programming languages. Proficiency in managing database security, replication, and scalability issues. Experience with Linux and shell scripting. Knowledge of modern database monitoring tools and techniques. Excellent problem-solving and analytical skills. Strong planning and organizational abilities. Ability to work in a fast-paced, evolving environment while maintaining high standards of accuracy and confidentiality. Excellent communication skills, both written and verbal, capable of conveying complex information in a straightforward, understandable manner. A keen interest in agriculture technology and a passion for leveraging data to solve real-world problems. What We Offer Remote First Environment Flexible Work Schedule Competitive and cost-effective benefits plans - Health, Dental, Vision, and Life Insurance 401(k) Plans with Company Match Unlimited Paid Time Off Paid Holidays Joining Traction Ag is like planting a seed in the fertile ground-the growth potential is immense. Your work will sprout, bloom, and bear the fruit of impact in an industry that feeds the world. We're more than just a software company. We're a team committed to making a real difference in the agricultural sector. We empower farmers with real-time data and mobile-friendly tools to make informed decisions, optimize operations, and boost profitability. As part of our team, you'll play a crucial role in shaping the future of farming and be supported in your own growth and development. So, are you ready to embark on this exciting journey with us? Apply today! Traction Ag, Inc. is an Equal Opportunity Employer dedicated to fostering a diverse work environment where all employees are valued and respected. We celebrate diversity and are committed to creating an inclusive atmosphere for people of every race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status, and all other unique characteristics that make each of our team members exceptional. We believe in providing equal opportunities for employment, growth, and advancement for everyone. We recognize that our company thrives when we embrace the richness of ideas and perspectives that come from a diverse workforce. At Traction Ag, hiring, promotions, and career development decisions are based solely on qualifications, performance, skills, and experience. We're committed to ensuring that all employment practices are free from any discrimination. If you share our passion for pioneering advancement in farm management software and possess a drive to turn challenges into opportunities, we would love to hear from you.

Created: 2024-10-19