Junior Database Administrator

As a market leader, iPipeline combines technology, innovation, and expertise to deliver ground-breaking, award-winning software solutions that transform the life insurance, protection, and financial services industry. With one of the industry’s largest data sets, we help advisors and agents automate, digitally optimize, and grow their business to better secure the financial futures of their clients.

At iPipeline, you’ll play a major role in helping us to provide best-in-class, transformative solutions. We’re passionate, creative, and innovative, and together as a team, we continue to advance, accelerate, and expand the reach of our technology. We value different perspectives and are committed to creating an environment that embraces diverse backgrounds and fosters inclusion.

We’re proud that we’ve been recognized in the industry as a repeat winner of various excellence awards, including our selection as a 2022 Top Workplace in the U.S., and as a Best Life Insurance Software Solution award winner in the UK. We believe that the culture we’ve built for our nearly 900 employees around the world is exceptional - and we’ve built a place where our employees love to come to work, every single day.

Come join our team

**You Can Enjoy**:

- Flexible Hybrid working.
- New, contemporary, open-plan office space
- Company matched pension benefits
- Generous Life and Critical Illness Cover
- Perkbox membership (discounts and freebies)
- 25 days holiday allowance plus option to buy and sell
- Well stocked kitchen of free soft drinks, tea, coffee and fruit
- An annual wellness allowance to keep you happy and healthy

**Purpose of the Role**:
This is primarily a development DBA role but will also involve internal and client production support.

We are looking to add to the DBA team someone that has a good grasp of database technologies, is a quick learner and able to bring new ideas to the table.

Consideration will be given to a developer that wants to move into an administration role or a Production Support DBA that wants to unleash their creative side and work in a more Agile environment.

This is a busy team and the ability to work under pressure to tight deadlines is essential.

**Responsibilities**:

- Ensure the availability and security of the products on-premise and cloud based SQL Server estate.
- Providing database support to developers, analysts, and testers.
- Managing database builds and rollouts.
- Packaging databases for delivery to client sites.
- SQL Performance and Optimization.
- Involvement in Database design at least to physical level
- Liaison with Client sites in the UK, Europe and US (installation, releases, maintenance)
- Defining SQL Standards
- Data security
- Management of SQL Backups

**Skills/Experience Required**:

- SQL Server Administration skills (2016, 2017, and above ).
- Strong T-SQL skills.
- Power shell or other scripting language.
- Excellent communication skills
- Able to work to tight deadlines in very fast moving, agile environment.
- Ability to diagnose and solve complex problems.
- Ability to communicate technical issues to both technical and non-technical staff
- Exposure to complex database builds using Visual Studio and TFS or similar.
- Performance and Tuning including Query optimization
- Exposure to Redgate Tool set.
- ER/Studio or other data modelling tool.
- Data Modelling.
- Automation skills, Jenkins or similar.
- Exposure to Cloud Based Database technologies preferably AWS.

**Additional notes**
- This role requires working one weekend a month for planned maintenance
- If the role evolves into external client support and on-call requirement it will attract overtime

**About iPipeline**

Founded in 1995, iPipeline is a unit of Roper Technologies (NYSE: ROP), a constituent of the S&P 500® and Fortune 500® indices. As a leading provider of cloud-based software solutions for the life insurance and financial services industry, our business is to accelerate and simplify sales, compliance operations and customer support. We automate processing for every stage of the business - from pre-sales, new business and underwriting to policy administration, point-of-sale execution, post-sale support and data analytics. We offer the broadest range of integrated solutions used by a leading community of carriers/providers, distributors, financial institutions, and financial professionals to enable them to secure the financial futures of their customers and their families.

iPipeline is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to gender, race, color, religious creed, national origin, age, sexual orientation, gender identity, physical or mental disability, and/or protected veteran status. We are committed to building a supportive and inclusive environment for all employees.