We are Farmers!
Join a team of diverse professionals at Farmers to acquire skills on the job and apply your learned knowledge to future roles at Farmers. Farmers Insurance also offers extensive training opportunities through the award winning University of Farmers named by Training magazine amongst top 10 corporate training units in the world.
Want to learn more about our culture & opportunities? Check out farmers.com/careers and be sure to follow us on Instagram and LinkedIn!
Develops and maintains the corporate database architecture which focuses on the logical design, physical design, implementation and management of operational data; provides consultation and review support to develop projects during design and construction of application programs; provides on-going support to the testing and production environments to ensure recoverability and integrity of corporate data; performs restart and recovery after system failures; develops and implements data security procedures; and performs the tasks assigned to the database when required.
Work with Project Team to review project intent and flush out technical requirements.
Develop Database objects for new and existing applications, such as creating Stored Procedures, triggers, functions, indexes, views, Joins and T-SQL.
Responsible for performance tuning and optimization of stored procedures and queries with the guidance of Sr DB dev if needed
Write programming scripts to enhance functionality and/or performance of company applications as necessary.
Production Support: Support of Operations Team with data manipulation and ad-hoc reporting. Work with IT team and end-users to help troubleshoot problems. Participate in on-call rotation and respond to critical database incidents. After-hours support for application release and change management activities.
Advocate database standard and best practice and participate in enhancing them.
Code review of colleagues work to ensure consistency and viability of logic.
Familiar with TFS source control and auto build/deployment process
Essential Job Functions
Participates in formulating a high level implementation plan which supports long range database directions. Participates in determining appropriate physical database architectures based on application requirements. Responsible for coordinating support for all Technical System Design (TSD) activities. Administers and generates physical databases in test and production environments. Assists in designing data access paths, and participates in business transaction designs. Assists programmers in optimizing the use of database to ensure response times meet defined targets. Oversees database system's performance and usage. May assume other duties as assigned.
Bachelor's in Computer Science, Information Systems, Engineering, or equivalent preferred
Minimum 5+ years overall IT experience, including hands-on expertise with recent relational database development and integration.
Efficient in using T-SQL for developing complex stored procedures, triggers, tables, user defined functions, views, indexes, query
Must have experience in data analysis and business requirements gathering (experience in writing business-driven user stories will be an advantage)
Performance Tuning, Handling Indexes, and Query Optimization
Knowledge of RDBMS and Data Warehouse concepts; familiar with SSAS, SSIS, SSRS
Advanced understanding of T-SQL programming, SQL queries, and stored procedures on SQL server
Proficient in database structures, principles, theories and practices
Experience in Agile methodology is plus.
Solid analytical and problem-solving skills
Able to work in a complex and fast-changing environment
Able to learn new technologies
Insurance domain experience preferred
Required job duties are essentially sedentary work consisting of occasional walking, standing and lifting, and/or carrying 10 lbs. maximum.
Required job duties are normally performed in a climate-controlled office environment.
High school diploma or equivalent required. Bachelor’s degree preferred in computer science, information systems, mathematic, or business. Continued education in related business area.
Two years as an Associate Database Designer, or six years experience in an information systems environment, including three years experience working with large-scale IBM database management systems, and operating system utilities with FIG.
Special Skill Requirement
Farmers is an equal opportunity employer, committed to the strength of a diverse workforce.
Job Posting: 02/17/2020