Senior Database Developer

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.

This is an office-based position.

Responsibilities

Job Summary:

The Expert Database Developer leads the design, implementation, and optimization of large-scale, mission-critical database systems. This role ensures high performance, reliability, and scalability of databases through advanced programming techniques, indexing strategies, and data modeling. Plays a key role in platform migrations, security improvements, and disaster recovery planning. Provides technical mentorship to less experienced database developers and collaborates cross-functionally to integrate data services with enterprise applications. Maintains strong knowledge of emerging technologies and ensures adherence to data governance and compliance standards

Job Responsibilities:

· Lead the development and implementation of advanced database solutions and upgrades.

· Optimize data structures and implement complex business logic within the database layer.

Performance Monitoring & Troubleshooting:

· Proactively tune performance of large and complex databases; lead root cause analysis.

· Implement monitoring strategies and automate issue detection when possible.

Performance Tuning:

· Monitor and optimize database performance, troubleshoot issues, and implement performance improvement solutions.

· Analyze execution plans, tune long-running queries, and refine indexing strategies.

Collaboration & Integration:

· Implement monitoring strategies and automate issue detection when possible.

· Advise stakeholders on database design choices during project planning.

Documentation & Training:

· Produce detailed technical documentation and standards for database design and use.

· Mentor less experienced database developers and contribute to team-wide training initiatives.

Innovation & Technical Growth:

· Drive adoption of automation and modern database development practices.

· Evaluate and pilot emerging database technologies and tools.

Backup & Recovery:

· Develop and implement strategies for data backup and recovery, ensuring the availability and integrity of databases.

· Test and refine disaster recovery procedures to minimize downtime and data loss.

Security:

· Implement and manage database security policies, including user access controls, encryption, and monitoring for unauthorized access or breaches.

· Collaborate with security teams to audit database security and respond to threats.

Data Migration:

· Oversee and manage database migrations and data transfers between different environments or systems.

· Ensure data consistency, accuracy, and performance throughout the migration process.

Compliance:

· Ensure that databases comply with industry regulations and internal policies, such as data privacy laws and auditing standards.

· Lead initiatives to improve audit readiness and enforce compliance across systems.

Qualifications

Technical Competencies:

· Technical Skills: Strong knowledge of database management systems (DBMS), including SQL and NoSQL databases, cloud databases, and data warehousing solutions.

· Scripting/Programming: Proficiency in SQL, shell scripting, or Python for automation and troubleshooting.

· Database Security: Experience with database security practices and tools, such as encryption, access control, and auditing.

· Analytical Skills: Ability to analyze complex systems and pinpoint database performance bottlenecks.

· Problem-Solving: Strong troubleshooting skills to identify and resolve database-related issues.

· Communication Skills: Ability to explain complex database concepts to non-technical stakeholders and collaborate with cross-functional teams.

Education and Knowledge:

· Typically requires a bachelor’s degree in computer science, Information Technology, or a related field (or international equivalent)

· Typically requires 6+ years of experience in advanced database design, development, and administration

· Certifications: Certification in a database management system (e.g., Microsoft SQL Server, MySQL, AWS, etc.) is a plus.

Benefits

We offer a competitive compensation and benefits package, opportunities for career growth, an employee stock purchase plan, 401(k), generous time off and flexible work/life balance, company-matched retirement packages, an employee wellness program, and an awards and recognition program – all in a creative, fast-growing, and innovative company.

Full Time