Responsibilities

The Senior Database Engineer will support the X9 to X11 Exadata upgrade from an application engineering perspective, including capacity planning for platform migrations and generating metrics reports. They will conduct performance tuning and query optimization across large datasets, supporting both Oracle and Snowflake environments for data warehousing, reporting, and advanced analytics. The role involves helping implement and optimize databases for GenAI models, including support for vectorized search, data pipelines, and AI-ready datasets. Leading database modernization efforts, such as Oracle to PostgreSQL Aurora migrations, while working with application owners to plan and refactor schemas, stored procedures, and integrations is crucial. Optimizing database systems for performance, scalability, and cost-efficiency across large-scale, multi-terabyte insurance datasets will be a key responsibility. Providing deep expertise in AWS database services, including RDS, Aurora PostgreSQL, and native AWS monitoring and performance tuning tools is also required. Evaluating new technologies to guide and support cost-cutting related to software and infrastructure initiatives, implementing data controls and governance aligned with industry regulations and internal risk frameworks, and partnering with infrastructure teams to automate environment provisioning and monitoring using modern tooling such as Splunk will contribute to the team’s success. Finally, mentoring junior engineers and contributing to building a resilient, high-performing database engineering function is an important aspect of the role.