Database Lead

Paycom - ATS; Kansas City (MO); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Paycom - ATS in the United States is seeking a Database Lead who oversees a SQL Developer team while actively designing and optimizing SQL Server database solutions that support ERP and business apps. This role partners with cross-functional teams to deliver secure and well-monitored software.

You will lead performance reviews, mentor developers, and drive coding standards, while hands-on developing tables, procedures, ETL/SSIS, SSRS, and BI reporting for Power BI.

Qualifications

• 10+ years of professional experience in application and database development.
• Experience leading, mentoring, or directing developers.
• Strong SQL and T-SQL skills with complex joins and window functions.
• Experience with SQL Server (2014-2022) and SSRS/SSIS.
• Experience with Power BI and data visualization tools.
• Background in Windows and Linux server environments.
• Excellent communication with technical and non-technical stakeholders.
• Interest in data lakes (Snowflake) and modern data architectures.

Responsibilities

• Directly manage the SQL Developer team, prioritizing work and setting expectations.
• Own performance management, 1:1s, and career development.
• Provide day-to-day technical guidance and mentorship.
• Lead code reviews and establish coding standards and best practices.
• Onboard and train new developers on systems and domain knowledge.
• Design scalable SQL Server architectures supporting ERP and apps.
• Develop data models,ETL/ELT processes, and database objects.
• Monitor performance, tuning, and data integrity across environments.
• Collaborate with cross-functional teams including BI, infra, and apps.
• Support data lake initiatives and Snowflake deployments.

Skills

SQL & T-SQL

MS SQL Server

Power BI

SSRS/SSIS

Leadership/Mentoring

Code Reviews

Windows/Linux

Python

AI coding tools

Data Lake Snowflake

Education

Bachelor's degree in Computer Science

Tools

Snowflake

SSIS

SSRS

Job description

Job Details: Job Location: REMOTE US - Kansas City, MO 64120, Position Type: Full Time

JOB SUMMARY: The Database Lead is a working lead who both manages and actively contributes to the SQL Developer team. This role is responsible for the team's day-to-day management - including assigning and prioritizing work, overseeing performance, and supporting the growth of each team member - while also personally designing, architecting, and optimizing SQL Server database solutions that support ERP and business applications. This role partners closely with cross-functional teams to deliver secure, reliable, and well-monitored software solutions.

ESSENTIAL FUNCTIONS:

Team Leadership & Management

• Directly manage the SQL Developer team, including assigning and prioritizing work, setting expectations, and overseeing day-to-day workload across the team.
• Own performance management for the team, including regular 1:1s, performance feedback, goal-setting, and contributing to performance reviews.
• Provide day-to-day technical guidance, mentorship, and support to SQL Developers, helping them grow their skills and resolve technical blockers.
• Lead code reviews and establish coding standards, patterns, and best practices across database development.
• Lead onboarding and training for new developers, including training on Supplylogic's systems, tools, and domain knowledge (e.g., supplier integrations, WMS).
• Act as a point of escalation for complex technical issues and production incidents, guiding troubleshooting and root-cause analysis.
• Contribute to technical design decisions and architecture direction in collaboration with the team.
• Report on team progress, capacity, and risks to the VP-Development, and represent the team in cross-functional planning discussions.

Hands-On Development

• Design scalable SQL Server database architectures supporting ERP and other application data.
• Develop and manage conceptual, logical, and physical data models for all custom-built applications.
• Establish database standards, indexing strategies, naming conventions, and best practices.
• Design, develop, manage, and optimize tables, stored procedures, views, functions, triggers, and T-SQL code.
• Manage and monitor SQL Agent jobs.
• Partner with the Infrastructure team on backups, restores, server permissions, and HIPAA compliance.
• Monitor and tune database performance, including execution plans, indexing, blocking, and deadlocks.
• Support ERP modules data replication, including Sales, Purchasing, Inventory, Finance, AR, AP, Shipping, and Warehouse Operations.
• Design and support SSIS, SSRS, and other database integrations, ( including but not limited to maintaining SSRS reports and subscriptions, creating/maintaining SSIS packages for client data, invoice transmissions, and remit transactions, supporting order integration with ERP and shipping modules, supporting the Supplier Integration team at the data level, and managing database syncs from Production to Development.).
• Build reporting-friendly structures for Power BI and SSRS.
• Ensure data integrity, validation, security, and auditability.
• Partner with application developers, business analysts, and infrastructure teams on all data initiatives.
• Support evaluation and implementation of data lake solutions, such as Snowflake.

Qualifications: QUALIFICATIONS AND SKILLS:

• Prior experience leading, mentoring, or providing direction to other developers, ideally in a working/hands-on lead capacity.
• Strong communication skills, with the ability to explain technical concepts to both technical and non-technical stakeholders.
• Experience conducting code reviews and establishing or enforcing development standards and best practices.
• 10+ years of professional experience in application and database development with relational databases, including prior experience leading, mentoring, or providing technical direction to other developers, ideally in a working/hands-on lead capacity.
• Strong SQL and T-SQL skills, including complex joins, window functions, set-based logic, stored procedures, and views.
• Experience with Microsoft SQL Server (2014-2022).
• Experience building and maintaining reports using SQL Server Reporting Services (SSRS).
• Experience building and maintaining ETL/ELT processes using SQL Server Integration Services (SSIS).
• Familiarity with indexing strategy, query execution plans, and performance-tuning tools.
• Experience with Power BI or similar reporting/BI tools.
• Skills and interest in working on a data lake solution, such as Snowflake.
• Strong communication skills, with the ability to explain technical concepts to both technical and non-technical stakeholders.
• Ability to work in Windows and/or Linux server environments, with comfort performing basic database administration tasks (backups, restores, user permissions).
• Strong Microsoft Excel skills and ability to work with spreadsheets for data analysis.
• Excellent communication and organizational skills, with the ability to multitask and manage multiple projects in a fast-paced, deadline-driven environment.
• Ability to operate effectively with minimal supervision.
• Python experience is a plus, particularly for scripting data pipelines, automation, or lightweight ETL tasks.
• Experience using AI coding tools (e.g., GitHub Copilot, Claude, or similar) to accelerate development, review code, and improve productivity.

Education:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.