Database Reliability Engineer - IntelliScript (Remote)

What We Do

Milliman IntelliScript is a group of a few hundred experts in fields ranging from actuarial science to information technology to clinical practice. Together, we develop and deploy category-defining, data-driven, software-as-a-service (SaaS) products for a broad spectrum of insurance, health IT and life sciences clients. We are a business unit within Milliman, Inc., a respected consultancy with offices around the world.

Candidates who have their pick of jobs are drawn to IntelliScript’s entrepreneurial and collaborative culture of innovation, excellence, exceptional customer service, balance, and transparency. Every single person has a voice in our company, and we challenge each other to push the outer limits of our full, diverse potential. And, we’ve shown sustained growth that ensures you’ll have room to grow your skillset, responsibilities, and career.

Our team is smart, down-to-earth, and ready to listen to your best ideas. We reward excellence and offer competitive compensation and benefits. Visit our LinkedIn page for a closer look at our company, and learn more about our cultural values here.

Milliman invests in skills training and career development and gives all employees access to a variety of learning and mentoring opportunities. Our growing number of Milliman Employee Resource Groups (ERGs) are employee-led communities that influence policy decisions, develop future leaders, and amplify the voices of their constituents. We encourage our employees to give back to their varied professions, including leadership in professional organizations. Please visit our website to learn more about Milliman’s commitments to our people, diversity and inclusion, social impact, and sustainability.

What this position entails

The Database Reliability Engineer will be the go-to authority for PostgreSQL database management and optimization. This role requires deep technical expertise in PostgreSQL, alongside extensive experience with AWS services, IAM security, DynamoDB, OpenSearch, DocumentDB, and other data platform technologies. You will be responsible for database design, implementation, security, performance tuning, and integration with various data technologies.

What you’ll be doing

Observability

• Design DB observability strategy and help implement reusable patterns to meet varying levels of required visibility
• Create observability dashboards that provide real-time visibility into key database metrics and health indicators
• Recommend best practices for monitoring, tracing, and logging Cloud (AWS) databases
• Establish anomaly detection/alerting and help tune DBs for performance and cost

Database Design and Implementation:

• Architect, implement, and help maintain PostgreSQL databases on AWS
• Optimize database schema, indexing, and query performance for high availability and scalability
• Ensure robust security measures are in place to protect sensitive data

AWS Integration:

• Implement backup, recovery, and monitoring solutions using AWS tools
• Ensure compliance with AWS best practices and security policies
• Recommend storage patterns and policies to optimize cost savings

IAM Security:

• Implement and help manage AWS Identity and Access Management (IAM) policies for secure access control
• Conduct regular security audits and ensure adherence to security protocols
• Collaborate with security teams to address vulnerabilities and enhance security measures

Database development

• Extensive experience in writing highly performant PL/pgSQL
• Ability to proactively diagnose performance issues and refactor code to be more performant

Support Non-Relational Data Platforms

• Optimize data models and query performance for DynamoDB
• Integrate DynamoDB with other AWS services and third-party applications
• Deploy, manage, and optimize OpenSearch clusters for search and analytics use cases
• Design, implement, and maintain DocumentDB instances

Data Platform Integration:

• Facilitate data integration and ETL processes between various data sources and targets
• Implement data governance and data quality best practices
• Ensure seamless integration and data synchronization between various data platforms
• Work with additional data technologies such as Redis,