Database Administrator

at  iPipeline

Overview:
As a global market leader, iPipeline combines technology, innovation, and expertise to deliver ground-breaking, award-winning software solutions that transform the life insurance, financial services, and protection industries. With one of the industry’s largest data sets, we help advisors/advisers and agents to transform paper and manual operations into a secure, seamless digital experience – from proposal to commission– so they can help 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 continually strive 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 as a repeat winner of various industry awards, demonstrating our excellence and highlighting us as a top workplace in both the US and the UK. We believe that the culture we’ve built for our nearly 900 employees around the word is exceptional - and we’ve created a place where our employees love to come to work, every single day.
Come join our team!

KEY TECHNICAL SKILLS REQUIRED

• SQL Server Administration skills (2016, 2017, and above ).
• Proficient T-SQL skills.
• Power shell or other scripting language.
• Good communication skills
• Able to work to tight deadlines in fast moving, agile environment.
• Ability to diagnose and solve complex problems.
• Ability to communicate technical issues to both technical and non-technical staff.

TECHNICAL SKILLS

• Exposure to Visual Studio
• Experience with source control .. TFS/ GitHub.
• 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

PERSONAL SKILLS

• Enthusiastic with excellent problem-solving skills
• Showing initiative / self-motivated to get the job done and improve practices
• Great interpersonal skills - ability to converse with both internal and external customers
• Excellent written and verbal communication
• Helpful and friendly, thriving in front of a challenge with a strong desire to succeed

• Ensure the availability and security of the SS/G Digital 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 Backup