Database Administrator

| Northwest Suburbs
Delivering one-of-a-kind cloud technology, accompanied by award winning customer service, Paylocity is a software development company in a category of its own. We are a publicly traded company that offers an Employee Stock Purchase Program (ESPP) which enables employees to share in the long-term growth and future
success of the company.
Poised to revolutionize the world of human capital management for hundreds of thousands of small and medium sized businesses, we are seeking the best and the brightest to help us create the future of our talent solutions – enabling our customers to better develop their employees and supervisors.
Our lean development process enables our small product oriented teams to innovate, collaborate and bring amazing features to market.
Our talent anywhere philosophy nurtures a diverse and dynamic group of colleagues with a shared mission to make great products and have fun doing it.
The Database Administrator is responsible for maintaining our databases on Microsoft SQL Server. The DBA will additionally provide expertise in the areas of analysis, reporting, and performance tuning. In this role, you will also work with the technical teams from software development and implementation to ensure quality data models, data integrity and maintain outstanding database performance.
Are you the teammate we are looking for?

Who you are:

  • Enthusiastic about developing the best software available and providing the ultimate customer experience
  • Interested in staying current and proficient on existing emerging relevant SQL technology through self study and company/vendor provided training opportunities
  • Ability to work directly with software development groups to ensure that we delivery quality database solutions
  • Able to work independently on modules and complete tasks with high quality, but unafraid to seek out suggestions from other team members
  • Familiar with best practices and standard DBA tasks

How we work:

  • Small, self-sufficient product-oriented teams with an entrepreneurial spirit organized into categories
  • Dedicated Tech Operations experts committed to cutting-edge infrastructure and developer tools
  • We don’t add more folks to our teams, we add additional teams to scale
  • Casual, collaborative, agile environment which embraces and operates under our shared principles
  • Complete transparency with open, honest discussions about our progress
  • Close working relationship between executive stakeholders and product teams

What we offer:

  • Lean enabling process that focuses on putting our product teams in the best position to succeed
  • A commitment to investing in our products, hiring the best talent, and giving them the chance to meaningfully contribute to a vast market opportunity
  • A subscription to an Online Training Forum for all technology colleagues

Required Experience:

  • Proficient knowledge of stored procedures, triggers, and T-SQL
  • 6+ years of Microsoft SQL Server database experience
  • Extensive experience with Microsoft SQL 2008/2012/2014
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Experience with Microsoft Reporting Services
  • Experience with DTS and SSIS
  • Experience with SQL transactional replication and clustering a plus
  • Excellent written and oral communication
  • MCITP:DBA or equivalent a plus
  • Experience with other database technologies (Oracle, MySQL, etc) a plus

During the last three months, you would have:

  • Executed SQL server maintenance to ensure a consistent and reliable database environment
  • Developed and maintain logical and physical database models
  • Imported and exported data to and from multiple data sources
  • Wrote ad-hoc queries, stored procedures, jobs, and functions to support the SQL servers
  • Resolved data issues and facilitated data analysis
  • Provided input in database design, performance tuning, troubleshooting, error handling and hardware planning
  • Identified and assisted in resolution to all operational related issues ranging from the Web Server, SQL Server, Operating systems, and more

Paylocity's Awards:

  • Glassdoor's Employees Choice Award in 2014 and 2017
  • 9-time Winner on Chicago Area's 101 Best and Brightest Companies to Work For
  • Inc Magazine listed Paylocity as an Inc 5000 Fastest Growing Privately Held Firm from 2007-2013
  • Ranked #13 on Built in Chicago Top 100 Digital Companies for 2016
  • Ranked #24 on Forbes 2013 List of Top 100 Digital Companies in Chicago
  • Ranked #38 on Crain's Fast Fifty List of Chicago's Fastest Growing Companies in 2014
  • Ranked #334 on Deloitte's 2014 Technology Fast 500 List of Fastest Growing Companies in North America

