Junior Database Administrator

| Greater Boulder Area
Sorry, this job was removed at 4:16 a.m. (MST) on Wednesday, December 22, 2021
Find out who's hiring in Greater Boulder Area.
See all Data + Analytics jobs in Greater Boulder Area
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

KPA exists to help companies keep their workforces safe and healthy. At the end of the day, we succeed if our clients can send their employees home at night, having not experienced the trauma of a workplace accident or an injury.


How do we do it? By offering a unique combination of software, consulting, and training that helps clients identify, remedy, and prevent workplace safety and compliance problems so they can focus on what’s important—their core business. 


Help us help keep people safe and businesses working efficiently. Named as one of Built In Colorado’s Best Places to Work, KPA is made up of diverse, vibrant individuals working together for the greater good.


We’re here to help our clients build safe, thriving organizations, and we’re looking for some like-minded people to help us do it. 


KPA's Junior Database Administrator has knowledge in Microsoft SQL Server 2016 and a keen sense of performance optimization, security, monitoring and troubleshooting. Some of the key responsibilities of the Jr. 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 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:

  • 0-2 years of experience working as a DBA
  • Experience with Microsoft SQL Server 2016 and greater
  • On-call troubleshooting experience with at least one production database server
  • Ability to create and monitor databases
  • 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

Preferred Experience:

  • Experience with MySQL
  • Experience working with PowerBI preferred
  • Experience working with ETL tools; SSIS
  • Experience with Azure DevOps, Octopus Deploy or TeamCity
  • Experience with SQL Server Data Tools or Redgate Data Tools
  • PowerShell experience

Compensation

  • Annual base salary between $85-95k
  • Bonus potential up to 10% annually

KPA Office/Event Attendance and COVID-19 Vaccination Policy


Daily office attendance is currently optional for all employees. Each office will be open for those seeking the opportunity to return to the office. Team meetings and events will be held in both KPA Offices and outside of KPA Offices where employee attendance will be expected.


For all KPA office sites, events and meetings, any employee attending, even temporarily, must be fully vaccinated with at least fourteen (14) days following their final vaccine. The final vaccine is defined as a second dose for Pfizer or Moderna, or the first dose of Johnson and Johnson.


About KPA


For over 30 years, KPA has helped 10,000+ clients achieve regulatory compliance, maintain a safe workplace, and save money. 


Business Nuts and Bolts 


Founded in 1986, KPA is a leading provider of Environment, Health & Safety (EHS), and Workforce Compliance software and consulting services. KPA solutions help clients identify, remedy, and prevent workplace safety and compliance problems across their entire enterprise. The combination of KPA's software, consulting services, and award-winning training content helps organizations minimize risk so they can focus on what's important—their core business.

KPA’s majority investor is a tier-one private equity firm, Providence Equity Partners, which provides -capital and expertise to accelerate growth organically and through additional acquisitions. We’re now in an exciting time of accelerated growth with the promotion of our SaaS solutions. 


Honoring Our Experiences, Building Mutual Respect 


At KPA, we strive to build an environment that respects our talented colleagues’ individual experiences and mutual respect for our customers and partners regardless of color, religion, ethnicity, and sexual orientation. We aim to make meaningful contributions to celebrate our differences and learn from each other, uniting in an open and accepting culture that acknowledges everyone’s physical, workplace safety, and psychological safety.


We are passionate about what we do, how we do and why we do it. Our culture is driven by the KPA core values – Integrity, Helpful, Excellence, Agile, Respectful, and Teamwork. Success will be determined by the capabilities, energy and character of the people we bring into our organization and the performance they achieve.


KPA, with headquarters in Colorado and teammates throughout the United Sates, is recognized as one of Colorado's Best Places to Work 2021 by Built In Colorado.


“To be ranked so highly in Built In’s Best Places to Work Awards is a recognition of KPA’s dedication to creating a team of outstanding professionals and our efforts to create a positive and safe workplace culture for everyone,” said Chris Fanning, KPA President and CEO. “I believe we’ve developed a high caliber organization comprised of passionate people who are experts in their respective fields and deliver great value to our customers.”

 

As a growing company KPA values its employees by supporting them with a full benefits package including:

- Medical (both PPO and HDHP plans available)

- Flexible Spending Account or Health Savings Account (dependent on medical plan)

- Dental

- Vision

- Paid Time Off increasing with tenure

- Paid Holidays and floating holidays

- 401(k) match with immediate vesting

