SQL Database Developer

Who We Are:

From Georgia. For Georgia.  Since 1914 Yancey Bros. Co. has proudly served as the authorized Caterpillar equipment dealer for Georgia, providing our customers with the highest quality sales, parts and service.  From Caterpillar heavy and compact construction equipment to on-highway trucks, we remain committed to learning more about our customers, offering equipment and support to keep up with their changing needs.  This all starts with our greatest asset…our employees.

What You Will Be Doing:

The SQL Database Developer designs, develops, and maintains robust and efficient processes within SQL Server. This role involves creating and optimizing stored procedures, functions, triggers, and views, as well as developing ETL processes for data integration and warehousing. In addition to the primary database platform being SQL Server, this position will also assist in developing within the Snowflake database platform. The ideal candidate will possess strong analytical and critical thinking skills, be adept at performance tuning and query optimization, and have a solid understanding of database security and best practices to ensure data integrity and accessibility for various applications and reporting needs.

This role is a hybrid position with at least 3 days in-office.

Major Tasks, Responsibilities, and Key Accountabilities:

• Design and Development:
  • 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
• Performance and Optimization:
  • 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.
• Data Integrity and Quality:
  • Develop and implement solutions for data migration, replication, and synchronization.
  • Ensure data integrity and security by implementing appropriate constraints, indexes, and user access controls.
• Collaboration and Maintenance:
  • 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.
• Documentation and Reporting:
  • 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.

Education/Experience:

• 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.

Required Qualifications/Skills:

To be successful in this role, a qualified candidate will be able to: 

• 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.

Preferred Qualifications/Skills:

To excel in this role, a qualified candidate will: 

• 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.

Environmental Job Requirements:
Environment:

• Climate controlled environment. Work under fluorescent lighting. Moderate noise levels.  Possible noise and vibrations carried over from the shop.

Physical:

• Seldom Lift/Carry/Lower 1 – 15 lbs, Never Lift/Carry/Lower +15 Lbs.
• Frequently sitting, repetition – hand/wrist simple grasping.
• Occasionally pushing/pulling, reaching,
• Seldom bending/twisting, walking, standing,
• Never crouching/stooping/squatting, crawling/kneeling, climbing/stepping

Travel:

• Typically requires travel 0% to 5% of the time.

Who We Are Looking For:

To be successful in this position you should be organized, show an attention for detail and a sense of urgency. You should have basic computer skills, safety conscious and the willingness to learn. The ability to multitask, problem solve and provide superior customer service are essential to this position as well.