Database Administrator (Remote) at Paylocity

| Remote
Sorry, this job was removed at 5:23 p.m. (CST) on Tuesday, June 23, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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 selfstudy 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

What you bring:

  • High School diploma or equivalent
  • 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
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
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • AccessDatabases
    • Microsoft SQL ServerDatabases
    • OracleDatabases

Location

Our office has modern workspaces, a cafe, and a gym. But since we're a talent-anywhere company, you may find our team members all over Chicagoland.

What are Paylocity Perks + Benefits

Paylocity Benefits Overview

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

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Highly diverse management team
Unconscious bias training
Someone's primary function is managing the company’s diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
We have a talent anywhere culture, where employees can work anywhere in the US and/or work from one of three US offices located in Illinois, Florida, and Idaho
Family Medical Leave
Adoption Assistance
Company sponsored family events
Acme co. sponsors family oriented events Annually.
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Parking
Recreational Clubs
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Acme Co. hosts lunch and learn meetings on occasion.
Cross functional training encouraged
Promote from within
Mentorship program
Our mentorship program includes 1-to-1 program, Cross-department program, Leadership mentoring.
Online course subscriptions available
More Jobs at Paylocity20 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
Legal
Marketing
Operations
Project Mgmt
Marketing
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Data + Analytics
new
Northwest Suburbs
Project Mgmt
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Finance
new
Northwest Suburbs
Finance
new
Northwest Suburbs
Finance
new
Northwest Suburbs
Finance
new
Northwest Suburbs
Data + Analytics
new
Chicago
Operations
new
Chicago
Finance
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Paylocity's full profileSee more Paylocity jobs