SQL Database Developer Location Hybrid work in Smyrna, GA : 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. 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.
Primary Responsibilities:
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 data flows.
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.
Additional Responsibilities:
Participate in required safety program, and work in a safe manner.
Additional duties as assigned by manager.
Who We Are Looking For:
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:
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.
Strong verbal and written communication skills.
Documentation skills for processes and procedures.
Values:
At Yancey Bros. Co, we are always looking to add people to our team who share our core values:
Safety: We value the lives and health of our team and customers above all else.
Integrity: We are ethical and trustworthy, demonstrate respect for others, and communicate truthfully and promptly.
Teamwork: We work as one across our organization for the benefit of our customers.
Excellence: We strive to be the best, continuously improving our customers' experience and the solutions we provide.
Sense of Urgency: We respond quickly to customer needs and hold ourselves accountable for results.
Ideal candidates will demonstrate the following values:
Acting in a safe manner
Exhibiting honesty and integrity
Acting in a fair and ethical manner
Team mentality
Delivering quality results
Embraces change / improvement
Exhibiting superior customer service skills
Exhibiting pride and ownership
Working with a sense of urgency
Exhibiting a winning attitude
What We Offer:
Yancey Bros Co offers a full benefits package that includes aggressive compensation levels, technician tool allowances, full medical, vision and dental coverage, employee wellness programs, paid vacations and more.
Competitive Pay Structure
~ Competitive Pay
~ Individual Bonus Opportunities Available
~ Technician Tool Allowance
~401k Plan Strong Company Match
~ Employee Profit Sharing
~ Financial Wellness Coaching
Employee Wellness Program
Medical, Vision, Dental Insurance
Prescription Drug Coverage
Flexible Spending Accounts
Short & Long Term Disability
Group Life Insurance
Personal Time Off
Paid Holidays
Paid Sick Leave
Career Development
Tuition Reimbursement
Ongoing Training
Advancement Opportunities
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.