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. 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.
Recommended Jobs
Physicians Needed: Travel Veteran Disability Examiner
Dane Street is hiring licensed Internal Medicine Physicians to conduct per diem Medical Disability Examinations for U.S. Veterans. Partnering with the Department of Veterans Affairs, you will help c…
In-Store Shopper (Online Orders) - Part Time Seasonal
At Whole Foods Market, we’re committed to providing record-setting grocery delivery services to our Prime Now customers. This is a fast-growing program and candidates who are passionate about our qua…
Application Specialist - Data Center Cooling Systems - HVAC
Job Description Job Description Application Specialist - Data Center Cooling Systems - Industrial HVAC Carel is a growing, multinational organization specializing in controls for HVAC, HVAC/R …
Locum Tenens General Dermatologist
Qualderm Partners – A Skin and Aesthetics Wellness Family is an exciting brand created from combining two of the best-in-class names in skin and aesthetics care: Pinnacle Dermatology and QualDerm Par…
Dentist
This is an excellent opportunity for a Dentist to step into a busy schedule within a long-standing Lawrenceville private practice. If you are a Dentist who feels stifled by corporate quotas or rotati…
Pediatric Dental Assistant
Dental Assistant Position Journey Smiles Orthodontics & Pediatric Dentistry We are a new, family centered practice dedicated to creating healthy, confident smiles in a warm & welcoming en…
OTR Dry van Company driver (1099) Job in Smyrna, GA by Rise United
Dry van 0.67$ (All miles paid) 3500-4000 Miles weekly (Guaranteed) Freightliner 2023-2025 (no cameras inside) We operate mostly midwest, west (no NYC, no mountains) Driver must have 2 years of exp.…
A-Tech Mechanic
A-Tech Mechanic (Do not apply unless you can do at least a timing belt). This is an application for an A-list mechanic. You may not Qualify if you have not been an mechanic for at least 5 years…
Montessori Toddler Lead Teacher
Job Description Job Description The Montessori Toddler Lead Teacher will guide a classroom of children aged 18 months to 3 years by designing and delivering a developmentally responsive Montessor…
OTR Class A Driver - 100% No-Touch - $0.60 CPM
We are currently accepting applications for OTR Class A drivers for a high-mileage operation. This position offers a straightforward pay structure, modern fleet equipment, and a 100% no-touch freight…