- No-cost Basic Life and AD&D Insurance

- Short- and Long-Term Disability Insurance

- Employee Assistance Program

- Telehealth

- Pet Insurance


KPA is committed to providing equal opportunity in all of our employment practices, including selection, hiring, promotion, transfer, and compensation, to all qualified applicants and employees without regard to race, religion, religious dress/grooming, color, ethnicity, sex (including sex stereotyping), sexual orientation, gender identity or gender expression, national origin, ancestry, citizenship status, creed, uniform service member status, military or veteran status, marital status, pregnancy, breast-feeding and/or pregnancy-related conditions, age, protected medical condition, leave status, physical or mental disability, genetic characteristics, or any other legally-protected status in accordance with the requirements of all federal, state and local laws. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.


If you need assistance or an accommodation due to a disability, you may contact us at [email protected].

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

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
  • People Operations
    • C#Languages
    • JavascriptLanguages
    • SqlLanguages
    • jQueryLibraries
    • ReactLibraries
    • AngularFrameworks
    • ASP.NETFrameworks
    • Node.jsFrameworks
    • Vue.jsFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • AWS (Amazon Web Services)Services
    • GitHubServices
    • Google CloudServices
    • Google AnalyticsAnalytics
    • Power BIAnalytics
    • BalsamiqDesign
    • CanvaDesign
    • FigmaDesign
    • MiroDesign
    • UXPinDesign
    • Aha!Management
    • AsanaManagement
    • Google DocsManagement
    • SmartsheetManagement
    • TrelloManagement
    • AzureManagement
    • VisioManagement
    • Chorus.AICRM
    • DocuSignCRM
    • HubSpotCRM
    • LinkedIn SalesNavigatorCRM
    • OutreachCRM
    • SalesforceCRM
    • Salesforce CPQCRM
    • SalesLoftCRM
    • ZoomInfoLead Gen
    • Microsoft TeamsCollaboration
    • SlackCollaboration
    • SmartsheetProject Management

Location

Our headquarters is located in the CirclePoint Corporate Center in Westminster, right off US 36 between 104th and 112th. Minutes from the Westminster Promenade, a major entertainment and food hub.

An Insider's view of KPA

What's something quirky about your company?

We have such a diverse workforce! From the Sales team to QA Analysts; people who've spent their careers in auto dealerships to new Environmental Health and Safety graduates; from the steel industry in PA to compliance software in OK to auditors on both coasts and everywhere in between. I'm so pumped to work with so many different kinds of people!

Meghan

Human Resources Generalist

How do you collaborate with other teams in the company?

I love how enthusiastic other teams and departments are to work together. Everyone in the organization is willing to lend a helping hand whether it’s through a quick ping, email, or a video call. It’s energizing being at a company that feels like one big team!

Emma

Senior Financial Analyst

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

Client Success Manager

What are KPA Perks + Benefits

KPA Benefits Overview

KPA strives to create a productive work environment by supporting employees and their families with competitive benefits.

Culture
Volunteer in local community
Partners with nonprofits
Open door policy
Open office floor plan
Flexible work schedule
Remote work program
Most of our roles have the flexibility to work remotely within a hybrid model.
Diversity
Mandated unconscious bias training
Diversity manifesto
Diversity employee resource groups
KPA's DEI Group helps to create an inclusive environment for our diverse workforce by developing internal training and organizing events and initiatives within the community.
Hiring practices that promote diversity
KPA is careful to source diverse candidates and interviews fairly based on skills and aptitude. Our recruiting team contiunally collects and analyzes data to promote equity in our hiring practices.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Wellness programs
Team workouts
KPA has provided a place for employees to gather online to take live yoga, stretching, and meditation classes.
Mental health benefits
KPA's EAP and Teledoc programs are available to all employees are easy to use resources to support and promote mental health during the pandemic.
Financial & Retirement
401(K)
401(K) matching
Performance bonus
Child Care & Parental Leave Benefits
Generous parental leave
We provide 6 weeks of paid parental leave.
Family medical leave
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid volunteer time
Paid holidays
Floating holidays
Bereavement leave benefits
Office Perks
Company-sponsored outings
Free snacks and drinks
Some meals provided
Company-sponsored happy hours
Onsite office parking
Fitness stipend
Onsite gym
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Continuing education stipend
We offer $2000 annually for continuing education.
Online course subscriptions available
Customized development tracks
Paid industry certifications

More Jobs at KPA

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