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

Database Engineer

Paylocity • Schaumburg, IL, US
18 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
    Data Engineer

    Data Engineer

    Adtalem Global Education • Lisle, Illinois, United States
    Full-time
    Adtalem Global Education is a national leader in post-secondary education and leading provider of professional talent to the healthcare industry. Adtalem educates and empowers students with the know...Show more
    Last updated: 1 day ago • Promoted
    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: 5 days ago • Promoted
    Data Operations Engineer

    Data Operations Engineer

    Calamos Asset Management • Naperville, IL, United States
    Full-time
    Calamos is a diversified, global asset and wealth management firm offering a wide range of innovative investment strategies. As one of the top liquid alternative asset managers in the world, Calamos...Show more
    Last updated: 3 days ago • Promoted
    Remote Senior SQL Engineer - AI Trainer

    Remote Senior SQL Engineer - AI Trainer

    SuperAnnotate • Long Grove, Illinois, US
    Remote
    Full-time
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show more
    Last updated: 9 days ago
    Software Engineer

    Software Engineer

    Bright Light Medical Imaging • Arlington Heights, Illinois, United States
    Full-time
    Bright Light Medical Imaging is a physician-run practice redefining diagnostic imaging with innovation, compassion, and precision. For over a decade, we’ve combined cutting-edge technology with a hu...Show more
    Last updated: 23 days ago • Promoted
    Cloud Engineer

    Cloud Engineer

    247Hire • Waukegan, Illinois, USA
    Full-time
    Principal Duties and Responsibilities : .Implement and deploy CI / CD based solutions.Support day-to-day AWS cloud infrastructure operations across development and production environments.Assist with p...Show more
    Last updated: 6 hours ago • Promoted • 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: 3 days 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: 6 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: 6 days ago • Promoted
    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: 3 days ago • Promoted
    Senior Software Engineer

    Senior Software Engineer

    Convr • Schaumburg, Illinois, United States
    Full-time
    Senior Software Engineer in Schaumburg, IL.Analyze user requirements and define functional specifications using Agile methodologies. Analyze large data sets using Python-based data frameworks to und...Show more
    Last updated: 23 days ago • Promoted
    Full Stack Engineer (QE)

    Full Stack Engineer (QE)

    Blue Ribbon Global Technologies • 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: 6 days ago • Promoted
    Data Engineer

    Data Engineer

    Randa Corp • Des Plaines, IL, US
    Full-time
    Randa Apparel & Accessories is one of the world’s leading fashion clothing and accessories companies, operating across 11 countries with a portfolio of 30+ iconic brands, including Haggar...Show more
    Last updated: 30+ days 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: 8 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: 3 days ago • Promoted
    SQL Developer with Oracle EBS

    SQL Developer with Oracle EBS

    Systegration • North Chicago, Illinois, United States
    Full-time
    SQL Developer with Oracle EBS-Contract.SQL Developer with strong Oracle EBS.Systegration is a consulting, placement, and training company that specializes in delivering solutions, expert staffing a...Show more
    Last updated: 2 days 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
    Senior Data Engineer

    Senior Data Engineer

    X4 Engineering • Mundelein, IL, US
    Full-time
    A data services company based in the heart of San Francisco, are looking for a.They are a team of passionate engineers and data experts that are working on a variety of different project, primarily...Show more
    Last updated: 10 days ago • Promoted