Yancey Bros. Co. ยท 1 month ago
SQL Database Developer
Smyrna, Georgia, United States
Full-time
Hybrid
Senior Level, Lead/Staff
8+ years expYancey Bros. Co. is an established Caterpillar equipment dealer in Georgia, committed to customer service and employee development. The SQL Database Developer will design, develop, and maintain SQL Server processes, optimize database performance, and collaborate with development teams to ensure data integrity and accessibility.
Machinery
Responsibilities
Design, develop, and implement high-quality, efficient database objects, including stored procedures, functions, views, and triggers using T-SQL
Participate in the database design process, including data modeling and normalization, ensuring adherence to best practices
Optimize and tune complex, high-volume T-SQL queries, stored procedures, and indexes to ensure optimal application performance
Identify and resolve database performance issues, including deadlocks, long-running queries, and poor execution plans
Develop and implement solutions for data migration, replication, and synchronization
Ensure data integrity and security by implementing appropriate constraints, indexes, and user access controls
Collaborate with application development teams to understand data requirements and translate them into effective database solutions
Conduct code reviews of database scripts and stored procedures written by other developers
Create and maintain technical documentation related to database design, code, and operational processes
Assist in the development process of Power BI Semantic Models to be used by Report Developers
Qualification
Required
Competently write secure and efficient T-SQL scripts
Proficiently develop ETL pipelines utilizing SSIS and PowerShell for data on Prem and in the Cloud
Thoroughly understand business logic requirements to fulfill the accurate results needed for making business decisions
Maintain accurate documentation of ETL pipelines
Optimize existing queries for improved performance through reduced I/O, decreased execution times, and streamlined logical processing
Mentor junior colleagues, fostering a culture of database best practices and knowledge sharing
Analyze complex, legacy ETL processes and offer solutions to improve efficiency and follow developmental best practices
Work effectively in Azure DevOps, utilizing User Stories, Source Control, and Documentation
Strong verbal and written communication skills
Documentation skills for processes and procedures
Ability to collaborate effectively with cross-functional teams, including developers, DevOps, and security teams
Must have a high school diploma or equivalent experience
Bachelor's degree in Management Information Systems, Computer Science, or related field
Must have 8+ years of relevant industry work experience
Preferred
Possess extensive knowledge in SSRS, SSIS, and Power BI
Successfully manage competing priorities, focusing on impactful deliverables for stakeholders
Take ownership of processes and continually grow / adjust to an ever-changing set of requirements and timelines
Be self-motivating, actively seeking areas of improvement, and use an agile approach to bring about quality changes to improve stability and efficiency
Company
Yancey Bros. Co.
Since 1914, the employees of Yancey Bros. Co.
1001-5000 employees
H1B Sponsorship
Yancey Bros. Co. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
Funding
Current Stage
Late StageLeadership Team
Tate Anderson
Chief Financial Officer
Jennifer Kozel, CHRO
Chief Human Resources Officer
Company data provided by crunchbase