RMS is looking for a Senior Database Engineer in London!
RMS is the world's leading provider of analytics and decision science solutions for the quantification and management of catastrophe risks. The models and consulting services of RMS are used by hundreds of insurance and reinsurance companies, hedge funds, corporations, and governments to assess a wide-range of natural and man-made perils such as - earthquake, flood, windstorm, terrorism, and disease pandemic. RMS continues to grow and diversify in order to service and meet the requirement of its clients through research and technology innovation and superior client service. The company's strength lies in its ability to use and develop the skills of its people across a wide remit of business activities.
At RMS, we believe the result of deeper knowledge is positive change. Our ultimate goal is to create a more sustainable and resilient world through a better understanding of catastrophic events. RMS is proud to be an equal opportunity employer.
The Software Development group focuses on developing and building cutting edge, high performance enterprise software solutions that deliver risk quantification tools to our 400+ clients worldwide. Using cutting edge technology, we are building an exciting next generation product that leverages the latest advances in database tools, grid computing, hardware-based acceleration techniques, and visualization optimization. Our Enterprise Platform utilizes restful web services, 100+ TB of data warehousing/OLAP solutions, large scale distributed data processing technology, best-in-class virtualization technology, and GPU-based computing in a SaaS environment.
Objective of the Senior Database Engineer:
The Senior Database Engineer will be responsible for the design and implementation of innovative software solutions within the catastrophe risk management space. Due to the global nature of the role, they will be working in close collaboration with business units, partner companies and our client-base across Europe and the US. Duties not limited to:
* Create, tune and optimize physical data models;
* Develop and tune SQL stored procedures, functions and views;
* Implement structural database changes, migrate changes to production environment;
* Proactively monitor database to meet performance and service-level commitments;
* Collaborate with internal clients to determine database requirements and translate them into
project task and deliverables;
* Undertake research into new database technologies to support leading edge development by the group;
* Draft and enforce compliance to developer standards for data access;
* Develop and maintain database test harnesses and test suite;
* Undertake research into new technologies and techniques to support leading edge development by the group;
* Train and mentor teammates.
Must be educated with at least a BS/MS Degree in Computer Science or related field;
Advanced, hands-on experience in Microsoft SQL Server, T-SQL or MySQL;
Expert level of knowledge on database design, performance optimization and scaling;
At least some exposure using No SQL databases such as MongoDB, Cassandra, or HBase;
SQL query writing and troubleshooting skills including performance monitoring and tuning;
Solid experience with stored procedures and building robust data access layer. Experience with persistence and data access layer technology such as NHibernate, LINQ, or Entity Framework;
Established software development experience in accordance to industry standard best practices;
Experience of delivering solutions using Agile and V-Model SDLC methodologies;
Pro-active self-starter who is comfortable working in distributed project team of varying sizes.
Exposure with C# or C++;
Experience of using Amazon SimpleDB, Amazon RDS, Amazon ElastiCache;
Experience building integrated, service orientated architecture solutions;
Experience in High Volume Transaction Processing Systems;
Strong knowledge on DBA activities and roles;
Experience in Business Intelligence and ETL tools;
Strong hands-on experience and knowledge of SDLC and design patterns used in professional software development setting;
Good working experience in large OLTP/OLAP systems, preferably insurance and banking domain.