Database Administrator
Sorry, this job was removed at 11:42 p.m. (CST) on Monday, September 18, 2017
By clicking Apply Now you agree to share your profile information with the hiring company.
At Paylocity, we are committed to expansion of our world-class suite of web-based software. Already a leading SaaS provider of Payroll, HR, Time & Labor Management, Online Benefits Enrollment, and Data Integration solutions, we are looking for talented individuals to ensure we continue to make it easier for our customers to do their jobs. Our Product Development organization nurtures a dynamic agile work environment full of talented individuals with a variety of thoughts, ideas and backgrounds. Guided by our shared values, and a passion for compelling software we come together to deliver great products and make Paylocity an exciting place to work. We are seeking an experienced Database Administrator to join our Database Administration team at Paylocity. This person will be 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. Performance Objectives/Job Duties
- Execute SQL server maintenance to ensure a consistent and reliable database environment.
- Develop and maintain logical and physical database models
- Work directly with software development groups to ensure that we deliver quality database solutions
- Importing and exporting data to and from multiple data sources
- Write ad-hoc queries, stored procedures, jobs, and functions to support the SQL servers
- Familiar with best practices and standard DBA tasks
- Resolve data issues and facilitate data analysis
- Stay current and proficient on existing and emerging relevant SQL technology through self-study and company and vendor provided training opportunities
- Provide input in database design, performance tuning, troubleshooting, error handling and hardware planning
- Identify and assist to resolve all operational related issues ranging from the Web Server, SQL Server, Operating Systems and more
Requirements
Experience Requirements
- 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 with SQL transactional replication, AlwaysOn High Availability groups and clustering
- 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
- Excellent written and oral communication
- MCITP:DBA or equivalent a plus
- Experience with other database technologies (Oracle, MySQL, etc) a plus
Read Full Job Description