SQL Server DBA at KPA

| Greater Boulder Area
Sorry, this job was removed at 10:15 p.m. (MST) on Thursday, February 27, 2020
Find out who's hiring in Colorado.
See all Data + Analytics jobs in Colorado
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's Database Administrator has knowledge in both Microsoft SQL Server 2016 and MySQL database technologies and 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 DBA will need to be available to work nights and weekends during product deployments to support client maintenance windows.
 
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.
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 development environments.
 
In the first 30 days you will:
Utilize Visual Studio SQL Server Data Tools to build, debug, maintain, and refactor databases inside Visual Studio and maintain changes in Azure DevOps code repositories.
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 and manage work items in Azure DevOps.
Understand the database obfuscation process.
Understand the implemented security processes.
 
In the first 90 days you will:
Work closely with DevOps team to further automate database deployment processes and facilitate CI / CD pipelines.
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:
Evaluate SQL Server options for future cloud strategy and rehosting to Microsoft Azure.
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:
Reduced the time to build new SQL Server environments through automated processes.
Demonstrated knowledge of the all database environments for the business.

Requirements:

  • 5 years of experience working as a DBA
  • 2 years of experience with Microsoft SQL Server 2016 and greater
  • 2 years of experience with MySQL and greater preferred
  • 1 Year on-call troubleshooting experience with at least one production database server
  • Ability to create and monitor databases
  • Strong database querying skills
  • Ability to create backup / recovery of databases
  • Knowledge of disk space and memory management for database servers
  • Experience to change users and user privileges
  • Knowledge of database security best practices
  • PowerShell experience preferred
  • Experience with SQL Server Data Tools or Redgate Data Tools preferred
  • Experience with Azure DevOps, Octopus Deploy or TeamCity preferred
  • Experience performing upgrades between versions, especially 2016 to 2017/2019
  • Experience working with Extract, Transform, and Load ETL tools; SSIS prefered
  • Experience working with PowerBI preferred
  •  
     
  • Education:
  • BS or MS degree in Computer Science/Computer Information Systems or equivalent

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