Who you are:

  • Enthusiastic about developing the best software available and providing the ultimate customer experience
  • Interested in staying current and proficient on existing emerging relevant SQL technology through self study and company/vendor provided training opportunities
  • Ability to work directly with software development groups to ensure that we delivery quality database solutions
  • Able to work independently on modules and complete tasks with high quality, but unafraid to seek out suggestions from other team members
  • Familiar with best practices and standard DBA tasks

How we work:

  • Small, self-sufficient product-oriented teams with an entrepreneurial spirit organized into categories
  • Dedicated Tech Operations experts committed to cutting-edge infrastructure and developer tools
  • We don’t add more folks to our teams, we add additional teams to scale
  • Casual, collaborative, agile environment which embraces and operates under our shared principles
  • Complete transparency with open, honest discussions about our progress
  • Close working relationship between executive stakeholders and product teams

What we offer:

  • Lean enabling process that focuses on putting our product teams in the best position to succeed
  • A commitment to investing in our products, hiring the best talent, and giving them the chance to meaningfully contribute to a vast market opportunity
  • A subscription to an Online Training Forum for all technology colleagues

Required Experience:

  • Proficient knowledge of stored procedures, triggers, and T-SQL
  • 6+ years of Microsoft SQL Server database experience
  • Extensive experience with Microsoft SQL 2008/2012/2014
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Experience with Microsoft Reporting Services
  • Experience with DTS and SSIS
  • Experience with SQL transactional replication and clustering a plus
  • Excellent written and oral communication
  • MCITP:DBA or equivalent a plus
  • Experience with other database technologies (Oracle, MySQL, etc) a plus

During the last three months, you would have:

  • Executed SQL server maintenance to ensure a consistent and reliable database environment
  • Developed and maintain logical and physical database models
  • Imported and exported data to and from multiple data sources
  • Wrote ad-hoc queries, stored procedures, jobs, and functions to support the SQL servers
  • Resolved data issues and facilitated data analysis
  • Provided input in database design, performance tuning, troubleshooting, error handling and hardware planning
  • Identified and assisted in resolution to all operational related issues ranging from the Web Server, SQL Server, Operating systems, and more

Paylocity's Awards:

  • Glassdoor's Employees Choice Award in 2014 and 2017
  • 9-time Winner on Chicago Area's 101 Best and Brightest Companies to Work For
  • Inc Magazine listed Paylocity as an Inc 5000 Fastest Growing Privately Held Firm from 2007-2013
  • Ranked #13 on Built in Chicago Top 100 Digital Companies for 2016
  • Ranked #24 on Forbes 2013 List of Top 100 Digital Companies in Chicago
  • Ranked #38 on Crain's Fast Fifty List of Chicago's Fastest Growing Companies in 2014
  • Ranked #334 on Deloitte's 2014 Technology Fast 500 List of Fastest Growing Companies in North America
Read Full Job Description

Location

1400 American Lane, Schaumburg, IL 60173

What are Paylocity Perks + Benefits

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
Company Equity
Employee Stock Purchase Plan
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Company Outings
Some Meals Provided
Happy Hours
Professional Development Benefits
Job Training & Conferences

Additional Perks + Benefits

Our commitment to hiring the best and brightest employees with a “talent anywhere” strategy means that no matter where you’re located around the country, you can be a part of our growing tech department • Enjoy an attitude of trust to work remotely, manage your own schedule and be productive • Work in small, cross-functional product-oriented teams • Showcase development progress in two-week sprints with strong executive involvement • Embrace the freedom to innovate, voice opinions and share new ideas

More Jobs at Paylocity28 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Operations
Product
Project Mgmt
Sales
Content
Developer
new
Northwest Suburbs
Sales
new
South Suburbs
Sales
new
West Suburbs
Developer
new
Chicago
Developer
new
Northwest Suburbs
Content
new
Northwest Suburbs
Finance
new
Northwest Suburbs
Project Mgmt
new
Northwest Suburbs
Product
new
Chicago
Design + UX
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Product
new
Northwest Suburbs
Product
new
Northwest Suburbs
Sales
new
North Suburbs
Internships
new
Northwest Suburbs
Internships
new
Northwest Suburbs
Internships
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Product
new
Northwest Suburbs
Data + Analytics
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Developer
new
Northwest Suburbs