State Farm has multiple openings for a Data Specialist/Database Administrator.
Our Corporate office is located in Bloomington, Illinois.
Duties/Responsibilities:
* Designs, creates, alters and maintains database solutions, across multiple platforms and computing environments, that meet business needs
* Performs industry research for data and database technologies and related software, tools, standards and training
* Develops, follows, and/or implements data and database administration procedures, strategies, guidelines, standards, tools, support and training
* Performs analysis and problem resolution related to data and databases
* Works to improve time to market opportunities and provide flexible solutions by embracing the solution provider mindset
* Applies innovation, passion, flexibility, adaptability, and initiative in daily activities in order to contribute to a Systems culture that clearly reflects these ideals
* Maintains an understanding of how technology can enhance State Farm's business and helps our business partners
A significant portion of this position will involve implementing and supporting PostgreSQL.
Competitive applicants demonstrate experience in PostgreSQL; however, applicants with experience in other Linux-based Relational Database Management Systems(RDBMS) such as Oracle, SQL Server, and DB2 LUW are welcome to apply and may be considered.
Preferred knowledge:
_ PostgreSQL experience or multiple other Linux-based RDBMS
_ Distributed DBMS Experience (sharding, clustering, load balancing, and replication)
_ Data Access Design
_ Data Access Development
_ SQL experience
_ Transactional Data Design
_ OO Design
Additional Skills that would be beneficial to this position:
_ PostgreSQL primary-standby replication (ex. Slony-I, Londite)
_ PostgreSQL master-master replication and conflict resolution
_ NoSQL DBMS experience, specifically key-value stores (ex. Riak, Cassandra, Voldemort, Redis)
_ Caching
_ Java development experience
