Database Engineer

This 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.

The following represents the primary duties of the position; others may be assigned as needed. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Responsibilities:

• Work on small to medium-sized 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 provide consistent, useful, constructive feedback.
• Effectively deliver medium or large team projects.
• Recognise 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 and 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 the 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.

Requirements:

• Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field.
• 2+ years of experience in an engineering role.
• Experience with Mongo Atlas or Amazon Aurora PostgreSQL database.
• Experience with AWS cloud is 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 minimising 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 optimisation 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 the ability to follow the outlined DR strategy.

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.

Skills

AWS, Amazon Aurora, Microsoft SQL Server, Mongo Atlas, MongoDB, PostgreSQL, SQL Server