Job Description
Qualifications
Our Test Data Management Test is on the lookout for a talented and experienced Database Designer/Administrator with a robust background in AWS
We are looking for someone to be part of our team that to assist with cloud migration along with providing service and support for applications that are already there
Expertise in AWS: Proven experience with AWS services and their application in database management
Technical Proficiency: Strong skills in both logical and physical database design, building SQL and Stored Procedures
Resourcefulness and Customer Focus: A track record of being resourceful, customer-focused, and thriving in a team environment
Competitive candidates must have the following skills:
SQL skills and experience with database design and optimization
Utilize AWS services such as RDS, Aurora, DynamoDB, or Redshift to architect and manage cloud-based databases
Ability to translate and transform business requirements into data models (Conceptual, Logical and Physical)
Ensure database security, backup, and recovery processes are in place and tested regularly
Strong communication and collaboration skills
Use of creative intelligence and an entrepreneurial spirit to approach problem solving with the tools of questioning, associative thinking, observing, networking and experimenting to yield new/differentiated ideas for products, technologies, and processes
Benefits
Starting Salary is $+0,000 - $120,000 annually
Because work-life-balance is a priority at State Farm, compensation is based on our standard 38:45-hour work week!
Salary offered is dependent on skills and qualifications, with the high end of the range limited to applicants with significant relevant experience
At State Farm, we offer more than just a paycheck
Check out our suite of benefits designed to give you the flexibility you need to take care of you and your family!
On top of our competitive pay, you are eligible for an annual raise and bonus
Focus on you and your family’s health with our robust health and wellbeing programs
State Farm pays most of your healthcare premium, and we offer multiple healthcare plan options, including a high deductible plan
All medical plans provide 100% coverage for in-network preventative care, AND you and your family have access to vision, dental, telemedicine, 24/7 mental health professionals, and much more!
Take advantage of educational benefits like industry leading training programs, top-notch tuition assistance programs, employee resource groups, and mentoring
Plan for those big moments in life with benefits like fertility/IVF/adoption assistance, college coaching, national discount programs, interactive monthly financial workshops, free financial coaching, and more
You can also start a savings account or consider financing through our State Farm Federal Credit Union!
You will have access to our generous time off policies designed so you can plan around holidays, family events, volunteering, or just to take a relaxing day off
With the opportunity to initially earn up to 20 days annually plus parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service/education support days, there will be plenty of time for you!
Give Back!
We offer several ways to give back through our Matching Gift Program, Good Neighbor Grant Program, and the Employee Assistance Fund
Plan for retirement using free financial advisors and a 401(k) plan with company contributions of up to 7% of your salary
Responsibilities
Design, Implement, and Maintain: Develop and maintain our database systems, focusing on leveraging AWS services
Ensure Performance and Availability: Monitor database performance and ensure high availability, Performance, and reliability
Collaborate Closely: Work hand-in-hand with development and operations teams to support data-driven applications and solutions
Optimize Solutions: Continuously improve and optimize database designs for efficiency and scalability
Involves helping product teams with failover, security and other considerations as they move their applications to the cloud
Collaborate with development teams to design and optimize database schemas, queries, stored procedures for application performance
Includes tuning queries, reviewing SQL queries, indexing, and monitoring
Creating and changing tables and databases
Job description
Overview
Being good neighbors - helping people, investing in our communities, and making the world a better place - is who we are at State Farm. It is at the core of how we operate and the reason for our success. Come join a #1 team and do some good! Khakis optional. . .
Starting Salary is $+0,000 - $120,000 annually. Because work-life-balance is a priority at State Farm, compensation is based on our standard 38:45-hour work week! Salary offered is dependent on skills and qualifications, with the high end of the range limited to applicants with significant relevant experience.
At State Farm, we offer more than just a paycheck. Check out our suite of benefits designed to give you the flexibility you need to take care of you and your family!
Get Paid! On top of our competitive pay, you are eligible for an annual raise and bonus.
Stay Well! Focus on you and your family’s health with our robust health and wellbeing programs. State Farm pays most of your healthcare premium, and we offer multiple healthcare plan options, including a high deductible plan. All medical plans provide 100% coverage for in-network preventative care, AND you and your family have access to vision, dental, telemedicine, 24/7 mental health professionals, and much more!
Develop and Grow! Take advantage of educational benefits like industry leading training programs, top-notch tuition assistance programs, employee resource groups, and mentoring.
Plan Ahead! Plan for those big moments in life with benefits like fertility/IVF/adoption assistance, college coaching, national discount programs, interactive monthly financial workshops, free financial coaching, and more. You can also start a savings account or consider financing through our State Farm Federal Credit Union!
Take a Little “You” Time! You will have access to our generous time off policies designed so you can plan around holidays, family events, volunteering, or just to take a relaxing day off. With the opportunity to initially earn up to 20 days annually plus parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service/education support days, there will be plenty of time for you!
Give Back! We offer several ways to give back through our Matching Gift Program, Good Neighbor Grant Program, and the Employee Assistance Fund.
Finish Strong! Plan for retirement using free financial advisors and a 401(k) plan with company contributions of up to 7% of your salary.
Visit our State Farm Careers page for more information on our benefits, locations, and the hiring process of joining the State Farm team!
HYBRID: Qualified candidates (in or near hub locations listed below) should plan to spend time working from home and some time working in the office as part of our hybrid work environment.
HUB LOCATIONS: Bloomington, IL, Tempe, AZ, Richardson, TX and Dunwoody, GA
SPONSORSHIP: Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunity.
Responsibilities
Our Test Data Management Test is on the lookout for a talented and experienced Database Designer/Administrator with a robust background in AWS. We are looking for someone to be part of our team that to assist with cloud migration along with providing service and support for applications that are already there.
As a Database Designer/Administrator at State Farm, you will:
• Design, Implement, and Maintain: Develop and maintain our database systems, focusing on leveraging AWS services.
• Ensure Performance and Availability: Monitor database performance and ensure high availability, Performance, and reliability.
• Collaborate Closely: Work hand-in-hand with development and operations teams to support data-driven applications and solutions.
• Optimize Solutions: Continuously improve and optimize database designs for efficiency and scalability.
What We're Looking For:
• Expertise in AWS: Proven experience with AWS services and their application in database management.
• Technical Proficiency: Strong skills in both logical and physical database design, building SQL and Stored Procedures.
• Resourcefulness and Customer Focus: A track record of being resourceful, customer-focused, and thriving in a team environment.
Qualifications
Competitive candidates must have the following skills:
• SQL skills and experience with database design and optimization.
• Utilize AWS services such as RDS, Aurora, DynamoDB, or Redshift to architect and manage cloud-based databases.
Other Skills:
• Ability to translate and transform business requirements into data models (Conceptual, Logical and Physical).
• Ensure database security, backup, and recovery processes are in place and tested regularly. Involves helping product teams with failover, security and other considerations as they move their applications to the cloud.
• Collaborate with development teams to design and optimize database schemas, queries, stored procedures for application performance. Includes tuning queries, reviewing SQL queries, indexing, and monitoring.
• Creating and changing tables and databases.
• Strong communication and collaboration skills.
• Use of creative intelligence and an entrepreneurial spirit to approach problem solving with the tools of questioning, associative thinking, observing, networking and experimenting to yield new/differentiated ideas for products, technologies, and processes.
SFARM
