Database Engineer at Vertafore

| Greater Denver Area
Sorry, this job was removed at 5:19 a.m. (MST) on Friday, July 2, 2021
Find out who's hiring in Colorado.
See all Data + Analytics jobs in Colorado
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Vertafore is a leading technology company whose innovative software solution 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

As a SQL Database Engineer (DBE), you will be responsible for database 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 DBE and looking for the next challenge, apply now!

Core Requirements and Responsibilities:

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

  • Required: Experience with AWS database administration, deployments, ideally RDS SQL Server
  • Resolve complex problems by investigating and devising solutions for database operations. May include installations, configuration, tuning and maintenance of database management.
  • 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.
  • Experience with automation, Ansible, Python, Terraform is a plus
  • Provides after-hours and weekend support and participate in on-call rotation (24X7)

Knowledge, Skills and Abilities:

  • 3+ years of experience in SQL Server administration and automation/scripting experience.
  • 2+ years of AWS cloud experience preferred
  • 2+ years of DevOps experience preferred
  • Develop new performance monitoring solutions
  • Experience with backups, restores and recovery
  • 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, Octopus Deploy, Kubernetes and ServiceNow.
  • Experience with multi-tenant systems, preferred
  • Demonstrated desire and ability to learn technologies quickly
  • Possesses good oral and written communication skills.
  • Contributes to a positive team environment.
  • Enjoys finding and implementing solutions to new challenges.
  • Proactively asks questions and learns about our products.
  • Effectively multi-tasks and adapts to change.
  • Strong problem solving and troubleshooting abilities.
  • Ability to work productively on various projects simultaneously.

Additional Requirements and Details:

· Travel required up to 10% of the time.

· Located and working from an office location.

· 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.

*We are currently working remotely due to COVID19. 

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases

Location

Great location in the heart of downtown Denver just a block away from the RTD lightrail.

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.
Friends outside of work
Eat lunch together
Intracompany committees
Vertafore offers opportunities to join several committees, including Women of Vertafore, LGBTQ+, etc.
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Unconscious bias training
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
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 Benefits
Our dental plan covers $1500 of expenses per person.
Vision Benefits
The vision benefits plan covers 100% for annual eye exams with $175 for glasses or contact lenses.
Health Insurance Benefits
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
Onsite Gym
Team workouts
Vertafore's team fitness initiatives include in-office yoga, a partnership with Planet Fitness, and other recreational team sports.
Retirement & Stock Options Benefits
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
Child Care & Parental Leave Benefits
Generous Parental Leave
Vertafore provides up to 6 weeks of parental leave for the primary caretaker. We also provides 6 weeks of leave for the secondary caretaker.
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 Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Vertafore hosts company outings annually.
Game Room
Stocked Kitchen
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.
Happy Hours
Recreational Clubs
Vertafore sponsors recreational clubs that include sports, board games, video games, book clubs, etc.
Home Office Stipend for Remote Employees
Professional Development Benefits
Tuition Reimbursement
Our tuition reimbursement plan offers an annual max of $5,250.
Lunch and learns
Cross functional training encouraged
Promote from within
Online course subscriptions available

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 Vertafore46 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Marketing
Operations
Product
Project Mgmt
Sales
Content
Developer
new
Denver
Operations
new
Remote
Developer
new
Denver
Operations
new
Denver
Design + UX
new
Denver
Developer
new
Denver
Sales
new
Remote
Design + UX
new
Denver
Finance
new
Denver
Developer
new
Denver
Data + Analytics
new
Denver
Finance
new
Remote
Developer
new
Denver
Finance
new
Denver
Sales
new
Remote
Product
new
Denver
Product
new
Denver
Product
new
Denver
Operations
new
Denver
Operations
new
Denver
Operations
new
Denver
Operations
new
Denver
Operations
new
Denver
Data + Analytics
new
Denver
Developer
new
Denver
Data + Analytics
new
Denver
Developer
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
HR + Recruiting
new
Denver
Marketing
new
Denver
Marketing
new
Denver
Marketing
new
Denver
Project Mgmt
new
Denver
Content
new
Denver
Design + UX
new
Denver
Developer
new
Denver
Developer
new
Denver
Content
new
Denver
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Vertafore's full profileSee more Vertafore jobs