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 world 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:
The Experienced Database Administrator independently manages and maintains databases, ensuring performance, availability, and security. Implements standard database configurations, monitors performance metrics, and takes corrective actions for common issues, independently and in conjunction with our clients' iPipeline software instances. Coordinates with development and infrastructure teams for routine updates and
enhancements.
-
Database Administration, Maintenance & Support:
-
Independently install and configure standard database systems in development and test environments.
-
Independently perform regular maintenance, patches, and updates.
-
Manage daily health checks and respond to common alerts.
-
Maintain documentation of configurations and changes.
-
Troubleshoot moderately complex issues in development and production environments. Use diagnostic tools to identify root causes and apply known solutions with minimal supervision. Collaborate with developers and system admins to resolve incidents efficiently.
-
Participate in database migrations and data transfers between environments (e.g., dev, test, prod). Perform pre- and post-migration tasks such as backups, validation, and troubleshooting. Document procedures and identify areas for improvement in migration processes.
-
Performance Monitoring & Optimization:
-
Monitor performance using diagnostic tools and address common bottlenecks.
-
Recommend and apply indexing, query tuning, and configuration adjustments.
-
Conduct impact assessments for proposed database changes.
-
Security & Access Control:
-
Implement and manage user roles and access levels based on job duties.
-
Enforce security policies and ensure user access logs are reviewed regularly.
-
Participate in audits and assist with remediation actions.
-
Backup & Recovery:
-
Manage backup schedules and verify backup integrity.
-
Execute recovery procedures during system incidents.
-
Maintain and test recovery documentation regularly.
-
Collaboration & Communication:
-
Coordinate with developers and system administrators on routine integrations.
-
Communicate technical details clearly with non-technical stakeholders.
-
Provide status updates and contribute to planning meetings.
-
Process Improvement & Innovation:
-
Propose optimizations to improve routine DBA workflows.
-
Document new procedures and update playbooks.
-
Participate in evaluating tools for performance monitoring and automation.
-
All other duties as assigned.
Qualifications:
Technical Competencies
-
Database Fundamentals & Architecture:
- Experience working with multiple database engines (e.g., Oracle, SQL Server, PostgreSQL); knowledgeable about basic integration concepts.
- Query Performance & Optimization:
- Skilled in SQL query tuning, indexing, and performance troubleshooting. Experience diagnosing and tuning slow-running queries using execution plans and basic indexing.
-
Schema Design & Data Modeling:
- Proficient in database configuration. Intermediate understanding of normalization and indexing strategies. Experience designing moderately complex schemas.
- Automation & Scripting:
- Solid scripting ability (e.g., PowerShell, Bash, Python). Experience writing scripts to automate routine administrative and maintenance tasks.
-
Monitoring & Diagnostics:
- Experience with monitoring tools and performance dashboards. Experience using diagnostic tools to identify performance issues and propose standard resolutions.
-
Backup, Recovery & High-Availability:
- Experience managing backup schedules and performing recovery. Intermediate understanding of RTO/RPO concepts.
-
Security & Access Management:
- Familiar with database security practices and compliance considerations. Experience implementing security groups, access controls, and basic encryption measures.
-
Professional Skills:
- Strong written and verbal communication skills. Ability to work independently on routine tasks and support incidents with minor guidance
Fringe Benefits:
- Typically requires a bachelor's degree in Computer Science, Information Technology, or a related field (or international equivalent).
-
Typically requires 3+ years of hands-on experience with database administration in production environments.
-
Certifications (e.g., Microsoft Certified: Azure Database Administrator, Oracle DBA) are a plus.