Database Lead

This is a fully remote position, open to applicants in Kansas, +1 more state.

📋 Description

• Manage the SQL Developer team directly by assigning and prioritizing tasks, setting expectations, and supervising daily workloads.

• Oversee performance management through regular one-on-one meetings, feedback, goal setting, and contributions to performance evaluations.

• Offer technical guidance, mentorship, and support to SQL Developers.

• Conduct code reviews and establish coding standards, patterns, and best practices.

• Spearhead onboarding and training initiatives for new developers.

• Address complex technical challenges and production incidents, guiding troubleshooting and root-cause analysis.

• Participate in technical design and architecture decision-making.

• Provide updates on team progress, capacity, and risks to the VP of Development.

• Design scalable SQL Server database architectures to support ERP and application data.

• Develop and manage conceptual, logical, and physical data models.

• Design, develop, manage, and optimize tables, stored procedures, views, functions, triggers, and T-SQL code.

• Oversee and monitor SQL Agent jobs.

• Collaborate with Infrastructure on backups, restores, server permissions, and HIPAA compliance.

• Monitor and optimize database performance, including execution plans, indexing, blocking, and deadlocks.

• Support ERP data replication across various departments such as Sales, Purchasing, Inventory, Finance, AR, AP, Shipping, and Warehouse Operations.

• Design and support SSIS, SSRS, and other database integration efforts.

• Create 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 data initiatives.

• Assist in the evaluation and implementation of data lake solutions like Snowflake.

⛳️ Requirements

• Demonstrated experience leading, mentoring, or directing other developers, preferably in a hands-on lead capacity.

• Over 10 years of professional experience in application and database development with relational databases.

• Proficient in SQL and T-SQL, including complex joins, window functions, set-based logic, stored procedures, and views.

• Experience with Microsoft SQL Server (versions 2014–2022).

• Proven track record in building and maintaining reports using SQL Server Reporting Services (SSRS).

• Skilled in creating and maintaining ETL/ELT processes using SQL Server Integration Services (SSIS).

• Knowledge of indexing strategies, query execution plans, and performance-tuning tools.

• Familiarity with Power BI or similar reporting/BI tools.

• Interest and skills in working on data lake solutions, such as Snowflake.

• Comfortable working in Windows and/or Linux server environments, with the ability to perform basic database administration tasks (backups, restores, user permissions).

• Strong Microsoft Excel skills and capability to analyze data using spreadsheets.

• Excellent communication and organizational skills, with the ability to juggle multiple projects in a fast-paced, deadline-driven environment.

• Ability to function effectively with minimal supervision.

• Experience with Python is a plus, especially for scripting data pipelines, automation, or lightweight ETL tasks.

• Familiarity with AI coding tools (e.g., GitHub Copilot, Claude, or similar) to enhance development, review code, and boost productivity.

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

🏝️ Benefits

• Full-time employment.

• Fully remote work arrangement.