Do you tend to think in columns and rows and have a continuous need to restore order to the universe (or at least to a database)?
Are you a SQL Guru with a flair for troubleshooting and a passion for data organization and management?
Do you take your work seriously, but not so seriously that you would turn down a game of Ping Pong or Wii Bowling on your lunch hour?
Are you interested in joining a company that has experienced a 1000% growth rate in the past five years?
Exciting things are happening at Paylocity, which means there are career opportunities for you! We are seeking a Database Administrator to join our IT department.
The DBA is responsible for supporting all of our SQL database servers. Paylocity actively develops and hosts our award-winning Payroll, HR, and Time & Attendance products as SaaS solutions. Our clients use these solutions 24 hours a day which makes these servers mission critical to our business and our clients! In this role, the DBA 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 work with the technical teams from software development and implementation to ensure data integrity and maintain outstanding database performance.
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 (Example: backups)
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
Proficient knowledge of stored procedures, triggers and T-SQL
4+ years of database experience and standards
Heavy experience with Microsoft Excel and Microsoft Access
Extensive experience with Microsoft SQL 2005/2008
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
Keyword: Database Administrator . DBA, SQLServer, T-SQL
Paylocity - 10 months ago
Go ahead and put whomever you like on the payroll; Paylocity is ready to make sure the pay keeps rolling on! The company (formerly Ameripay...