Database Administrator

| Remote
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, the DBA 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 

• Able 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 

• Critical thinking and problem-solving ability

• Excellent written and oral communication

 

 

During the first six months, you will: 

• Execute SQL server maintenance to ensure a consistent and reliable database environment 

• Import and export data to and from multiple data sources 

• Write ad-hoc queries, stored procedures, jobs, and functions to support the SQL servers 

• Resolve data issues and facilitate data analysis 

• Provide input in database design, performance tuning, troubleshooting, error handling and hardware planning 

• Identify and assist in resolution to all operational related issues ranging from the Web Server, SQL Server, Operating systems, and more

 

What you bring: 

• 5+ years of Microsoft SQL Server database experience

• Extensive experience with Microsoft SQL 2014+

• Proficient knowledge of SQL, stored procedures, triggers, and T-SQL

• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, Extended Events, and other related monitoring and troubleshooting tools.

• Experience with Microsoft Reporting Services

• Experience with patching/upgrading

• Experience with DTS and SSIS

• Experience with SQL Always On and clustering a plus

• MCITP:DBA or equivalent a plus

• Willing to participate in on-call duties

• Willing to be part of database code pushes/change controls related to the database

• Experience with other database technologies (Oracle, MySQL, etc) a plus

 

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 Paylocity48 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR + Recruiting
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Operations
new
Northwest Suburbs
Data + Analytics
new
Northwest Suburbs
Sales
new
Northwest Suburbs
Project Mgmt
new
Remote
Data + Analytics
new
Remote
Data + Analytics
new
Remote
Operations
new
Remote
Product
new
Remote
Project Mgmt
new
Remote
HR + Recruiting
new
Northwest Suburbs
Developer
new
Remote
Marketing
new
Northwest Suburbs
Project Mgmt
new
Remote
Data + Analytics
new
Remote
Sales
new
Northwest Suburbs
Finance
new
Northwest Suburbs
Operations
new
Northwest Suburbs
HR + Recruiting
new
Northwest Suburbs
Data + Analytics
new
Remote
Project Mgmt
new
Remote
Data + Analytics
new
Remote
HR + Recruiting
new
Remote
HR + Recruiting
new
Remote
Project Mgmt
new
Remote
Product
new
Remote
Developer
new
Remote
Marketing
new
Northwest Suburbs
Finance
new
Remote
Developer
new
Remote
Internships
new
Remote
Project Mgmt
new
Remote
HR + Recruiting
new
Remote
Data + Analytics
new
Northwest Suburbs
Data + Analytics
new
Remote
Project Mgmt
new
Remote
Project Mgmt
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Developer
new
Remote
Project Mgmt
new
Remote
Data + Analytics
new
Remote
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