Senior Database Engineer

Job Type

Full-time

Description
Location: Remote
(Must be in Guadalajara)
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.

Help 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

We are committed to building a world-class team by hiring top talent globally. To ensure compliance, we use an Employer of Record model. Our ideal candidates would be based in Guadalajara, our surrounding areas, with right to work there, and be able to work within four hours of Eastern Standard Time.

Senior Database Engineer
Position Overview
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.

Primary Responsibilities
The below 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.

• Work on a small or medium project 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 small or medium 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
• Participation in on-call duties

Education And Experience

• Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field.
• 5+ years professional engineering experience
• 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
• Must be adaptable to change and have a willingness to learn
• Must have a strong sense of curiosity
• Must commit to their role and take responsibility for their tasks
• Must be able to work effectively in an agile and team environment
• Must be effective and creative in problem solving
• Experience in Performance Tuning, Query Optimization, using related monitoring and troubleshooting tools.
• Utilizing metrics to trend data for performance analysis and capacity planning
• Responsibility for database SLA
• 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.

Paylocity is an equal-opportunity employer.
Paylocity is committed to the full inclusion of all individuals. We recruit, train, compensate, and promote regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected status as required by applicable law. At Paylocity, we believe diversity makes us better.

We embrace and encourage our employees' differences in age, culture, ethnicity, family or marital status, gender identity or expression, language, national origin, physical and mental ability, political affiliation, race, religion or spiritual belief, sexual orientation, socio-economic status, veteran status, and other characteristics that make our employees unique. We actively cultivate these differences through our employee resource groups (ERGs), employee experiences, perspectives, talents, and approaches to drive innovation in the software and services we provide our customers.

We comply with federal and state disability laws and make reasonable accommodations for applicants and employees with disabilities. To request reasonable accommodation in the job application or interview process, please contact This email address is exclusively designated for such requests, aligning with federal and state disability laws. Please do not send resumes to this email address, as they will be removed.