Senior 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 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

Do you have experience in Unit testing?, Do you have a Bachelor's degree?, * 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 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.