Sr. Database Engineer

| Denver, CO, USA | Hybrid
Employer Provided Salary: 120,000-140,000 Annually
Salary data is provided by the employer. Please note this is not a guarantee of compensation.
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

$120000 - $140000 / year

Vertafore is a leading technology company whose innovative software solutions are advancing the insurance industry. Our suite of products provides solutions to our customers that help them better manage their business, boost their productivity and efficiencies, and lower costs while strengthening relationships.

Our mission is to move InsurTech forward by putting people at the heart of the industry. We are leading the way with product innovation, technology partnerships, and focusing on customer success.

Our fast-paced and collaborative environment inspires us to create, think, and challenge each other in ways that make our solutions and our teams better.

We are headquartered in Denver, Colorado, with offices across the U.S., Canada, and India.

JOB DESCRIPTION

Application deadline 6/19/2024

As a Sr. Database Engineer, you will be responsible for database engineering, administration, design, development, and support applications available systems. You will be responsible for continuously enhancing the automation process of the database and should have an interest in DevOps to help us improve our software engineering practices. You will be required to work closely with multiple stakeholders in order to understand their database needs. After understanding their needs, you will make recommendations and provide self-services offerings that will allow stakeholders to deploy, monitor, and maintain the correct databases for their business.

You will work with fast-paced, skilled team of engineers and developers across multiple high-profile projects. You will also participate in IT projects from inception of the project up and through the daily maintenance phase of a project. You should have good understanding of cloud concepts. If you are a top-notch Database Administrator and looking for the next challenge, apply now!

Core Requirements and Responsibilities:

Essential job functions included but are not limited to the following:

Primary Skill - SQL Server DBA: Secondary Skill – PostgreSQL, MongoDB DBA


· Required: Experience with SQL Server database administration, deployments on on-premises and Cloud infrastructure preferably on AWS

· Collaborate on Database Automation activities to improve process efficiency and risk compliance

· Drive Stability initiatives by proactively reviewing and addressing Database performance and capacity trends

· Configure and administer database replication between servers, across Local Area Network and Wide Area Network for high availability and disaster recovery.

  • Determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.

· Ensure centralized 24x7 Database Monitoring and Auditing Tools in place and effective in operation

· Resolve complex problems by investigating and devising solutions for database operations. May include installations, configuration, tuning, identifying/resolving complex query bottlenecks and maintenance of database management

· Identify ways to improve data platform, solutions to complex problems; effectively propose paths forward to drive outcomes.

· Hands-on end-to-end Database Development encompassing Database Design and Development working with cross-functional teams.

· Should be able to debug application code written in PL SQL and T SQL for different applications.

· Develop automation frameworks (Infrastructure as code, CI/CD pipelines) and tooling that will be consumed by the entire engineering organization.

· Understand the business priorities and requirements; architect/develop solutions to meet the business need and lead execution.

· Work as an individual contributor and collaborate with multiple teams/vendors/consultants in an effective manner.

· Advanced knowledge in Transactional Replication, Clustering, SQL Always-on

· Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server

· Experience in infrastructure automation through Powershell, Terraform, Chef, Ansible, Puppet or other automation tool is highly advantageous

Knowledge, Skills and Abilities:

· Experience in troubleshooting and resolving database integrity issues, migration issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

· Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tool

· RDS/Aurora Postgres, MongoDB or Oracle administration experience desirable

· Enhance automated functions including monitoring, backing up, recovering, increasing availability, user management, access to controls and logging audits.

· MS SQL Server, Integration Services (SSIS) experience required.

· Strong T-SQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques.

· Knowledge of SQL, data warehousing and data management concepts.

· Familiarity with standard tools and platforms that enable continuous delivery such as GitLab, Kubernetes and ServiceNow.

· Analysis Services (SSAS), AWS Quick Sights experience a plus.

· Nice to have experience with multi-tenant systems

· Demonstrated desire and ability to learn technologies quickly

· Possesses good oral and written communication skills.

· Effectively multi-tasks and adapts to change.

· Strong problem solving and troubleshooting abilities.

· Participate in On Call rotation schedule as part of 24x7 service requirement

Qualifications:

· Bachelor's Degree or higher in Computer Science, Engineering, Mathematics, or similar field or related work experience. 

· 4 or more years of expert knowledge and experience in SQL Server administration, performance optimization, T-SQL development and other DB type (PostgreSQL, MongoDB, Oracle).

· 4+ Years Prior Database Engineering and Administration Experience Preferred

· 2+ years of AWS cloud experience preferred

· 2+ years of DevOps experience preferred


Additional Requirements and Details:

· Travel required up to 10% of the time.

· Ability to work remote with a stable internet connection on an as needed basis

· Located and working from an office location (when required)

· Occasional lifting and/or moving up to 10 pounds.

· Frequent repetitive hand and arm movements required to operate a computer.

