Database Reliability Engineer - IntelliScript Remote
Database Reliability Engineer - IntelliScript Remote
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 109000 - 248000
1 Vacancy
Job 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 categorydefining datadriven softwareasaservice (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 IntelliScripts 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 weve shown sustained growth that ensures youll have room to grow your skillset responsibilities and career.
Our team is smart downtoearth and ready to listen to your best ideas. We reward excellence and offer competitive compensation and benefits. Visit ourLinkedIn pagefor a closer look at our company and learn more about our cultural valueshere.
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 employeeled 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 Millimans commitments to our people diversity and inclusion social impact and sustainability.
What this position entails
The Database Reliability Engineer will be the goto 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 youll be doing
Observability
- Design DB observability strategy and help implement reusable patterns to meet varying levels of required visibility
- Create observability dashboards that provide realtime 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 NonRelational Data Platforms
- Optimize data models and query performance for DynamoDB
- Integrate DynamoDB with other AWS services and thirdparty 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 expertlevel support for databaserelated issues
- Perform root cause analysis and implement longterm 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 problemsolving 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 highquality database systems with industry standard best practices
- Naturally curious enjoys digging deep to uncover information
- Customercentric 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
- Selfmotivated 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
- 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 purposebuilt databases
Location
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 as needed.
The base salary for the position will vary with the candidates qualications and experience. The salary range is $109000 $248000 depending on relevant factors including but not limited to education skills certifications and location. If overall experience is less than 10 years the range would be $109000 $222000; for experience of greater than 10 years the range would be $122000 $248000. In addition we offer a performancebased bonus plan prot sharing and generous benets.
Milliman Benefits (Full time U.S. positions only)
At Milliman we focus on creating an environment that recognizes and meets the personal and professional needs of the individual and their family. We offer competitive benefits which include the following based on plan eligibility:
- A 401(k) plan with matching program and profitsharing contribution
- Employee Assistance Program (EAP)
- Paid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; fulltime employees will accrue 15 days of PTO per year and employees working less than a fulltime schedule will accrue PTO at a prorated amount based on hours worked
- Family building benefits including adoption and fertility assistance and paid parental leave up to 12 weeks for employees who have worked for Milliman for at least 12 months and have worked at least 1250 hours in the preceding 12month period
- Commuter Program which allows you to use pretax dollars to pay for your parking or public transit expenses to get to and from work. You may utilize this benefit any time throughout the year and funds will be available the first of the month following your first contribution.
- A minimum of ten paid holidays
- Milliman covers 100 of the premiums for life insurance AD&D and both shortterm and longterm disability coverage
- Flexible spending accounts allow employees to set aside pretax dollars to pay for dependent care transportation and applicable medical needs
- Medical dental and vision coverage for employees and their dependents including domestic partners
Equal Opportunity
All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability or status as a protected veteran.
Employment Type
Full-Time
