Site Reliability Engineer III - IntelliScript (Remote)

Milliman, Inc; Brookfield (WI); Hybrid; USD 117,000 - 261,000; Full time

Job summary

A leading company in Brookfield, WI is seeking a Site Reliability Engineer III with expertise in PostgreSQL and AWS. The role involves database management, optimization, and integration with various data technologies. The ideal candidate will have a collaborative spirit and a passion for building high-quality database systems. This position offers opportunities for professional growth and a competitive compensation package.

Benefits

Medical, Dental and Vision Coverage

401(k) Plan with Company Matching

Paid Time Off (PTO)

Flexible Spending Accounts (FSA)

Paid Parental Leave

Life Insurance & AD&D

Short-Term and Long-Term Disability

Discretionary Bonus Program

Employee Assistance Program (EAP)

Family Building Benefits

Qualifications

• 5+ years of experience with PostgreSQL databases and performance tuning.
• Extensive experience with AWS services, particularly RDS, EC2, S3, and Lambda.

Responsibilities

• Design and implement PostgreSQL databases on AWS.
• Create observability dashboards for database metrics.
• Provide expert-level support for database-related issues.

Skills

PostgreSQL

AWS

PL/pgSQL

Python

Bash

Data Governance

Problem Solving

Education

Computer Science

Tools

DynamoDB

OpenSearch

DocumentDB

Terraform

Redis

Kafka

Amazon SQS

Job description

Description

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 Site Reliability Engineer III 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 will 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, Kafka, Amazon SQS, etc.


• Familiar with Terraform and infrastructure as code concepts


• Familiarity with setting up dashboards and alerting in Datadog and AWS

Troubleshooting and Support:

• Provide expert-level support for database-related issues


• Perform root cause analysis and implement long-term solutions for recurring problems


• Collaborate with development teams to optimize application performance

Mentorship and Training:

• Mentor and train database administrators and developers


• Develop and deliver training sessions and documentation on best practices and new technologies

What we need

• 5+ years of experience working with PostgreSQL databases, including advanced features and performance tuning.


• Extensive experience with AWS services, particularly RDS, EC2, S3, Lambda, and DynamoDB


• Strong understanding of AWS IAM security best practices and implementation


• Proficient in other data technologies such as /Valkey, Kafka, Amazon SQS, OpenSearch, DocumentDB. etc.


• Strong understanding of database design principles, normalization, and indexing


• Experience with database monitoring and performance tuning tools


• Proficient in scripting languages such as Python, Bash, or similar


• Excellent problem-solving skills and the ability to troubleshoot complex issues.


• Strong communication and interpersonal skills, with the ability to work effectively in a team environment


• AWS certifications (such as AWS Certified Solutions Architect, AWS Certified Database - Specialty, or AWS Certified Security - Specialty) are a plus

What you bring to the table

• Passionate about building high-quality database systems with industry standard best practices


• Naturally curious, enjoys digging deep to uncover information


• Customer-centric approach to finding solutions


• Comfortable communicating / translating specs and business needs between stakeholders and technical teams


• Able to learn new concepts and adapt quickly to an existing, complex environment


• Self-motivated, with the ability to work independently and in teams, with or without supervision


• Strong work ethic: pitches in wherever needed


• Collaborative by nature: seeks out the input and needs of others, shares insights and opportunities

Wish list

• Continued education and/or advanced degree(s) in Computer Science, Information Technology, or a related field


• Ability to understand and refactor complex legacy software


• Experience in environments subject to HIPAA and/or PCI regulations


• Professional experience with project lifecycle planning such as Agile/Scrum


• Comfortable with Atlassian software suite (Jira, Confluence, and OpsGenie)


• AWS Glue


• AWS Neptune or other AWS purpose-built databases

Location

The expected application deadline for this job is June 30, 2025. This position will be based out of the Milliman office in Brookfield, WI; however, this position is open to remote work. Applicants must be willing to travel to the Milliman office in Brookfield, WI for quarterly PI Planning meetings and our annual company meeting.

Compensation

The overall salary range for this role is $117,500 - $260,640. For candidates residing in:

• Premium Alaska, California, Connecticut, Illinois, Maryland, Massachusetts, New Jersey, Pennsylvania, Virginia, Washington, or the District of Columbia:
  
  
  
  • $129,250 - $213,290 if overall experience is less than 10 years; and
  
  
  • $144,760 - $238,920 for experience greater than 10 years.
  
  
  
  


• Notable New York City, Newark, San Jose, or San Francisco:
  
  
  
  • $141,000 - $232,680 if overall experience is less than 10 years; and
  
  
  • $157,920 - $260,640 for experience greater than 10 years.
  
  
  
  


• National All other states:
  
  
  
  • $117,500 - $193,900 if overall experience is less than 10 years; and
  
  
  • $131,600 - $217,200 for experience greater than 10 years.
  
  
  
  

A combination of factors will be considered, including, but not limited to, education, relevant work experience, qualifications, skills, certifications, etc.

Benefits

We offer a comprehensive benefits package designed to support employees' health, financial security, and well-being. Benefits include:

• Medical, Dental and Vision - Coverage for employees, dependents, and domestic partners.


• Employee Assistance Program (EAP) - Confidential support for personal and work-related challenges.


• 401(k) Plan - Includes a company matching program and profit-sharing contributions.


• Discretionary Bonus Program - Recognizing employee contributions.


• Flexible Spending Accounts (FSA) - Pre-tax savings for dependent care, transportation, and eligible medical expenses.


• Paid Time Off (PTO) - Begins accruing on the first day of work. Full-time employees accrue 15 days per year, and employees working less than full-time accrue PTO on a prorated basis.


• Holidays - A minimum of 10 paid holidays per year.


• Family Building Benefits - Includes adoption and fertility assistance.


• Paid Parental Leave - Up to 12 weeks of paid leave for employees who meet eligibility criteria.


• Life Insurance & AD&D - 100% of premiums covered by Milliman.


• Short-Term and Long-Term Disability - Fully paid by Milliman.

Equal Opportunity

Milliman is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected Veteran Status, age, or any other characteristic protected by the law.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.