· Specific vision abilities required by this job include close vision (working on a computer, etc.).

· Frequent sitting and/or standing.

#LI-Hybrid

The Vertafore Way

Insurance is about relationships, and technology should make those relationships stronger. That's why, at Vertafore, it's our mission to transform the way the industry operates by putting people at the heart of insurance technology. By focusing on our customers, becoming better every day, and delivering results you can see, we provide the level of trust and security that insurance is all about.

· Bias to Action: We're united by an innate drive to take action and make a difference in the technology and insurance spaces.

· Win Together: We work together as one team, showing empathy and respect along the way.

· Show Up Curious: We work to challenge one another to push boundaries and think beyond the box.

· Say It, Do It: We honor every one of our commitments because integrity is important to us.

· Customer Success is Our Success: We cultivate authentic relationships and follow up by actively listening to their needs.

· We Love Insurance: We appreciate the impact insurance has on the world.

Is this role not an exact fit for you? Keep an eye on our Careers Page for other positions!

Vertafore is a drug free workplace and conducts preemployment drug and background screenings.

The selected candidate must be legally authorized to work in the United States.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all the job responsibilities, duties, skill, or working conditions. In addition, this document does not create an employment contract, implied or otherwise, other than an "at will" relationship.

Vertafore strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, sexual orientation, genetic information, or any other characteristic protected by state or federal law.

We do not accept resumes from agencies, headhunters, or other suppliers who have not signed a formal agreement with us.

Vertafore is a Flexible First working environment which allows team members to work from home as often as you’d like, while using our offices as a place for collaboration, community, and teambuilding. There are times you may be asked to come into an office and/or travel for specific meetings for a specific business purpose and this varies by job responsibilities.

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • ReactLibraries
    • ASP.NETFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • AWS (Amazon Web Services)Services

What are Vertafore Perks + Benefits

Culture
Volunteer in local community
Vertafore offers employees 1 paid day to volunteer at the non-profit of their choice.
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Employee resource groups
Employee-led culture committees
Quarterly engagement surveys
Hybrid work model
President's club
Employee awards
Remote work program
Vertafore is a Flexible First working environment which allows team members to work from home as often as you’d like while using our offices as a place for collaboration, community, and team buildin
Diversity
Mandated unconscious bias training
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance + Wellness
Flexible Spending Account (FSA)
Vertafore employees can contribute up to $2750 annually to their FSA.
Disability insurance
Disability insurance covers 100% of annual salary for up to 90 days of disability.
Dental insurance
Our dental plan covers $1500 of expenses per person.
Vision insurance
The vision benefits plan covers 100% for annual eye exams with $175 for glasses or contact lenses.
Health insurance
Vertafore offers three different health plans to meet the needs of our employees.
Life insurance
Pet insurance
We offer a Pet Insurance plan through Nationwide.
Wellness programs
Team workouts
Vertafore's team fitness initiatives include in-office yoga, a partnership with Planet Fitness, and other recreational team sports.
Mental health benefits
Financial & Retirement
401(K)
401(K) matching
Vertafore provides employees with a 401(k) matching plan managed by [provider]. We match up to 50% of contributions up to 3% of an employee's annual gross pay.
Employee stock purchase plan
Performance bonus
Pay transparency
Child Care & Parental Leave
Generous parental leave
Family medical leave
Adoption Assistance
We reimburse up to $2,500 for eligible adoption expenses and 6 weeks of paid leave.
Company sponsored family events
Vertafore sponsors family oriented events semi-annually.
Vacation + Time Off
Unlimited vacation policy
Paid volunteer time
Paid holidays
Paid sick days
Bereavement leave benefits
Company-wide vacation
Every year on the second Friday in April, our company shuts down for "Refresh & Recharge Day." It's a day to unplug and get back to what you love outside of work.
Office Perks
Commuter benefits
Company-sponsored outings
Vertafore hosts company outings annually.
Free snacks and drinks
In various areas of the office, Vertafore provides weekly fresh fruit services, bagels and donuts on specified days, as well as snacks and drinks.
Some meals provided
We provide free breakfast on Mondays and Fridays.
Company-sponsored happy hours
Recreational clubs
Vertafore sponsors recreational clubs that include sports, board games, video games, book clubs, etc.
Home-office stipend for remote employees
Onsite gym
Professional Development
Tuition reimbursement
Our tuition reimbursement plan offers an annual max of $5,250.
Lunch and learns
Promote from within
Mentorship program
Vertafore's mentorship framework is an independently led experience between a mentee and a mentor. Resources are ongoingly provided to start this relationship and keep it successful & valuable.
Online course subscriptions available
Personal development training

Additional Perks + Benefits

We felt like the stretch of no three day weekends from Feb - May was too long, so we added our own holiday! We celebrate Vertafore Rest and Recharge day in April, and the whole company has a long weekend.

More Jobs at Vertafore

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about VertaforeFind similar jobs like this