Sr. Database Engineer at Vertafore

| Greater Denver Area
Sorry, this job was removed at 4:14 a.m. (MST) on Friday, February 19, 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.

Core Requirements and Responsibilities:

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

· Facilitate database operations\management best practices for uptime, performance, scalability, architecture and design, HA and DR

· Support of mission critical SQL Servers when needed

· Be the key person responsible production Postgres DB running on Aurora RDS in AWS.

· Design schema that will be storing hundreds of millions of records

· Perform query performance troubleshooting, identify and create non-performant queries

· Identify and create missing indices

· Ensure the resulting schema is performant for both CRUD and querying

· Be the key person responsible for managing schema evolution while minimizing production system maintenance windows

· Utilize AWS tools to troubleshoot performance issues

· Perform bulk data import and export

· Design of customized reporting tables/materialized views that are needed to provide dynamic reporting operating on a massive data set that is frequently updated


Qualifications:

· Experience with AWS database deployments, ideally Aurora Postgres RDS

· Experience with network latency/IO troubleshooting on AWS

· Strong SQL Server performance troubleshooting skills

· Experience with multi-tenant systems

· Prior experience with ETLs and design of backend for the reporting solutions

 

Travel required up to 10% of the time.

· Ability to work remotely 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.

*Our offices are currently closed due to COVID-19 and are scheduled to re-open mid 2021.

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
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.
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.
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.
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
More Jobs at Vertafore30 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR + Recruiting
Marketing
Operations
Product
Project Mgmt
Sales
Content
Developer
new
Denver
Developer
new
Denver
Data + Analytics
new
Remote
Sales
new
Denver
Product
new
Denver
Operations
new
Denver
Marketing
new
Denver
Content
new
Denver
HR + Recruiting
new
Denver
Product
new
Denver
Developer
new
Denver
Developer
new
Denver
Product
new
Denver
Finance
new
Denver
Developer
new
Denver
Finance
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Product
new
Denver
Sales
new
Denver
HR + Recruiting
new
Remote
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