Database Engineer

About Paylocity

Paylocity is an award-winning provider of cloud-based HR and payroll software solutions, offering the most complete platform for the modern workforce. The company has become one of the fastest-growing HCM software providers worldwide by offering an intuitive, easy-to-use product suite that helps businesses automate and streamline HR and payroll processes, attract and retain talent, and build a strong workplace culture.

While traditional HR and payroll providers automate basic HR processes such as payroll and benefits administration, Paylocity goes further by developing tools that HR and businesses need to compete for talent and deliver against the expectations of the modern workforce.

Paylocity acquired Airbase! Airbase Inc., a modern finance and spend management software solution that combines bill pay / accounts payable automation, expense management, corporate cards and procurement capabilities. The acquisition of Airbase represents an expansion of Paylocity’s suite and is expected to deliver incremental integrated value to HR and finance leaders in managing all of their spend on a single platform – expanding the Paylocity total addressable market beyond HCM and further into the Office of the CFO.

We give our employees what they need to succeed, including great benefits and perks! We offer various benefits, as well as perks that support you, your family, and your finances. And if it’s career development you desire, we provide that, too! At Airbase by Paylocity, people matter most and have always been at the heart of our business.

Help Airbase by Paylocity enhance communication and enable employees to connect, collaborate, and create from anywhere with a position in Product & Technology! Want to develop the strategies and principles needed to deliver compelling software? Join our team and help us enhance our all-in-one software platform, elevate our one-of-a-kind technology, and improve the employee experience. Take your career to the next level at one of G2's Top 100 Software Companies. Explore our Product & Technology positions to see where you fit!

Position Overview

This Database Engineer role is a member of our product teams, responsible for creating, enhancing, and supporting databases. They are responsible for maintaining our critical data stores. Working side-by-side with Product Owners, Software Test Engineers, and Business Stakeholders, they are actively involved in the complete software development life cycle including technical design, hands-on coding, unit testing, integration testing, performance tuning, maintenance, test automation, deploys and database upgrades.

Primary Responsibilities

• Work on a small to medium size projects overall within a team/area
• Work in parallel with peers and often take a leading role on features or refactors
• Regularly mentor or coach one or more junior database engineers
• Design standalone systems of moderate complexity, or major new features in existing systems
• Perform code reviews and provides consistent, useful, constructive feedback
• Effectively deliver medium or large team projects
• Recognize and surface risks/unknowns and keep work in line with bigger picture goals
• Provide input in database design, performance tuning, troubleshooting, error handling and hardware planning
• Resolve data issues and facilitate data analysis
• Interested in staying current and proficient on existing emerging relevant database technology through self-study and company/vendor provided training opportunities
• Follows defined database standards. Responsible for overall health and database stability for databases assigned to them.
• Understand our overall database backup strategy and be able to perform point in time recovery.
• Owns RPO and RTO of servers/databases assigned to them.
• Participation in on-call duties

Education And Experience

• Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field.
• 2+ years experience in an engineering role
• Experience with Mongo Atlas or Amazon Aurora PostgreSQL database
• Experience with AWS cloud highly preferred
• Experience with Microsoft SQL Server database
• Experience with SQL Always On and clustering
• Responsibility for database SLA
• Advanced knowledge of database level patching while minimizing downtime
• Provide support for growing database technologies used by Paylocity.
• Advanced knowledge of gathering/understanding compliance related data and adhering to compliance standards.
• Intermediate level knowledge of SQL Coding.
• Provides table/object design recommendations where appropriate while adhering to outlined standards.
• Provides intermediate guidance on optimization and index strategy.
• Ability to perform intermediate recommendations on system resource requirements which includes server right sizing.
• Fundamental knowledge of HA technologies used by our data stores.
• Expert knowledge of data backup, recovery, integrity, security, and compliance.
• Fundamental knowledge of disaster recovery concepts and ability to follow outlined DR strategy.
• Participation in on-call duties

Physical Requirements

• Ability to sit for extended periods: The role requires sitting at a desk or workstation for long periods, typically 7-8 hours a day.
• Use of computer and phone systems: The employee must be able to operate a computer, use phone systems, and type. This includes using multiple software programs and inquiries simultaneously.

Key skills/competency

• Database Administration
• Performance Tuning
• SQL Server
• PostgreSQL
• MongoDB
• AWS Cloud
• Data Backup & Recovery
• High Availability (HA)
• Compliance Standards
• Software Development Life Cycle (SDLC)