SQL Server DBA

| Greater Boulder Area
KPA (www.kpa.io) is a proven SaaS technology and services partner for corporate compliance and human resource professionals seeking opportunities to raise productivity, control expense, and mitigate financial and reputational risk via business process automation, improved safety and workplace compliance, and better HR practices. With KPA’s proven portfolio of end-to-end solutions and operational best practice clients can unlock opportunities to drive down costs, mitigate risk, and enhance the employee experience at a lower cost than clients can achieve internally.
Founded in 1986, KPA is owned by Providence Equity Partners, a top-tier private-equity company, and is focused on delivering SaaS solutions to the small and mid-size business (“SMB”) markets.
KPA is looking for someone that can grow with our company. A Database Administrator will have knowledge in Microsoft SQL Server 2016 with a keen sense of performance optimization, security, monitoring and troubleshooting. Some of the key responsibilities of the DBA include installing and configuring, updating database tables, backing up and recovering databases, building table indexes, and identifying and optimizing database query performance.
The following is an overview of some (not all) of the top priorities for this role over the first 12 months:
In the first 2 weeks you will:
• Install Visual Studio Database Project for SQL Server and install MySQL development environment.
• Have a running development environment confirmed by successfully building the Database Project for one of the existing web products.
• Restore obfuscated databases on local development environment.
• Connect to the different database environments.
In the first 30 days you will:
• Identify five performance related issues with the recommended solution which need to be fixed on the database server.
• Review and gain knowledge of the database monitoring tools used in Production.
• Review and understand the various jobs and processes running against the database servers.
• Begin working database helpdesk tickets
• Understand the database obfuscation process.
• Understand the implemented security processes.
In the first 90 days you will:
• Develop a tactical approach to fixing issues reported by the database monitoring tools
• Review and report access discrepancies to highly secure data.
• Review and adjust indexing strategy to one database on the server. 
• Participate in the Production deployment process.
• Handle all database helpdesk tickets
• Restore QA/UAT environments on request.
In the first 6 months you will:
• Review and adjust as needed the indexing strategy for all databases.
• Handle all Production deployments.
• Fix or Report all issues relating to the database.
• Provide weekly performance summary of the database infrastructure.
• Review and Report any database access irregularities.
By the end of the first year you will have:
• Demonstrated knowledge of the all database environments for the business.

As a growing company KPA values its employees by supporting them with a full benefits package including:
- Medical (both PPO and HSA plans available)
- Dental
- Vision
- Paid Time Off
- Parental Leave
- Holidays
- 401(k) match with immediate vesting
- Life Insurance
- Short and long term disability insurance
- FSA
-HSA matching

Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • SqlLanguages
    • jQueryLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • Microsoft SQL ServerDatabases
    • RedisDatabases

Location

The Lafayette Y, a coffee shop, brewpub, a variety of restaurants and childcare facilities are all within walking distance. Free Parking!
“I’ve Never Woken up and not Wanted to Come to Work”: How KPA Keeps People Inspired Every Day
Watch

An Insider's view of KPA

What’s the vibe like in the office?

At KPA we sparkle and shine like its going out of style. People are genuinely happy to be here at work. Our teams know how to get it done and still have fun! Before I came to KPA I was searching for something special. Now that I am here, I realize this is what I was looking for all along. It is truly a magical place to work. #Coloradoproud

Brandy

Accounts Payable Specialist

How do you collaborate with other teams in the company?

The SDR team is at the center of outreach and client engagement in many cases. I personally love to collaborate with all teams when asked because in the end we all have the same vision. Stepping outside that comfy little box is the only way to successfully schedule appointments, create opportunities and close deals.

JoAnna

Sales Development Representative

What makes someone successful on your team?

Being in a client facing role, holding a professional & positive demeanor is crucial to one’s success. The ability to empathize with varying clients’ needs & changing communication styles are also essential. Most importantly though, is relationship building. It is our job to instill trust with our clients & once this happens, the rest is simple.

Matt

Senior Implementation Manager

How do your team's ideas influence the company's direction?

Our company is open to all kinds of new ideas that help us succeed and push us in the right direction. At the end of the day it doesn’t matter who comes up with the idea, if its the sales team or any other team within the company. Collaboration is the key to success and all that matters is we are learning, growing and winning as an organization.

Lee

Director, Inside Sales

What are KPA Perks + Benefits

Culture
Volunteer in local community
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Group brainstorming sessions
Diversity
Highly diverse management team
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 2 weeks of parental leave.
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Perks & Discounts
Casual Dress
Stocked Kitchen
Some Meals Provided
Happy Hours
Parking
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and learns
Cross functional training encouraged
Promote from within
Online course subscriptions available
Customized development tracks
Paid industry certifications
More Jobs at KPA3 open jobs
All Jobs
Data + Analytics
Operations
Sales
Operations
new
Boulder
Data + Analytics
new
Boulder