[ref. t10204216] Bromley - Experienced Database Administrator
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!
About iPipeline
Founded in 1995, iPipeline operates as a business unit of Roper Technologies (Nasdaq: ROP), a constituent of the Nasdaq 100, S&P 500®, and Fortune 1000® indices. iPipeline is a leading global provider of comprehensive and integrated digital solutions for the life insurance and financial services industries in North America, and life insurance and pensions industries in the UK.We couple one of the most expansive digital and automated platforms with one of the industry’s largest data libraries to accelerate, automate, and simplify various applications, processes, and workflows – from quote to commission – with seamless integration.
Our vision is to help everyone achieve lasting financial security by delivering innovative solutions that connect, simplify, and transform the industry.
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.
Responsibilities:
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.
This is primarily a development DBA role but will also involve internal and client production support. 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.
- 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 Backups
Qualifications:
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.
- 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
- 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
- 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