Talent.com
Database Engineer
Database EngineerPaylocity • Schaumburg, IL, US
Database Engineer

Database Engineer

Paylocity • Schaumburg, IL, US
16 days ago
Job type
  • Full-time
Job description

Job Description

Job Description

Description :

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 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 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.
  • Airbase by Paylocity is an equal-opportunity employer. We are 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 Airbase by 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, or any other status protected by state or local law for an individual who falls within the jurisdiction of such law. 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.

    Applicants who require an accommodation throughout the application and interview process should request this in advance by contacting accessibility@paylocity.com.

    #LI-Remote

    Requirements :

    Create a job alert for this search

    Database Engineer • Schaumburg, IL, US

    Similar jobs
    Engineer, Cloud

    Engineer, Cloud

    KeHE Distributors • Naperville, IL, US
    Full-time
    Why Work for KeHE? / h2pGood people, working with good people, for our common good.Sound good? KeHE-a natural, organic, specialty and fresh food distributor-is all about good and is growing, so there...Show more
    Last updated: 30+ days ago • Promoted
    Azure Data Engineer

    Azure Data Engineer

    ATTAINX INC • Schaumburg, Illinois, United States, 60194
    Full-time
    US Citizen w / Active Secret Clearance.We are seeking an experienced Azure Data Engineer with proven ability to evaluate, optimize, and modernize enterprise data warehouse environments.The role comb...Show more
    Last updated: 18 days ago
    Cloud Engineer III IntelliScript (Remote)

    Cloud Engineer III IntelliScript (Remote)

    Milliman • Brookfield, Illinois, USA
    Remote
    Full-time
    Milliman IntelliScript is a group of a few hundred experts in fields ranging from actuarial science to information technology to clinical practice. Together we develop and deploy category-defining d...Show more
    Last updated: 3 days ago • Promoted
    GuptaSQL Tech Lead

    GuptaSQL Tech Lead

    Veracity • Deerfield, IL, United States
    Full-time
    Deerfield, IL (3 days / week onsite).Own the process to performing current state analysis (Validate system's technical functionality against business requirements) of large IT systems and identify ga...Show more
    Last updated: 1 day ago • Promoted
    Data Analytics Engineer (Hybrid, Schaumburg, IL)

    Data Analytics Engineer (Hybrid, Schaumburg, IL)

    Byline Bank • Schaumburg, IL, United States
    Full-time
    Headquartered in Chicago, Byline Bank, a subsidiary of Byline Bancorp, Inc.NYSE : BY), is a full-service commercial bank serving small- and medium-sized businesses, financial sponsors and consumers.B...Show more
    Last updated: 15 days ago • Promoted
    Full Stack Engineer (QE)

    Full Stack Engineer (QE)

    Relig Staffing, Inc. • Riverwoods, Illinois, USA
    Full-time
    Primary Skills : Java Spring Spring Boot Kafka RabbitMQ PostgreSQL Kubernetes.Nice to have : OCP AWS Liquibase Jenkins.Quality- Automation Testing Exp Data Testing Frameworks (Like BDDTDD) Tools like...Show more
    Last updated: 4 days ago • Promoted
    Data Engineer

    Data Engineer

    Damco • Lisle, IL, United States
    Full-time
    Need Locals (nearby location candidate can relocate and start day1 onsite) Day 1 onsite MFG domain exp.Experience working with Datastage, ETL Azure certification, leverage various Azure data servic...Show more
    Last updated: 1 day ago • Promoted
    AWS Cloud Engineer (Hybrid) Waukegan, IL (only local candidates)

    AWS Cloud Engineer (Hybrid) Waukegan, IL (only local candidates)

    Stellent IT LLC • Waukegan, IL, United States
    Full-time
    Quick Apply
    AWS Cloud Engineer (Hybrid) Location : Waukegan, IL (only local candidate's) Show more
    Last updated: 14 hours ago • New!
    Enterprise Cloud Architect

    Enterprise Cloud Architect

    Cynet Systems • Rosemont, IL, United States
    Full-time
    Lead the endtoend architecture and design of life insurance platforms and systems ensuring alignment with business goals and industry best practices. Collaborate with business stakeholders product m...Show more
    Last updated: 1 day ago • Promoted
    Full Stack Engineer (QE)

    Full Stack Engineer (QE)

    SOMERSET STAFFING • Riverwoods, Illinois, USA
    Full-time
    Primary Skills : Java Spring Spring Boot Kafka RabbitMQ PostgreSQL Kubernetes.Nice to have : OCP AWS Liquibase Jenkins.Quality- Automation Testing Exp Data Testing Frameworks (Like BDDTDD) Tools like...Show more
    Last updated: 4 days ago • Promoted
    Full Stack Engineer (QE)

    Full Stack Engineer (QE)

    Expert Technology Services • Riverwoods, Illinois, USA
    Full-time
    Primary Skills : Java Spring Spring Boot Kafka RabbitMQ PostgreSQL Kubernetes.Nice to have : OCP AWS Liquibase Jenkins.Quality- Automation Testing Exp Data Testing Frameworks (Like BDDTDD) Tools like...Show more
    Last updated: 4 days ago • Promoted
    Lead Database Administrator

    Lead Database Administrator

    Chamberlain Group • Oak Brook, Illinois, USA
    Full-time
    Chamberlain Group (CG) is a global leader in intelligent access and Blackstone portfolio company.Powered by our myQ technology we make access simple and secure for millions of homeowners businesses...Show more
    Last updated: 21 days ago • Promoted
    Senior Azure Data Engineer

    Senior Azure Data Engineer

    Accellor • Hoffman Estates, IL, US
    Full-time
    Quick Apply
    Accellor is an AI-first digital transformation partner built for the next generation of enterprise.We help global organizations turn cloud, data, and AI into real, measurable business outcomes at s...Show more
    Last updated: 14 days ago
    Data Engineer II

    Data Engineer II

    Jobot • Franklin Park, IL, US
    Full-time
    REMOTE opportunity, Excellent Benefits, Cutting Edge Projects, and MORE!.This Jobot Job is hosted by : Caitlyn Hardy.Are you a fit? Easy Apply now by clicking the "Apply Now" button and sending us y...Show more
    Last updated: 1 day ago • Promoted
    Senior Systems Engineer

    Senior Systems Engineer

    Wintrust • Rosemont, Illinois, USA
    Full-time
    Wintrust provides community and commercial banking specialty finance and wealth management services through its 16 bank charters and nine non-bank businesses. Wintrust delivers the sophisticated sol...Show more
    Last updated: 5 days ago • Promoted
    Cloud Engineer

    Cloud Engineer

    Spectraforce Technologies • North Chicago, IL, United States
    Full-time
    Assignment Length : 1 year (possibility of extension).In Client's Business Technology Solutions, we are shaping the digital transformation accelerating the future of medicine-and doing it together, ...Show more
    Last updated: 1 day ago • Promoted
    Lead NoSQL Database Administrator

    Lead NoSQL Database Administrator

    Uline • Waukegan, IL, US
    Full-time
    Lead NoSQL Database Administrator.Pay from $120,000 to $185,000 per year.Lakeside Drive, Waukegan, IL 60085.Are you driven to optimize database performance and implement automation solutions? Are y...Show more
    Last updated: 30+ days ago • Promoted
    Data Engineer

    Data Engineer

    Denver Staffing • Wood Dale, IL, United States
    Full-time +1
    We are seeking a highly skilled Data Engineer to join our Customer Solutions team reporting to Senior Director of Customer Solutions in Midwest region for Quest Diagnostics.In this role, you will b...Show more
    Last updated: 15 hours ago • Promoted • New!